libzdb-general April 2008

libzdb-general@tildeslash.com

2 participants
4 discussions

Connection_lastRowId on postgresql
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, This call always returns 0 on a postgresql connection. I assume this is because my tables are without OIDs. Is that intentional? I can work around it. But perhaps a small note in the api docs would be in order? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 15

ensureCapacity
by Paul J Stevens 03 May '08

03 May '08

Jan-Henrik, Found some time today to do more testing on a problem I was still having with the mysql driver (the postgres driver is kicking ass). I suspect there is still a problem in ensureCapacity (or it's consumers). I'm attaching a small program that will reliably reproduce this. Looks like strings from the /first/ row (and only the first row) retrieved from a resultset are still being truncated at 256 char length. tested against yesterdays svn-rev. thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

more segfaults (sqlite this time)
by Paul J Stevens 25 Apr '08

25 Apr '08

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? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 7

segfaults in ResultSet_free
by Paul J Stevens 07 Apr '08

07 Apr '08

Jan-Henrik, I've started using threads in my application and now the mysql driver starts to segfault: Starting program: /home/paul/git/dbmail/src/dbmail-imapd -D [Thread debugging using libthread_db enabled] [New process 27692] [New Thread -1217631440 (LWP 27692)] [New Thread -1218696304 (LWP 27694)] [Thread -1218696304 (LWP 27694) exited] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1217631440 (LWP 27692)] 0xb7d80175 in ResultSet_free (R=0x81526e4) at src/db/ResultSet.c:65 65 (*R)->op->free(&(*R)->I); this only happens when I use the mysql driver. The postgres driver has exhibited some infrequent crashes but those have been very difficult to reproduce. My guess is it has to do with the query involved: INSERT IGNORE INTO dbmail_headername (headername) VALUES (?) a construct not used for postgres. Perhaps this type of query affects the kind of MYSQL_RES returned. I'm not sure. I'll try to investigate myself. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 3

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general April 2008