Bug #59904 MyISAM data is lost after incremental backup

Submitted: 2 Feb 2011 21:29 Modified: 4 Feb 2011 8:50
Reporter: Hema Sridharan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S2 (Serious)
Version:MEB 3.6 OS:Linux
Assigned to: Thava Alagu CPU Architecture:Any

[2 Feb 2011 21:29] Hema Sridharan
Description:
- Create database db1 and innodb(t0), myisam(t1) tables.
- Insert data in both the tables. Lets say I insert data 1, 2 in t1
- Perform full backup
- Add some more data to both innodb and myisam table. Lets say I insert data 3,4 in t1
- Perform incremental backup
- Stop server, apply log for full backup, copy-backup, restart the server
- Check the data. Table t1 should have 1,2 
- Again stop server and perform restore for incremental backup, restart the server
- Check the data. Table t1 should have 1,2,3 &4

Table t1 will have only data 1 and 2. 3,4 is missing for MyISAM tables after incremental backup.
NOTE: I executed the test with MEB 3.6 version from bzrroot/meb/sbin-repo/single-bin/ repo in mysql-5.1-meb server.

How to repeat:
Please find the attached test case to reproduce the bug.
[2 Feb 2011 21:30] Hema Sridharan
Please find the attached test case

Attachment: incremental_bug.test (application/octet-stream, text), 2.40 KiB.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 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.