Bug #38877 | Data recovery with mysqlbinlog fails for Falcon, if backup is present in binlog | ||
---|---|---|---|
Submitted: | 18 Aug 2008 22:22 | Modified: | 11 Sep 2008 16:22 |
Reporter: | Hema Sridharan | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Backup | Severity: | S2 (Serious) |
Version: | mysql-6.0-backup, mysql-6.0, 6.0.7-bzr | OS: | Linux (64 bit, 32-bit) |
Assigned to: | Sergey Vojtovich | CPU Architecture: | Any |
[18 Aug 2008 22:22]
Hema Sridharan
[19 Aug 2008 3:56]
Valeriy Kravchuk
Thank you for a bug report. Verified just as described with recent 6.0.7 from bzr on 32-bit Linux: openxs@suse:/home2/openxs/dbs/6.0/mysql-test> ./mysql-test-run.pl --force rep_bug38877 Logging: ./mysql-test-run.pl --force rep_bug38877 MySQL Version 6.0.7 Using dynamic switching of binlog format Using ndbcluster when necessary, mysqld supports it Setting mysqld to support SSL connections Binaries are debug compiled Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using NDBCLUSTER_PORT = 9311 Using NDBCLUSTER_PORT_SLAVE = 9312 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database Saving snapshot of installed databases ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- main.rep_bug38877 [ fail ] Warning: Not freed memory segments: 2 Warning: Memory that was not free'ed (560 bytes): 104 bytes at 0x0080957a8, allocated at line 1019 in 'log_event.cc' 456 bytes at 0x00806f040, allocated at line 201 in 'my_alloc.c' mysqltest: The specified result file does not exist: '/home2/openxs/dbs/6.0/mysql-test/r/rep_bug38877.result' The result from queries just before the failure was: < snip > id a 1 a 2 b 3 c 4 d 5 e 557; FLUSH LOGS; DROP DATABASE ptr; SHOW DATABASES; Database information_schema mysql ptr test SHOW TABLES FROM ptr; Tables_in_ptr t1 SELECT * FROM ptr.t1; id a ... So, table is empty.
[11 Sep 2008 16:22]
Sergey Vojtovich
Wasn't able to repeat with current 6.0-falcon-team tree. The problem was likely fixed by patch for BUG#33575. At least without that patch it is repeatable.