Package: mysql-server-5.1
Version: 5.1.49-3
Severity: normal
Hi,
Recently I've installed new mysql 5.1 server in our company, before we
used mysql 5.0. Now we are experiencing problems with prepared
statements using mysqli php driver. Sometimes mysql spit outs this error:
"Mysqli statement execute error : Prepared statement needs to be
re-prepared"
I've found that this error is generated when some database is dumped by
mysqldump from our backup server. It doesn't matter if it's the same
database.
I searched the internet resources for this problem and I've found this
upstream bug:
http://bugs.mysql.com/bug.php?id=42041
But this is not solved yet and I can confirm that this problem is
present in debian too. I'had increased table_definition_cache to 2048 (
from 256 ) but it had no effect. What can I do with it ?
Thanks
-- System Information:
Debian Release: 6.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-xen-amd64 (SMP w/4 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Versions of packages mysql-server-5.1 depends on:
ii adduser 3.112+nmu2 add and remove users and groups
ii debconf [de 1.5.36.1 Debian configuration
management sy
ii libc6 2.11.2-10 Embedded GNU C Library:
Shared lib
ii libdbi-perl 1.612-1 Perl Database Interface (DBI)
ii libgcc1 1:4.4.5-8 GCC support library
ii libmysqlcli 5.1.49-3 MySQL database client library
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3
ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2
init scrip
ii mysql-clien 5.1.49-3 MySQL database client binaries
ii mysql-commo 5.1.49-3 MySQL database common
files, e.g.
ii mysql-serve 5.1.49-3 MySQL database server binaries
ii passwd 1:4.1.4.2+svn3283-2+squeeze1 change and administer
password and
ii perl 5.10.1-17 Larry Wall's Practical
Extraction
ii psmisc 22.11-1 utilities that use the proc
file s
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages mysql-server-5.1 recommends:
ii heirloom-mailx [mailx] 12.4-2 feature-rich BSD mail(1)
ii libhtml-template-perl 2.9-2 module for using HTML
Templates wi
Versions of packages mysql-server-5.1 suggests:
pn tinyca <none> (no description available)
-- Configuration Files:
/etc/mysql/debian-start changed [not included]
-- debconf information excluded
--
Ondřej Kunc
správce serverové farmy
CZOL media interactive s.r.o.
Sídlo: Moulíkova 2238/1, Praha 5, 15000
Kanceláře: Na Moráni 5357, Chomutov, 43001
Telefon: +420 723 137 981
E-mail: on...@czol.eu
URL: www.czol.eu, www.cz-hosting.com
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
