Bug 155183 – mail-filter/sqlgrey-1.7.4 "prepare_cached" log warnings

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Tomislav Filipcic 2006-11-14 18:32:33 UTC]

sqlgrey-1.7.4 is logging the following warnings to the log file while it is running

Nov 15 02:52:41 [sqlgrey] warning: prepare_cached(SELECT now()) statement handle DBI::st=HASH(0xf1b820) still Active at /usr/sbin/sqlgrey line 260_



Portage 2.1.1-r1 (default-linux/amd64/2006.1, gcc-4.1.1, glibc-2.4-r4, 2.6.16.29-xen x86_64)
=================================================================
System uname: 2.6.16.29-xen x86_64 Dual Core AMD Opteron(tm) Processor 265
Gentoo Base System version 1.12.6
Last Sync: Wed, 15 Nov 2006 00:00:01 +0000
app-admin/eselect-compiler: [Not Present]
dev-java/java-config: [Not Present]
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r4
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="amd64 berkdb bitmap-fonts cli cracklib crypt cups dlloader dri elibc_glibc fortran gdbm gpm iconv imap input_devices_evdev input_devices_keyboard input_devices_mouse ipv6 isdnlog kernel_linux libg++ maildir ncurses nls nptl nptlonly pam pcre perl ppds pppd python readline reflection sasl session spl ssl tcpd truetype-fonts type1-fonts udev unicode userland_GNU video_cards_apm video_cards_ark video_cards_ati video_cards_chips video_cards_cirrus video_cards_cyrix video_cards_dummy video_cards_fbdev video_cards_glint video_cards_i128 video_cards_i810 video_cards_mga video_cards_neomagic video_cards_nv video_cards_rendition video_cards_s3 video_cards_s3virge video_cards_savage video_cards_siliconmotion video_cards_sis video_cards_sisusb video_cards_tdfx video_cards_tga video_cards_trident video_cards_tseng video_cards_v4l video_cards_vesa video_cards_vga video_cards_via video_cards_vmware video_cards_voodoo xorg zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

[Comment 1 Tomislav Filipcic 2006-11-15 04:42:09 UTC]

Information from the offical mailing list

http://sourceforge.net/mailarchive/forum.php?thread_id=24200414&forum_id=42520

[Comment 2 Francesco R. (RETIRED) 2006-11-15 06:53:04 UTC]

fixed with dev-perl/DBD-mysql-3.0007
3.0008 is in the tree too, I'll request to stable it soon

[Comment 3 Francesco R. (RETIRED) 2006-11-15 06:53:37 UTC]

btw upstream reference:
http://www.nntp.perl.org/group/perl.dbi.users/30172