gcache.page. files not removed fast enough for some workloads
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| Fuel for OpenStack |
High
|
Ivan Suzdal | ||
| 6.1.x |
High
|
Rodion Tikunov | ||
| 7.0.x |
High
|
Rodion Tikunov | ||
| 8.0.x |
High
|
Ivan Suzdal | ||
| Galera |
Undecided
|
Unassigned | ||
| Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Confirmed
|
High
|
Unassigned |
Bug Description
This is copy of initial report: https:/
For workloads with huge transactions it may happen that gcache.page.xxxx files will fill all the available disk space as due to current removal algorithm, oldest files may remain pretty long.
Here is a quickly reproducible test case:
perl -e '$s="$s\x31"; for my $i (0..26214400) { print $s; } ' > /tmp/blob
use test
CREATE TABLE blob1 (
id int(11) NOT NULL,
a tinyint(4) DEFAULT NULL,
big longblob,
PRIMARY KEY (id)
) ENGINE=InnoDB;
insert into blob1 values (1,1,LOAD_
for i in {1..50}; do mysql test -e "UPDATE blob1 SET a=$i,big=
Changed in percona-xtradb-cluster: | |
milestone: | none → 5.6.25-25.12 |
Changed in percona-xtradb-cluster: | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster: | |
milestone: | 5.6.25-25.12 → future-5.6 |
Changed in percona-xtradb-cluster: | |
importance: | Undecided → High |
Changed in fuel: | |
status: | New → Confirmed |
importance: | Undecided → High |
assignee: | nobody → MOS Linux (mos-linux) |
milestone: | none → 9.0 |
Changed in fuel: | |
assignee: | MOS Linux (mos-linux) → Ivan Suzdal (isuzdal) |
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix proposed to packages/trusty/galera (master) | #1 |
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix merged to packages/trusty/galera (master) | #2 |
Reviewed: https:/
Submitter: Pkgs Jenkins <email address hidden>
Branch: master
Commit: e7558b9c8ae2893
Author: Ivan Suzdal <email address hidden>
Date: Mon Jan 25 12:55:55 2016
Fix for gcache.page files removal.
Change-Id: Ia74799e9ea55a0
Related-Bug: #1488530
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix proposed to packages/trusty/galera (8.0) | #3 |
Related fix proposed to branch: 8.0
Change author: Ivan Suzdal <email address hidden>
Review: https:/
Fuel Devops McRobotson (fuel-devops-robot) wrote : Related fix merged to packages/trusty/galera (8.0) | #4 |
Reviewed: https:/
Submitter: Pkgs Jenkins <email address hidden>
Branch: 8.0
Commit: 8acb72b37f8efa0
Author: Ivan Suzdal <email address hidden>
Date: Wed Jan 27 18:09:58 2016
Fix for gcache.page files removal.
Change-Id: Ia74799e9ea55a0
Related-Bug: #1488530
(cherry picked from commit e7558b9c8ae2893
Changed in fuel: | |
status: | Confirmed → Fix Committed |
Timur Nurlygayanov (tnurlygayanov) wrote : | #5 |
Verified om MOS 8.0 RC1:
mysql> use test
ERROR 1049 (42000): Unknown database 'test'
mysql> CREATE DATABASE test
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> use test
Database changed
mysql> CREATE TABLE blob1 (
-> id int(11) NOT NULL,
-> a tinyint(4) DEFAULT NULL,
-> big longblob,
-> PRIMARY KEY (id)
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.03 sec)
mysql> insert into blob1 values (1,1,LOAD_
ERROR 1118 (42000): The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_
So, the size of this file was reduced.
issue not reproduced after
root@node-1:~# for i in {1..50}; do mysql test -e "UPDATE blob1 SET a=$i,big=
root@node-1:~# for i in {1..5000}; do mysql test -e "UPDATE blob1 SET a=$i,big=
root@node-1:~#
Moved to Fix Released.
Rodion Tikunov (rtikunov) wrote : | #6 |
In 7.0 galera updated to galera-3 and the bug can not be reproduced.
Rodion Tikunov (rtikunov) wrote : | #7 |
Could not reproduce for 6.1
Alexander Gubanov (ogubanov) wrote : | #8 |
Verified on MOS 9.0 (build 201) - can't reproduce.
Details: http://
Changed in fuel: | |
status: | Fix Committed → Fix Released |
Claudio (claudio-enjoy) wrote : | #9 |
same issue with :
Percona-
Percona-
Percona-
percona-
Percona-
percona-
Percona-
both configuration generate 300+ gcache.page.000* logs
1 wsrep_provider_
2 wsrep_provider_
any suggestion ?
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Related fix proposed to branch: master /review. fuel-infra. org/16432
Change author: Ivan Suzdal <email address hidden>
Review: https:/