Bug #18021 Error 1412 appears after restoring data from backup
Submitted: 7 Mar 2006 11:53 Modified: 19 May 2006 14:31
Reporter: Serge Kozlov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version: OS:Linux (Linux FC4)
Assigned to: Assigned Account CPU Architecture:Any

[7 Mar 2006 11:53] Serge Kozlov 
Description:
There is 'ndb' suite in extra test tree and testcase 'ha_backup.test'
failed. 
TEST                           RESULT
-------------------------------------------------------

ha_backup                      [ fail ]

Errors are (from /home/ndbdev/skozlov/builds/mysql-test/var/log/mysqltest-time)
:
mysqltest: In included file "./suite/ndb/include/ha_select.inc": At line 1: quer
y 'SELECT COUNT(a), SUM(b), MAX(b), MIN(b) FROM t1' failed: 1412: Table definiti
on has changed, please retry transaction
(the last lines may be the most important ones)

How to repeat:
1. Log into ndb16
2. Go to ~/skozlov/builds/mysql-test/suite/ndb directory
3. Run ./ndbtest.sh ndbtest.ini --do-test=ha_backup
[7 Mar 2006 11:54] Serge Kozlov 
See trace files into ndb16:/space/bug18021
[27 Mar 2006 19:15] Serge Kozlov 
'ha_backup' testcase has simple set of command:
1. Add table (sql).
2. Insert some rows (sql). 
3. Select from table (sql). 
4. Run backup (external perl script). 
5. Restart cluster with --initial option (external perl script).
6. Run restore (external perl script). 
7. Select again like point 3 (sql).

Result from 3 must be equal result from 6.
[19 May 2006 9:38] Jonas Oreland 
Is this fixed with you latest (not yet pushed) fixes
[19 May 2006 14:31] Tomas Ulin 
restarting cluster and keeping mysqld alive... has not been handled correctly... all issues connected to this I will refer to bug:
Bug #19395