Bug #16095 INSERT DELAYED crashes mysql server
Submitted: 30 Dec 2005 10:45 Modified: 24 Jan 2006 23:32
Reporter: Alexander Barkov Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.5 bk current OS:FreeBSD (FreeBSD/Suse 10)
Assigned to: MySQL Verification Team CPU Architecture:Any

[30 Dec 2005 10:45] Alexander Barkov
INSERT DELAYED crashes mysqld with this error message:

Assertion failed: (query && mysql_bin_log.is_open()), function binlog_query, file sql_class.cc, line 2519.

How to repeat:
Start a fresh mysqld, then run these queries:

drop table if exists t1;
create table t1 (a int);
insert delayed into t1 values (10);
[30 Dec 2005 13:07] MySQL Verification Team
miguel@hegel:~/dbs/5.1> libexec/mysqld
051230 11:09:31  InnoDB: Started; log sequence number 0 43655
051230 11:09:31 [Note] libexec/mysqld: ready for connections.
Version: '5.1.5-alpha-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
mysqld: sql_class.cc:2519: int THD::binlog_query(THD::enum_binlog_query_type, const char*, ulong, bool, bool): Assertion `query && mysql_bin_log.is_open()' failed.
mysqld got signal 6;
[13 Jan 2006 0:33] Mike Hillyer
Should not be in Documenting status. Cannot tell if verified so setting to Open.
[24 Jan 2006 23:32] Jon Stephens
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 

Additional info:

Documented in 5.1.5 changelog. Closed.