[MDEV-37194] Crash when partitioning a large table. - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Incomplete
Affects Version/s: 10.11.11
Fix Version/s: N/A
Component/s: Partitioning, Storage Engine - InnoDB
Labels:
None
Environment:
Debian GNU/Linux 12
(Debian Stable)

Description

I was trying to partition a very large existing table for a speed-up (a 300M record table, I also have a 3.8B record table waiting to be done as well) after doing a database migration which added primary keys instead of indexes and expanded the index to the microsecond precision in the zabbix monitoring software database.

This is a very large database, and something went wrong with the migration. Note that the environment does have ECC memory and is in a secure datacenter, so I'm ruling out a cosmic particle as rather unlikely.

Unfortunately I can't attach the core dump file as the database contains confidential data which might have been included in the application's memory. If you need more information or analysis, please tell me what to do.

I did notice that it tried to write exactly 1 MB to that file but ended up writing 532 KB. However, my disk space is doing just fine:

df -h

Filesystem      Size  Used Avail Use% Mounted on

udev             16G     0   16G   0% /dev

tmpfs           3.2G  736K  3.2G   1% /run

/dev/sda1        14G  6.5G  6.5G  51% /

tmpfs            16G     0   16G   0% /dev/shm

tmpfs           5.0M     0  5.0M   0% /run/lock

/dev/sdb1      1007G  379G  578G  40% /sqldata

tmpfs           3.2G  4.0K  3.2G   1% /run/user/1000

And, just for completeness sake, I checked the hypervisor for any overcommit leading to a disk write error because the entire machine is filled up with data, and could not find any problem; there's 4TB (3.6TiB) of total SSD space (used for primary disks) available of which 2.9TiB is free. There's another 4TB (3.6TiB) of HDD space available (used for the history database) of which 1.6TiB is free.

Logs below;

mariadb log report of crash:

2025-07-10  8:40:46 38086 [Warning] InnoDB: 1048576 bytes should have been written at 83886080 from (unknown file), but got only 544768. Retrying.

2025-07-10  8:40:46 38086 [Warning] InnoDB: Retry attempts for writing partial data failed.

2025-07-10  8:40:46 38086 [ERROR] [FATAL] InnoDB: Unknown error Temp file write failure

250710  8:40:46 [ERROR] /usr/sbin/mariadbd got signal 6 ;

Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report

a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the

information below.

Server version: 10.11.11-MariaDB-0+deb12u1 source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/

contains instructions to obtain a better version of the backtrace below.

Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.

(note: Retrieving this information may fail)

Thread pointer: 0x7ff2d8013ad8

stack_bottom = 0x7ff3385a8000 thread_stack 0x49000

/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55e40a6a22ee]

/usr/sbin/mariadbd(handle_fatal_signal+0x1a3)[0x55e40a180da3]

2025-07-10  8:40:48 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown

2025-07-10  8:40:48 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 1

2025-07-10  8:40:48 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply

2025-07-10  8:40:48 0 [Note] Event Scheduler: Stopped

libc_sigaction.c:0(__restore_rt)[0x7ff757c45050]

nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7ff757c93eec]

posix/raise.c:27(__GI_raise)[0x7ff757c44fb2]

stdlib/abort.c:81(__GI_abort)[0x7ff757c2f472]

/usr/sbin/mariadbd(+0x6c323b)[0x55e409d9d23b]

/usr/sbin/mariadbd(+0x6b56b2)[0x55e409d8f6b2]

/usr/sbin/mariadbd(+0xe42745)[0x55e40a51c745]

/usr/sbin/mariadbd(+0xd8c382)[0x55e40a466382]

/usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0x1af)[0x55e40a1905bf]

/usr/sbin/mariadbd(+0xccebc3)[0x55e40a3a8bc3]

/usr/sbin/mariadbd(_ZN7handler12ha_write_rowEPKh+0x1af)[0x55e40a1905bf]

/usr/sbin/mariadbd(+0x9052e6)[0x55e409fdf2e6]

/usr/sbin/mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x44b3)[0x55e409fe9673]

/usr/sbin/mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x322)[0x55e40a057952]

/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0xe66)[0x55e409f21476]

/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1c6)[0x55e409f26416]

/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1425)[0x55e409f28a95]

/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x13f)[0x55e409f2aa4f]

/usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x385)[0x55e40a052a35]

/usr/sbin/mariadbd(handle_one_connection+0x5d)[0x55e40a052d8d]

/usr/sbin/mariadbd(+0xcd9ee7)[0x55e40a3b3ee7]

nptl/pthread_create.c:442(start_thread)[0x7ff757c921f5]

x86_64/clone3.S:83(clone3)[0x7ff757d1289c]

Connection ID (thread ID): 38086

Status: KILL_SERVER

Query (0x7ff2d8022670): ALTER TABLE `history` PARTITION BY RANGE (clock)

(PARTITION p2025_01_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-29 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_29 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-30 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_30 VALUES LESS THAN (UNIX_TIMESTAMP("2025-01-31 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_01_31 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-02-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_02_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-29 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_29 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-30 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_30 VALUES LESS THAN (UNIX_TIMESTAMP("2025-03-31 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_03_31 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-29 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_29 VALUES LESS THAN (UNIX_TIMESTAMP("2025-04-30 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_04_30 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-29 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_29 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-30 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_30 VALUES LESS THAN (UNIX_TIMESTAMP("2025-05-31 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_05_31 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-11 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_11 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-12 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_12 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-13 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_13 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-14 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_14 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-15 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_15 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-16 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_16 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-17 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_17 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-18 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_18 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-19 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_19 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-20 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_20 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-21 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_21 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-22 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_22 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-23 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_23 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-24 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_24 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-25 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_25 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-26 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_26 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-27 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_27 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-28 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_28 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-29 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_29 VALUES LESS THAN (UNIX_TIMESTAMP("2025-06-30 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_06_30 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-01 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_01 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-02 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_02 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-03 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_03 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-04 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_04 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-05 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_05 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-06 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_06 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-07 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_07 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-08 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_08 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-09 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_09 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-10 00:00:00")) ENGINE = InnoDB,

 PARTITION p2025_07_10 VALUES LESS THAN (UNIX_TIMESTAMP("2025-07-11 00:00:00")) ENGINE = InnoDB)

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off

Writing a core file...

Working directory at /sqldata/mysql

Resource Limits (excludes unlimited resources):

Limit                     Soft Limit           Hard Limit           Units

Max stack size            8388608              unlimited            bytes

Max core file size        0                    unlimited            bytes

Max processes             128260               128260               processes

Max open files            32768                32768                files

Max locked memory         524288               524288               bytes

Max pending signals       128260               128260               signals

Max msgqueue size         819200               819200               bytes

Max nice priority         0                    0

Max realtime priority     0                    0

Core pattern: |/lib/systemd/systemd-coredump %P %u %g %s %t 9223372036854775808 %h %d

Kernel version: Linux version 5.10.0-35-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.237-1 (2025-05-19)

2025-07-10  8:41:21 0 [Note] Starting MariaDB 10.11.11-MariaDB-0+deb12u1 source revision e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4 server_uid m/61/6bq1xF/QPTBEFnF+gyP81Y= as process 330817

2025-07-10  8:41:21 0 [Note] mariadbd: Aria engine: starting recovery

recovered pages: 0% 100% (0.0 seconds); tables to flush: 1 0

 (0.0 seconds);

2025-07-10  8:41:21 0 [Note] mariadbd: Aria engine: recovery done

2025-07-10  8:41:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.13

2025-07-10  8:41:21 0 [Note] InnoDB: Number of transaction pools: 1

2025-07-10  8:41:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2025-07-10  8:41:21 0 [Note] InnoDB: Using liburing

2025-07-10  8:41:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16.000GiB, chunk size = 256.000MiB

2025-07-10  8:41:21 0 [Note] InnoDB: Initialized memory pressure event listener

2025-07-10  8:41:21 0 [Note] InnoDB: Completed initialization of buffer pool

2025-07-10  8:41:22 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)

2025-07-10  8:41:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11834598170657

2025-07-10  8:41:25 0 [Note] InnoDB: Memory pressure event freed 0 pages

2025-07-10  8:41:25 0 [Note] InnoDB: End of log at LSN=11834631637969

2025-07-10  8:41:27 0 [Note] InnoDB: To recover: 6634 pages

2025-07-10  8:41:28 0 [Note] InnoDB: 128 rollback segments are active.

2025-07-10  8:41:28 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"

2025-07-10  8:41:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

2025-07-10  8:41:28 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

2025-07-10  8:41:28 0 [Note] InnoDB: log sequence number 11834631637969; transaction id 11297324458

2025-07-10  8:41:28 0 [Note] Plugin 'FEEDBACK' is disabled.

2025-07-10  8:41:28 0 [Note] InnoDB: Loading buffer pool(s) from /sqldata/mysql/ib_buffer_pool

2025-07-10  8:41:28 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.

2025-07-10  8:41:28 0 [Note] DDL_LOG: Crash recovery executed 1 entries

2025-07-10  8:41:28 0 [Note] Server socket created on IP: '127.0.0.1'.

2025-07-10  8:41:28 1 [Note] Event Scheduler: scheduler thread started with id 1

2025-07-10  8:41:28 0 [Note] /usr/sbin/mariadbd: ready for connections.

Version: '10.11.11-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12

2025-07-10  8:41:30 4 [Note] Detected table cache mutex contention at instance 1: 26% waits. Additional table cache instance activated. Number of instances after activation: 2.

2025-07-10  8:42:09 0 [Note] InnoDB: Buffer pool(s) load completed at 250710  8:42:09

gdb report:

PID: 305422 (mariadbd)

           UID: 107 (mysql)

           GID: 112 (mysql)

        Signal: 6 (ABRT)

     Timestamp: Thu 2025-07-10 08:40:50 CEST (10min ago)

  Command Line: /usr/sbin/mariadbd

    Executable: /usr/sbin/mariadbd

 Control Group: /system.slice/mariadb.service

          Unit: mariadb.service

         Slice: system.slice

       Boot ID: 9cdb630258494ff3b522bfef62a82f45

    Machine ID: df04173cbba84c479aea27c5700adeaa

      Hostname: zabbix

       Storage: /var/lib/systemd/coredump/core.mariadbd.107.9cdb630258494ff3b522bfef62a82f45.305422.1752129650000000.zst (present)

  Size on Disk: 147.8M

       Message: Process 305422 (mariadbd) of user 107 dumped core.

                Module libsystemd.so.0 from deb systemd-252.38-1~deb12u1.amd64

                Stack trace of thread 329596:

                #0  0x00007ff757c93eec __pthread_kill_implementation (libc.so.6 + 0x8aeec)

                #1  0x00007ff757c44fb2 __GI_raise (libc.so.6 + 0x3bfb2)

                #2  0x00007ff757c2f4fc __GI_abort (libc.so.6 + 0x264fc)

                #3  0x000055e409d9d23b n/a (mariadbd + 0x6c323b)

                #4  0x000055e409d8f6b2 n/a (mariadbd + 0x6b56b2)

                #5  0x000055e40a51c745 n/a (mariadbd + 0xe42745)

                #6  0x000055e40a466382 n/a (mariadbd + 0xd8c382)

                #7  0x000055e40a1905bf _ZN7handler12ha_write_rowEPKh (mariadbd + 0xab65bf)

                #8  0x000055e40a3a8bc3 n/a (mariadbd + 0xccebc3)

                #9  0x000055e40a1905bf _ZN7handler12ha_write_rowEPKh (mariadbd + 0xab65bf)

                #10 0x000055e409fdf2e6 n/a (mariadbd + 0x9052e6)

                #11 0x000055e409fe9673 _Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb (mariadbd + 0x90f673)

                #12 0x000055e40a057952 _ZN19Sql_cmd_alter_table7executeEP3THD (mariadbd + 0x97d952)

                #13 0x000055e409f21476 _Z21mysql_execute_commandP3THDb (mariadbd + 0x847476)

                #14 0x000055e409f26416 _Z11mysql_parseP3THDPcjP12Parser_state (mariadbd + 0x84c416)

                #15 0x000055e409f28a95 _Z16dispatch_command19enum_server_commandP3THDPcjb (mariadbd + 0x84ea95)

                #16 0x000055e409f2aa4f _Z10do_commandP3THDb (mariadbd + 0x850a4f)

                #17 0x000055e40a052a35 _Z24do_handle_one_connectionP7CONNECTb (mariadbd + 0x978a35)

                #18 0x000055e40a052d8d handle_one_connection (mariadbd + 0x978d8d)

                #19 0x000055e40a3b3ee7 n/a (mariadbd + 0xcd9ee7)

                #20 0x00007ff757c921f5 start_thread (libc.so.6 + 0x891f5)

                #21 0x00007ff757d1289c __clone3 (libc.so.6 + 0x10989c)

                Stack trace of thread 305427:

                #0  0x00007ff757d0521f __GI___poll (libc.so.6 + 0xfc21f)

                #1  0x000055e40a59e699 n/a (mariadbd + 0xec4699)

                #2  0x00007ff757fc04a3 n/a (libstdc++.so.6 + 0xd44a3)

                #3  0x00007ff757c921f5 start_thread (libc.so.6 + 0x891f5)

                #4  0x00007ff757d1289c __clone3 (libc.so.6 + 0x10989c)

                Stack trace of thread 305433:

                #0  0x00007ff757c45c82 __GI___sigtimedwait (libc.so.6 + 0x3cc82)

                #1  0x000055e409e088b3 signal_hand (mariadbd + 0x72e8b3)

                #2  0x000055e40a3b3ee7 n/a (mariadbd + 0xcd9ee7)

                #3  0x00007ff757c921f5 start_thread (libc.so.6 + 0x891f5)

                #4  0x00007ff757d1289c __clone3 (libc.so.6 + 0x10989c)

                Stack trace of thread 305425:

                #0  0x00007ff7587359f7 n/a (liburing.so.2 + 0x29f7)

                #1  0x00007ff758735c39 __io_uring_get_cqe (liburing.so.2 + 0x2c39)

                #2  0x000055e40a639470 n/a (mariadbd + 0xf5f470)

                #3  0x00007ff757fc04a3 n/a (libstdc++.so.6 + 0xd44a3)

                #4  0x00007ff757c921f5 start_thread (libc.so.6 + 0x891f5)

                #5  0x00007ff757d1289c __clone3 (libc.so.6 + 0x10989c)

                Stack trace of thread 305422:

                #0  0x00007ff757d0799c __GI___select (libc.so.6 + 0xfe99c)

                #1  0x000055e40a69fffc my_sleep (mariadbd + 0xfc5ffc)

                #2  0x000055e409e12b51 _Z11mysqld_mainiPPc (mariadbd + 0x738b51)

                #3  0x00007ff757c3024a __libc_start_call_main (libc.so.6 + 0x2724a)

                #4  0x00007ff757c30305 __libc_start_main_impl (libc.so.6 + 0x27305)

                #5  0x000055e409e06271 _start (mariadbd + 0x72c271)

                Stack trace of thread 327420:

                #0  0x0000000000000000 n/a (n/a + 0x0)

                #1  0x000055e40a5ac86d n/a (mariadbd + 0xed286d)

                #2  0x000055e40a5acc76 n/a (mariadbd + 0xed2c76)

                #3  0x000055e40a4aac63 n/a (mariadbd + 0xdd0c63)

                #4  0x00007ff740916c50 n/a (n/a + 0x0)

                ELF object binary architecture: AMD x86-64

Attachments

Issue Links

relates to

MDEV-36017 Fatal InnoDB error: Unknown error Temp file write failure

Closed

Activity

People

Assignee:: Unassigned

Reporter:: npr

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2025-07-10 07:19

Updated:: 2025-08-18 12:28

Resolved:: 2025-08-18 12:28

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.