autopkgtest fails for 8.0.31 on ppc64el
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_
CURRENT_TEST: main.regular_
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[
Server [mysqld.1 - pid: 47662, winpid: 47662, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
safe_process[
----------SERVER LOG END-------------
- the logfile can be found in '/tmp/tmp.
For example, see: https:/
Related branches
- git-ubuntu bot: Approve
- Robie Basak: Approve
- Canonical Server Reporter: Pending requested
-
Diff: 27 lines (+8/-0)2 files modifieddebian/changelog (+7/-0)
debian/tests/upstream (+1/-0)
It looks like this started failing in Novemeber 2021 during the Jammy cycle, and has been failing ever since.