Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-3105

LP #1293529: Hang on create table when innodb_priority_cleaner=ON

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Jan Lindström last update 22-03-2014 09:52:41

      (gdb) thread apply all bt

      Thread 24 (Thread 0x7fa279fff700 (LWP 52780)):
      #0 0x00007fa27bd1a0fe in pthread_cond_timedwait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000e42f95 in safe_cond_timedwait (cond=0x204ee80 <COND_checkpoint>,
      mp=0x204edc0 <LOCK_checkpoint>, abstime=0x7fa279ffed60,
      file=0x101b350 "/home/mariadb/bzr/10.0-mdev5875/include/mysql/psi/mysql_thread.h", line=1212)
      at /home/mariadb/bzr/10.0-mdev5875/mysys/thr_mutex.c:547
      #2 0x0000000000a43b68 in inline_mysql_cond_timedwait (that=0x204ee80 <COND_checkpoint>,
      mutex=0x204edc0 <LOCK_checkpoint>, abstime=0x7fa279ffed60,
      src_file=0x101b398 "/home/mariadb/bzr/10.0-mdev5875/storage/maria/ma_servicethread.c",
      src_line=119) at /home/mariadb/bzr/10.0-mdev5875/include/mysql/psi/mysql_thread.h:1212
      #3 0x0000000000a43fff in my_service_thread_sleep (control=0x166ba30 <checkpoint_control>,
      sleep_time=30000000000) at /home/mariadb/bzr/10.0-mdev5875/storage/maria/ma_servicethread.c:118
      #4 0x0000000000a38ce7 in ma_checkpoint_background (arg=0x1e)
      at /home/mariadb/bzr/10.0-mdev5875/storage/maria/ma_checkpoint.c:709
      #5 0x0000000000dedf1e in pfs_spawn_thread (arg=0x7fa27a3ff2b0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/perfschema/pfs.cc:1853
      #6 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #7 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #8 0x0000000000000000 in ?? ()

      Thread 23 (Thread 0x7fa25b7ff700 (LWP 52781)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa100, segment=0, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=0, message1=0x7fa25b7fede8,
      message2=0x7fa25b7fedf0, type=0x7fa25b7fedf8, space_id=0x7fa25b7fee00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      --Type <return> to continue, or q <return> to quit--
      #3 0x0000000000d65e2f in fil_aio_wait (segment=0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c680 <n>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 22 (Thread 0x7fa25affe700 (LWP 52782)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa0b0, segment=0, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=1, message1=0x7fa25affdde8,
      message2=0x7fa25affddf0, type=0x7fa25affddf8, space_id=0x7fa25affde00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=1)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c688 <n+8>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 21 (Thread 0x7fa25a7fd700 (LWP 52783)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa060, segment=0, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=2, message1=0x7fa25a7fcde8,
      message2=0x7fa25a7fcdf0, type=0x7fa25a7fcdf8, space_id=0x7fa25a7fce00)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=2)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c690 <n+16>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 20 (Thread 0x7fa259ffc700 (LWP 52784)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa060, segment=1, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=3, message1=0x7fa259ffbde8,
      message2=0x7fa259ffbdf0, type=0x7fa259ffbdf8, space_id=0x7fa259ffbe00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=3)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c698 <n+24>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 19 (Thread 0x7fa2597fb700 (LWP 52785)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa060, segment=2, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=4, message1=0x7fa2597fade8,
      --Type <return> to continue, or q <return> to quit--
      message2=0x7fa2597fadf0, type=0x7fa2597fadf8, space_id=0x7fa2597fae00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=4)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6a0 <n+32>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 18 (Thread 0x7fa258ffa700 (LWP 52786)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa060, segment=3, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=5, message1=0x7fa258ff9de8,
      message2=0x7fa258ff9df0, type=0x7fa258ff9df8, space_id=0x7fa258ff9e00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=5)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6a8 <n+40>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 17 (Thread 0x7fa2587f9700 (LWP 52787)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa150, segment=0, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      --Type <return> to continue, or q <return> to quit--
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=6, message1=0x7fa2587f8de8,
      message2=0x7fa2587f8df0, type=0x7fa2587f8df8, space_id=0x7fa2587f8e00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=6)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6b0 <n+48>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 16 (Thread 0x7fa257ff8700 (LWP 52788)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa150, segment=1, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=7, message1=0x7fa257ff7de8,
      message2=0x7fa257ff7df0, type=0x7fa257ff7df8, space_id=0x7fa257ff7e00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=7)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6b8 <n+56>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 15 (Thread 0x7fa2577f7700 (LWP 52789)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa150, segment=2, seg_size=2048)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=8, message1=0x7fa2577f6de8,
      message2=0x7fa2577f6df0, type=0x7fa2577f6df8, space_id=0x7fa2577f6e00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=8)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6c0 <n+64>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 14 (Thread 0x7fa256ff6700 (LWP 52790)):
      #0 0x00007fa27c583644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
      #1 0x0000000000bb79c9 in os_aio_linux_collect (array=0x7fa2773fa150, segment=3, seg_size=2048)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5048
      #2 0x0000000000bb7d5a in os_aio_linux_handle (global_seg=9, message1=0x7fa256ff5de8,
      message2=0x7fa256ff5df0, type=0x7fa256ff5df8, space_id=0x7fa256ff5e00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0file.cc:5193
      #3 0x0000000000d65e2f in fil_aio_wait (segment=9)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fil/fil0fil.cc:5641
      #4 0x0000000000c784e3 in io_handler_thread (arg=0x205c6c8 <n+72>)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0start.cc:494
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 13 (Thread 0x7fa2557ff700 (LWP 52792)):
      #0 0x00007fa27bd1a0fe in pthread_cond_timedwait@@GLIBC_2.3.2 ()
      --Type <return> to continue, or q <return> to quit--
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9ee0 in os_cond_wait_timed (cond=0x7fa25c9a18c0, fast_mutex=0x7fa25c9a1880,
      abstime=0x7fa2557fee00) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:177
      #2 0x0000000000bba6af in os_event_wait_time_low (event=0x7fa25c9a1880, time_in_usec=1000000,
      reset_sig_count=1) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:723
      #3 0x0000000000b91a5d in lock_wait_timeout_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/lock/lock0wait.cc:503
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #6 0x0000000000000000 in ?? ()

      Thread 12 (Thread 0x7fa2547ff700 (LWP 52793)):
      #0 0x00007fa27bd19d84 in pthread_cond_wait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9fc8 in os_cond_wait (cond=0x7fa25c9a12c0, fast_mutex=0x7fa25c9a1280)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:214
      #2 0x0000000000bba4f0 in os_event_wait_low (event=0x7fa25c9a1280, reset_sig_count=84)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:610
      #3 0x0000000000c7dd98 in sync_array_wait_event (arr=0x7fa277340540, index=1)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0arr.cc:433
      #4 0x0000000000c82c3a in mutex_spin_wait (_mutex=0x7fa27a014fc8, high_priority=false,
      file_name=0x107b9c0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      line=461) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0sync.cc:671
      #5 0x0000000000c6ebaa in mutex_enter_func (mutex=0x7fa27a014fc8,
      file_name=0x107b9c0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      line=461, priority=IB_DEFAULT_PRIO)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/sync0sync.ic:316
      #6 0x0000000000c6ed0f in pfs_mutex_enter_func (mutex=0x7fa27a014fc8,
      file_name=0x107b9c0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      --Type <return> to continue, or q <return> to quit--
      line=461, priority=IB_DEFAULT_PRIO)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/sync0sync.ic:399
      #7 0x0000000000c6fe6d in log_get_lsn ()
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic:461
      #8 0x0000000000c734eb in srv_error_monitor_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:2085
      #9 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #10 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #11 0x0000000000000000 in ?? ()

      Thread 11 (Thread 0x7fa253ffe700 (LWP 52794)):
      #0 0x00007fa27bd1a0fe in pthread_cond_timedwait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9ee0 in os_cond_wait_timed (cond=0x7fa2783feac0, fast_mutex=0x7fa2783fea80,
      abstime=0x7fa253ffddd0) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:177
      #2 0x0000000000bba6af in os_event_wait_time_low (event=0x7fa2783fea80, time_in_usec=5000000,
      reset_sig_count=1) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:723
      #3 0x0000000000c7307f in srv_monitor_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:1914
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #6 0x0000000000000000 in ?? ()

      Thread 10 (Thread 0x7fa252fff700 (LWP 52795)):
      #0 0x00007fa27bd19d84 in pthread_cond_wait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9fc8 in os_cond_wait (cond=0x7fa25cbfa6c0, fast_mutex=0x7fa25cbfa680)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:214
      #2 0x0000000000bba4f0 in os_event_wait_low (event=0x7fa25cbfa680, reset_sig_count=107)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:610
      #3 0x0000000000c7dd98 in sync_array_wait_event (arr=0x7fa277340540, index=0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0arr.cc:433
      #4 0x0000000000c80e1c in rw_lock_x_lock_func (lock=0x206bee0 <dict_operation_lock>, pass=0,
      file_name=0x107bec8 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc",
      line=2595, priority_lock=false, high_priority=false)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0rw.cc:876
      #5 0x0000000000c6f667 in pfs_rw_lock_x_lock_func (lock=0x206bee0 <dict_operation_lock>, pass=0,
      file_name=0x107bec8 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc", line=2595)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/sync0rw.ic:886
      #6 0x0000000000c74309 in srv_master_evict_from_table_cache (pct_check=50)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:2595
      #7 0x0000000000c74787 in srv_master_do_active_tasks ()
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:2726
      #8 0x0000000000c75138 in srv_master_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:2957
      #9 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #10 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #11 0x0000000000000000 in ?? ()

      Thread 9 (Thread 0x7fa2527fe700 (LWP 52796)):
      #0 0x00007fa27bd19d84 in pthread_cond_wait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9fc8 in os_cond_wait (cond=0x7fa2783fe9c0, fast_mutex=0x7fa2783fe980)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:214
      #2 0x0000000000bba4f0 in os_event_wait_low (event=0x7fa2783fe980, reset_sig_count=1)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:610
      #3 0x0000000000c759e2 in srv_purge_coordinator_suspend (slot=0x7fa2773a1880, rseg_history_len=0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:3258
      --Type <return> to continue, or q <return> to quit--
      #4 0x0000000000c75ecf in srv_purge_coordinator_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/srv/srv0srv.cc:3378
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()

      Thread 8 (Thread 0x7fa2513ff700 (LWP 52797)):
      #0 0x00007fa27ac12023 in select () from /lib/x86_64-linux-gnu/libc.so.6
      #1 0x0000000000bbb20a in os_thread_sleep (tm=1000000)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0thread.cc:284
      #2 0x0000000000d110d7 in page_cleaner_sleep_if_needed (next_loop_time=1395055819474)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/buf/buf0flu.cc:2549
      #3 0x0000000000d113b4 in buf_flush_page_cleaner_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/buf/buf0flu.cc:2674
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #6 0x0000000000000000 in ?? ()

      Thread 7 (Thread 0x7fa250bfe700 (LWP 52798)):
      #0 0x00007fa27bd19d84 in pthread_cond_wait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9fc8 in os_cond_wait (cond=0x7fa2783feb40, fast_mutex=0x7fa2783feb00)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:214
      #2 0x0000000000bba4f0 in os_event_wait_low (event=0x7fa2783feb00, reset_sig_count=1)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:610
      #3 0x0000000000d0951a in buf_dump_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/buf/buf0dump.cc:594
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      --Type <return> to continue, or q <return> to quit--
      #6 0x0000000000000000 in ?? ()

      Thread 6 (Thread 0x7fa2503fd700 (LWP 52799)):
      #0 0x00007fa27bd1a0fe in pthread_cond_timedwait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9ee0 in os_cond_wait_timed (cond=0x7fa25cbfa140, fast_mutex=0x7fa25cbfa100,
      abstime=0x7fa2503fce20) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:177
      #2 0x0000000000bba6af in os_event_wait_time_low (event=0x7fa25cbfa100, time_in_usec=10000000,
      reset_sig_count=1) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:723
      #3 0x0000000000d55037 in dict_stats_thread (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/dict/dict0stats_bg.cc:349
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #6 0x0000000000000000 in ?? ()

      Thread 5 (Thread 0x7fa24fbfc700 (LWP 52800)):
      #0 0x00007fa27bd1a0fe in pthread_cond_timedwait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9ee0 in os_cond_wait_timed (cond=0x7fa25c757440, fast_mutex=0x7fa25c757400,
      abstime=0x7fa24fbfbd70) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:177
      #2 0x0000000000bba6af in os_event_wait_time_low (event=0x7fa25c757400, time_in_usec=5000000,
      reset_sig_count=1) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:723
      #3 0x0000000000cb84eb in ib_wqueue_timedwait (wq=0x7fa27a054738, wait_in_usecs=5000000)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/ut/ut0wqueue.cc:154
      #4 0x0000000000d9013e in fts_optimize_thread (arg=0x7fa27a054738)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/fts/fts0opt.cc:2994
      #5 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #6 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #7 0x0000000000000000 in ?? ()
      --Type <return> to continue, or q <return> to quit--

      Thread 4 (Thread 0x7fa27c995700 (LWP 52801)):
      #0 0x00007fa27bd1d9f7 in do_sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x00007fa27bd1da79 in sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0
      #2 0x0000000000593cf9 in signal_hand (arg=0x0)
      at /home/mariadb/bzr/10.0-mdev5875/sql/mysqld.cc:3300
      #3 0x0000000000dedf1e in pfs_spawn_thread (arg=0x7fa25c767ef0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/perfschema/pfs.cc:1853
      #4 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #5 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #6 0x0000000000000000 in ?? ()

      Thread 3 (Thread 0x7fa27c94c700 (LWP 52806)):
      #0 0x00007fa27ac0d303 in poll () from /lib/x86_64-linux-gnu/libc.so.6
      #1 0x0000000000e8c863 in vio_io_wait (vio=0x7fa255a7d370, event=VIO_IO_EVENT_READ,
      timeout=28800000) at /home/mariadb/bzr/10.0-mdev5875/vio/viosocket.c:969
      #2 0x0000000000e8b21e in vio_socket_io_wait (vio=0x7fa255a7d370, event=VIO_IO_EVENT_READ)
      at /home/mariadb/bzr/10.0-mdev5875/vio/viosocket.c:108
      #3 0x0000000000e8b3d2 in vio_read (vio=0x7fa255a7d370, buf=0x7fa255a85070 "\a", size=4)
      at /home/mariadb/bzr/10.0-mdev5875/vio/viosocket.c:181
      #4 0x00000000005a0646 in my_real_read (net=0x7fa25c7b1328, complen=0x7fa27c94bce0)
      at /home/mariadb/bzr/10.0-mdev5875/sql/net_serv.cc:870
      #5 0x00000000005a0cac in my_net_read (net=0x7fa25c7b1328)
      at /home/mariadb/bzr/10.0-mdev5875/sql/net_serv.cc:1072
      #6 0x000000000064f2ca in do_command (thd=0x7fa25c7b1070)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_parse.cc:937
      #7 0x000000000077434f in do_handle_one_connection (thd_arg=0x7fa25c7b1070)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_connect.cc:1379
      #8 0x00000000007740b5 in handle_one_connection (arg=0x7fa25c7b1070)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_connect.cc:1293
      #9 0x0000000000dedf1e in pfs_spawn_thread (arg=0x7fa255e9bbd0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/perfschema/pfs.cc:1853
      #10 0x00007fa27bd15e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #11 0x00007fa27ac18cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      #12 0x0000000000000000 in ?? ()

      Thread 2 (Thread 0x7fa27c903700 (LWP 52808)):
      #0 0x00007fa27bd19d84 in pthread_cond_wait@@GLIBC_2.3.2 ()
      from /lib/x86_64-linux-gnu/libpthread.so.0
      #1 0x0000000000bb9fc8 in os_cond_wait (cond=0x7fa25c9a12c0, fast_mutex=0x7fa25c9a1280)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:214
      #2 0x0000000000bba4f0 in os_event_wait_low (event=0x7fa25c9a1280, reset_sig_count=84)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/os/os0sync.cc:610
      #3 0x0000000000c7dd98 in sync_array_wait_event (arr=0x7fa277340540, index=2)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0arr.cc:433
      #4 0x0000000000c82c3a in mutex_spin_wait (_mutex=0x7fa27a014fc8, high_priority=false,
      file_name=0x104f7b0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      line=358) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/sync/sync0sync.cc:671
      #5 0x0000000000bb00d2 in mutex_enter_func (mutex=0x7fa27a014fc8,
      file_name=0x104f7b0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      line=358, priority=IB_DEFAULT_PRIO)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/sync0sync.ic:316
      #6 0x0000000000bb0237 in pfs_mutex_enter_func (mutex=0x7fa27a014fc8,
      file_name=0x104f7b0 "/home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic",
      line=358, priority=IB_DEFAULT_PRIO)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/sync0sync.ic:399
      #7 0x0000000000bb0dd6 in log_reserve_and_write_fast (str=0x7fa27c8fd7c0, len=23,
      start_lsn=0x7fa27c8fda18)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/include/log0log.ic:358
      #8 0x0000000000bb204c in mtr_log_reserve_and_write (mtr=0x7fa27c8fd560)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/mtr/mtr0mtr.cc:265
      #9 0x0000000000bb22e1 in mtr_commit (mtr=0x7fa27c8fd560)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/mtr/mtr0mtr.cc:327
      #10 0x0000000000c97c0d in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7fa24e789b80,
      index=0x7fa27a022bf8, clust_entry=0x7fa24c4feef8, update=0x0, cmpl_info=0, rec=0x0,
      offsets=0x0, roll_ptr=0x7fa27c8fdab8)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/trx/trx0rec.cc:1353
      #11 0x0000000000cdc20d in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7fa27c8fdc70,
      entry=0x7fa24c4feef8, thr=0x7fa24e789b80, mtr=0x7fa27c8fdcf0, inherit=0x7fa27c8fdb30)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/btr/btr0cur.cc:1283
      #12 0x0000000000cdc91e in btr_cur_optimistic_insert (flags=0, cursor=0x7fa27c8fdc70,
      offsets=0x7fa27c8fdc30, heap=0x7fa27c8fdc40, entry=0x7fa24c4feef8, rec=0x7fa27c8fdc48,
      big_rec=0x7fa27c8fdc38, n_ext=0, thr=0x7fa24e789b80, mtr=0x7fa27c8fdcf0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/btr/btr0cur.cc:1510
      #13 0x0000000000c1112f in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fa27a022bf8,
      n_uniq=2, entry=0x7fa24c4feef8, n_ext=0, thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:2501
      #14 0x0000000000c121a8 in row_ins_clust_index_entry (index=0x7fa27a022bf8, entry=0x7fa24c4feef8,
      thr=0x7fa24e789b80, n_ext=0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:2905
      #15 0x0000000000c12483 in row_ins_index_entry (index=0x7fa27a022bf8, entry=0x7fa24c4feef8,
      thr=0x7fa24e789b80) at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:2999
      #16 0x0000000000c12743 in row_ins_index_entry_step (node=0x7fa24c51feb8, thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:3076
      #17 0x0000000000c12a53 in row_ins (node=0x7fa24c51feb8, thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:3216
      #18 0x0000000000c12db4 in row_ins_step (thr=0x7fa24e789b80)
      --Type <return> to continue, or q <return> to quit--
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0ins.cc:3341
      #19 0x0000000000be844d in que_thr_step (thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/que/que0que.cc:1095
      #20 0x0000000000be874c in que_run_threads_low (thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/que/que0que.cc:1177
      #21 0x0000000000be88d9 in que_run_threads (thr=0x7fa24e789b80)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/que/que0que.cc:1218
      #22 0x0000000000c2b1f0 in row_create_index_for_mysql (index=0x7fa24c5025f8, trx=0x7fa24e49d078,
      field_lengths=0x7fa24c4449f0)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/row/row0mysql.cc:2447
      #23 0x0000000000b386a9 in create_index (trx=0x7fa24e49d078, form=0x7fa27c8ff220, flags=1,
      table_name=0x7fa27c8fe610 "test/table1_innodb_key_pk_parts_2_time_6#P#p1", key_num=13)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/handler/ha_innodb.cc:9681
      #24 0x0000000000b39c61 in ha_innobase::create (this=0x7fa24e793088,
      name=0x7fa27c8fed40 "./test/table1_innodb_key_pk_parts_2_time_6#P#p1", form=0x7fa27c8ff220,
      create_info=0x7fa27c901d20)
      at /home/mariadb/bzr/10.0-mdev5875/storage/xtradb/handler/ha_innodb.cc:10488
      #25 0x0000000000853904 in handler::ha_create (this=0x7fa24e793088,
      name=0x7fa27c8fed40 "./test/table1_innodb_key_pk_parts_2_time_6#P#p1", form=0x7fa27c8ff220,
      info=0x7fa27c901d20) at /home/mariadb/bzr/10.0-mdev5875/sql/handler.cc:4244
      #26 0x0000000000dfc679 in ha_partition::create (this=0x7fa24e4c8088,
      name=0x7fa27c901730 "./test/table1_innodb_key_pk_parts_2_time_6", table_arg=0x7fa27c8ff220,
      create_info=0x7fa27c901d20) at /home/mariadb/bzr/10.0-mdev5875/sql/ha_partition.cc:733
      #27 0x0000000000853904 in handler::ha_create (this=0x7fa24e4c8088,
      name=0x7fa27c901730 "./test/table1_innodb_key_pk_parts_2_time_6", form=0x7fa27c8ff220,
      info=0x7fa27c901d20) at /home/mariadb/bzr/10.0-mdev5875/sql/handler.cc:4244
      #28 0x00000000008547e8 in ha_create_table (thd=0x7fa255a8a070,
      path=0x7fa27c901730 "./test/table1_innodb_key_pk_parts_2_time_6", db=0x7fa24e423aa8 "test",
      table_name=0x7fa24e423410 "table1_innodb_key_pk_parts_2_time_6", create_info=0x7fa27c901d20,
      --Type <return> to continue, or q <return> to quit--
      frm=0x7fa27c901720) at /home/mariadb/bzr/10.0-mdev5875/sql/handler.cc:4613
      #29 0x000000000074a610 in rea_create_table (thd=0x7fa255a8a070, frm=0x7fa27c901720,
      path=0x7fa27c901730 "./test/table1_innodb_key_pk_parts_2_time_6", db=0x7fa24e423aa8 "test",
      table_name=0x7fa24e423410 "table1_innodb_key_pk_parts_2_time_6", create_info=0x7fa27c901d20,
      file=0x7fa24e516340, no_ha_create_table=false)
      at /home/mariadb/bzr/10.0-mdev5875/sql/unireg.cc:409
      #30 0x0000000000704aba in create_table_impl (thd=0x7fa255a8a070, db=0x7fa24e423aa8 "test",
      table_name=0x7fa24e423410 "table1_innodb_key_pk_parts_2_time_6",
      path=0x7fa27c901730 "./test/table1_innodb_key_pk_parts_2_time_6", create_info=0x7fa27c901d20,
      alter_info=0x7fa27c901c90, create_table_mode=0, is_trans=0x7fa27c901992,
      key_info=0x7fa27c901710, key_count=0x7fa27c901704, frm=0x7fa27c901720)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_table.cc:4706
      #31 0x0000000000704fff in mysql_create_table_no_lock (thd=0x7fa255a8a070,
      db=0x7fa24e423aa8 "test", table_name=0x7fa24e423410 "table1_innodb_key_pk_parts_2_time_6",
      create_info=0x7fa27c901d20, alter_info=0x7fa27c901c90, is_trans=0x7fa27c901992,
      create_table_mode=0) at /home/mariadb/bzr/10.0-mdev5875/sql/sql_table.cc:4817
      #32 0x00000000007051f4 in mysql_create_table (thd=0x7fa255a8a070, create_table=0x7fa24e4234d0,
      create_info=0x7fa27c901d20, alter_info=0x7fa27c901c90)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_table.cc:4870
      #33 0x0000000000654253 in mysql_execute_command (thd=0x7fa255a8a070)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_parse.cc:3055
      #34 0x000000000065d6d6 in mysql_parse (thd=0x7fa255a8a070,
      rawbuf=0x7fa24e422088 "CREATE TABLE `table1_innodb_key_pk_parts_2_time_6` (\n`col_datetime_6_not_null_key` datetime(6) not null,\n`col_datetime_6` datetime(6),\n`col_date_key` date,\n`col_timestamp_3_not_null_key` timestamp(3) "..., length=2419, parser_state=0x7fa27c9025c0)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_parse.cc:6447
      #35 0x00000000006501ce in dispatch_command (command=COM_QUERY, thd=0x7fa255a8a070,
      packet=0x7fa255a90071 "CREATE TABLE `table1_innodb_key_pk_parts_2_time_6` (\n`col_datetime_6_not_null_key` datetime(6) not null,\n`col_datetime_6` datetime(6),\n`col_date_key` date,\n`col_timestam--Type <return> to continue, or q <return> to quit--
      p_3_not_null_key` timestamp(3) "..., packet_length=2419)
      at /home/mariadb/bzr/10.0-mdev5875/sql/sql_parse.cc:1308
      #36 0x000000000064f529 in do_command

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: