[debian-mysql] Bug#615011: mysql-server-5.1: 'Prepared statement needs to be re-prepared' when, mysqldump is running

[Ondřej Kunc]

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: ondra at czol.eu
URL: www.czol.eu, www.cz-hosting.com