Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
11.4.3
-
Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3
mariadb:11.4-ubi from docker-hub running in docker on windows.
Description
creating empty table plus primary or unique key forces shutdown+recovery from official docker-image.
db-1 | 2024-09-16 11:00:19 487 [ERROR] InnoDB: preallocating 81920 bytes for file ./mountedoutside/user.ibd failed with error 2
|
db-1 | 2024-09-16 11:00:19 0x7f9c203f3640 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-9-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/fil/fil0fil.cc line 629
|
db-1 | InnoDB: Failing assertion: fsize != os_offset_t(-1)
|
db-1 | InnoDB: We intentionally generate a memory trap.
|
db-1 | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
db-1 | InnoDB: If you get repeated assertion failures or crashes, even
|
db-1 | InnoDB: immediately after the mariadbd startup, there may be
|
db-1 | InnoDB: corruption in the InnoDB tablespace. Please refer to
|
db-1 | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
db-1 | InnoDB: about forcing recovery.
|
db-1 | 240916 11:00:19 [ERROR] mysqld got signal 6 ;
|
db-1 | Sorry, we probably made a mistake, and this is a bug.
|
db-1 | To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
db-1 |
|
db-1 | We will try our best to scrape up some info that will hopefully help
|
db-1 | diagnose the problem, but since we have already crashed,
|
db-1 | something is definitely wrong and this may fail.
|
db-1 |
|
db-1 | Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3
|
db-1 | key_buffer_size=134217728
|
db-1 | read_buffer_size=131072
|
db-1 | max_used_connections=10
|
db-1 | max_threads=153
|
db-1 | thread_count=10
|
db-1 | It is possible that mysqld could use up to
|
db-1 | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K bytes of memory
|
db-1 | Hope that's ok; if not, decrease some variables in the equation.
|
db-1 |
|
db-1 | Thread pointer: 0x7f9bfc000c58
|
db-1 | Attempting backtrace. You can use the following information to find out
|
db-1 | where mysqld died. If you see no messages after this, something went
|
db-1 | terribly wrong...
|
db-1 | stack_bottom = 0x7f9c203f2cb8 thread_stack 0x49000
|
db-1 | Printing to addr2line failed
|
db-1 | mariadbd(my_print_stacktrace+0x2e)[0x5572f258767e]
|
db-1 | mariadbd(handle_fatal_signal+0x478)[0x5572f2051168]
|
db-1 | /lib64/libc.so.6(+0x3e6f0)[0x7f9c438046f0]
|
db-1 | /lib64/libc.so.6(+0x8b94c)[0x7f9c4385194c]
|
db-1 | /lib64/libc.so.6(raise+0x16)[0x7f9c43804646]
|
db-1 | /lib64/libc.so.6(abort+0xd3)[0x7f9c437ee7f3]
|
db-1 | mariadbd(+0x6e4678)[0x5572f1c44678]
|
db-1 | mariadbd(+0x6f41d4)[0x5572f1c541d4]
|
db-1 | mariadbd(+0x6f53bf)[0x5572f1c553bf]
|
db-1 | mariadbd(+0x6f794b)[0x5572f1c5794b]
|
db-1 | mariadbd(+0x6f8273)[0x5572f1c58273]
|
db-1 | mariadbd(+0xf78768)[0x5572f24d8768]
|
db-1 | mariadbd(+0xf7987c)[0x5572f24d987c]
|
db-1 | mariadbd(+0xefaeaa)[0x5572f245aeaa]
|
db-1 | mariadbd(+0xf3b523)[0x5572f249b523]
|
db-1 | mariadbd(+0xf3bdd7)[0x5572f249bdd7]
|
db-1 | mariadbd(+0xe72f21)[0x5572f23d2f21]
|
db-1 | mariadbd(+0xdfca4e)[0x5572f235ca4e]
|
db-1 | mariadbd(+0xe04f5b)[0x5572f2364f5b]
|
db-1 | mariadbd(+0xe08024)[0x5572f2368024]
|
db-1 | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x5493)[0x5572f1e95e63]
|
db-1 | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3fb)[0x5572f1f036cb]
|
db-1 | mariadbd(_Z21mysql_execute_commandP3THDb+0x4684)[0x5572f1dcd694]
|
db-1 | mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5572f1dce797]
|
db-1 | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xee5)[0x5572f1dd0985]
|
db-1 | mariadbd(_Z10do_commandP3THDb+0x134)[0x5572f1dd2e94]
|
db-1 | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5572f1efe61f]
|
db-1 | mariadbd(handle_one_connection+0x5d)[0x5572f1efe96d]
|
db-1 | mariadbd(+0xd2cbb2)[0x5572f228cbb2]
|
db-1 | /lib64/libc.so.6(+0x89c02)[0x7f9c4384fc02]
|
db-1 | /lib64/libc.so.6(+0x10ec40)[0x7f9c438d4c40]
|
db-1 |
|
db-1 | Trying to get some variables.
|
db-1 | Some pointers may be invalid and cause the dump to abort.
|
db-1 | Query (0x7f9bfc010b70): alter table user
|
db-1 | add constraint user_name_unique
|
db-1 | unique (name)
|
db-1 |
|
db-1 | Connection ID (thread ID): 487
|
db-1 | Status: NOT_KILLED
|
db-1 |
|
db-1 | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on
|
|
issuing
create table if not exists operator ( |
id int not null, |
name varchar(64) not null, |
idpid varchar(128) not null |
) engine=innodb default charset=utf8mb4 collate utf8mb4_bin; |
|
alter table operator |
add constraint operator_id_pk |
primary key (id); |
|
alter table operator |
add constraint operator_name_unique |
unique (name); |
|
alter table operator |
add constraint operator_idpid_unique |
unique (idpid); |
This is mostly to document that the linked issue is also reproducible in a newer version. The three constraints order is arbitrary - it is always the first that fails.
Attachments
Issue Links
- is duplicated by
-
MDEV-35425 MariaDB crashes when kanboard performs database initialization in Windows WSL Docker environment
-
- Closed
-
- relates to
-
MDEV-28580 Server crash when creating an index after adding a foreign key
-
- Closed
-
-
MDEV-26381 InnoDB: Failing assertion: fsize != os_offset_t(-1) on CREATE TABLE with many partitions / ENOMEM (out of kernel memory) from fstat handling
-
- Closed
-
-
MDEV-29260 Server crashes when running migration queries inside Docker on Windows
-
- Closed
-
-
MDEV-35501 innodb.log_file_name fails with "Could not measure size of ..."
-
- Closed
-
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
Description |
creating empty table plus primary or unique key forces shutdown+recovery from official docker-image.
{code} db-1 | 2024-09-16 11:00:19 487 [ERROR] InnoDB: preallocating 81920 bytes for file ./mountedoutside/user.ibd failed with error 2 db-1 | 2024-09-16 11:00:19 0x7f9c203f3640 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-9-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/fil/fil0fil.cc line 629 db-1 | InnoDB: Failing assertion: fsize != os_offset_t(-1) db-1 | InnoDB: We intentionally generate a memory trap. db-1 | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ db-1 | InnoDB: If you get repeated assertion failures or crashes, even db-1 | InnoDB: immediately after the mariadbd startup, there may be db-1 | InnoDB: corruption in the InnoDB tablespace. Please refer to db-1 | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ db-1 | InnoDB: about forcing recovery. db-1 | 240916 11:00:19 [ERROR] mysqld got signal 6 ; db-1 | Sorry, we probably made a mistake, and this is a bug. db-1 | To report this bug, see https://mariadb.com/kb/en/reporting-bugs db-1 | db-1 | We will try our best to scrape up some info that will hopefully help db-1 | diagnose the problem, but since we have already crashed, db-1 | something is definitely wrong and this may fail. db-1 | db-1 | Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3 db-1 | key_buffer_size=134217728 db-1 | read_buffer_size=131072 db-1 | max_used_connections=10 db-1 | max_threads=153 db-1 | thread_count=10 db-1 | It is possible that mysqld could use up to db-1 | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K bytes of memory db-1 | Hope that's ok; if not, decrease some variables in the equation. db-1 | db-1 | Thread pointer: 0x7f9bfc000c58 db-1 | Attempting backtrace. You can use the following information to find out db-1 | where mysqld died. If you see no messages after this, something went db-1 | terribly wrong... db-1 | stack_bottom = 0x7f9c203f2cb8 thread_stack 0x49000 db-1 | Printing to addr2line failed db-1 | mariadbd(my_print_stacktrace+0x2e)[0x5572f258767e] db-1 | mariadbd(handle_fatal_signal+0x478)[0x5572f2051168] db-1 | /lib64/libc.so.6(+0x3e6f0)[0x7f9c438046f0] db-1 | /lib64/libc.so.6(+0x8b94c)[0x7f9c4385194c] db-1 | /lib64/libc.so.6(raise+0x16)[0x7f9c43804646] db-1 | /lib64/libc.so.6(abort+0xd3)[0x7f9c437ee7f3] db-1 | mariadbd(+0x6e4678)[0x5572f1c44678] db-1 | mariadbd(+0x6f41d4)[0x5572f1c541d4] db-1 | mariadbd(+0x6f53bf)[0x5572f1c553bf] db-1 | mariadbd(+0x6f794b)[0x5572f1c5794b] db-1 | mariadbd(+0x6f8273)[0x5572f1c58273] db-1 | mariadbd(+0xf78768)[0x5572f24d8768] db-1 | mariadbd(+0xf7987c)[0x5572f24d987c] db-1 | mariadbd(+0xefaeaa)[0x5572f245aeaa] db-1 | mariadbd(+0xf3b523)[0x5572f249b523] db-1 | mariadbd(+0xf3bdd7)[0x5572f249bdd7] db-1 | mariadbd(+0xe72f21)[0x5572f23d2f21] db-1 | mariadbd(+0xdfca4e)[0x5572f235ca4e] db-1 | mariadbd(+0xe04f5b)[0x5572f2364f5b] db-1 | mariadbd(+0xe08024)[0x5572f2368024] db-1 | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x5493)[0x5572f1e95e63] db-1 | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3fb)[0x5572f1f036cb] db-1 | mariadbd(_Z21mysql_execute_commandP3THDb+0x4684)[0x5572f1dcd694] db-1 | mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5572f1dce797] db-1 | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xee5)[0x5572f1dd0985] db-1 | mariadbd(_Z10do_commandP3THDb+0x134)[0x5572f1dd2e94] db-1 | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5572f1efe61f] db-1 | mariadbd(handle_one_connection+0x5d)[0x5572f1efe96d] db-1 | mariadbd(+0xd2cbb2)[0x5572f228cbb2] db-1 | /lib64/libc.so.6(+0x89c02)[0x7f9c4384fc02] db-1 | /lib64/libc.so.6(+0x10ec40)[0x7f9c438d4c40] db-1 | db-1 | Trying to get some variables. db-1 | Some pointers may be invalid and cause the dump to abort. db-1 | Query (0x7f9bfc010b70): alter table user db-1 | add constraint user_name_unique db-1 | unique (name) db-1 | db-1 | Connection ID (thread ID): 487 db-1 | Status: NOT_KILLED db-1 | db-1 | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on {code} issueing create table if not exists operator ( id int not null, name varchar(64) not null, idpid varchar(128) not null ) engine=innodb default charset=utf8mb4 collate utf8mb4_bin; alter table operator add constraint operator_id_pk primary key (id); alter table operator add constraint operator_name_unique unique (name); alter table operator add constraint operator_idpid_unique unique (idpid); This is mostly to document that the linked issue is also reproducible in a newer version. |
creating empty table plus primary or unique key forces shutdown+recovery from official docker-image.
{code} db-1 | 2024-09-16 11:00:19 487 [ERROR] InnoDB: preallocating 81920 bytes for file ./mountedoutside/user.ibd failed with error 2 db-1 | 2024-09-16 11:00:19 0x7f9c203f3640 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-9-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/fil/fil0fil.cc line 629 db-1 | InnoDB: Failing assertion: fsize != os_offset_t(-1) db-1 | InnoDB: We intentionally generate a memory trap. db-1 | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ db-1 | InnoDB: If you get repeated assertion failures or crashes, even db-1 | InnoDB: immediately after the mariadbd startup, there may be db-1 | InnoDB: corruption in the InnoDB tablespace. Please refer to db-1 | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ db-1 | InnoDB: about forcing recovery. db-1 | 240916 11:00:19 [ERROR] mysqld got signal 6 ; db-1 | Sorry, we probably made a mistake, and this is a bug. db-1 | To report this bug, see https://mariadb.com/kb/en/reporting-bugs db-1 | db-1 | We will try our best to scrape up some info that will hopefully help db-1 | diagnose the problem, but since we have already crashed, db-1 | something is definitely wrong and this may fail. db-1 | db-1 | Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3 db-1 | key_buffer_size=134217728 db-1 | read_buffer_size=131072 db-1 | max_used_connections=10 db-1 | max_threads=153 db-1 | thread_count=10 db-1 | It is possible that mysqld could use up to db-1 | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K bytes of memory db-1 | Hope that's ok; if not, decrease some variables in the equation. db-1 | db-1 | Thread pointer: 0x7f9bfc000c58 db-1 | Attempting backtrace. You can use the following information to find out db-1 | where mysqld died. If you see no messages after this, something went db-1 | terribly wrong... db-1 | stack_bottom = 0x7f9c203f2cb8 thread_stack 0x49000 db-1 | Printing to addr2line failed db-1 | mariadbd(my_print_stacktrace+0x2e)[0x5572f258767e] db-1 | mariadbd(handle_fatal_signal+0x478)[0x5572f2051168] db-1 | /lib64/libc.so.6(+0x3e6f0)[0x7f9c438046f0] db-1 | /lib64/libc.so.6(+0x8b94c)[0x7f9c4385194c] db-1 | /lib64/libc.so.6(raise+0x16)[0x7f9c43804646] db-1 | /lib64/libc.so.6(abort+0xd3)[0x7f9c437ee7f3] db-1 | mariadbd(+0x6e4678)[0x5572f1c44678] db-1 | mariadbd(+0x6f41d4)[0x5572f1c541d4] db-1 | mariadbd(+0x6f53bf)[0x5572f1c553bf] db-1 | mariadbd(+0x6f794b)[0x5572f1c5794b] db-1 | mariadbd(+0x6f8273)[0x5572f1c58273] db-1 | mariadbd(+0xf78768)[0x5572f24d8768] db-1 | mariadbd(+0xf7987c)[0x5572f24d987c] db-1 | mariadbd(+0xefaeaa)[0x5572f245aeaa] db-1 | mariadbd(+0xf3b523)[0x5572f249b523] db-1 | mariadbd(+0xf3bdd7)[0x5572f249bdd7] db-1 | mariadbd(+0xe72f21)[0x5572f23d2f21] db-1 | mariadbd(+0xdfca4e)[0x5572f235ca4e] db-1 | mariadbd(+0xe04f5b)[0x5572f2364f5b] db-1 | mariadbd(+0xe08024)[0x5572f2368024] db-1 | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x5493)[0x5572f1e95e63] db-1 | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3fb)[0x5572f1f036cb] db-1 | mariadbd(_Z21mysql_execute_commandP3THDb+0x4684)[0x5572f1dcd694] db-1 | mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5572f1dce797] db-1 | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xee5)[0x5572f1dd0985] db-1 | mariadbd(_Z10do_commandP3THDb+0x134)[0x5572f1dd2e94] db-1 | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5572f1efe61f] db-1 | mariadbd(handle_one_connection+0x5d)[0x5572f1efe96d] db-1 | mariadbd(+0xd2cbb2)[0x5572f228cbb2] db-1 | /lib64/libc.so.6(+0x89c02)[0x7f9c4384fc02] db-1 | /lib64/libc.so.6(+0x10ec40)[0x7f9c438d4c40] db-1 | db-1 | Trying to get some variables. db-1 | Some pointers may be invalid and cause the dump to abort. db-1 | Query (0x7f9bfc010b70): alter table user db-1 | add constraint user_name_unique db-1 | unique (name) db-1 | db-1 | Connection ID (thread ID): 487 db-1 | Status: NOT_KILLED db-1 | db-1 | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on {code} issueing create table if not exists operator ( id int not null, name varchar(64) not null, idpid varchar(128) not null ) engine=innodb default charset=utf8mb4 collate utf8mb4_bin; alter table operator add constraint operator_id_pk primary key (id); alter table operator add constraint operator_name_unique unique (name); alter table operator add constraint operator_idpid_unique unique (idpid); This is mostly to document that the linked issue is also reproducible in a newer version. The three constraints order is arbitrary - it is always the first that fails. |
Link |
This issue relates to |
Remote Link | This issue links to "https://github.com/microsoft/WSL/issues/8443 (Web Link)" [ 37142 ] |
Description |
creating empty table plus primary or unique key forces shutdown+recovery from official docker-image.
{code} db-1 | 2024-09-16 11:00:19 487 [ERROR] InnoDB: preallocating 81920 bytes for file ./mountedoutside/user.ibd failed with error 2 db-1 | 2024-09-16 11:00:19 0x7f9c203f3640 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-9-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/fil/fil0fil.cc line 629 db-1 | InnoDB: Failing assertion: fsize != os_offset_t(-1) db-1 | InnoDB: We intentionally generate a memory trap. db-1 | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ db-1 | InnoDB: If you get repeated assertion failures or crashes, even db-1 | InnoDB: immediately after the mariadbd startup, there may be db-1 | InnoDB: corruption in the InnoDB tablespace. Please refer to db-1 | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ db-1 | InnoDB: about forcing recovery. db-1 | 240916 11:00:19 [ERROR] mysqld got signal 6 ; db-1 | Sorry, we probably made a mistake, and this is a bug. db-1 | To report this bug, see https://mariadb.com/kb/en/reporting-bugs db-1 | db-1 | We will try our best to scrape up some info that will hopefully help db-1 | diagnose the problem, but since we have already crashed, db-1 | something is definitely wrong and this may fail. db-1 | db-1 | Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3 db-1 | key_buffer_size=134217728 db-1 | read_buffer_size=131072 db-1 | max_used_connections=10 db-1 | max_threads=153 db-1 | thread_count=10 db-1 | It is possible that mysqld could use up to db-1 | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K bytes of memory db-1 | Hope that's ok; if not, decrease some variables in the equation. db-1 | db-1 | Thread pointer: 0x7f9bfc000c58 db-1 | Attempting backtrace. You can use the following information to find out db-1 | where mysqld died. If you see no messages after this, something went db-1 | terribly wrong... db-1 | stack_bottom = 0x7f9c203f2cb8 thread_stack 0x49000 db-1 | Printing to addr2line failed db-1 | mariadbd(my_print_stacktrace+0x2e)[0x5572f258767e] db-1 | mariadbd(handle_fatal_signal+0x478)[0x5572f2051168] db-1 | /lib64/libc.so.6(+0x3e6f0)[0x7f9c438046f0] db-1 | /lib64/libc.so.6(+0x8b94c)[0x7f9c4385194c] db-1 | /lib64/libc.so.6(raise+0x16)[0x7f9c43804646] db-1 | /lib64/libc.so.6(abort+0xd3)[0x7f9c437ee7f3] db-1 | mariadbd(+0x6e4678)[0x5572f1c44678] db-1 | mariadbd(+0x6f41d4)[0x5572f1c541d4] db-1 | mariadbd(+0x6f53bf)[0x5572f1c553bf] db-1 | mariadbd(+0x6f794b)[0x5572f1c5794b] db-1 | mariadbd(+0x6f8273)[0x5572f1c58273] db-1 | mariadbd(+0xf78768)[0x5572f24d8768] db-1 | mariadbd(+0xf7987c)[0x5572f24d987c] db-1 | mariadbd(+0xefaeaa)[0x5572f245aeaa] db-1 | mariadbd(+0xf3b523)[0x5572f249b523] db-1 | mariadbd(+0xf3bdd7)[0x5572f249bdd7] db-1 | mariadbd(+0xe72f21)[0x5572f23d2f21] db-1 | mariadbd(+0xdfca4e)[0x5572f235ca4e] db-1 | mariadbd(+0xe04f5b)[0x5572f2364f5b] db-1 | mariadbd(+0xe08024)[0x5572f2368024] db-1 | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x5493)[0x5572f1e95e63] db-1 | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3fb)[0x5572f1f036cb] db-1 | mariadbd(_Z21mysql_execute_commandP3THDb+0x4684)[0x5572f1dcd694] db-1 | mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5572f1dce797] db-1 | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xee5)[0x5572f1dd0985] db-1 | mariadbd(_Z10do_commandP3THDb+0x134)[0x5572f1dd2e94] db-1 | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5572f1efe61f] db-1 | mariadbd(handle_one_connection+0x5d)[0x5572f1efe96d] db-1 | mariadbd(+0xd2cbb2)[0x5572f228cbb2] db-1 | /lib64/libc.so.6(+0x89c02)[0x7f9c4384fc02] db-1 | /lib64/libc.so.6(+0x10ec40)[0x7f9c438d4c40] db-1 | db-1 | Trying to get some variables. db-1 | Some pointers may be invalid and cause the dump to abort. db-1 | Query (0x7f9bfc010b70): alter table user db-1 | add constraint user_name_unique db-1 | unique (name) db-1 | db-1 | Connection ID (thread ID): 487 db-1 | Status: NOT_KILLED db-1 | db-1 | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on {code} issueing create table if not exists operator ( id int not null, name varchar(64) not null, idpid varchar(128) not null ) engine=innodb default charset=utf8mb4 collate utf8mb4_bin; alter table operator add constraint operator_id_pk primary key (id); alter table operator add constraint operator_name_unique unique (name); alter table operator add constraint operator_idpid_unique unique (idpid); This is mostly to document that the linked issue is also reproducible in a newer version. The three constraints order is arbitrary - it is always the first that fails. |
creating empty table plus primary or unique key forces shutdown+recovery from official docker-image.
{code} db-1 | 2024-09-16 11:00:19 487 [ERROR] InnoDB: preallocating 81920 bytes for file ./mountedoutside/user.ibd failed with error 2 db-1 | 2024-09-16 11:00:19 0x7f9c203f3640 InnoDB: Assertion failure in file /home/buildbot/amd64-rhel-9-rpm-autobake/build/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/storage/innobase/fil/fil0fil.cc line 629 db-1 | InnoDB: Failing assertion: fsize != os_offset_t(-1) db-1 | InnoDB: We intentionally generate a memory trap. db-1 | InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ db-1 | InnoDB: If you get repeated assertion failures or crashes, even db-1 | InnoDB: immediately after the mariadbd startup, there may be db-1 | InnoDB: corruption in the InnoDB tablespace. Please refer to db-1 | InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ db-1 | InnoDB: about forcing recovery. db-1 | 240916 11:00:19 [ERROR] mysqld got signal 6 ; db-1 | Sorry, we probably made a mistake, and this is a bug. db-1 | To report this bug, see https://mariadb.com/kb/en/reporting-bugs db-1 | db-1 | We will try our best to scrape up some info that will hopefully help db-1 | diagnose the problem, but since we have already crashed, db-1 | something is definitely wrong and this may fail. db-1 | db-1 | Server version: 11.4.3-MariaDB source revision: 5ab81ffe0097a22a774957df28c5223cf0201de3 db-1 | key_buffer_size=134217728 db-1 | read_buffer_size=131072 db-1 | max_used_connections=10 db-1 | max_threads=153 db-1 | thread_count=10 db-1 | It is possible that mysqld could use up to db-1 | key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468068 K bytes of memory db-1 | Hope that's ok; if not, decrease some variables in the equation. db-1 | db-1 | Thread pointer: 0x7f9bfc000c58 db-1 | Attempting backtrace. You can use the following information to find out db-1 | where mysqld died. If you see no messages after this, something went db-1 | terribly wrong... db-1 | stack_bottom = 0x7f9c203f2cb8 thread_stack 0x49000 db-1 | Printing to addr2line failed db-1 | mariadbd(my_print_stacktrace+0x2e)[0x5572f258767e] db-1 | mariadbd(handle_fatal_signal+0x478)[0x5572f2051168] db-1 | /lib64/libc.so.6(+0x3e6f0)[0x7f9c438046f0] db-1 | /lib64/libc.so.6(+0x8b94c)[0x7f9c4385194c] db-1 | /lib64/libc.so.6(raise+0x16)[0x7f9c43804646] db-1 | /lib64/libc.so.6(abort+0xd3)[0x7f9c437ee7f3] db-1 | mariadbd(+0x6e4678)[0x5572f1c44678] db-1 | mariadbd(+0x6f41d4)[0x5572f1c541d4] db-1 | mariadbd(+0x6f53bf)[0x5572f1c553bf] db-1 | mariadbd(+0x6f794b)[0x5572f1c5794b] db-1 | mariadbd(+0x6f8273)[0x5572f1c58273] db-1 | mariadbd(+0xf78768)[0x5572f24d8768] db-1 | mariadbd(+0xf7987c)[0x5572f24d987c] db-1 | mariadbd(+0xefaeaa)[0x5572f245aeaa] db-1 | mariadbd(+0xf3b523)[0x5572f249b523] db-1 | mariadbd(+0xf3bdd7)[0x5572f249bdd7] db-1 | mariadbd(+0xe72f21)[0x5572f23d2f21] db-1 | mariadbd(+0xdfca4e)[0x5572f235ca4e] db-1 | mariadbd(+0xe04f5b)[0x5572f2364f5b] db-1 | mariadbd(+0xe08024)[0x5572f2368024] db-1 | mariadbd(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10TABLE_LISTP13Recreate_infoP10Alter_infojP8st_orderbb+0x5493)[0x5572f1e95e63] db-1 | mariadbd(_ZN19Sql_cmd_alter_table7executeEP3THD+0x3fb)[0x5572f1f036cb] db-1 | mariadbd(_Z21mysql_execute_commandP3THDb+0x4684)[0x5572f1dcd694] db-1 | mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5572f1dce797] db-1 | mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xee5)[0x5572f1dd0985] db-1 | mariadbd(_Z10do_commandP3THDb+0x134)[0x5572f1dd2e94] db-1 | mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5572f1efe61f] db-1 | mariadbd(handle_one_connection+0x5d)[0x5572f1efe96d] db-1 | mariadbd(+0xd2cbb2)[0x5572f228cbb2] db-1 | /lib64/libc.so.6(+0x89c02)[0x7f9c4384fc02] db-1 | /lib64/libc.so.6(+0x10ec40)[0x7f9c438d4c40] db-1 | db-1 | Trying to get some variables. db-1 | Some pointers may be invalid and cause the dump to abort. db-1 | Query (0x7f9bfc010b70): alter table user db-1 | add constraint user_name_unique db-1 | unique (name) db-1 | db-1 | Connection ID (thread ID): 487 db-1 | Status: NOT_KILLED db-1 | db-1 | Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,cset_narrowing=off,sargable_casefold=on {code} issuing {code:sql} create table if not exists operator ( id int not null, name varchar(64) not null, idpid varchar(128) not null ) engine=innodb default charset=utf8mb4 collate utf8mb4_bin; alter table operator add constraint operator_id_pk primary key (id); alter table operator add constraint operator_name_unique unique (name); alter table operator add constraint operator_idpid_unique unique (idpid); {code} This is mostly to document that the linked issue is also reproducible in a newer version. The three constraints order is arbitrary - it is always the first that fails. |
Assignee | Daniel Black [ danblack ] |
Priority | Major [ 3 ] | Blocker [ 1 ] |
Remote Link | This issue links to "previous WIP patch (Web Link)" [ 37147 ] |
Fix Version/s | 11.4 [ 29301 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Assignee | Daniel Black [ danblack ] | Marko Mäkelä [ marko ] |
Summary | Create table + constraint fails on assert in fil0fil.cc line 629 | Under Windows Subsystem for Linux, InnoDB crashes on ALTER TABLE or OPTIMIZE TABLE |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Assignee | Marko Mäkelä [ marko ] | Vladislav Vaintroub [ wlad ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.11 [ 27614 ] | |
Fix Version/s | 11.2 [ 28603 ] |
Assignee | Vladislav Vaintroub [ wlad ] | Marko Mäkelä [ marko ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
issue.field.resolutiondate | 2024-10-24 15:18:20.0 | 2024-10-24 15:18:20.421 |
Fix Version/s | 10.5.27 [ 29902 ] | |
Fix Version/s | 10.6.20 [ 29903 ] | |
Fix Version/s | 10.11.10 [ 29904 ] | |
Fix Version/s | 11.2.6 [ 29906 ] | |
Fix Version/s | 11.4.4 [ 29907 ] | |
Fix Version/s | 11.6.2 [ 29908 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.11 [ 27614 ] | |
Fix Version/s | 11.2 [ 28603 ] | |
Fix Version/s | 11.4 [ 29301 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Link |
This issue relates to |
Link |
This issue is duplicated by |
Link |
This issue relates to |