autopkgtest fails for 8.0.31 on ppc64el

Bug #1999076 reported by Lena Voytek
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-8.0 (Ubuntu)
Fix Released
Critical
Lena Voytek
Focal
Fix Released
Undecided
Unassigned
Jammy
Fix Released
Undecided
Unassigned
Kinetic
Fix Released
Undecided
Unassigned

Bug Description

When autopkgtests for mysql run on ppc64el, the test main.regular_expressions_utf-8 fails with the following info:

CURRENT_TEST: main.regular_expressions_utf-8
mysqltest: At line 616: Query 'DO '1' regexp repeat('$', 50000000)' failed with wrong error 2013: 'Lost connection to MySQL server during query', should have failed with error '3700'.

The result from queries just before the failure was:
# Test that the replacement buffer can grow beyond the maximum VARCHAR
# column length.
#
CREATE TABLE t1 ( a TEXT );
INSERT INTO t1 VALUES ( repeat( 'a', 16384 ) );
SELECT char_length ( regexp_replace( a, 'a', 'b' ) ) FROM t1;
char_length ( regexp_replace( a, 'a', 'b' ) )
16384
SET GLOBAL regexp_time_limit = 10000;
SELECT regexp_like ( regexp_replace( a, 'a', 'b' ), 'b{16384}' ) FROM t1;
regexp_like ( regexp_replace( a, 'a', 'b' ), 'b{16384}' )
1
SET GLOBAL regexp_time_limit = DEFAULT;
DROP TABLE t1;
#
# Bug#27134570: DOS: REGEXP TAKES EXPONENTIALLY LONGER, CAN'T BE KILLED,
# HOGS CPU
#
DO '1' regexp repeat('$', 50000000);
ERROR HY000: Lost connection to MySQL server during query
safe_process[47731]: Child process: 47732, exit: 1

Server [mysqld.1 - pid: 47662, winpid: 47662, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
safe_process[47662]: Child process: 47663, killed by signal: 9
----------SERVER LOG END-------------

 - the logfile can be found in '/tmp/tmp.mSRlhxaIrc/var/log/main.regular_expressions_utf-8/regular_expressions_utf-8.log'

For example, see: https://autopkgtest.ubuntu.com/results/autopkgtest-lunar/lunar/ppc64el/m/mysql-8.0/20221205_235042_c519f@/log.gz

Related branches

Revision history for this message
Robie Basak (racb) wrote :

It looks like this started failing in Novemeber 2021 during the Jammy cycle, and has been failing ever since.

Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package mysql-8.0 - 8.0.31-0ubuntu3

---------------
mysql-8.0 (8.0.31-0ubuntu3) lunar; urgency=medium

  * d/t/upstream: Skip main.regular_expressions_utf-8 upstream test since it
    fails on ppc64el (LP: #1999076)

 -- Lena Voytek <email address hidden> Wed, 07 Dec 2022 15:40:53 -0700

Changed in mysql-8.0 (Ubuntu):
status: In Progress → Fix Released
Revision history for this message
Lena Voytek (lvoytek) wrote :

Adding mysql ppc64el to big_packages fixed this issue

Changed in mysql-8.0 (Ubuntu Focal):
status: New → Fix Released
Changed in mysql-8.0 (Ubuntu Jammy):
status: New → Fix Released
Changed in mysql-8.0 (Ubuntu Kinetic):
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.