[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
[Expired for mysql-5.1 (Ubuntu) because there has been no activity for 60 days.] ** Changed in: mysql-5.1 (Ubuntu) Status: Incomplete => Expired -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/663481 Title: JDBC: statement.setBinaryStream fails iff mysql logging is disabled -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
Do most of the other statements execute without a problem ? ** Changed in: mysql-5.1 (Ubuntu) Importance: Undecided => Medium ** Changed in: mysql-5.1 (Ubuntu) Status: New => Incomplete -- 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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
Sorry, the additional spaces in the error message and statement are caused by me copying them from the network dump. They are not there in reality. -- 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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
** Attachment added: "ok.txt" https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/663481/+attachment/1702080/+files/ok.txt -- 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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 663481] Re: JDBC: statement.setBinaryStream fails iff mysql logging is disabled
** Attachment added: "broken.txt" https://bugs.launchpad.net/bugs/663481/+attachment/1702078/+files/broken.txt -- 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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs