Bug #37876 Importing Maria table from other server via binary copy does not work
Submitted: 4 Jul 2008 14:06 Modified: 11 Jul 2008 8:58
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Maria storage engine Severity:S3 (Non-critical)
Version:5.1-maria OS:Any
Assigned to: Guilhem Bichot CPU Architecture:Any

[4 Jul 2008 14:06] Guilhem Bichot 
Description:
Generate a transactional Maria table with one mysqld (use
./mtr --mem --start-and-exit maria).
Then shut this mysqld down, copy table somewhere, and run the mtr command again, copy back table, do SELECT on it: master.err says that table is automatically zerofilled. But it keeps its create_rename_lsn which is incorrect.

How to repeat:
see description

Suggested fix:
Reset create_rename_lsn, is_of_horizon, skip_redo_lsn during zerofill, set them to proper values when assigning the table to this installation. As this assignment happens in _ma_mark_file_changed() (using translog_get_horizon() as new LSN), and two calls to this function can run concurrently for two tables, there is a chance that the two tables get same LSN: write a dummy log record to make sure that this does not happen, instead of using translog_get_horizon().
[11 Jul 2008 8:58] Guilhem Bichot 
http://lists.mysql.com/maria/107
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://dev.mysql.com/doc/en/installing-source.html
[24 Jul 2008 8:26] Bugs System 
Pushed into 6.0.7-alpha  (revid:kpettersson@mysql.com-20080724082624-59z1hc8un6mxdb46) (pib:2)
[14 Sep 2008 2:33] Bugs System 
Pushed into 6.0.6-alpha  (revid:guilhem@mysql.com-20080709090227-qunztd28udazvchw) (version source revid:hakan@mysql.com-20080716160135-l7310heud233kagu) (pib:3)