Bug #57618 While replaying log entries ndb_restore does not retry on temporary errors

• Submitted: 21 Oct 2010 7:31
• Modified: 22 Oct 2010 13:18
• Reporter: Geert Vanderkelen
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-7.1
• OS: Any
• Assigned to: Jonas Oreland
• CPU Architecture: Any
• Tags: Backup, ndb_restore, restore

[21 Oct 2010 7:31] Geert Vanderkelen

Description:
ndb_restore does retry after a transaction fails with a temporary error when restoring data. For example, a REDO log overloaded error is reported, but the failed transaction is retried.
ndb_restore does not, however, retry transactions when replaying log entries and fails right away when a temporary error occurs.

Looking at the code, there isn't any retry mechanisme for log entries like there is for tuples.

I guess this is for all MySQL Cluster versions.

How to repeat:
Provoke a REDO overload. Example output:

......
Temporary error: 1220: REDO log files overloaded (increase FragmentLogFileSize)
Temporary error: 1220: REDO log files overloaded (increase FragmentLogFileSize)
.....
_____________________________________________________
Processing data in table: dbname/def/t1(335) fragment 8
_____________________________________________________
Processing data in table: dbname/def/t2(240) fragment 8
Opening file '/path/to/ndbd/BACKUP/BACKUP-3/BACKUP-3.10.log'
execute failed: 1220: REDO log files overloaded (increase FragmentLogFileSize)

[21 Oct 2010 8:12] 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/121471

3312 Jonas Oreland	2010-10-21
      ndb - bug#57618 - also retry log-entries, (patch use goto to make it small)

[21 Oct 2010 8:54] 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/121492

3315 Jonas Oreland	2010-10-21
      ndb - bug#57618 - also retry log-entries, (patch use goto to make it small)

[21 Oct 2010 9:01] Bugs System

Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:[e-mail]-20101021085109-ocjmrdphvq432q9p) (version source revid:[e-mail]-20101021085109-ocjmrdphvq432q9p) (merge vers: 5.1.51-ndb-6.3.39) (pib:21)

[21 Oct 2010 10:37] Bugs System

Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:[e-mail]-20101021085841-gen335fpuaugd5d8) (version source revid:[e-mail]-20101021085841-gen335fpuaugd5d8) (merge vers: 5.1.51-ndb-7.0.20) (pib:21)

[21 Oct 2010 10:39] Jonas Oreland

pushed to 6.3.39, 7.0.20 and 7.1.9

[22 Oct 2010 13:18] Jon Stephens

Documented bugfix in the NDB-6.3.39, 7.0.20, and 7.1.9 changelogs as follows:

      ndb_restore now retries failed transactions when replaying log 
      entries, just as it does when restoring data. 

Closed.