Bug #41018 innodb_max_dirty_pages_pct_func fails sporadically: error 28 from storage engine

• Submitted: 25 Nov 2008 15:40
• Modified: 30 Jan 9:07
• Reporter: Sven Sandberg
• Status: Not a Bug
• Category: Tests: Server
• Severity: S2 (Serious)
• Version: 6.0-rpl
• OS: Any
• Assigned to: Horst Hunger
• Target Version: 6.0+
• Tags: 6.0-rpl-green, test failure, sporadic, pushbuild, innodb_max_dirty_pages_pct_func
• Triage: Triaged: D3 (Medium)

[25 Nov 2008 15:40] Sven Sandberg

Description:
sporadic pushbuild failure in 6.0-rpl:

main.innodb_max_dirty_pages_pct_func     [ fail ]

CURRENT_TEST: main.innodb_max_dirty_pages_pct_func
mysqltest: At line 143: query 'CALL add_until(10)' failed: 1030: Got error 28 from
storage engine

The result from queries just before the failure was:
SET @start_value= @@global.innodb_max_dirty_pages_pct;
'#--------------------FN_DYNVARS_044_02-------------------------#'
SET @@global.innodb_max_dirty_pages_pct = 80;
'connect (con1,localhost,root,,,,)'
SELECT @@global.innodb_max_dirty_pages_pct;
@@global.innodb_max_dirty_pages_pct
80
SET @@global.innodb_max_dirty_pages_pct = 70;
'connect (con2,localhost,root,,,,)'
SELECT @@global.innodb_max_dirty_pages_pct;
@@global.innodb_max_dirty_pages_pct
70
'#--------------------FN_DYNVARS_044_02-------------------------#'
'connection default'
'---Check when innodb_max_dirty_pages_pct is 10---'
SET @@global.innodb_max_dirty_pages_pct = 10;
FLUSH STATUS;

Warnings from just before the error:
Error 1030 Got error 28 from storage engine

 - saving '/dev/shm/var-n_mix-130/log/main.innodb_max_dirty_pages_pct_func/' to
'/dev/shm/var-n_mix-130/log/main.innodb_max_dirty_pages_pct_func/'

Retrying test, attempt(2/3)...

worker[1] mysql-test-run: WARNING: Process [mysqld.1 - pid: 25500, winpid: 25500, exit:
256] died

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=109
sapsrv2/n_mix

xref: http://tinyurl.com/69wwko

[30 Jan 14:26] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090129165607-wiskabxm948yx463)
(version source revid:[e-mail]-20090129163120-e2ntks4wgpqde6zt) (merge vers:
6.0.10-alpha) (pib:6)

[30 Jan 16:07] Bugs System

Pushed into 5.1.32 (revid:[e-mail]-20090129165946-d6jnnfqfokuzr09y) (version
source revid:[e-mail]-20081205211552-7odzip74f430g1du) (merge vers: 5.1.31)
(pib:6)

[17 Feb 15:52] Bugs System

Pushed into 5.1.32-ndb-6.3.23 (revid:[e-mail]-20090217131017-6u8qz1edkjfiobef)
(version source revid:[e-mail]-20090203133556-9rclp06ol19bmzs4) (merge vers:
5.1.32-ndb-6.3.22) (pib:6)

[17 Feb 17:40] Bugs System

Pushed into 5.1.32-ndb-6.4.3 (revid:[e-mail]-20090217134419-5ha6xg4dpedrbmau)
(version source revid:[e-mail]-20090203133556-9rclp06ol19bmzs4) (merge vers:
5.1.32-ndb-6.3.22) (pib:6)

[17 Feb 19:16] Bugs System

Pushed into 5.1.32-ndb-6.2.17 (revid:[e-mail]-20090217134216-5699eq74ws4oxa0j)
(version source revid:[e-mail]-20090201210519-vehobc4sy3g9s38e) (merge vers:
5.1.32-ndb-6.2.17) (pib:6)