Home > database >  Mysql crash frequently, for help Daniel!
Mysql crash frequently, for help Daniel!

Time:10-12

[Thread was debugging using libthread_db enabled]
Using the host libthread_db library/lib64/libthread_db. So. "" 1".
The Core was generated by `/usr/local/mysql/bin/mysqld - basedir=/usr/local/mysql - datadir=/data/mysql/my '.
The Program terminated with signal SIGABRT, Aborted.
# 0 0 x00007f63d5c089d1 pthread_kill in () the from/lib64/libpthreads. So. 0
[the Current thread is 1 (thread 0 x7f6127df4700 (LWP) 10085)]

49 (Thread Thread 0 x7f611b2e7700 (LWP) 10046) :
# 0 0 x00007f63d5c0ad1d in fsync () the from/lib64/libpthreads. So. 0
No symbol table info available.
# 1 0 x00000000010bbb64 os_file_fsync_posix in (the file=12) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 3057
Ret=
Failures=0
# 2 os_file_flush_func (file=12) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 3161
Ret=0
# 3 0 x00000000012519a9 in pfs_os_file_flush_func (src_line=6009, file=... , src_file=) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/include/os0file IC: 505
State={m_flags=3, m_operation=PSI_FILE_SYNC, m_file=0 x7f63cc876f00, m_name=0 x0, m_class=0 x367f8c0, m_thread=0 x7f63d0d0ee40, m_number_of_bytes=6, m_timer_start=3577309178508334, m_timer=0 x130ce90 , m_wait=0 x0}
Locker=
Src_file=0 x16333a8 "/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/fil/fil0fil cc"
# 4 fil_flush (space_id=) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/fil/fil0fil. Cc: 6009
Old_mod_counter=176
The node=0 x14984f78
The file={m_file=12, m_psi=}
Space=0 xb0
# 5 0 x0000000001251c85 in fil_flush_file_spaces (purpose=) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/fil/fil0fil. Cc: 6100
I=
Space=
Space_ids=0 x7f60a00008d8
N_space_ids=7
# 6 0 x00000000011f2a2b in buf_dblwr_update (bpage=, flush_type=) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/buf/buf0dblwr. Cc: 750
No locals.
# 7 0 x00000000011e6e88 in buf_page_io_complete (bpage=0 x7f6184408ff0, evict=false) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/buf/buf0buf. Cc: 5876
Io_type=BUF_IO_WRITE
Buf_pool=
Uncompressed=
# 8 0 x000000000125948e in fil_aio_wait (segment=8) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/fil/fil0fil. Cc: 5886
The node=0 x14984f78
Type={m_block_size=4096, m_type=258, m_compression={m_type=Compression will: : NONE}, m_encryption={m_type=Encryption: : NONE, m_key=0 x0, m_klen=0, m_iv=0 x0, static master_key_id=0, the static uuid='000' \ }}
Message=0 x7f6184408ff0
Err=
# 9 0 x000000000115deb0 in io_handler_thread (arg=) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/SRV/srv0start. Cc: 311
Segment=8
Start=
# 10 0 x00007f63d5c03dd5 start_thread in () the from/lib64/libpthreads. So. 0
No symbol table info available.
# 11 0 x00007f63d46bcead in clone () the from/lib64/libc. So. 6
No symbol table info available.

Thread (Thread 48 0 x7f611bae8700 (LWP) 10045) :
# 0 0 x00007f63d59fa644 __io_getevents_0_4 in () the from/lib64/libaio. So. 1
No symbol table info available.
# 1 0 x00000000010ba474 LinuxAIOHandler in: : collect (this=0 x7f611bae7dd0) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 2504
Events=0 x3a9d910
Timeout={tv_sec=0, tv_nsec=500000000}
Ret=
Io_ctx=0 x7f63cb005000
Start_pos=256
End_pos=512
# 2 0 x00000000010bc684 LinuxAIOHandler in: : poll (this=0 x7f611bae7dd0, m1=0 x7f611bae7e88, m2=0 x7f611bae7e80, request=0 x7f611bae7e50) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 2650
N_pending=0
Err=
Slot=0 x0
# 3 0 x00000000010bca3c in os_aio_linux_handler (request=0 x7f611bae7e50, m2=0 x7f611bae7e80, m1=0 x7f611bae7e88, global_segment=7), the at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 2706
Handler={m_array=0 x3a9b868 m_n_slots=256, m_segment=1, m_global_segment=7}
Err=
# 4 os_aio_handler (segment=7,=0 x7f611bae7e88 m1, m2=0 x7f611bae7e80, request=0 x7f611bae7e50) at/export/home/pb2/build/sb_0-29016441-1528454776.43/mysql - 5.7.23/storage/innobase/OS/os0file. Cc: 6253
Err=
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull