Public bug reported: MySQL 5.1 fails with "Incorrect a rguments to mysq ld_stmt_execute" on the following prepared statement: update rpzone set d ata=?, protocol_ version=33 where zone_id='int_se mos_tavern_0' if and only if mysql logging is disabled.
The problem does not occur on Debian 5.0, Ubuntu 09.04, 09.10, 10.04. Setting the following lines in /etc/mysql/my.conf makes the problem go away: general_log_file = /var/log/mysql/mysql.log general_log = 1 I tried it repeatedly and enabling logging really seems to make a difference. This was confirmed by rodneymillerpca in http://stendhalgame.org/chat/2010-10-19.html I attached a network dump of both a good and a bad case. Note that the data sent from the client to the mysql server is bit by bit identical in both cases. The following java code is used to execute the statement: public int execute(String sql, InputStream... inputStreams) throws SQLException, IOException { String mySql = rewriteSql(sql); int res = -2; PreparedStatement statement = connection.prepareStatement(mySql); try { int i = 1; // yes, jdbc starts counting at 1. for (InputStream inputStream : inputStreams) { statement.setBinaryStream(i, inputStream, inputStream.available()); i++; } res = statement.executeUpdate(); } finally { statement.close(); } return res; } ProblemType: Bug DistroRelease: Ubuntu 10.10 Package: mysql-server-5.1 5.1.49-1ubuntu8 ProcVersionSignature: Ubuntu 2.6.35-22.34-generic 2.6.35.4 Uname: Linux 2.6.35-22-generic x86_64 NonfreeKernelModules: nvidia Architecture: amd64 Date: Tue Oct 19 21:21:02 2010 ProcEnviron: LANG=de_DE.utf8 SHELL=/bin/bash SourcePackage: mysql-5.1 ** Affects: mysql-5.1 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug maverick -- JDBC: statement.setBinaryStream fails iff mysql logging is disabled https://bugs.launchpad.net/bugs/663481 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
