mysql got signal 11_mysql 报mysqld got signal 11 问题,哪位可以帮忙分析下Log?

121120 13:56:59 - mysqld got signal 11 ;

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.

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.

key_buffer_size=268435456

read_buffer_size=1048576

max_used_connections=57

max_threads=5000

thread_count=12

connection_count=11

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 10556987 K

bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

thd: 0x2aab043e0e10

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 = 0x4aa800d0 thread_stack 0x80000

/usr/local/webserver/mysql/libexec/mysqld(my_print_stacktrace+0x24) [0x8a9e44]

/usr/local/webserver/mysql/libexec/mysqld(handle_segfault+0x33b) [0x5d1ffb]

/lib64/libpthread.so.0 [0x3ad5c0ebe0]

/usr/local/webserver/mysql/libexec/mysqld(Field_varstring::sql_type(String&) const+0x9a) [0x5a222a]

/usr/local/webserver/mysql/libexec/mysqld(store_column_type(TABLE*, Field*, charset_info_st*, unsigned int)+0x6a) [0x6ffeda]

/usr/local/webserver/mysql/libexec/mysqld [0x70e331]

/usr/local/webserver/mysql/libexec/mysqld(get_all_tables(THD*, TABLE_LIST*, Item*)+0x459) [0x7075f9]

/usr/local/webserver/mysql/libexec/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x1d0) [0x6fdb80]

/usr/local/webserver/mysql/libexec/mysqld(JOIN::exec()+0x439) [0x65b8f9]

/usr/local/webserver/mysql/libexec/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x198) [0x65dbd8]

/usr/local/webserver/mysql/libexec/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x16f) [0x65e51f]

/usr/local/webserver/mysql/libexec/mysqld [0x5df08b]

/usr/local/webserver/mysql/libexec/mysqld(mysql_execute_command(THD*)+0x2786) [0x5e26b6]

/usr/local/webserver/mysql/libexec/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x230) [0x5e6220]

/usr/local/webserver/mysql/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x987) [0x5e6bb7]

/usr/local/webserver/mysql/libexec/mysqld(do_command(THD*)+0xc2) [0x5e7712]

/usr/local/webserver/mysql/libexec/mysqld(do_handle_one_connection(THD*)+0x65a) [0x5d993a]

/usr/local/webserver/mysql/libexec/mysqld(handle_one_connection+0x9) [0x5d9fc9]

/lib64/libpthread.so.0 [0x3ad5c0677d]

/lib64/libc.so.6(clone+0x6d) [0x3ad54d325d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort...

thd->query at 0x2aab042ae1c0 is an invalid pointer

thd->thread_id=299827

thd->killed=NOT_KILLED

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.

121120 13:56:59 mysqld_safe Number of processes running now: 0

121120 13:56:59 mysqld_safe mysqld restarted

InnoDB: The InnoDB memory heap is disabled

InnoDB: Mutexes and rw_locks use GCC atomic builtins

121120 13:56:59  InnoDB: highest supported file format is Barracuda.

InnoDB: Log scan progressed past the checkpoint lsn 695697903098

121120 13:56:59  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

InnoDB: Doing recovery: scanned up to log sequence number 695703145472

InnoDB: Doing recovery: scanned up to log sequence number 695708388352

InnoDB: Doing recovery: scanned up to log sequence number 695713631232

InnoDB: Doing recovery: scanned up to log sequence number 695718874112

InnoDB: Doing recovery: scanned up to log sequence number 695724116992

InnoDB: Doing recovery: scanned up to log sequence number 695729359872

InnoDB: Doing recovery: scanned up to log sequence number 695734602752

InnoDB: Doing recovery: scanned up to log sequence number 695739845632

InnoDB: Doing recovery: scanned up to log sequence number 695740037589

121120 13:57:00  InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

InnoDB: Apply batch completed

InnoDB: Last MySQL binlog file position 0 130678811, file name /home/mysql/binlog/binlog.000130

121120 13:57:34 InnoDB Plugin 1.0.6 started; log sequence number 695740037589

121120 13:57:34 [Warning] 'user' entry 'root@dev.da-mai.com' ignored in --skip-name-resolve mode.

121120 13:57:34 [Warning] 'user' entry '@dev.da-mai.com' ignored in --skip-name-resolve mode.

121120 13:57:34 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './mysql/event' is marked as crashed and should be repaired

121120 13:57:34 [Warning] Checking table:   './mysql/event'

121120 13:57:34 [ERROR] 1 client is using or hasn't closed the table properly

121120 13:57:34 [Note] Event Scheduler: Loaded 16 events

121120 13:57:34 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.

Version: '5.5.3-m3'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

121120 13:57:34 [Note] Event Scheduler: scheduler thread started with id 1

121120 13:57:34 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/auth_item' is marked as crashed and should be repaired

121120 13:57:34 [Warning] Checking table:   './damai/auth_item'

121120 13:57:34 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/auth_assignment' is marked as crashed and should be repaired

121120 13:57:34 [Warning] Checking table:   './damai/auth_assignment'

121120 13:57:34 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/operation_log' is marked as crashed and should be repaired

121120 13:57:34 [Warning] Checking table:   './damai/operation_log'

121120 13:57:38 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './trace/piwik_log_action' is marked as crashed and should be repaired

121120 13:57:38 [Warning] Checking table:   './trace/piwik_log_action'

121120 13:57:41 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/ztc0027' is marked as crashed and should be repaired

121120 13:57:41 [Warning] Checking table:   './damai/ztc0027'

121120 13:57:41 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/shop' is marked as crashed and should be repaired

121120 13:57:41 [Warning] Checking table:   './damai/shop'

121120 13:57:41 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/trade0002' is marked as crashed and should be repaired

121120 13:57:41 [Warning] Checking table:   './damai/trade0002'

121120 13:57:43 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './trace/piwik_log_visit' is marked as crashed and should be repaired

121120 13:57:43 [Warning] Checking table:   './trace/piwik_log_visit'

121120 13:57:43 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './trace/piwik_log_link_visit_action' is marked as crashed and should be repaired

121120 13:57:43 [Warning] Checking table:   './trace/piwik_log_link_visit_action'

121120 13:57:45 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './mysql/proc' is marked as crashed and should be repaired

121120 13:57:45 [Warning] Checking table:   './mysql/proc'

121120 13:57:45 [ERROR] 1 client is using or hasn't closed the table properly

121120 13:57:53 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: Table './damai/message' is marked as crashed and should be repaired

121120 13:57:53 [Warning] Checking table:   './damai/message'

121120 13:57:53 [ERROR] 1 client is using or hasn't closed the table properly

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. 2025-03-09 13:57:47+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.2.0-1.el9 started. 2025-03-09 13:57:48+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-03-09 13:57:48+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.2.0-1.el9 started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2025-03-09T05:57:48.531353Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-03-09T05:57:48.796751Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.2.0) starting as process 1 2025-03-09T05:57:48.830566Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-09T05:57:50.751653Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-09T05:57:51.358634Z 1 [ERROR] [MY-010520] [Server] Invalid (old?) table or database name 'hm-item' 2025-03-09T05:57:51Z UTC - mysqld got signal 11 ; Signal SIGSEGV (Address not mapped to object) at address 0x0 Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=6e45d3c3fff42426a19918d101b1be25b8ec7297 Thread pointer: 0x7b6d2b0 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 = 7f73c1411b10 thread_stack 0x100000 #0 0xc84d30 <unknown> #1 0x7f73ce20f72f <unknown> #2 0x1950243 <unknown> #3 0x19a4793 <unknown> #4 0x16fd7bb <unknown> #5 0x153a34a <unknown> #6 0x154e9ca <unknown> #7 0xd2cc07 <unknown> #8 0x1cf6501 <unknown> #9 0x7f73ce25ad31 <unknown> #10 0x7f73ce2df0b3 <unknown> #11 0xffffffffffffffff <unknown> Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 1 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/cras
最新发布
03-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值