[MDEV-15063] InnoDB assertion failure !is_owned() at dict0defrag_bg.cc:327 Created: 2018-01-25  Updated: 2018-01-25  Resolved: 2018-01-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2
Fix Version/s: 10.2.13

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

10.2 with commit 7fc25cfbca3cadc53bdcd44572ac2d29d17cff0d test innodb.innodb_defragment

stack

Thread 1 (Thread 0x7f8b21584700 (LWP 25126)):
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1  0x000055594a5ba47e in my_write_core (sig=6) at /home/jan/mysql/10.2/mysys/stacktrace.c:477
#2  0x0000555949e4c6a7 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.2/sql/signal_handler.cc:305
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5  0x00007f8b318a13fa in __GI_abort () at abort.c:89
#6  0x00007f8b31898e37 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55594a79117d "!is_owned()", file=file@entry=0x55594a791140 "/home/jan/mysql/10.2/storage/innobase/include/sync0policy.ic", line=line@entry=64, function=function@entry=0x55594a791760 <MutexDebug<TTASEventMutex<GenericPolicy> >::enter(TTASEventMutex<GenericPolicy> const*, char const*, unsigned int)::__PRETTY_FUNCTION__> "void MutexDebug<Mutex>::enter(const Mutex*, const char*, unsigned int) [with Mutex = TTASEventMutex<GenericPolicy>]") at assert.c:92
#7  0x00007f8b31898ee2 in __GI___assert_fail (assertion=0x55594a79117d "!is_owned()", file=0x55594a791140 "/home/jan/mysql/10.2/storage/innobase/include/sync0policy.ic", line=64, function=0x55594a791760 <MutexDebug<TTASEventMutex<GenericPolicy> >::enter(TTASEventMutex<GenericPolicy> const*, char const*, unsigned int)::__PRETTY_FUNCTION__> "void MutexDebug<Mutex>::enter(const Mutex*, const char*, unsigned int) [with Mutex = TTASEventMutex<GenericPolicy>]") at assert.c:101
#8  0x000055594a07e24a in MutexDebug<TTASEventMutex<GenericPolicy> >::enter (this=0x55594c4a9f00, mutex=0x55594c4a9ef0, name=0x55594a8980a0 "/home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc", line=327) at /home/jan/mysql/10.2/storage/innobase/include/sync0policy.ic:64
#9  0x000055594a07d404 in GenericPolicy<TTASEventMutex<GenericPolicy> >::enter (this=0x55594c4a9f00, mutex=..., filename=0x55594a8980a0 "/home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc", line=327) at /home/jan/mysql/10.2/storage/innobase/include/sync0policy.h:348
#10 0x000055594a07ba3b in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x55594c4a9ef0, n_spins=30, n_delay=6, name=0x55594a8980a0 "/home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc", line=327) at /home/jan/mysql/10.2/storage/innobase/include/ib0mutex.h:633
#11 0x000055594a351485 in dict_stats_save_defrag_stats (index=0x7f8ae016db98) at /home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc:327
#12 0x000055594a3511a5 in dict_stats_process_entry_from_defrag_pool () at /home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc:243
#13 0x000055594a3511fe in dict_defrag_process_entries_from_defrag_pool () at /home/jan/mysql/10.2/storage/innobase/dict/dict0defrag_bg.cc:255
#14 0x000055594a34fbff in dict_stats_thread () at /home/jan/mysql/10.2/storage/innobase/dict/dict0stats_bg.cc:469
#15 0x00007f8b33e50494 in start_thread (arg=0x7f8b21584700) at pthread_create.c:333
#16 0x00007f8b31955aff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97



 Comments   
Comment by Jan Lindström (Inactive) [ 2018-01-25 ]

commit 859d100d70a9dba222b229bbc0d5a01194e8ed5f
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Thu Jan 25 11:28:38 2018 +0200

MDEV-15063: InnoDB assertion failure !is_owned() at dict0defrag_bg.cc:327

Probem was that dict_sys mutex was owned when calling function
dict_stats_save_defrag_stats() that assumes we do not own
dict_sys mutex.0

Generated at Thu Feb 08 08:18:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.