[MDEV-7876] parts.partition_alter2_1_1_innodb fails sporadically in buildbot Created: 2015-03-30  Updated: 2015-08-07  Resolved: 2015-08-07

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/4110/steps/test_3/logs/stdio

parts.partition_alter2_1_1_innodb 'innodb_plugin' w2 [ fail ]
        Test ended at 2015-03-29 21:37:20
 
CURRENT_TEST: parts.partition_alter2_1_1_innodb
mysqltest: In included file "./suite/parts/inc/partition_trigg1.inc": 
included from ./suite/parts/inc/partition_check.inc at line 972:
included from ./suite/parts/inc/partition_alter_1.inc at line 71:
included from ./suite/parts/inc/partition_alter_11.inc at line 91:
included from ./suite/parts/inc/partition_alter2_1.inc at line 33:
included from /mnt/buildbot/build/mariadb-10.1.3/mysql-test/suite/parts/t/partition_alter2_1_1_innodb.test at line 84:
At line 58: query 'DROP TRIGGER trg_1' failed: 1360: Trigger does not exist
 
The result from queries just before the failure was:
< snip >
UPDATE t1 SET f_charbig = CONCAT('===',CAST(f_int1 AS CHAR),'===');
INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig)
SELECT f_int1,f_int2,f_char1,f_char2,'just inserted' FROM t0_template
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
INSERT INTO t0_aux(f_int1,f_int2,f_char1,f_char2,f_charbig)
SELECT -f_int1,-f_int1,CAST(-f_int1 AS CHAR),CAST(-f_int1 AS CHAR),
'just inserted' FROM t0_template
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
CREATE TRIGGER trg_1 BEFORE INSERT ON t0_aux FOR EACH ROW
BEGIN
UPDATE t1 SET f_int1 = -f_int1, f_int2 = -f_int2,
f_charbig = 'updated by trigger'
      WHERE f_int1 = new.f_int1;
END|
INSERT INTO t0_aux(f_int1,f_int2,f_char1,f_char2,f_charbig)
SELECT f_int1,f_int2,f_char1,f_char2,NULL FROM t0_template
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
	
# check trigger-1 success: 	0
DROP TRIGGER trg_1;
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.1.3/mysql-test/var/2/log/partition_alter2_1_1_innodb.log

It happened several times by now. Not easily reproducible.



 Comments   
Comment by Elena Stepanova [ 2015-08-07 ]

It has not happened since early May, closing for now.

Generated at Thu Feb 08 07:22:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.