Bug #27077 ndb->extra(HA_EXTRA_IGNORE_NO_KEY) becomes repeatedl ineffectiv once was reset
| Submitted: | 13 Mar 2007 10:46 | Modified: | 11 Jun 2009 17:07 |
|---|---|---|---|
| Reporter: | Andrei Elkin | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Cluster: Replication | Severity: | S3 (Non-critical) |
| Version: | mysql-5.1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | 5.1.17 | ||
[13 Mar 2007 10:46]
Andrei Elkin
[14 Mar 2007 6:49]
Andrei Elkin
Taking on myself to analyze the case better.
[15 Mar 2007 18:45]
Andrei Elkin
Closing it though smells bad.
What remains wondering me is that
an attempt to set ndb's mood in Write_rows_log_event::do_before_row_operations with
table->file->extra(HA_EXTRA_IGNORE_NO_KEY);
and reset at Write_rows_log_event::do_after_row_operations with
table->file->extra(HA_EXTRA_NO_IGNORE_NO_KEY);
creates a side effect: slave stops with
Last_Errno: 839
Last_Error: Error in Write_rows event: error during transaction execution on table test.t1
when executing the reported piece of rpl_ndb_idempotent
Needs discussing with cluster team.
[2 May 2007 14:25]
Andrei Elkin
Tested how possibly fix for Bug #27320 ndb handler does not reset extra flags on reset() could affect the current case. The reported test still fails if int Write_rows_log_event::do_after_row_operations() executed the matching (to do_before_row_operations table->file->extra(HA_EXTRA_NO_IGNORE_NO_KEY); rpl_ndb_idempotent [ fail ] Errors are (from /tmp/andrei/mysql-5.1-new-rpl/mysql-test/var/log/mysqltest-time) : mysqltest: At line 106: could not sync with master ('select master_pos_wait('master-bin.000001', 1007)' returned NULL) slave.err: 070502 17:17:28 [ERROR] Slave: Error in Write_rows event: error during transaction execution on table test.t1, Error_code: 839 070502 17:17:28 [ERROR] Slave (additional info): Unknown error Error_code: 1105 070502 17:17:28 [Warning] Slave: Got error 839 'Illegal null attribute' from NDB Error_code: 1296 070502 17:17:28 [Warning] Slave: Unknown error Error_code: 1105 070502 17:17:28 [ERROR] Error running query, slave SQL thread aborted.
[1 Jun 2007 19:23]
Bugs System
Pushed into 5.1.20-beta
[25 Jun 2007 11:17]
Andrei Elkin
"Pushed" should be ignored - a mistake of pushbuild buglist generator.
[19 May 2009 12:49]
Jonathan Miller
Still and issues?
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.047 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.