Bug #110416 mysqld strange exit code
Submitted: 17 Mar 2023 16:21 Modified: 20 Mar 2023 13:42
Reporter: Pedro Ferreira Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:8.0.32 OS:Ubuntu (22.04)
Assigned to: CPU Architecture:x86 (x86_64)
Tags: mysqld

[17 Mar 2023 16:21] Pedro Ferreira 
Description:
After starting mysqld and connection mysql run these queries:

CREATE SCHEMA test;
USE test;
CREATE TABLE t0 (c0 INT);
CREATE TABLE t1 (c0 INT);
INSERT INTO t1(c0) VALUES (NULL);
SELECT 1 FROM t1 WHERE (SELECT schema(), 1 FROM t1) IN (SELECT CAST(X'4D' AS CHAR), 2 FROM t0);

Then issue the SHUTDOWN command and mysqld will exit with code 1 instead of 0. If this is not an issue, please close this bug report.

The compilation parameters are the same as issue 108148:

-DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77

How to repeat:
Run the statements above.
[20 Mar 2023 13:42] MySQL Verification Team 
Hi Mr. Ferrera,

Thank you for your bug report.

We have run your test case and mysqld exited with 0, not 1.

This could be a problem with your temporary table settings.

When mysqld is shutting down, you should get a message like this:

"Removed temporary tablespace data file: "ibtmp1""

Hence, you should analyse carefully your settings , especially for the intrinsic temporary tables, as described in Our Reference Manual.