more segfaults (sqlite this time)

[Paul J Stevens]

Jan-Henrik Haukeland wrote:
> Could you try and create a test program that reproduce this and the  
> MySQL error you previously reported. I have not seen these problems  
> before myself. I don't know if you do, but notice that sharing a  
> Connection, PreparedStatement or ResultSet between threads is not  
> thread-safe and will open a can of worms.

That I dont do, afaik. I always fetch a connection, execute, handle
result, and return the connection within a single thread. I will double
check, but I've hardly begun using threads so there's not many places to
look. Also, the postgres driver is much more stable at the moment. I'm
still seeing some crashes there as well, but those are few and very far
between, but also point to Connection_clear.



> 
> 
> On 5. april. 2008, at 16.59, Paul J Stevens wrote:
>> Dont shoot the messenger plz :-)
>>
>> running some tests using sqlite I'm getting what appears to be stack
>> corruption:
>>
>>
>>
>> (gdb) bt
>> #0  0xffffe410 in __kernel_vsyscall ()
>> #1  0xb78cbf75 in raise () from /lib/tls/i686/cmov/libc.so.6
>> #2  0xb78cd8f1 in abort () from /lib/tls/i686/cmov/libc.so.6
>> #3  0xb7d01b95 in Util_abort (e=0xb7d102a0 "MemoryException -- %s at  
>> %s
>> in line %d\n") at src/util/Util.c:83
>> #4  0xb7d023d2 in Mem_resize (p=0x5316e008, size=1665138688,
>> file=0xb7d214c0 "src/util/StringBuffer.c", line=61) at src/util/ 
>> Mem.c:76
>> #5  0xb7d07c29 in StringBuffer_vappend (S=0x8115438, s=0x81008c0  
>> "UPDATE
>> OR IGNORE dbmail_mailboxes SET mtime=STRFTIME('%Y-%m-%d
>> %H:%M:%S','now','localtime') WHERE mailbox_idnr=2",
>>    ap=0xbfe38778 "{z\t\b��\t\b�") at src/util/StringBuffer.c:61
>> #6  0xb7d0e88f in SQLiteConnection_execute (C=0x8115de8, sql=0x81008c0
>> "UPDATE OR IGNORE dbmail_mailboxes SET mtime=STRFTIME('%Y-%m-%d
>> %H:%M:%S','now','localtime') WHERE mailbox_idnr=2",
>>    ap=0xbfe38778 "{z\t\b��\t\b�") at src/db/sqlite/ 
>> SQLiteConnection.c:174
>>
>>
>>
>> any ideas?
> 
> --
> To unsubscribe:
> http://www.tildeslash.com/mailman/listinfo/libzdb-general


-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl