Bug #19656 MySQL Error log flooded with [ERROR] NDB Binlog: Duplicate key on write or upda
Submitted: 9 May 2006 21:55 Modified: 23 May 2006 14:43
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.11 OS:
Assigned to: Jon Stephens CPU Architecture:Any

[9 May 2006 21:55] Jonathan Miller
Description:
perror 121
OS error code 121:  Remote I/O error
MySQL error code 121: Duplicate key on write or update

060509 22:50:54 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:50:57 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:01 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:02 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:06 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:08 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:14 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:17 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:19 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:21 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:24 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:26 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:28 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:31 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:33 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:35 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:35 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:37 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:39 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:41 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:43 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:47 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:49 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:51 [ERROR] NDB Binlog: Writing row to binlog_index: 121
060509 22:51:53 [ERROR] NDB Binlog: Writing row to binlog_index: 121

How to repeat:
Run Stress testing including cid_ndb_dd.pl (3 copies) and DBT2 while loading
the
TPC-B database
[10 May 2006 6:24] Jonas Oreland
I get this when restarting cluster initial,  wo/ stopping mysqld and doing mysqld_install_db

Did you do this?
[10 May 2006 13:11] Tomas Ulin
if cluster is restarted --initial, we unfortunately currently have no way of detecting this...

anyways... a --initial start resets the gci's... hence you are getting the "duplicate key, 121" in binlog index,

you have to do a "reset master", to clear the binlog_index, and to get rid of is
[10 May 2006 13:18] Jonathan Miller
In either case, flooding the error log is not a good way to handel this one or two message would be fine. Maybe even with the explination you just gave me. But we should not have a log full of the same error message.
[23 May 2006 14:43] Jon Stephens
This is already documented. See http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-issues.html