Bug #21563 apply_status table is not recreated when binlog-format=statement
Submitted: 10 Aug 2006 10:17 Modified: 17 Sep 2007 11:55
Reporter: Jonas Oreland Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: justin he CPU Architecture:Any

[10 Aug 2006 10:17] Jonas Oreland
Description:
1) start cluster
2) start mysqld (create schema/apply_status)
3) restart cluster --initial
4) mysql recreates schema (but _not_ apply status)

This is due to the fact that the apply_status table is only listened to
  incase of binlog-format=row

A solution would be to move it so that it is handled the same way as schema table
Another solution would be to not create it at all if binlog-format=statement

So current behaviour is inconsistent. But very unlikely to happen 
  for any user...

How to repeat:
 

Suggested fix:
[10 Aug 2006 11:30] Jonas Oreland
see http://bugs.mysql.com/bug.php?id=21283
[1 Aug 2007 6:29] 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/31933

ChangeSet@1.2569, 2007-08-01 14:15:15+08:00, Justin.He@dev3-240.dev.cn.tlan +1 -0
  Bug#21563, apply_status table is not recreated when binlog-format=statement
[3 Aug 2007 6:23] 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/32050

ChangeSet@1.2569, 2007-08-03 14:08:40+08:00, Justin.He@dev3-240.dev.cn.tlan +2 -0
  Bug#21563, apply_status table is not recreated when binlog-format=statement