Test innodb.percona_log_arch_expire_sec is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
On 5.6 trunk:
innodb.
Test ended at 2017-03-24 10:00:06
CURRENT_TEST: innodb.
mysqltest: At line 23: Test failed. Archived logs have nod been purged.
The result from queries just before the failure was:
call mtr.add_
call mtr.add_
call mtr.add_
call mtr.add_
drop table if exists t;
create table t (a int not null) ENGINE=InnoDB;
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t values (1),(2)
insert into t (a) select t1.a from t t1, t t2, t t3 LIMIT 40000;
SET @save_log_
SET GLOBAL innodb_
insert into t (a) select t1.a from t t1, t t2, t t3 LIMIT 40000;
insert into t (a) select t1.a from t t1, t t2, t t3 LIMIT 40000;
SELECT sleep(4);
sleep(4)
0
safe_process[
The cause is that the expired log purge is a background process, and there is no synchronisation.
tags: | added: ci log-archiving |
https:/ /github. com/percona/ percona- server/ pull/1776 /github. com/percona/ percona- server/ pull/1777
https:/