Bug #16095 INSERT DELAYED crashes mysql server
Submitted: 30 Dec 2005 11:45 Modified: 25 Jan 2006 0:32
Reporter: Alexander Barkov
Status: Closed
Category:Server Severity:S2 (Serious)
Version:5.1.5 bk current OS:FreeBSD (FreeBSD/Suse 10)
Assigned to: Miguel Solorzano Target Version:

[30 Dec 2005 11:45] Alexander Barkov 
Description:
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 14:07] Miguel Solorzano 
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 1:33] Mike Hillyer 
Should not be in Documenting status. Cannot tell if verified so setting to Open.
[25 Jan 2006 0: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 
http://www.mysql.com/downloads/

Additional info:

Documented in 5.1.5 changelog. Closed.