Bug #19852 Restoring backup made from cluster with full data memory fails
Submitted: 16 May 2006 13:30 Modified: 2 Sep 2006 6:08
Reporter: Geert Vanderkelen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1,5.0,5.1 OS:Linux (Linux)
Assigned to: Tomas Ulin

[16 May 2006 13:30] Geert Vanderkelen
Description:

Restoring a backup made using the hot backup in Cluster using ndb_restore fails when the backup was taking from a cluster which has full data memory.
Putting the memory higher is a workaround, but not mostly not an option.

How to repeat:

- setup a cluster (1 datanode) with small Datamemory, like 10Mb
- fill till no space available anymore (hug ALL DUMP 1000)
- take a backup
- ndbd --initial
- ndb_restore the backup
=> fails.

827: Out of memory in Ndb Kernel, table data (increase DataMemory)
Restore: Failed to restore data due to a unrecoverable error. Exiting...

NDBT_ProgramExit: 1 - Failed
[27 Jun 2006 6: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/8288
[27 Jun 2006 7:35] 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/8293
[27 Jun 2006 9:22] 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/8299
[27 Jun 2006 9:25] Tomas Ulin
5.1 merge
  http://lists.mysql.com/commits/8293
[27 Jun 2006 9:50] 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/8303
[27 Jun 2006 22:53] Tomas Ulin
pushed to 5.1.12 and 5.0.23
won't fix in 4.1
[28 Jun 2006 4:16] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://www.mysql.com/doc/en/Installing_source_tree.html

Documented bugfix in 5.0.23 & 5.1.12 changelogs. Closed.
[29 Jun 2006 6:22] 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/8449
[3 Aug 2006 12:46] 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/10005

ChangeSet@1.2233, 2006-08-03 14:46:11+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#20892
    Correction of bug#19852 (that also revealed another bug)
    Do grow noOfPagesToGrow with more than was actually allocated
[1 Sep 2006 19:32] Jonas Oreland
pushed to 5.0.25
smaller correction of previous patch
[2 Sep 2006 6:08] Jon Stephens
Noted availability of improved patch in 5.0.25 changelog.