Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
Note: Possibly it has already been fixed, but I don't see a clear indication of it.
bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28 |
innodb_zip.recover 'innodb' w1 [ fail ]
|
Test ended at 2020-05-06 14:52:03
|
|
CURRENT_TEST: innodb_zip.recover
|
mysqltest: In included file "./include/wait_until_connected_again.inc":
|
included from ./include/start_mysqld.inc at line 18:
|
included from ./include/restart_mysqld.inc at line 11:
|
included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29:
|
At line 23: Server failed to restart
|
|
The result from queries just before the failure was:
|
#
|
# MDEV-12720 recovery fails with "Generic error"
|
# for ROW_FORMAT=compressed
|
#
|
CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB
|
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
BEGIN;
|
insert into a(i) select null;
|
insert into a select null, uuid() from a a, a b, a c;
|
insert into a select null, uuid() from a a, a b, a c;
|
insert into a select null, uuid() from a a, a b, a c;
|
SET GLOBAL innodb_flush_log_at_trx_commit=1;
|
COMMIT;
|
Last words in the log:
2020-05-07 9:42:08 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 17, since the redo log references ./test/t1.ibd with space ID 16.
|
2020-05-07 9:42:08 0 [Note] InnoDB: Starting a batch to recover 332 pages from redo log.
|
2020-05-07 9:42:09 0 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 21 failed attempts to flush a page! Consider increasing innodb_buffer_pool_size. Pending flushes (fsync) log: 0; buffer pool: 0. 381 OS file reads, 78 OS file writes, 78 OS fsyncs.
|
Attachments
Issue Links
- duplicates
-
MDEV-21351 Replace recv_sys.heap with list of buf_block_t*
-
- Closed
-
- relates to
-
MDEV-21351 Replace recv_sys.heap with list of buf_block_t*
-
- Closed
-
-
MDEV-21826 Recovery failure : loop of Read redo log up to LSN
-
- Closed
-
-
MDEV-23979 Corrupted page breaks recovery in innodb_gis.types
-
- Open
-
-
MDEV-19176 Do not run out of InnoDB buffer pool during recovery
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
_Note: Possibly it has already been fixed, but I don't see a clear indication of it._
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio {noformat:title=bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28} innodb_zip.recover 'innodb' w1 [ fail ] Test ended at 2020-05-06 14:52:03 CURRENT_TEST: innodb_zip.recover mysqltest: In included file "./include/wait_until_connected_again.inc": included from ./include/start_mysqld.inc at line 18: included from ./include/restart_mysqld.inc at line 11: included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29: At line 23: Server failed to restart The result from queries just before the failure was: # # # for ROW_FORMAT=compressed # CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; BEGIN; insert into a(i) select null; insert into a select null, uuid() from a a, a b, a c; insert into a select null, uuid() from a a, a b, a c; insert into a select null, uuid() from a a, a b, a c; SET GLOBAL innodb_flush_log_at_trx_commit=1; COMMIT; {noformat} |
_Note: Possibly it has already been fixed, but I don't see a clear indication of it._
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3970/steps/mtr_centos_mix/logs/stdio {noformat:title=bb-10.2-release 75dcb74da652d8ba504b6906b2aa2ae5 2020-05-06 16:30:28} innodb_zip.recover 'innodb' w1 [ fail ] Test ended at 2020-05-06 14:52:03 CURRENT_TEST: innodb_zip.recover mysqltest: In included file "./include/wait_until_connected_again.inc": included from ./include/start_mysqld.inc at line 18: included from ./include/restart_mysqld.inc at line 11: included from /usr/share/mysql-test/suite/innodb_zip/t/recover.test at line 29: At line 23: Server failed to restart The result from queries just before the failure was: # # # for ROW_FORMAT=compressed # CREATE TABLE a(i INT PRIMARY KEY AUTO_INCREMENT, s VARCHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; BEGIN; insert into a(i) select null; insert into a select null, uuid() from a a, a b, a c; insert into a select null, uuid() from a a, a b, a c; insert into a select null, uuid() from a a, a b, a c; SET GLOBAL innodb_flush_log_at_trx_commit=1; COMMIT; {noformat} Last words in the log: {noformat} 2020-05-07 9:42:08 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 17, since the redo log references ./test/t1.ibd with space ID 16. 2020-05-07 9:42:08 0 [Note] InnoDB: Starting a batch to recover 332 pages from redo log. 2020-05-07 9:42:09 0 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (21 search iterations)! 21 failed attempts to flush a page! Consider increasing innodb_buffer_pool_size. Pending flushes (fsync) log: 0; buffer pool: 0. 381 OS file reads, 78 OS file writes, 78 OS fsyncs. {noformat} |
Fix Version/s | 10.3 [ 22126 ] | |
Affects Version/s | 10.3 [ 22126 ] |
Fix Version/s | 10.4 [ 22408 ] | |
Affects Version/s | 10.4 [ 22408 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
Labels | need_rr |
Link | This issue relates to MDEV-23979 [ MDEV-23979 ] |
Link |
This issue duplicates |
Fix Version/s | 10.5.1 [ 24029 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
Labels | need_rr | not-10.5 |
issue.field.resolutiondate | 2020-10-19 08:50:19.0 | 2020-10-19 08:50:19.732 |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Resolution | Fixed [ 1 ] | |
Status | Closed [ 6 ] | Stalled [ 10000 ] |
Summary | innodb_zip.recover failed in buildbot with server failing to restart | innodb_zip.recover, innodb_gis.types failed in buildbot with server failing to restart |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] |
Fix Version/s | 10.5.1 [ 24029 ] |
Workflow | MariaDB v3 [ 108452 ] | MariaDB v4 [ 143641 ] |
Fix Version/s | 10.2 [ 14601 ] |
issue.field.resolutiondate | 2022-11-08 16:42:22.0 | 2022-11-08 16:42:22.747 |
Fix Version/s | 10.3.38 [ 28507 ] | |
Fix Version/s | 10.4.28 [ 28509 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Another one, on bb-10.3-release:
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/3984
tokudb_bugs.xa-3 'innodb' w1 [ fail ]
Test ended at 2020-05-07 09:50:42
CURRENT_TEST: tokudb_bugs.xa-3
mysqltest: In included file "./include/wait_until_connected_again.inc":
included from /usr/share/mysql-test/plugin/tokudb/tokudb_bugs/t/xa-3.test at line 82:
At line 23: Server failed to restart
The result from queries just before the failure was:
< snip >
INSERT INTO t2 VALUES (2);
SET SESSION debug_dbug="d,crash_commit_after_prepare";
COMMIT;
ERROR HY000: Lost connection to MySQL server during query
select * from t1;
a
select * from t2;
b
drop table t1, t2;
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=innodb;
CREATE TABLE t2 (b INT PRIMARY KEY) ENGINE=tokudb;
BEGIN;
SELECT @@log_bin;
@@log_bin
0
INSERT INTO t1 VALUES (1);
INSERT INTO t2 VALUES (2);
SET SESSION debug_dbug="d,crash_commit_after";
COMMIT;
ERROR HY000: Lost connection to MySQL server during query