[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled

[Nhb-web]

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.