Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.3, 11.4, 11.5
-
None
Description
Replay using CLI. could not reproduce the issue through MTR
RR trace is saved in galapq server. /qa-dev/MDEV-34256/mariadb-11.5.1-linux-x86_64/rr
CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT) ENGINE=InnoDB; |
SET GLOBAL innodb_immediate_scrub_data_uncompressed=1; |
INSERT INTO t1 VALUES (repeat(1,16777215)); |
DROP TEMPORARY TABLE t1; |
SET GLOBAL innodb_truncate_temporary_tablespace_now=1; |
SET @@GLOBAL.innodb_buffer_pool_size=10485760; |
Leads to:
|
11.5.1 b2fc885469a7db2c25eab67fbc8e220dc2f805f8 (Optimized) |
Core was generated by `/test/MD270524-mariadb-11.5.1-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14c7bf7ff700 (LWP 3406662))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014c7e1362859 in __GI_abort () at abort.c:79
|
#2 0x00005639c618f164 in fil_invalid_page_access_msg (is_read=<optimized out>, len=94806187045432, offset=94806187045096, name=<optimized out>) at /test/11.5_opt/storage/innobase/fil/fil0fil.cc:2846
|
#3 fil_space_t::io (this=this@entry=0x5639c919f0e8, type=@0x14c7bf7fec40: {bpage = 0x0, slot = 0x0, node = 0x0, type = IORequest::WRITE_ASYNC}, offset=offset@entry=12582912, len=len@entry=16384, buf=<optimized out>, bpage=bpage@entry=0x0) at /test/11.5_opt/storage/innobase/fil/fil0fil.cc:2921
|
#4 0x00005639c69fc88b in fil_space_t::flush_freed (this=0x5639c919f0e8, writable=<optimized out>) at /test/11.5_opt/storage/innobase/include/os0file.h:216
|
#5 0x00005639c69fe79f in buf_flush_space (id=4294967294) at /test/11.5_opt/storage/innobase/buf/buf0flu.cc:1174
|
#6 buf_flush_LRU_list_batch (n=<synthetic pointer>, n=<synthetic pointer>, max=<optimized out>) at /test/11.5_opt/storage/innobase/buf/buf0flu.cc:1285
|
#7 buf_do_LRU_batch (n=<synthetic pointer>, max=<optimized out>) at /test/11.5_opt/storage/innobase/buf/buf0flu.cc:1359
|
#8 buf_flush_LRU (max_n=<optimized out>) at /test/11.5_opt/storage/innobase/buf/buf0flu.cc:1705
|
#9 buf_flush_page_cleaner () at /test/11.5_opt/storage/innobase/buf/buf0flu.cc:2478
|
#10 0x000014c7e1759de4 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
|
#11 0x000014c7e1873609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#12 0x000014c7e145f133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 11.3.3 (dbg), 11.3.3 (opt), 11.4.2 (dbg), 11.4.2 (opt), 11.5.1 (dbg), 11.5.1 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.4.34 (dbg), 10.4.34 (opt), 10.5.26 (dbg), 10.5.26 (opt), 10.6.18 (dbg), 10.6.18 (opt), 10.11.8 (dbg), 10.11.8 (opt), 11.0.6 (dbg), 11.0.6 (opt), 11.1.5 (dbg), 11.1.5 (opt), 11.2.4 (dbg), 11.2.4 (opt)
Attachments
Issue Links
- is caused by
-
MDEV-28699 Shrink temporary tablespaces without restart
-
- Closed
-