libzdb-general

libzdb-general@tildeslash.com

1 participants
152 discussions

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

[Announce] libzdb 2.2
by Jan-Henrik Haukeland 28 Mar '08

28 Mar '08

Version 2.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.tar.gz MD5 checksum: 3a1677704ce3821c53d6d0ae7b98dbb5 libzdb-2.2.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature and bug fix release which has been tested on the following platforms: Darwin 8.8.1 [ppc/x86] Linux FC/U [x86] Changes in this release: Version 2.2 ----------- * Detailed error message added to exception. In an exception handler, the variable Exception_frame.message, now provides an alternative to Connection_getLastError() for obtaining the latest error message * From this release, building with exceptions handling is no longer optional but required * Internal optimizing changes Bug fixes: * Fixed Connection_prepareStatement() error reported on a PostgreSQL Connection. Thanks to Paul Stevens for bug report. * MySQL: Fixed error in ResultSet_getBlob() and ResultSet_getString() which lead to a segfault when trying to obtain "large" strings and blobs. Again thanks to Paul Stevens. * PostgreSQL: Fixed the "syntax error at character 12" for prepared statemen deallocation. Thanks to Paul Stevens for bug report.

1 0

errors during Connection_clear/Connection_close
by Paul J Stevens 27 Mar '08

27 Mar '08

Hi there, me again :-) Whenever I close a connection that holds a prepared statement, the postgres backend logs an error like this: 2008-03-20 09:49:54 CET LOG: execute 1804289383: select user_idnr from dbmail_users where userid=$1 2008-03-20 09:49:54 CET DETAIL: parameters: $1 = 'testuser1' 2008-03-20 09:49:54 CET ERROR: syntax error at or near "1804289383" at character 12 2008-03-20 09:49:54 CET STATEMENT: DEALLOCATE 1804289383; it's *always* at character 12, where of course the stmt ID varies. It only occurs when I close the connection, I assume because that triggers a Connection_clear, which releases the statements. This doesn't appear to affect functionality, but it doesn't exactly inspire confidence either, I suppose. Any ideas? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 1

segfaults in mysql driver
by Paul J Stevens 22 Mar '08

22 Mar '08

Jan-Henrik, I'm running into some problems with the mysql backend. I can't seem to retrieve long-ish strings. The attached code will reliably segfault on my systems. This code does *not* fail on Postgresql. Am I doing something wrong? thanks, -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

3 12

svn repository
by Jan-Henrik Haukeland 21 Mar '08

21 Mar '08

FYI: libzdb svn repository is available here http://code.google.com/p/libzdb/source/checkout

2 5

how to deal with longjmp warnings
by Paul J Stevens 12 Mar '08

12 Mar '08

Hi there, I'm busy adding try/catch macros around all my queries, but now my compiler starts to complain: warning: variable 'xyz' might be clobbered by 'longjmp' or 'vfork' Any suggestion on how best to deal with these? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 2

[Announce] libzdb 2.1
by Jan-Henrik Haukeland 04 Mar '08

04 Mar '08

Version 2.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.1.tar.gz MD5 checksum: 5abec56051f105cacb6dcec237a1d989 Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a feature release which has been tested on the following platforms: Darwin 9.1.0 [ppc/x86] Linux Ubuntu [x86] Changes in this release: Version 2.1 ----------- * API: Connection_ping is promoted to a public method. Clients can use this method to test if a Connection is alive. * API: Connection_clear() is exposed as a public method. Normally it is not necessary to call this method, but in some situations, if you use PreparedStatement_executeQuery it is necessary to call this function to close a prepared statement explicit. Basically, if you see this SQLite error, "SQL statements in progress", call this function to close any previous opened statements before proceeding. * Upon returning a Connection, the Connection Pool previously tried to commit a Connection if it was in a non-committed state, while now it rollback instead, which is assumed to be more correct. * Improved retry when SQLite report database lock, which should reduce the chance to meet the infamous SQLite "database is locked" error * Removed section 3 from "Tildeslash License Exception" so libzdb is licensed clear and permissive. * Internal optimizing changes

3 12

postgres wont do preparedstatements
by Paul J Stevens 25 Feb '08

25 Feb '08

Jan-Henrik, So I converted dbmail to use libzdb, and use prepared statements. But I can't seem to get prepared statements to work for postgresql. Sqlite and mysql work as expected by postgres keeps throwing exceptions. My test code reads: //URL_T url = \ URL_new("postgresql://localhost:5432/dbmail?user=dbmail&password=dbmail"); URL_T url = URL_new("postgresql://dbmail:dbmail@localhost/dbmail"); ConnectionPool_T pool = ConnectionPool_new(url); Connection_T con = ConnectionPool_getConnection(pool); PreparedStatement_T p = Connection_prepareStatement(con, "SELECT * FROM dbmail_users WHERE userid=?"); THis keeps throwing exception at: Uncaught exception SQLException raised in Connection_prepareStatement at src/db/Connection.c:294 On the postgres side all I see is: 2008-02-23 09:46:48 CET DEBUG: parse 1804289383: SELECT * FROM dbmail_users WHERE userid=$1 2008-02-23 09:46:48 CET DEBUG: StartTransactionCommand 2008-02-23 09:46:48 CET DEBUG: StartTransaction 2008-02-23 09:46:48 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 2270118/1/0, nestlvl: 1, children: <> 2008-02-23 09:46:48 CET DEBUG: CommitTransactionCommand 2008-02-23 09:46:48 CET DEBUG: CommitTransaction 2008-02-23 09:46:48 CET DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 2270118/1/1, nestlvl: 1, children: <> 2008-02-23 09:46:48 CET LOG: unexpected EOF on client connection Any ideas? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl

2 8

[Announce] libzdb 2.0.1
by Jan-Henrik Haukeland 10 Jun '07

10 Jun '07

Version 2.0.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.0.1.tar.gz MD5 checksum: ce379f198aa3a1ab1a6e4699ebccd683 libzdb-2.0.1.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a minor feature release which has been tested on the following platforms: Darwin 8.8.1 [ppc/x86] Linux FC [x86] Changes in this release: Version 2.0.1 ----------- * ConnectionPool_version() is now a class method * Minor internal changes Future plans include adding date/time handling to ResultSet and PreparedStatements.

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general