110363 2005-10-24 12:32 0000 Out of memory errors with DBD-mysql-3.0002_p3 2006-05-31 16:59:01 0000 1 1 1 Unclassified Gentoo Linux Applications 2005.0 All Linux RESOLVED FIXED P2 normal --- 1 corporate_gadfly@hotmail.com perl@gentoo.org mmokrejs@ribosome.natur.cuni.cz corporate_gadfly@hotmail.com 2005-10-24 12:32:27 0000 After upgrading from DBD-mysql 2.9007 to 3.0002_p3, a local bugzilla installation running with mysql broke completely. I was able to isolate it with a simple test case which was failing under 3.0002_p3 and running fine with 2.9007. I will attach the script immediately after this comment. It was dying with the following errors. Out of memory! Out of memory! Callback called exit. Some version numbers: DBI-1.48 DBD-mysql-2.9007 perl-5.8.7-r1 gcc-3.4.4-r1 mysql-4.1.14 I would suggest not making 3.0002_p3 for a *long* time. corporate_gadfly@hotmail.com 2005-10-24 12:33:48 0000 Created an attachment (id=71351) Test script for retrieving data from mysql (actually a query from bugzilla) corporate_gadfly@hotmail.com 2005-10-24 12:35:14 0000 Created an attachment (id=71352) Test script for retrieving data from mysql (actually a query from bugzilla) corporate_gadfly@hotmail.com 2005-10-24 12:36:31 0000 Created an attachment (id=71353) emerge --info corporate_gadfly@hotmail.com 2005-10-24 12:42:40 0000 (In reply to comment #3) > Created an attachment (id=71353) [edit] > emerge --info > I toned down my CFLAGS and CXXFLAGS to "-march=pentium4 -Os -pipe" with no change whatsoever. 3.0002_p3 still fails. phantom4@gmx.net 2005-11-01 04:12:40 0000 I've got the same problem here. After changing the bugzilla installation to another server (with mysql v5.0.15) i can't get it running here. Bugzilla checksetup.pl shows an "out of memory!" error. The testscript shows the same "out of memory!" error. emerge --info System uname: 2.6.14-gentoo i686 Pentium III (Katmai) Gentoo Base System version 1.12.0_pre9 ccache version 2.4 [enabled] dev-lang/python: 2.4.2 sys-apps/sandbox: 1.2.13 sys-devel/autoconf: 2.13, 2.59-r7 sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1 sys-devel/binutils: 2.16.1 sys-devel/libtool: 1.5.20 virtual/os-headers: 2.6.11-r2 ACCEPT_KEYWORDS="x86 ~x86" AUTOCLEAN="yes" CBUILD="i686-pc-linux-gnu" CFLAGS="-O2 -march=pentium3 -fomit-frame-pointer -pipe" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-O2 -march=pentium3 -fomit-frame-pointer -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="autoconfig ccache distlocks sandbox sfperms strict" GENTOO_MIRRORS="ftp://pegasus.gfs" LANG="de_DE@euro" LC_ALL="de_DE@euro" LINGUAS="de" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://pegasus.gfs/gentoo-portage" USE="x86 7zip acpi aim alsa apache2 apm arts avi berkdb bitmap-fonts bzip2 ccache cgi clamav clamd cli command-args crypt curl curlwrappers discard-path eds elf emboss encode extensions fam foomaticdb force-cgi-redirect fortran ftp gd gdbm gif gmp gnome gnutls gpm graphicsmagick graphviz gs gstreamer gtk2 gzip http icp icq imagemagick imap imlib irc jabber jbig john jp2 jpeg jpeg2k kde ldap libclamav libg++ libwww lzo lzw mad mbox md5sum mhash mikmod mime mmx mng motif mp3 mpeg msn mysql mysqli nagios-dns nagios-game nagios-ntp nagios-ping nagios-ssh ncurses netpbm nfs nis nls nocd ntlm ogg oggvorbis opengl oscar oss pam pcre pdflib pear perl php png postgres python qt quicktime quotas rar readline samba sasl session silc slang smtp snmp sockets spell sse ssl svg symlink syslog tcpd test tetex threads tiff tokenizer tos truetype truetype-fonts type1-fonts udev unicode ups userlocales vhosts vorbis webdav wmf xml xml2 xmlrpc xmms xsl xv yahoo zip zlib linguas_de userland_GNU kernel_linux elibc_glibc" Unset: ASFLAGS, CTARGET, LDFLAGS eroper@wanfear.com 2005-11-17 15:57:51 0000 (In reply to comment #0) Just dropping in to comment that this version of DBD-mysql also broke my Maia Mailguard installation. Rolling back DBD-mysql resolved the issue. thomas.scheiblauer@hauptversammlung.at 2005-11-26 01:38:46 0000 I've also had problems with this release. 3.0002_p3 segfaults when used by zmaudit.pl (Zoneminder http://www.zoneminder.com). I was able to pin it down to the execute call within the following code excerpt. Within this call it segfaults after a few loops in a non-deterministic fashion. It works perfectly with the previous ebuild of DBD-mysql. +++ code excerpt my $db_monitors; my $sql1 = "select Id from Monitors order by Id"; my $sth1 = $dbh->prepare_cached( $sql1 ) or die( "Can't prepare '$sql1': ".$dbh->errstr() ); my $sql2 = "select Id, (unix_timestamp() - unix_timestamp(StartTime)) as Age from Events where MonitorId = ? order by Id"; my $sth2 = $dbh->prepare_cached( $sql2 ) or die( "Can't prepare '$sql2': ".$dbh->errstr() ); my $res = $sth1->execute() or die( "Can't execute: ".$sth1->errstr() ); while( my $monitor = $sth1->fetchrow_hashref() ) { Debug( "Found database monitor '$monitor->{Id}'" ); my $db_events = $db_monitors->{$monitor->{Id}} = {}; my $res = $sth2->execute( $monitor->{Id} ) or die( "Can't execute: ".$sth2->errstr() ); while ( my $event = $sth2->fetchrow_hashref() ) { $db_events->{$event->{Id}} = $event->{Age}; } Debug( "Got ".int(keys(%$db_events))." events\n" ); $sth2->finish(); } $sth1->finish(); +++ corporate_gadfly@hotmail.com 2005-11-26 13:32:04 0000 (In reply to comment #0) > I would suggest not making 3.0002_p3 for a *long* time. Oops... that's supposed to day "I would suggest not making 3.0002_p2 **stable** for a *long* time. mmokrejs@ribosome.natur.cuni.cz 2005-12-09 03:32:10 0000 Hi, I have same problem with bugzilla-2.20/checksetup.pl See my bugreport at https://bugzilla.mozilla.org/show_bug.cgi?id=297649 Solution is to use v3.0002 (haven't tried myself yet): http://groups.google.com.au/group/netscape.public.mozilla.webtools/browse_thread/thread/df6c6e5468c47fd2/52e14738b3cf2080?lnk=raot&hl=en corporate_gadfly@hotmail.com 2005-12-09 06:39:22 0000 (In reply to comment #9) > Hi, > I have same problem with bugzilla-2.20/checksetup.pl > See my bugreport at https://bugzilla.mozilla.org/show_bug.cgi?id=297649 > > Solution is to use v3.0002 (haven't tried myself yet): > http://groups.google.com.au/group/netscape.public.mozilla.webtools/browse_thread/thread/df6c6e5468c47fd2/52e14738b3cf2080?lnk=raot&hl=en Here are the release dates for the 3.0002 series. [DIR] DBD-mysql-3.0002/ 11-Jul-2005 09:46 - [DIR] DBD-mysql-3.0002_1/ 03-Aug-2005 19:47 - [DIR] DBD-mysql-3.0002_2/ 26-Sep-2005 16:15 - [DIR] DBD-mysql-3.0002_3/ 28-Sep-2005 11:46 - [DIR] DBD-mysql-3.0002_4/ 06-Nov-2005 13:40 - Can you report if downgrading to 3.0002 fixes the problem? corporate_gadfly@hotmail.com 2005-12-09 06:45:30 0000 (In reply to comment #10) > > Here are the release dates for the 3.0002 series. > > [DIR] DBD-mysql-3.0002/ 11-Jul-2005 09:46 - > [DIR] DBD-mysql-3.0002_1/ 03-Aug-2005 19:47 - > [DIR] DBD-mysql-3.0002_2/ 26-Sep-2005 16:15 - > [DIR] DBD-mysql-3.0002_3/ 28-Sep-2005 11:46 - > [DIR] DBD-mysql-3.0002_4/ 06-Nov-2005 13:40 - > > Can you report if downgrading to 3.0002 fixes the problem? > I tried it myself and there are no problems with 3.0002. Can the dev who added 3.0002_p3 to portage mask it please and instead add 3.0002 which seems to work fine? From the Changelog: *DBD-mysql-3.0002_p3 (16 Oct 2005) 16 Oct 2005; Francesco Riosa <vivo@gentoo.org> -DBD-mysql-2.9006.ebuild, +DBD-mysql-3.0002_p3.ebuild: version bump and clean-up mmokrejs@ribosome.natur.cuni.cz 2005-12-18 15:22:05 0000 Any news on the awaited ebuild? Thanks. ;-) mcummings@gentoo.org 2006-01-13 17:01:24 0000 did _p4 fix these issues at all? Its at the threshold of being open to being unmasked, but I don't want to unmask if it still causes you problems. In bug 112281, it resolved issues with a spamassassin session with mysql, but i want to confirm that isn't a fluke. thanks! mmokrejs@ribosome.natur.cuni.cz 2006-01-14 08:13:48 0000 The testcase attached to this bug breaks with DBD-mysql-3.0002_p4. The testcase really works with plain 3.002 (the mysql-5.0-new_bit_type.patch does not apply cleanly, so I ometted that from my test). Please introduce the DBD-mysql-3.0002.ebuild. mcummings@gentoo.org 2006-01-15 09:04:27 0000 3.0002 added to the tree, will mark stable in 30 days if there are no further reports against it corporate_gadfly@hotmail.com 2006-05-25 09:46:40 0000 (In reply to comment #15) > 3.0002 added to the tree, will mark stable in 30 days if there are no further > reports against it > If anyone is still following this bug, I had good luck with dev-perl/DBD-mysql-3.0004 when I upgraded to it recently. mcummings@gentoo.org 2006-05-27 13:18:11 0000 (In reply to comment #16) > If anyone is still following this bug, I had good luck with > dev-perl/DBD-mysql-3.0004 when I upgraded to it recently. > Yes, thanks! mmokrejs@ribosome.natur.cuni.cz 2006-05-31 16:59:01 0000 3.004 works for me as well. 71351 2005-10-24 12:33 0000 Test script for retrieving data from mysql (actually a query from bugzilla) test-mysql.pl text/plain IyEvdXNyL2Jpbi9wZXJsIC1UdwoKdXNlIHN0cmljdDsKdXNlIERCSTsKdXNlIERCRDo6bXlzcWw7 CgpteSAkZGJoOwoKZXZhbCB7CiAgICAkZGJoID0gREJJLT5jb25uZWN0KAogICAgICAgICdkYmk6 bXlzcWw6ZGF0YWJhc2U9YnVncycsICdidWdzJywgJ25vdGhpbmcnLAogICAgICAgIHsKICAgICAg ICAgICAgUmFpc2VFcnJvciAgPT4gMSwKICAgICAgICAgICAgUHJpbnRFcnJvciAgPT4gMCwKICAg ICAgICAgICAgQXV0b0NvbW1pdCAgPT4gMCwKICAgICAgICB9KTsKfTsKICAgICAgICAjIGRvIG5v dCBwcm9jZWVkIGFueSBmdXJ0aGVyIGlmIGNvbm5lY3Rpb24gdG8gZGF0YWJhc2UgaXMKICAgICAg ICAjIHVuc3VjY2Vzc2Z1bAppZiggJEAgKSB7CiAgICBkaWUgIkRhdGFiYXNlIGNvbm5lY3Rpb24g ZmFpbHVyZTogJEAiOwogICAgICAgIGV4aXQ7Cn0KCmV2YWwgewogICAgbXkgJHN0aCA9ICRkYmgt PnNlbGVjdHJvd19hcnJheSgiCiAgICAgICAgU0VMRUNUIHNjaGVtYV9kYXRhLCB2ZXJzaW9uIEZS T00gYnpfc2NoZW1hCiAgICAgICAgIik7CiAgICAkc3RoLT5maW5pc2g7Cn07CmlmKCAkQCApIHsK ICAgICRkYmgtPnJvbGxiYWNrOwogICAgJGRiaC0+ZGlzY29ubmVjdDsKICAgIGRpZSAkQDsKfQok ZGJoLT5kaXNjb25uZWN0Owo= 71352 2005-10-24 12:35 0000 Test script for retrieving data from mysql (actually a query from bugzilla) test-mysql.pl text/plain IyEvdXNyL2Jpbi9wZXJsIC1UdwoKdXNlIHN0cmljdDsKdXNlIERCSTsKdXNlIERCRDo6bXlzcWw7 CgpteSAkZGJoOwoKZXZhbCB7CiAgICAkZGJoID0gREJJLT5jb25uZWN0KAogICAgICAgICdkYmk6 bXlzcWw6ZGF0YWJhc2U9YnVncycsICdidWdzJywgJ25vdGhpbmcnLAogICAgICAgIHsKICAgICAg ICAgICAgUmFpc2VFcnJvciAgPT4gMSwKICAgICAgICAgICAgUHJpbnRFcnJvciAgPT4gMCwKICAg ICAgICAgICAgQXV0b0NvbW1pdCAgPT4gMCwKICAgICAgICB9KTsKfTsKICAgICAgICAjIGRvIG5v dCBwcm9jZWVkIGFueSBmdXJ0aGVyIGlmIGNvbm5lY3Rpb24gdG8gZGF0YWJhc2UgaXMKICAgICAg ICAjIHVuc3VjY2Vzc2Z1bAppZiggJEAgKSB7CiAgICBkaWUgIkRhdGFiYXNlIGNvbm5lY3Rpb24g ZmFpbHVyZTogJEAiOwogICAgICAgIGV4aXQ7Cn0KCm15KCAkZGF0YSwgJHZlcnNpb24gKTsKZXZh bCB7CiAgICAoICRkYXRhLCAkdmVyc2lvbiApID0gJGRiaC0+c2VsZWN0cm93X2FycmF5KCIKICAg ICAgICBTRUxFQ1Qgc2NoZW1hX2RhdGEsIHZlcnNpb24gRlJPTSBiel9zY2hlbWEKICAgICAgICAi KTsKfTsKaWYoICRAICkgewogICAgJGRiaC0+ZGlzY29ubmVjdDsKICAgIGRpZSAkQDsKfQokZGJo LT5kaXNjb25uZWN0OwoKcHJpbnQgJ1ZlcnNpb246ICcsICR2ZXJzaW9uLCAiXG4iOwo= 71353 2005-10-24 12:36 0000 emerge --info emerge-info.txt text/plain X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX18KCmNmZy11cGRhdGUgMS43LjEgOiBCdWlsZGluZyBjaGVj a3N1bSBpbmRleC4uLiAodGFrZXMgYSBmZXcgc2Vjb25kcykgIGRvbmUhCl9fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fCgpHZW50b28gQmFzZSBTeXN0ZW0gdmVyc2lvbiAxLjEyLjBfcHJlOQpQb3J0YWdl IDIuMC41M19yYzYgKGRlZmF1bHQtbGludXgveDg2LzIwMDUuMCwgZ2NjLTMuNC40LCBnbGliYy0y LjMuNS1yMiwgMi42LjEwLWNrNSBpNjg2KQo9PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQpTeXN0ZW0gdW5hbWU6IDIuNi4xMC1j azUgaTY4NiBJbnRlbChSKSBQZW50aXVtKFIpIDQgQ1BVIDIuNjBHSHoKZGlzdGNjIDIuMTguMyBp Njg2LXBjLWxpbnV4LWdudSAocHJvdG9jb2xzIDEgYW5kIDIpIChkZWZhdWx0IHBvcnQgMzYzMikg W2VuYWJsZWRdCmNjYWNoZSB2ZXJzaW9uIDIuNCBbZGlzYWJsZWRdCmRldi1sYW5nL3B5dGhvbjog ICAgIDIuMy41LCAyLjQuMgpzeXMtYXBwcy9zYW5kYm94OiAgICAxLjIuMTMKc3lzLWRldmVsL2F1 dG9jb25mOiAgMi4xMywgMi41OS1yNwpzeXMtZGV2ZWwvYXV0b21ha2U6ICAxLjRfcDYsIDEuNSwg MS42LjMsIDEuNy45LXIxLCAxLjguNS1yMywgMS45LjYtcjEKc3lzLWRldmVsL2JpbnV0aWxzOiAg Mi4xNi4xCnN5cy1kZXZlbC9saWJ0b29sOiAgIDEuNS4yMAp2aXJ0dWFsL29zLWhlYWRlcnM6ICAy LjYuMTEtcjIKQUNDRVBUX0tFWVdPUkRTPSJ4ODYgfng4NiIKQVVUT0NMRUFOPSJ5ZXMiCkNCVUlM RD0iaTY4Ni1wYy1saW51eC1nbnUiCkNGTEFHUz0iLW1hcmNoPXBlbnRpdW00IC1PMyAtcGlwZSAt cyAtZm9taXQtZnJhbWUtcG9pbnRlciAtZmZvcmNlLWFkZHIgLWZhbGlnbi1mdW5jdGlvbnM9NCAt ZnByZWZldGNoLWxvb3AtYXJyYXlzIC1mZmFzdC1tYXRoIgpDSE9TVD0iaTY4Ni1wYy1saW51eC1n bnUiCkNPTkZJR19QUk9URUNUPSIvZXRjIC91c3Iva2RlLzIvc2hhcmUvY29uZmlnIC91c3Iva2Rl LzMuMy9lbnYgL3Vzci9rZGUvMy4zL3NoYXJlL2NvbmZpZyAvdXNyL2tkZS8zLjMvc2h1dGRvd24g L3Vzci9rZGUvMy40L2VudiAvdXNyL2tkZS8zLjQvc2hhcmUvY29uZmlnIC91c3Iva2RlLzMuNC9z aHV0ZG93biAvdXNyL2tkZS8zL3NoYXJlL2NvbmZpZyAvdXNyL2xpYi9YMTEveGtiIC91c3IvbGli L21vemlsbGEvZGVmYXVsdHMvcHJlZiAvdXNyL3NoYXJlL2NvbmZpZyAvdmFyL2JpbmQgL3Zhci9x bWFpbC9jb250cm9sIgpDT05GSUdfUFJPVEVDVF9NQVNLPSIvZXRjL2djb25mIC9ldGMvdGVybWlu Zm8gL2V0Yy90ZXhtZi93ZWIyYyAvZXRjL2Vudi5kIgpDWFhGTEFHUz0iLW1hcmNoPXBlbnRpdW00 IC1PMyAtcGlwZSAtcyAtZm9taXQtZnJhbWUtcG9pbnRlciAtZmZvcmNlLWFkZHIgLWZhbGlnbi1m dW5jdGlvbnM9NCAtZnByZWZldGNoLWxvb3AtYXJyYXlzIC1mZmFzdC1tYXRoIgpESVNURElSPSIv dXNyL3BvcnRhZ2UvZGlzdGZpbGVzIgpGRUFUVVJFUz0iYXV0b2NvbmZpZyBkaXN0Y2MgZGlzdGxv Y2tzIHNhbmRib3ggc2ZwZXJtcyBzdHJpY3QgdXNlcnByaXYgdXNlcnNhbmRib3giCkdFTlRPT19N SVJST1JTPSJodHRwOi8vbWlycm9ycy50ZHMubmV0L2dlbnRvbyBmdHA6Ly9mdHAuZ3RsaWIuY2Mu Z2F0ZWNoLmVkdS9wdWIvZ2VudG9vIGZ0cDovL2Nzb2NpZXR5LWZ0cC5lY24ucHVyZHVlLmVkdS9w dWIvZ2VudG9vLyBodHRwOi8vY3NvY2lldHktZnRwLmVjbi5wdXJkdWUuZWR1L3B1Yi9nZW50b28v IGh0dHA6Ly9vcGVuLXN5c3RlbXMudWZsLmVkdS9taXJyb3JzL2dlbnRvbyIKTUFLRU9QVFM9Ii1q OSIKUEtHRElSPSIvdXNyL3BvcnRhZ2UvcGFja2FnZXMiClBPUlRBR0VfVE1QRElSPSIvdmFyL3Rt cCIKUE9SVERJUj0iL3Vzci9wb3J0YWdlIgpQT1JURElSX09WRVJMQVk9Ii91c3IvcG9ydGFnZS5s b2NhbCIKU1lOQz0icnN5bmM6Ly9yc3luYy5uYW1lcmljYS5nZW50b28ub3JnL2dlbnRvby1wb3J0 YWdlIgpVU0U9Ing4NiBYIGFhbGliIGFsc2EgYXBhY2hlMiBhcG0gYXJ0cyBhdmkgYmFzaC1jb21w bGV0aW9uIGJlcmtkYiBiaXRtYXAtZm9udHMgYm9ub2JvIGNkciBjcnlwdCBjdXBzIGN1cmwgZGly ZWN0ZmIgZWRzIGVtYm9zcyBlbmNvZGUgZXNkIGZhbSBmbGFjIGZvbnQtc2VydmVyIGZvb21hdGlj ZGIgZm9ydHJhbiBnZCBnZGJtIGdpZiBnbm9tZSBncG0gZ3N0cmVhbWVyIGd0ayBndGsyIGd1aWxl IGltYWdlbWFnaWNrIGltbGliIGlwdjYgamF2YSBqcGVnIGp1bml0IGtkZSBsZGFwIGxpYmcrKyBs aWJ3d3cgbWFkIG1ib3ggbWlrbW9kIG1vdGlmIG1vemlsbGEgbXAzIG1wZWcgbXlzcWwgbmN1cnNl cyBubHMgb2ZmZW5zaXZlIG9nZyBvZ2d2b3JiaXMgb3BlbmdsIG9zcyBwYW0gcGRmbGliIHBlcmwg cG5nIHBvc3RncmVzIHB5dGhvbiBxdCBxdWlja3RpbWUgcmVhZGxpbmUgcnVieSBzYW1iYSBzZGwg c2xhbmcgc25tcCBzcGVleCBzcGVsbCBzc2wgc3ZnYSB0Y2x0ayB0Y3BkIHRldGV4IHRpZmYgdHJ1 ZXR5cGUgdHJ1ZXR5cGUtZm9udHMgdHlwZTEtZm9udHMgdWRldiB2b3JiaXMgeGluZSB4aW5lcmFt YSB4bWwgeG1sMiB4bW1zIHh2IHpsaWIgdXNlcmxhbmRfR05VIGtlcm5lbF9saW51eCBlbGliY19n bGliYyIKVW5zZXQ6ICBBU0ZMQUdTLCBDVEFSR0VULCBMQU5HLCBMQ19BTEwsIExERkxBR1MsIExJ TkdVQVMKCg==