Bug #29522 log.cc:1448: failed assertion `mysql_bin_log.is_open() && rex_data->empty()'
Submitted: 3 Jul 2007 15:39 Modified: 27 Jul 2007 23:15
Reporter: Antony Curtis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Antony Curtis CPU Architecture:Any

[3 Jul 2007 15:39] Antony Curtis
Description:
Assertion while closing connection after performing a few simple statements with Innodb while AUTOCOMMIT=1 when using ps-protocol and row binlog.

The following appears in error log
log.cc:1448: failed assertion `mysql_bin_log.is_open() && trx_data->empty()'

This assertion occurs within binlog_close_connection()

How to repeat:
Using current mysql-5.1-engines tree

perl ./mysql-test-run.pl --ps-protocol --mysqld=--binlog-format=row federated_innodb

Suggested fix:
adding "trx_data->reset();" before the assertion appears to fix problem but is probably not the right solution.
[3 Jul 2007 20:54] Sveta Smirnova
Thank you for the report.

Verified as described.
[7 Jul 2007 16:54] Antony Curtis
federated_innodb test in 5.1 should be enabled after fixing this bug.
(Changed to p1 by request of Calvin)
[25 Jul 2007 1:16] Timothy Smith
This bug doesn't show up in most recent 5.1-engines tree.  I compared multiple versions of the -engines tree, and found that it starts working on this push:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=mysql-5.1-engines&order=214

That is, on the commit from Antony with:

ChangeSet
  acurtis/antony@xiphis.org/ltamd64.xiphis.org|ChangeSet|20070720183519|50032    2007/07/20 11:35:19-07:00 acurtis@xiphis.org +5 -0
  Bug#29875
    "Disable transaction support in Federated storage engine"
    Minimal patch to disable Federated's transactions until they can be fixed.

This bug can't be worked on until the federation transaction support is fixed.  However, the test case works now with transaction support disabled in federated, so this test can be re-enabled.

If WL #2952 is completed, and federated has transaction support again, probably this test will work properly.  If not, then this bug can be re-opened to handle the problem.

Regards,

Timothy
[25 Jul 2007 23:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31577

ChangeSet@1.2562, 2007-07-25 16:01:43-07:00, antony@pcg5ppc.xiphis.org +1 -0
  Bug#29522
    "log.cc:1448: failed assertion `mysql_bin_log.is_open() && rex_data->empty()'"
    When Federated's transaction support was disabled by bug29875,
    this assertion became unreproducable.
[26 Jul 2007 4:22] Antony Curtis
no code to review. simply reenabling the test. approved to push by Calvin.
[26 Jul 2007 4:25] Antony Curtis
pushed to 5.1-engines repository
[27 Jul 2007 16:49] Bugs System
Pushed into 5.1.21-beta
[27 Jul 2007 23:15] Paul DuBois
Test suite change. No changelog entry needed.