| Bug #112521 | Abort in /mysql-8.0.34/sql/signal_handler.cc:286 | ||
|---|---|---|---|
| Submitted: | 26 Sep 2023 12:40 | Modified: | 26 Sep 2023 13:06 |
| Reporter: | xin wen | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
| Version: | 8.0.34 | OS: | Ubuntu (20.04) |
| Assigned to: | CPU Architecture: | Any | |
[26 Sep 2023 12:40]
xin wen
[26 Sep 2023 13:06]
MySQL Verification Team
Hello xin wen, Thank you for the report and test case. Observed that 8.0.34 debug build is affected. regards, Umesh
[26 Sep 2023 13:06]
MySQL Verification Team
- ./mtr --nocheck-testcases bug112521 --debug-server Logging: ./mtr --nocheck-testcases bug112521 --debug-server MySQL Version 8.0.34 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/mysql-8.0.34/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c13 INT , c39 INT ) ; INSERT INTO t0 SET c13 = -27 ; CREATE VIEW v0 AS SELECT REVERSE ( c13 ) * LAG ( c13 , 1513851253354973910 ) OVER ( ) AS c40 FROM ( SELECT c13 AS c6 FROM t0 ) AS t1 JOIN t0 ON t0 . c13 = t0 . c13 INTERSECT SELECT c39 AS c6 FROM t0 ; WITH t2 AS ( SELECT -126 AS c13 , -76 AS c14 ) SELECT RAND ( ) - FLOOR ( c47 ) IS NOT FALSE AS c46 , 56 BETWEEN AVG ( 5037955339126189160 ) AND 46 AS c38 FROM ( SELECT c13 AS c22 FROM t2 ) AS t3 JOIN ( SELECT c40 AS c47 FROM v0 ) AS t4 ON c22 = c47 GROUP BY c47 ; [ 50%] main.bug112521 [ fail ] Test ended at 2023-09-26 15:05:36 CURRENT_TEST: main.bug112521 mysqltest: At line 4: Query 'WITH t2 AS ( SELECT -126 AS c13 , -76 AS c14 ) SELECT RAND ( ) - FLOOR ( c47 ) IS NOT FALSE AS c46 , 56 BETWEEN AVG ( 5037955339126189160 ) AND 46 AS c38 FROM ( SELECT c13 AS c22 FROM t2 ) AS t3 JOIN ( SELECT c40 AS c47 FROM v0 ) AS t4 ON c22 = c47 GROUP BY c47 ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query -bt #0 0x00007f34ab842aa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000402c28e in my_write_core(int) () #2 0x00000000032d235e in handle_fatal_signal () #3 <signal handler called> #4 0x00007f34a9b8d387 in raise () from /lib64/libc.so.6 #5 0x00007f34a9b8ea78 in abort () from /lib64/libc.so.6 #6 0x00000000032d2452 in my_server_abort() () #7 0x00000000040263cd in my_abort() () #8 0x0000000004864d23 in temptable::Handler::index_first(unsigned char*) () #9 0x00000000033e27cc in handler::ha_index_first(unsigned char*) () #10 0x00000000034ff6da in IndexScanIterator<false>::Read() () #11 0x0000000003669356 in MaterializeIterator<DummyIteratorProfiler>::Read() () #12 0x0000000003666c33 in FilterIterator::Read() () #13 0x0000000003667032 in AggregateIterator::Read() () #14 0x000000000322d193 in Query_expression::ExecuteIteratorQuery(THD*) () #15 0x000000000322d2aa in Query_expression::execute(THD*) () #16 0x00000000031b71dc in Sql_cmd_dml::execute_inner(THD*) () #17 0x00000000031c0beb in Sql_cmd_dml::execute(THD*) () #18 0x0000000003161263 in mysql_execute_command(THD*, bool) () #19 0x00000000031626a2 in dispatch_sql_command(THD*, Parser_state*) () #20 0x0000000003163cd5 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #21 0x000000000316596c in do_command(THD*) () #22 0x00000000032c437c in handle_connection () #23 0x00000000047e1af5 in pfs_spawn_thread () #24 0x00007f34ab83dea5 in start_thread () from /lib64/libpthread.so.0 #25 0x00007f34a9c55b2d in clone () from /lib64/libc.so.6
