2013-07-30 00:01:29 |
Nickolay Ihalainen |
bug |
|
|
added bug |
2013-07-30 00:05:12 |
Nickolay Ihalainen |
description |
percona-xtrabackup-2.0.7-552.rhel5
xtrabackup version 2.0.7 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 552)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /database/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 2147483648
xtrabackup: using O_DIRECT
InnoDB: Warning: allocated tablespace 424, old maximum was 9 ...
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 5458041, but got no. 1070811265 from the log file.
xtrabackup: Error: xtrabackup_copy_logfile() failed.
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.
The error emitted after 179m45.411s since backup start.
Before backup start transaction log information:
Log sequence number 186856561401671
Log flushed up to 186856559716066
Last checkpoint at 186854266314745
Max checkpoint age 3476324967
Checkpoint age target 3367689812
Modified age 2265855030
Checkpoint age 2295086926
0 pending log writes, 0 pending chkp writes
1019036192 log i/o's done, 220.02 log i/o's/second
Right after xtrabackup crash:
Log sequence number 186919780065548
Log flushed up to 186919776998233
Last checkpoint at 186917463665464
Max checkpoint age 3476324967
Checkpoint age target 3367689812
Modified age 2313548226
Checkpoint age 2316400084
0 pending log writes, 0 pending chkp writes
1020869843 log i/o's done, 88.32 log i/o's/second
There are several errors from previous runs:
xtrabackup: error: expected log block no. 3388077, but got no. 1068741301 from the log file.
>> log scanned up to (183619734185080)
>> log scanned up to (183619741409546)
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 2551941, but got no. 1067905165 from the log file.
From previous month innodb recovery information:
130618 23:46:21 Percona XtraDB (http://www.percona.com) 1.0.15-12.7 started; log sequence number 166828151398485
As you can see block no. diff is always 1065353224 compare to much smaller LSN change:
(186919780065548-186856561401671)/1024/1024/1024 = 58G |
Affected versions:
percona-xtrabackup-2.1.2-611.rhel5
percona-xtrabackup-2.0.7-552.rhel5
xtrabackup version 2.0.7 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 552)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /database/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 2147483648
xtrabackup: using O_DIRECT
InnoDB: Warning: allocated tablespace 424, old maximum was 9 ...
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 5458041, but got no. 1070811265 from the log file.
xtrabackup: Error: xtrabackup_copy_logfile() failed.
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.
The error emitted after 179m45.411s since backup start.
Before backup start transaction log information:
Log sequence number 186856561401671
Log flushed up to 186856559716066
Last checkpoint at 186854266314745
Max checkpoint age 3476324967
Checkpoint age target 3367689812
Modified age 2265855030
Checkpoint age 2295086926
0 pending log writes, 0 pending chkp writes
1019036192 log i/o's done, 220.02 log i/o's/second
Right after xtrabackup crash:
Log sequence number 186919780065548
Log flushed up to 186919776998233
Last checkpoint at 186917463665464
Max checkpoint age 3476324967
Checkpoint age target 3367689812
Modified age 2313548226
Checkpoint age 2316400084
0 pending log writes, 0 pending chkp writes
1020869843 log i/o's done, 88.32 log i/o's/second
There are several errors from previous runs:
xtrabackup: error: expected log block no. 3388077, but got no. 1068741301 from the log file.
>> log scanned up to (183619734185080)
>> log scanned up to (183619741409546)
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 2551941, but got no. 1067905165 from the log file.
From previous month innodb recovery information:
130618 23:46:21 Percona XtraDB (http://www.percona.com) 1.0.15-12.7 started; log sequence number 166828151398485
As you can see block no. diff is always 1065353224 compare to much smaller LSN change:
(186919780065548-186856561401671)/1024/1024/1024 = 58G |
|
2013-07-30 00:05:29 |
Nickolay Ihalainen |
summary |
Xtrabackup 2.0.7 failed: expected log block no. 5458041, but got no. 1070811265 from the log file |
Xtrabackup 2.0.7 or 2.1.2 failed: expected log block no. 5458041, but got no. 1070811265 from the log file |
|
2013-07-30 06:53:43 |
Alexey Kopytov |
percona-xtrabackup: status |
New |
Incomplete |
|
2013-07-31 23:16:41 |
markus_albe |
tags |
|
i33538 |
|
2013-08-01 13:28:26 |
Alexey Kopytov |
percona-xtrabackup: status |
Incomplete |
New |
|
2013-08-05 12:38:41 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.0 |
|
2013-08-05 12:38:41 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.0 |
|
2013-08-05 12:38:41 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.1 |
|
2013-08-05 12:38:41 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.1 |
|
2013-08-05 12:38:59 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
New |
Triaged |
|
2013-08-05 12:39:02 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
New |
Triaged |
|
2013-08-05 12:39:05 |
Alexey Kopytov |
percona-xtrabackup/2.0: importance |
Undecided |
High |
|
2013-08-05 12:39:07 |
Alexey Kopytov |
percona-xtrabackup/2.1: importance |
Undecided |
High |
|
2013-08-05 12:39:09 |
Alexey Kopytov |
percona-xtrabackup/2.0: assignee |
|
Alexey Kopytov (akopytov) |
|
2013-08-05 12:39:12 |
Alexey Kopytov |
percona-xtrabackup/2.1: assignee |
|
Alexey Kopytov (akopytov) |
|
2013-08-05 12:39:17 |
Alexey Kopytov |
percona-xtrabackup/2.0: milestone |
|
future-2.0-releases |
|
2013-08-05 12:39:18 |
Alexey Kopytov |
percona-xtrabackup/2.1: milestone |
|
future-2.1-releases |
|
2013-08-05 12:53:01 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Triaged |
Fix Committed |
|
2013-08-05 12:53:03 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Triaged |
Fix Committed |
|
2013-08-05 12:53:08 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1206309-2.0 |
|
2013-08-05 12:53:14 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1206309-2.1 |
|
2013-08-07 05:44:02 |
Alexey Kopytov |
percona-xtrabackup/2.0: milestone |
future-2.0-releases |
2.0.8 |
|
2013-08-07 07:02:20 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Fix Committed |
Fix Released |
|
2013-08-07 07:02:22 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Fix Committed |
Fix Released |
|
2013-08-10 15:41:59 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Fix Released |
In Progress |
|
2013-08-10 15:42:01 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Fix Released |
In Progress |
|
2013-08-10 15:54:39 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1206309-addendum-2.0 |
|
2013-08-10 15:54:49 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1206309-addendum-2.1 |
|
2013-08-10 15:54:52 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
In Progress |
Fix Committed |
|
2013-08-10 15:54:54 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
In Progress |
Fix Committed |
|
2013-08-12 09:39:39 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Fix Committed |
Fix Released |
|
2013-08-12 09:39:42 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Fix Committed |
Fix Released |
|
2013-09-03 08:36:28 |
Alexey Kopytov |
percona-xtrabackup/2.1: milestone |
future-2.1-releases |
2.1.5 |
|
2013-09-04 13:49:21 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.2 |
|
2013-09-04 13:49:21 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.2 |
|
2013-09-04 13:49:30 |
Alexey Kopytov |
percona-xtrabackup/2.2: milestone |
2.1.5 |
2.2.0 |
|
2017-01-24 19:42:02 |
Scott Solmonson |
bug |
|
|
added subscriber Scott Solmonson |