libzdb-general

libzdb-general@tildeslash.com

148 discussions

support for other databases
by Uwe Kiewel 04 Dec '08

04 Dec '08

Hi, do you plan to implement support for other databases? An interface to sqlrelay and/or DB2 would be fine. Kind regards, Uwe

2 1

[Announce] libzdb 2.2.3
by Jan-Henrik Haukeland 30 Jul '08

30 Jul '08

Version 2.2.3 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.3.tar.gz MD5 checksum: a2a79dfbafa10a20d2cf0edfb5d5795e libzdb-2.2.3.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a bug fix release which has been tested on the following platforms: Darwin 9.4.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Note, this release should fix problems with SQLite database locks. As you probably know, SQLite locks the database file on certain operations. This is a problem when two or more connections tries to update the SQLite database at the same time, since only one connection will succeed. There are ways around this problem and the strategy we use in libzdb is to retry the statement whenever a database lock is encountered. Unfortunately the retry code had a bug which prevented it to run more than one time. This is now fixed and libzdb will handle concurrent usage of SQLite much better. Changes in this release: Version 2.2.3 ------------- Bug fixes: * Make sure connection properties, max rows and query timeout are reset on Connection_close(), if changed. * Ensure that timeout is set for new Connections and fixed a bug in the SQLite retry macro so the SQLite driver now will retry executing on database lock

1 0

[Announce] libzdb 2.2.2
by Jan-Henrik Haukeland 08 Jun '08

08 Jun '08

Version 2.2.2 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.2.tar.gz MD5 checksum: 756e148181b8f108a8a586dbd0a25b0c libzdb-2.2.2.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a non-critical minor bug fix release which has been tested on the following platforms: Darwin 9.3.0 [ppc/x86] Linux FC/U [x86/x64] FreeBSD [x86] Changes in this release: Version 2.2.2 ------------- * Ensure that reaper progress forward and remove all connections it can * Fixed a va_copy bug on 64 bits systems

1 0

[Announce] libzdb 2.2.1
by Jan-Henrik Haukeland 04 May '08

04 May '08

Version 2.2.1 of Zild Database Library is available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-2.2.1.tar.gz MD5 checksum: 20c6bceae77f9e358e19b3ca4283afa1 libzdb-2.2.1.tar.gz Change log: http://www.tildeslash.com/libzdb/dist/CHANGES.txt This is a bug fix release which has been tested on the following platforms: Darwin 9.2.2 [ppc/x86] Linux FC/U [x86] Changes in this release: Version 2.2.1 ------------- * SQLite: Improved error reporting by using sqlite3_prepare_v2() when available. Thanks to Paul Stevens for suggesting this. Bug fixes: * MySQL and PostgreSQL: Fixed off-by-one count when verifying validity of parameter and column index. Thanks to Paul Stevens for bug report. * MySQL: Workaround mysql column truncation bug. Thanks to Paul Stevens for bug report.

1 0

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

[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

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