Yes, there are only two statements failing: update rpzone set data=?, protocol_version=33 where zone_id='int_semos_tavern_0'; and update opobject set data=?, protocol_version=33 where object_id=12
They fail every time with different values. All other statements (selects, updates, inserts) work without problems. There is a batch insert using a prepared statement into the npcs table. So prepared statement work, too. What is unique about those two failing queries is that they both use statement.setBinaryStream. The tables are defined as: mysql> show fields from rpobject; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+----------------+ | object_id | int(11) | NO | PRI | NULL | auto_increment | | data | blob | YES | | NULL | | | protocol_version | int(11) | YES | | NULL | | +------------------+---------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> show fields from rpzone; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | zone_id | varchar(32) | NO | PRI | NULL | | | data | blob | YES | | NULL | | | protocol_version | int(11) | YES | | NULL | | +------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) They are the only tables with blob fields. ** Attachment added: "mysql-good.log" https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/663481/+attachment/1703472/+files/mysql.log -- 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
