Bug 1421496 - [abrt] mariadb-server: fil_load_single_table_tablespace(): mysqld killed by SIGABRT
Summary: [abrt] mariadb-server: fil_load_single_table_tablespace(): mysqld killed by S...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: mariadb
Version: 26
Hardware: x86_64
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Michal Schorm
QA Contact: Fedora Extras Quality Assurance
URL: https://retrace.fedoraproject.org/faf...
Whiteboard: abrt_hash:9ed744db13f68ecfd0f67716ca2...
: 1478267 1488730 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-02-12 18:36 UTC by koraq
Modified: 2018-02-06 14:35 UTC (History)
9 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2018-02-06 14:35:46 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)
File: backtrace (41.09 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: cgroup (242 bytes, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: core_backtrace (4.39 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: dso_list (2.52 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: environ (1.88 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: limits (1.29 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: maps (14.95 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: mountinfo (3.24 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: namespaces (102 bytes, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: open_fds (1.37 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: proc_pid_status (1.11 KB, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details
File: var_log_messages (302 bytes, text/plain)
2017-02-12 18:36 UTC, koraq
no flags Details

Description koraq 2017-02-12 18:36:12 UTC
Version-Release number of selected component:
mariadb-server-10.1.21-1.fc25

Additional info:
reporter:       libreport-2.8.0
backtrace_rating: 4
cmdline:        /usr/libexec/mysqld --defaults-file=/home/ante/.local/share/akonadi/mysql.conf --datadir=/home/ante/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-ante.v57CXh/mysql.socket
crash_function: fil_load_single_table_tablespace
executable:     /usr/libexec/mysqld
global_pid:     1707
kernel:         4.9.8-201.fc25.x86_64
pkg_fingerprint: 4089 D8F2 FDB1 9C98
pkg_vendor:     Fedora Project
runlevel:       N 5
type:           CCpp
uid:            1000

Truncated backtrace:
Thread no. 1 (10 frames)
 #5 fil_load_single_table_tablespace at /usr/src/debug/mariadb-10.1.21/storage/xtradb/fil/fil0fil.cc:4929
 #6 fil_load_single_table_tablespaces at /usr/src/debug/mariadb-10.1.21/storage/xtradb/fil/fil0fil.cc:5218
 #7 recv_init_crash_recovery at /usr/src/debug/mariadb-10.1.21/storage/xtradb/log/log0recv.cc:3085
 #8 recv_recovery_from_checkpoint_start_func at /usr/src/debug/mariadb-10.1.21/storage/xtradb/log/log0recv.cc:3394
 #9 innobase_start_or_create_for_mysql at /usr/src/debug/mariadb-10.1.21/storage/xtradb/srv/srv0start.cc:2517
 #10 innobase_init at /usr/src/debug/mariadb-10.1.21/storage/xtradb/handler/ha_innodb.cc:4444
 #11 ha_initialize_handlerton at /usr/src/debug/mariadb-10.1.21/sql/handler.cc:513
 #12 plugin_initialize at /usr/src/debug/mariadb-10.1.21/sql/sql_plugin.cc:1408
 #13 plugin_init at /usr/src/debug/mariadb-10.1.21/sql/sql_plugin.cc:1678
 #14 init_server_components at /usr/src/debug/mariadb-10.1.21/sql/mysqld.cc:5148

Comment 1 koraq 2017-02-12 18:36:19 UTC
Created attachment 1249656 [details]
File: backtrace

Comment 2 koraq 2017-02-12 18:36:21 UTC
Created attachment 1249657 [details]
File: cgroup

Comment 3 koraq 2017-02-12 18:36:22 UTC
Created attachment 1249658 [details]
File: core_backtrace

Comment 4 koraq 2017-02-12 18:36:24 UTC
Created attachment 1249659 [details]
File: dso_list

Comment 5 koraq 2017-02-12 18:36:25 UTC
Created attachment 1249660 [details]
File: environ

Comment 6 koraq 2017-02-12 18:36:27 UTC
Created attachment 1249661 [details]
File: limits

Comment 7 koraq 2017-02-12 18:36:29 UTC
Created attachment 1249662 [details]
File: maps

Comment 8 koraq 2017-02-12 18:36:31 UTC
Created attachment 1249663 [details]
File: mountinfo

Comment 9 koraq 2017-02-12 18:36:32 UTC
Created attachment 1249664 [details]
File: namespaces

Comment 10 koraq 2017-02-12 18:36:33 UTC
Created attachment 1249665 [details]
File: open_fds

Comment 11 koraq 2017-02-12 18:36:35 UTC
Created attachment 1249666 [details]
File: proc_pid_status

Comment 12 koraq 2017-02-12 18:36:36 UTC
Created attachment 1249667 [details]
File: var_log_messages

Comment 13 koraq 2017-05-05 19:54:26 UTC
Similar problem has been detected:

I restarted my computer and after entering my password in the login box, KDE loaded and the first thing that happned was that mariadb and korganizer died. Happens every time. Bloody annoying.

reporter:       libreport-2.8.0
backtrace_rating: 4
cmdline:        /usr/libexec/mysqld --defaults-file=/home/ante/.local/share/akonadi/mysql.conf --datadir=/home/ante/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-ante.biLm8T/mysql.socket
crash_function: fil_load_single_table_tablespace
executable:     /usr/libexec/mysqld
global_pid:     1794
kernel:         4.10.10-200.fc25.x86_64
package:        mariadb-server-10.1.21-3.fc25
pkg_fingerprint: 4089 D8F2 FDB1 9C98
pkg_vendor:     Fedora Project
reason:         mysqld killed by SIGABRT
runlevel:       N 5
type:           CCpp
uid:            1000

Comment 14 koraq 2017-06-04 08:21:51 UTC
Similar problem has been detected:

I started my computer and logged into plasma, the first thing that happened was that abrt said mariadb had crashed.

This is what's in the mariadb error log:

2017-06-04 10:13:22 7fd2702368c0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Using Linux native AIO
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Using SSE crc32 instructions
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Completed initialization of buffer pool
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Highest supported file format is Barracuda.
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: The log sequence numbers 29550130 and 29550130 in ibdata files do not match the log sequence number 31062713 in the ib_logfiles!
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Database was not shutdown normally!
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Starting crash recovery.
2017-06-04 10:13:22 140541801228480 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-06-04 10:13:22 140541801228480 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace akonadi/pimitemflagrelation uses space ID: 18 at filepath: ./akonadi/pimitemflagrelation.ibd. Cannot open tablespace akonadi/relationtable which uses space ID: 18 at filepath: ./akonadi/relationtable.ibd
2017-06-04 10:13:22 7fd2702368c0  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./akonadi/relationtable.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
170604 10:13:22 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

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

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 10.1.21-MariaDB
key_buffer_size=16384
read_buffer_size=131072
max_used_connections=0
max_threads=258
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 566702 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48400
/usr/libexec/mysqld(my_print_stacktrace+0x2e)[0x561a6ee1b1ee]
/usr/libexec/mysqld(handle_fatal_signal+0x3bd)[0x561a6e96423d]
/lib64/libpthread.so.0(+0x115c0)[0x7fd26fece5c0]
/lib64/libc.so.6(gsignal+0x9f)[0x7fd26e30391f]
/lib64/libc.so.6(abort+0x16a)[0x7fd26e30551a]
/usr/libexec/mysqld(+0x9c5078)[0x561a6ed92078]
/usr/libexec/mysqld(+0x86d053)[0x561a6ec3a053]
/usr/libexec/mysqld(+0x8fbcb2)[0x561a6ecc8cb2]
/usr/libexec/mysqld(+0x81fab6)[0x561a6ebecab6]
/usr/libexec/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x66)[0x561a6e966346]
/usr/libexec/mysqld(+0x41db98)[0x561a6e7eab98]
/usr/libexec/mysqld(_Z11plugin_initPiPPci+0x7fa)[0x561a6e7ec1aa]
/usr/libexec/mysqld(+0x377b33)[0x561a6e744b33]
/usr/libexec/mysqld(_Z11mysqld_mainiPPc+0xa5a)[0x561a6e748d6a]
/lib64/libc.so.6(__libc_start_main+0xf1)[0x7fd26e2ee401]
/usr/libexec/mysqld(_start+0x2a)[0x561a6e73c7aa]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
addr2line: Dwarf Error: Offset (2197951744) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (2063734016) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (318433542) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (585210629) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (598470147) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (598470147) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (598470147) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (598470147) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (3338797761) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (405547521) greater than or equal to .debug_str size (2417909).
addr2line: Dwarf Error: Offset (135201055) greater than or equal to .debug_str size (2417909).

reporter:       libreport-2.8.0
backtrace_rating: 4
cmdline:        /usr/libexec/mysqld --defaults-file=/home/ante/.local/share/akonadi/mysql.conf --datadir=/home/ante/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-ante.uhbIXv/mysql.socket
crash_function: fil_load_single_table_tablespace
executable:     /usr/libexec/mysqld
global_pid:     1871
kernel:         4.11.3-200.fc25.x86_64
package:        mariadb-server-10.1.21-3.fc25
pkg_fingerprint: 4089 D8F2 FDB1 9C98
pkg_vendor:     Fedora Project
reason:         mysqld killed by SIGABRT
runlevel:       N 5
type:           CCpp
uid:            1000

Comment 15 Michal Schorm 2017-06-04 11:13:55 UTC
I've got some problems delivering new MariaDB versions, however finally an update is on the way:
https://bodhi.fedoraproject.org/updates/?packages=mariadb

I'd like to know, if the issue persists with the new version.

Comment 16 koraq 2017-06-08 18:07:53 UTC
Similar problem has been detected:

I logged in to plasma, and boom mariadb crashed. Happens every time.

reporter:       libreport-2.8.0
backtrace_rating: 4
cmdline:        /usr/libexec/mysqld --defaults-file=/home/ante/.local/share/akonadi/mysql.conf --datadir=/home/ante/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-ante.rUOrhg/mysql.socket
crash_function: fil_load_single_table_tablespace
executable:     /usr/libexec/mysqld
global_pid:     1786
kernel:         4.11.3-202.fc25.x86_64
package:        mariadb-server-10.1.21-3.fc25
pkg_fingerprint: 4089 D8F2 FDB1 9C98
pkg_vendor:     Fedora Project
reason:         mysqld killed by SIGABRT
runlevel:       N 5
type:           CCpp
uid:            1000

Comment 17 Michal Schorm 2017-07-12 07:26:35 UTC
Solving with MariaDB upstream: https://jira.mariadb.org/browse/MDEV-13284

Is this still a problem, with 10.1.24 or 10.1.25 (in Bodhi) version?

Comment 18 Pupkur 2017-08-04 07:02:22 UTC
*** Bug 1478267 has been marked as a duplicate of this bug. ***

Comment 19 koraq 2017-08-21 12:23:06 UTC
Now the crash upon boot problems seems to have gone away.

$ rpm -q mariadb
mariadb-10.1.25-1.fc25.x86_64

New version of mariadb in place.

Thanks!

Comment 20 Pupkur 2017-09-06 06:43:17 UTC
*** Bug 1488730 has been marked as a duplicate of this bug. ***

Comment 21 Fedora End Of Life 2017-11-16 14:58:16 UTC
This message is a reminder that Fedora 25 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 25. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as EOL if it remains open with a Fedora  'version'
of '25'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version'
to a later Fedora version.

Thank you for reporting this issue and we are sorry that we were not
able to fix it before Fedora 25 is end of life. If you would still like
to see this bug fixed and are able to reproduce it against a later version
of Fedora, you are encouraged  change the 'version' to a later Fedora
version prior this bug is closed as described in the policy above.

Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.

Comment 22 Michal Schorm 2018-02-06 14:35:46 UTC
Workaround is to use innodb-force-recovery=1

Fixed in MariaDB 10.2 and later. (F27)

Can't be fixed in 10.1 and earlier. (F26)


Note You need to log in before you can comment on or make changes to this bug.