Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.4.7
-
OS: Ubuntu 22.05
Docker: 28.1.1
CPU: Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
Memory: 64Gb
-
Not for Release Notes
Description
Tested the pam+ldap auth solution which works btw, but a decision was made not use use it, because php's mysqli still does not support the auth-pam plugin. So i reverted the changed and rebuilt the custom docker image (it's just installes some backup script and packages like procps, telnet, tcpdump, vim, etc...)
I updated the staging's datatabase with this new image and suddenly it crashed. I first thinked of it migth be related to the pam+ldap solution being removed so quickly reverted the changed rebuilt the image but it did not help. Using he previous image (the one used for pam+ldap testing) worked just fine.
After debugging, nuking the mysql and information_schema and loosing my nerves (my bad) I found that mariadb:11.4.7 just been released on dockerhub 4 days ago. I quickly built another image with 11.4.4 and... I worked and is still working.
The log message was:
Version: '11.4.7-MariaDB-ubu2404-log' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
|
2025-05-27 14:22:44 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
|
|
|
Query (0x7f23f0010e90): SELECT c.table_schema, c.table_name, column_name, auto_increment,
|
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
|
mariadbd(+0x10afc6b)[0x558bb531dc6b]
|
Thread pointer: 0x7f23f0000c68
|
Sorry, we probably made a mistake, and this is a bug.
|
WHERE c.extra = 'auto_increment' AND t.auto_increment IS NOT NULL
|
Following these instructions will help MariaDB developers provide a fix quicker.
|
FROM information_schema.columns c
|
when 'smallint' then 15
|
|
when 'tinyint' then 7
|
Max stack size 8388608 unlimited bytes
|
Server version: 11.4.7-MariaDB-ubu2404-log source revision: 118cfcf82107188f2295631193658b2ef94f4f3f
|
mariadbd(+0xcf3953)[0x558bb4f61953]
|
mariadbd(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x2aa)[0x558bb4b1e46a]
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
|
250527 14:22:45 [ERROR] mariadbd got signal 11 ;
|
The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
|
mariadbd(+0x8a148c)[0x558bb4b0f48c]
|
stack_bottom = 0x7f263c6d9000 thread_stack 0x49000
|
when 'mediumint' then 23
|
when 'int' then 31
|
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x17a)[0x558bb4aaa65a]
|
STRAIGHT_JOIN information_schema.tables t ON (BINARY c.table_schema=t.table_schema AND BINARY c.table_name=t.table_name)
|
Working directory at /var/lib/mysql
|
Your assistance in bug reporting will enable us to fix this for the next release.
|
mariadbd(+0x7fdcc1)[0x558bb4a6bcc1]
|
mariadbd(_Z21mysql_execute_commandP3THDb+0x38cf)[0x558bb4a7523f]
|
Max open files 1048576 1048576 files
|
Max locked memory 65536 65536 bytes
|
mariadbd(_ZN4Item19print_parenthesisedEP6String15enum_query_type10precedence+0x21)[0x558bb4d7a6f1]
|
a bug on https://jira.mariadb.org/.
|
Max msgqueue size 819200 819200 bytes
|
/lib/x86_64-linux-gnu/libc.so.6(+0x9caa4)[0x7f2653181aa4]
|
Kernel version: Linux version 5.15.0-139-generic (buildd@lcy02-amd64-029) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #149-Ubuntu SMP Fri Apr 11 22:06:13 UTC 2025
|
mariadbd(my_print_stacktrace+0x30)[0x558bb51c4560]
|
information below.
|
mariadbd(handle_one_connection+0x3f)[0x558bb4be570f]
|
pow(2, case data_type
|
contains instructions to obtain a better version of the backtrace below.
|
/docker-entry.sh: line 8: 11 Segmentation fault (core dumped) /usr/local/bin/docker-entrypoint.sh "$@"
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is caused by
-
-
- Closed
-