Bug 1592735

Summary: testsuite failure during rebuild - parts.partition_alter1_2_innodb 'innodb_plugin'
Product: Red Hat Enterprise Linux 7 Reporter: Karel Volný <kvolny>
Component: mariadbAssignee: Michal Schorm <mschorm>
Status: CLOSED ERRATA QA Contact: Lukáš Zachar <lzachar>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 7.5CC: databases-maint, hhorak, mmuzila
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-09-29 20:41:08 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1834835    

Description Karel Volný 2018-06-19 07:59:27 UTC
Description of problem:
trying to run tps, I got server crash

Version-Release number of selected component (if applicable):
mariadb-5.5.60-1.el7_5.src.rpm

Actual results:
parts.partition_alter1_2_innodb 'innodb_plugin' [ fail ]  timeout after 1800 seconds
        Test ended at 2018-06-14 20:24:28

Test case timeout after 1800 seconds

== /home/test/rpmbuild/BUILD/mariadb-5.5.60/mysql-test/var/log/partition_alter1_2_innodb.log == 
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
CREATE TRIGGER trg_1 AFTER DELETE 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 = - old.f_int1;
END|
DELETE FROM t0_aux
WHERE f_int1 IN (- (@max_row_div2 - 1),- @max_row_div2,- (@max_row_div2 + 1));
	
# check trigger-8 success: 	1
DROP TRIGGER trg_1;
UPDATE t1 SET f_int1 = CAST(f_char1 AS SIGNED INT),
f_int2 = CAST(f_char1 AS SIGNED INT),
f_charbig = 'just inserted'
   WHERE f_int1 <> CAST(f_char1 AS SIGNED INT);
DELETE FROM t0_aux
WHERE ABS(f_int1) BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
DELETE FROM t1
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;

 == /home/test/rpmbuild/BUILD/mariadb-5.5.60/mysql-test/var/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'reading initial communication packet', system error: 104


 - saving '/home/test/rpmbuild/BUILD/mariadb-5.5.60/mysql-test/var/log/parts.partition_alter1_2_innodb-innodb_plugin/' to '/home/test/rpmbuild/BUILD/mariadb-5.5.60/mysql-test/var/log/parts.partition_alter1_2_innodb-innodb_plugin/'
 - found 'core.718' (0/5)

Comment 8 errata-xmlrpc 2020-09-29 20:41:08 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Moderate: mariadb security and bug fix update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2020:4026