Bug#383700: Bug #384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD
On Thu, Aug 24, 2006 at 02:02:43AM +0200, Christian Hammers wrote:
> Some users of the Debian packages I create recently reported that after the
> upgrade from MySQL 5.0.22 to 5.0.24 Perl scripts that try to explicitly set
> $dbh->{AutoCommit} = 0;
> die with the error message:
> "Transactions not supported by database"
Hi,
this bug (#384047) is also at least #384221 (libdbd-mysql-perl) and
#383700 (request-tracker3.4).
I believe the problem is an incompatible ABI change in
libmysqlclient.15.so with version 5.0.24.
This addition in struct st_mysql_options:
--- mysql-dfsg-5.0-5.0.22/include/mysql.h 2006-05-25 11:56:42.0
+0300
+++ mysql-dfsg-5.0-5.0.24/include/mysql.h 2006-07-27 21:52:03.0
+0300
@@ -164,6 +164,7 @@
char *ssl_ca;/* PEM CA file */
char *ssl_capath;/* PEM directory of CA-s? */
char *ssl_cipher;/* cipher to use */
+ my_bool ssl_verify_server_cert; /* if to verify server cert */
char *shared_memory_base_name;
unsigned long max_allowed_packet;
my_bool use_ssl; /* if to use SSL or not */
causes the size of st_mysql_options to grow. This also affects the MYSQL
struct, since it contains st_mysql_options.
Now, libdbd-mysql-perl has this in dbdimp.h:
struct imp_dbh_st {
dbih_dbc_t com; /* MUST be first element in structure */
MYSQL mysql;
int has_transactions; /* boolean indicating support for
* transactions, currently always
* TRUE for MySQL and always FALSE
* for mSQL.
*/
[...]
so the grown MYSQL struct overlaps with has_transactions.
This hits libdbd-mysql-perl 3.006-1, which is currently compiled
against libmysqlclient15off-dev 5.0.22-x (with x depending on
the architecture). When run with libmysqlclient15off 5.0.24-1,
has_transactions gets reset to 0 and the result is 'Transactions not
supported by database'. Recompiling libdbd-mysql-perl helps, as the API
has not changed in an incompatible way.
In my understanding, the right fix is to bump the soname or to revert
the struct st_mysql_options change.
Cheers,
--
Niko Tyni [EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Processed: Re: Bug#384047: Bug #384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD
Processing commands for [EMAIL PROTECTED]: > forward 384047 http://bugs.mysql.com/21829 Unknown command or malformed arguments to command. > forward 384221 http://bugs.mysql.com/21829 Unknown command or malformed arguments to command. > forward 383700 http://bugs.mysql.com/21829 Unknown command or malformed arguments to command. > tags 384047 + upstream confirmed Bug#384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD Tags were: confirmed upstream Tags added: upstream, confirmed > tags 384221 + upstream confirmed Bug#384221: libdbd-mysql-perl: Transactions not supported by database There were no tags set. Tags added: upstream, confirmed > tags 383700 + upstream confirmed Bug#383700: request-tracker3.4: AutoCommit croak in RT while trying to Resolve ticket There were no tags set. Tags added: upstream, confirmed > stop Stopping processing here. Please contact me if you need assistance. Debian bug tracking system administrator (administrator, Debian Bugs database) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#383700: Bug#384047: Bug #384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD
forward 384047 http://bugs.mysql.com/21829 forward 384221 http://bugs.mysql.com/21829 forward 383700 http://bugs.mysql.com/21829 tags 384047 + upstream confirmed tags 384221 + upstream confirmed tags 383700 + upstream confirmed stop Hello Niko Thanks for this analysis, I've opened a "critical" bug at mysql and forwarded your mail to it. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Processed: Re: Processed: Re: Bug#384047: Bug #384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD
Processing commands for [EMAIL PROTECTED]: > forwarded 384047 http://bugs.mysql.com/21829 Bug#384047: mysql-server-5.0: "Transactions not supported by database" error when used with perl DBI/DBD Forwarded-to-address changed from [EMAIL PROTECTED] to http://bugs.mysql.com/21829. > forwarded 384221 http://bugs.mysql.com/21829 Bug#384221: libdbd-mysql-perl: Transactions not supported by database Noted your statement that Bug has been forwarded to http://bugs.mysql.com/21829. > forwarded 383700 http://bugs.mysql.com/21829 Bug#383700: request-tracker3.4: AutoCommit croak in RT while trying to Resolve ticket Noted your statement that Bug has been forwarded to http://bugs.mysql.com/21829. > End of message, stopping processing here. Please contact me if you need assistance. Debian bug tracking system administrator (administrator, Debian Bugs database) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#369418: marked as done (falselogin: segfaults when no waiting time is specified)
Your message dated Fri, 25 Aug 2006 07:02:15 -0700 with message-id <[EMAIL PROTECTED]> and subject line Bug#369418: fixed in falselogin 0.3-1 has caused the attached Bug report to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database) --- Begin Message --- Package: falselogin Version: 0.2-5 Severity: normal When no waiting time is specified (refer to man falselogin), falselogin in current unstable version will segfault after showing the normal output. If time is specified (i.e., 1) or "enter" string is passed, it will work as expected. Decimal numbers are also working. Jose -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.15.2 Locale: LANG=es_VE, LC_CTYPE=es_VE (charmap=ISO-8859-1) Versions of packages falselogin depends on: ii libc6 2.3.6-9GNU C Library: Shared libraries falselogin recommends no packages. -- no debconf information --- End Message --- --- Begin Message --- Source: falselogin Source-Version: 0.3-1 We believe that the bug you reported is fixed in the latest version of falselogin, which is due to be installed in the Debian FTP archive: falselogin_0.3-1.diff.gz to pool/main/f/falselogin/falselogin_0.3-1.diff.gz falselogin_0.3-1.dsc to pool/main/f/falselogin/falselogin_0.3-1.dsc falselogin_0.3-1_i386.deb to pool/main/f/falselogin/falselogin_0.3-1_i386.deb falselogin_0.3.orig.tar.gz to pool/main/f/falselogin/falselogin_0.3.orig.tar.gz A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Jose Parrella <[EMAIL PROTECTED]> (supplier of updated falselogin package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Format: 1.7 Date: Wed, 23 Aug 2006 00:14:27 -0400 Source: falselogin Binary: falselogin Architecture: source i386 Version: 0.3-1 Distribution: unstable Urgency: low Maintainer: Jose Parrella <[EMAIL PROTECTED]> Changed-By: Jose Parrella <[EMAIL PROTECTED]> Description: falselogin - false login shell Closes: 358516 369418 Changes: falselogin (0.3-1) unstable; urgency=low . * New maintainer. Closes: #358516. * Uploaded through sponsor Thaddeus H. Black <[EMAIL PROTECTED]>. * Removed Build-depends on Etch/Sid debhelper. * In falselogin.c: - Solved segfault when arguments of --wait are not completely specified. Closes: #369418. - Solved segfault when no mailbox is found for user. - Changed %mail% usage so now it will be substituted only by the number of mails, allowing the user to i18n the mail message. - Moved mail counting to a separate function so now it will be called if it's really needed in the conffile. - Moved calls to other functions into control structures so they will now be invoked if they're really needed. - Switched to strgsub in order to avoid possible buffer overruns. - Switched to getline to avoid undesirable line-handling issues. * Added debian/upstream.pl which produces new upstream orig files. * Updated manpage reflecting new behaviours. * Conforms to Standards version 3.7.2. (no changes) Files: 6723e6a6f8b98e3d11459b13a9af1f5f 590 utils optional falselogin_0.3-1.dsc f3d02bc2fd835018ac7b2a7c0cf7ef57 3361 utils optional falselogin_0.3.orig.tar.gz 523ea1fb9252ff162c2e12e5ac6acb82 3787 utils optional falselogin_0.3-1.diff.gz 32029194a5db73050bb45edb23b8d7e7 8514 utils optional falselogin_0.3-1_i386.deb -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFE7v9ch3E0gzgBXn4RAuxhAJ99R6aYLZYxR0oKAPwjNyFwu4TlMACgw2jp Sg47YkEy+VVWy24rJSC1Hxg= =F59b -END PGP SIGNATURE- --- End Message ---
Processing of haskelldb_0.9.cvs.601-11_i386.changes
haskelldb_0.9.cvs.601-11_i386.changes uploaded successfully to localhost along with the files: haskelldb_0.9.cvs.601-11.dsc haskelldb_0.9.cvs.601-11.diff.gz libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb haskelldb-bin_0.9.cvs.601-11_i386.deb Greetings, Your Debian queue daemon -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#383533: libghc6-haskelldb-dev: curious version number in dependency
Hola Arjan Oosting! > Marga, as you uploaded the last version of haskelldb for me, could you > upload this simple fix as well? Uploaded -- Love, Marga. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
haskelldb_0.9.cvs.601-11_i386.changes ACCEPTED
Accepted: haskelldb-bin_0.9.cvs.601-11_i386.deb to pool/main/h/haskelldb/haskelldb-bin_0.9.cvs.601-11_i386.deb haskelldb_0.9.cvs.601-11.diff.gz to pool/main/h/haskelldb/haskelldb_0.9.cvs.601-11.diff.gz haskelldb_0.9.cvs.601-11.dsc to pool/main/h/haskelldb/haskelldb_0.9.cvs.601-11.dsc libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb to pool/main/h/haskelldb/libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb Override entries for your package: haskelldb-bin_0.9.cvs.601-11_i386.deb - optional devel haskelldb_0.9.cvs.601-11.dsc - source devel libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb - optional libdevel Announcing to debian-devel-changes@lists.debian.org Closing bugs: 383533 Thank you for your contribution to Debian. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#383533: marked as done (libghc6-haskelldb-dev: curious version number in dependency)
Your message dated Fri, 25 Aug 2006 14:19:56 -0700 with message-id <[EMAIL PROTECTED]> and subject line Bug#383533: fixed in haskelldb 0.9.cvs.601-11 has caused the attached Bug report to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database) --- Begin Message --- Package: libghc6-haskelldb-dev Version: 0.9.cvs.601-10 This version of the package has a dependency header that looks like this (in part): Depends: libghc6-hsql-dev (>= 1.6), libghc6-hsql-dev (<< ++) Although "++" seems to be strictly according to the syntax in Policy (even if it doesn't start with a digit), but I suspect it is not what is meant here. -- I've never seen anyone wear a Freudian slip. --- End Message --- --- Begin Message --- Source: haskelldb Source-Version: 0.9.cvs.601-11 We believe that the bug you reported is fixed in the latest version of haskelldb, which is due to be installed in the Debian FTP archive: haskelldb-bin_0.9.cvs.601-11_i386.deb to pool/main/h/haskelldb/haskelldb-bin_0.9.cvs.601-11_i386.deb haskelldb_0.9.cvs.601-11.diff.gz to pool/main/h/haskelldb/haskelldb_0.9.cvs.601-11.diff.gz haskelldb_0.9.cvs.601-11.dsc to pool/main/h/haskelldb/haskelldb_0.9.cvs.601-11.dsc libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb to pool/main/h/haskelldb/libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Arjan Oosting <[EMAIL PROTECTED]> (supplier of updated haskelldb package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Format: 1.7 Date: Thu, 24 Aug 2006 13:49:53 +0200 Source: haskelldb Binary: haskelldb-bin libghc6-haskelldb-dev Architecture: source i386 Version: 0.9.cvs.601-11 Distribution: unstable Urgency: low Maintainer: Debian QA Group <[EMAIL PROTECTED]> Changed-By: Arjan Oosting <[EMAIL PROTECTED]> Description: haskelldb-bin - Utilities for use with HaskellDB libghc6-haskelldb-dev - Haskell library for expressing database queries Closes: 383533 Changes: haskelldb (0.9.cvs.601-11) unstable; urgency=low . * QA upload. * debian/control: Fix typo in substitution variable which caused a strange version number. (Closes: #383533) Files: 6d2c02c1d143ca38b63beed4a2b3fa43 814 devel optional haskelldb_0.9.cvs.601-11.dsc bd499f5b7c32e0ae148cff05f1a2e50d 4394 devel optional haskelldb_0.9.cvs.601-11.diff.gz 595fef991b6034aa71dc51d512a06faf 1142824 libdevel optional libghc6-haskelldb-dev_0.9.cvs.601-11_i386.deb a8f2f82fed40c67993c3489d47664a44 606114 devel optional haskelldb-bin_0.9.cvs.601-11_i386.deb -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQFE71R7lAuUx1tI/64RAtL3AJ0Y2dT4r1+E/61KC1h47tosi4UN6wCeP9qG vznNQ5Izmb1cr41Bdd/Guns= =HWaL -END PGP SIGNATURE- --- End Message ---
swingwt_0.87-5_i386.changes ACCEPTED
Accepted: libswingwt-dev_0.87-5_all.deb to pool/main/s/swingwt/libswingwt-dev_0.87-5_all.deb libswingwt-java_0.87-5_all.deb to pool/main/s/swingwt/libswingwt-java_0.87-5_all.deb libswingwt0_0.87-5_i386.deb to pool/main/s/swingwt/libswingwt0_0.87-5_i386.deb swingwt-demo_0.87-5_i386.deb to pool/main/s/swingwt/swingwt-demo_0.87-5_i386.deb swingwt_0.87-5.diff.gz to pool/main/s/swingwt/swingwt_0.87-5.diff.gz swingwt_0.87-5.dsc to pool/main/s/swingwt/swingwt_0.87-5.dsc Override entries for your package: libswingwt-dev_0.87-5_all.deb - optional libdevel libswingwt-java_0.87-5_all.deb - optional libs libswingwt0_0.87-5_i386.deb - optional libs swingwt-demo_0.87-5_i386.deb - optional devel swingwt_0.87-5.dsc - source libs Announcing to debian-devel-changes@lists.debian.org Thank you for your contribution to Debian. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Processing of swingwt_0.87-5_i386.changes
swingwt_0.87-5_i386.changes uploaded successfully to localhost along with the files: swingwt_0.87-5.dsc swingwt_0.87-5.diff.gz libswingwt-dev_0.87-5_all.deb libswingwt-java_0.87-5_all.deb libswingwt0_0.87-5_i386.deb swingwt-demo_0.87-5_i386.deb Greetings, Your Debian queue daemon -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#383700: marked as done (request-tracker3.4: AutoCommit croak in RT while trying to Resolve ticket)
Your message dated Fri, 25 Aug 2006 20:02:17 -0700 with message-id <[EMAIL PROTECTED]> and subject line Bug#383700: fixed in mysql-dfsg-5.0 5.0.24-2 has caused the attached Bug report to be marked as done. This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database) --- Begin Message --- Package: request-tracker3.4 Version: 3.4.4-3 Severity: important Hi all, I have just upgrade my debian and Request-Tracker cry while I want to Resolve or Comment a ticket. He say it was a problem which Perl DBD and an option AutoCommit. (I don't have the exact error, sorry). I use a MySQL Database. After looking on Internet, I have download the source package of libdbd-mysql-perl-3.0006, rebuild it (dpkg-buildpackage) and install it. With these actions, the problem disappeared. So I don't sure if it's a good idea to post the bug here but I have encoutered it with RT and I don't know where to post it. Regards, -- Package-specific info: Changed files: -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.16.14 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-1) (ignored: LC_ALL set to fr_FR) Versions of packages request-tracker3.4 depends on: ii libapache-session-perl 1.81-1 Perl modules for keeping persisten ii libcache-cache-perl 1.05-1 Managed caches of persistent infor ii libcache-simple-timedexpiry- 0.21-1 Perl module to cache and expire ke ii libclass-returnvalue-perl0.53-1 A return-value object that lets yo ii libdbd-mysql-perl3.0006-1A Perl5 database interface to the ii libdbd-pg-perl 1.49-1 a PostgreSQL interface for Perl 5 ii libdbi-perl 1.51-2 Perl5 database interface by Tim Bu ii libdbix-searchbuilder-perl 1.43-1 Encapsulate SQL queries and rows i ii libexception-class-perl 1.21-1 a module that allows you to declar ii libfcgi-perl 0.67-2 FastCGI Perl module ii libfreezethaw-perl 0.43-3 converting Perl structures to stri ii libhtml-mason-perl 1:1.33-2HTML::Mason Perl module ii libhtml-parser-perl 3.55-1 A collection of modules that parse ii libhtml-scrubber-perl0.08-3 Perl extension for scrubbing/sanit ii liblocale-maketext-fuzzy-per 0.02-2 Maketext from already interpolated ii liblocale-maketext-lexicon-p 0.62-1 Lexicon-handling backends for "Loc ii liblog-dispatch-perl 2.11-1 Dispatches messages to multiple Lo ii libmailtools-perl1.74-0.1Manipulate email in perl programs ii libmime-perl 5.420-0.1 Perl5 modules for MIME-compliant m ii libmldbm-perl2.01-1 Store multidimensional hash struct ii libmodule-versions-report-pe 1.02-2 Report versions of all modules in ii libparams-validate-perl 0.77-1 validate parameters to Perl method ii libregexp-common-perl2.120-1 Provide commonly requested regular ii libterm-readkey-perl 2.30-3 A perl module for simple terminal ii libtest-inline-perl 2.103-1 Perl extension for embed tests and ii libtext-autoformat-perl 1.13-1 Perl module for automatic text wra ii libtext-quoted-perl 1.8-2 Extract the structure of a quoted ii libtext-template-perl1.44-1.1Text::Template perl module ii libtext-wikiformat-perl 0.76-1 translates Wiki formatted text int ii libtext-wrapper-perl 1.000-2 Simple word wrapping routine ii libtime-modules-perl 2003.1126-2 Various Perl modules for time/date ii libtree-simple-perl 1.16-1 A simple tree object ii libxml-rss-perl 1.05-1 Perl module for managing RSS (RDF ii libxml-simple-perl 2.14-4 Perl module for reading and writin ii perl 5.8.8-6.1 Larry Wall's Practical Extraction ii postfix [mail-transport-agen 2.3.2-1 A high-performance mail transport ii rt3.4-apache23.4.4-3 Apache 2 specific files for reques ii rt3.4-clients3.4.4-3 Mail gateway and command-line inte ii sysklogd [system-log-daemon] 1.4.1-18System Logging Daemon Versions of packages request-tracker3.4 recommends: ii mysql-server 5.0.24-1 mysql database server (current ver ii mysql-server-5.0 [mysql-serve 5.0.24-1 mysql database server binaries -- no debconf information --- End Message -
