| Bug #38120 | main.partition fails sporadically | ||
|---|---|---|---|
| Submitted: | 15 Jul 2008 7:28 | Modified: | 9 Oct 2008 18:57 |
| Reporter: | Alexander Nozdrin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
| Version: | 6.0-BK, 5.1 | OS: | Any |
| Assigned to: | Mattias Jonsson | CPU Architecture: | Any |
| Tags: | pushbuild, sporadic, test failure | ||
[20 Aug 2008 20:01]
Mattias Jonsson
Seems to be because of alter of general_log (which can be quite big when running the full main test suite) Will try to remove or alter the test that uses the general_log (or truncate the log before using it).
[27 Aug 2008 7:53]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/52655 2717 Mattias Jonsson 2008-08-27 Bug#38120: main.partition fails sporadically sporadic failures due to full disk. Fix by truncating general_log before altering it. (if running the full main-test, it can be big).
[28 Aug 2008 14:46]
Matthias Leich
ok to push. I also vote for pushing into 5.1.
[1 Sep 2008 11:25]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/52985 2717 Mattias Jonsson 2008-09-01 Bug#38120: main.partition fails sporadically sporadic failures due to full disk. Fix by truncating general_log before altering it. (if running the full main-test, it can be big).
[14 Sep 2008 1:26]
Bugs System
Pushed into 6.0.7-alpha (revid:mattiasj@mysql.com-20080901112519-nlt0nlxbxbo2t38w) (version source revid:vvaintroub@mysql.com-20080804094710-jb2qpqxpf2ir2gf3) (pib:3)
[15 Sep 2008 13:57]
Jon Stephens
Test failure only, no user-visible changes to document.
[4 Oct 2008 10:57]
Mattias Jonsson
This got tagged after I pushed to 6.0, and should be included in 5.1, reopening it. please don't close it before it is included in 5.1
[6 Oct 2008 7:18]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/55393 2847 Mattias Jonsson 2008-10-06 [merge] null-merge (bug#38120 was already pushed to 6.0) -- MySQL Code Commits Mailing List For list archives: http://lists.mysql.com/commits To unsubscribe: http://lists.mysql.com/commits?unsub=commits@bugs.mysql.com
[6 Oct 2008 7:31]
Mattias Jonsson
pushed to mysql-5.1-bugteam (null merged to mysql-6.0-bugteam, since it was already there)
[9 Oct 2008 17:37]
Bugs System
Pushed into 5.1.30 (revid:mattiasj@mysql.com-20080901112519-nlt0nlxbxbo2t38w) (version source revid:mats@sun.com-20081008113713-2vxny72m5w1tywoi) (pib:4)
[9 Oct 2008 18:57]
Paul DuBois
Test case changes. No changelog entry needed.
[17 Oct 2008 16:46]
Bugs System
Pushed into 6.0.8-alpha (revid:mattias.jonsson@sun.com-20081006071701-afy1dij0egeoz1bq) (version source revid:mattias.jonsson@sun.com-20081006071701-afy1dij0egeoz1bq) (pib:5)
[28 Oct 2008 21:06]
Bugs System
Pushed into 5.1.29-ndb-6.2.17 (revid:mattiasj@mysql.com-20080901112519-nlt0nlxbxbo2t38w) (version source revid:tomas.ulin@sun.com-20081028140209-u4emkk1xphi5tkfb) (pib:5)
[28 Oct 2008 22:24]
Bugs System
Pushed into 5.1.29-ndb-6.3.19 (revid:mattiasj@mysql.com-20080901112519-nlt0nlxbxbo2t38w) (version source revid:tomas.ulin@sun.com-20081028194045-0353yg8cvd2c7dd1) (pib:5)
[1 Nov 2008 9:51]
Bugs System
Pushed into 5.1.29-ndb-6.4.0 (revid:mattiasj@mysql.com-20080901112519-nlt0nlxbxbo2t38w) (version source revid:jonas@mysql.com-20081101082305-qx5a1bj0z7i8ueys) (pib:5)
Description: main.partition [ fail ] mysqltest: At line 1618: query 'ALTER TABLE general_log ENGINE = MyISAM' failed: 20: Disk is full writing './mysql/#sql-331b_1.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs The result from queries just before the failure was: < snip > Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment t1 MyISAM 10 Fixed 3 7 21 0 0 0 4 NULL NULL NULL latin1_swedish_ci NULL partitioned drop table t1; CREATE TABLE t1(a INT NOT NULL, b TINYBLOB, KEY(a)) PARTITION BY RANGE(a) ( PARTITION p0 VALUES LESS THAN (32)); INSERT INTO t1 VALUES (1, REPEAT('a', 10)); INSERT INTO t1 SELECT a + 1, b FROM t1; INSERT INTO t1 SELECT a + 2, b FROM t1; INSERT INTO t1 SELECT a + 4, b FROM t1; INSERT INTO t1 SELECT a + 8, b FROM t1; ALTER TABLE t1 ADD PARTITION (PARTITION p1 VALUES LESS THAN (64)); ALTER TABLE t1 DROP PARTITION p1; DROP TABLE t1; create table t (s1 int) engine=myisam partition by key (s1); create trigger t_ad after delete on t for each row insert into t values (old.s1); insert into t values (1); drop table t; USE mysql; SET GLOBAL general_log = 0; ALTER TABLE general_log ENGINE = MyISAM; How to repeat: https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.partition