禅道使用
598107

断电重启mysqlzt服务失败[ERROR] mysqld got except解决中 悬赏15积分

提问者笑点低的回锅肉 答案数1 阅读数20 发表时间2024-11-20 17:08:28

2024-11-20 16:52:33 192 [Note] Plugin 'InnoDB' is disabled.

2024-11-20 16:52:33 192 [Note] Server socket created on IP: '127.0.0.1'.

241120 16:52:33 [ERROR] mysqld got exception 0xc0000005 ;

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=16777216

read_buffer_size=262144

max_used_connections=0

max_threads=1001

thread_count=0

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 787888 K bytes of memory

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

Thread pointer: 0x1fbd8c83ac8

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...

mysqld.exe!?reset_for_next_command@THD@@QEAAXXZ()

mysqld.exe!?rpl_load_gtid_slave_state@@YAHPEAVTHD@@@Z()

mysqld.exe!handle_slave_background()

mysqld.exe!pthread_join()

mysqld.exe!my_wildcmp_mb_bin()

mysqld.exe!my_wildcmp_mb_bin()

KERNEL32.DLL!BaseThreadInitThunk()

ntdll.dll!RtlUserThreadStart()

Trying to get some variables.

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

Query (0x0):

Connection ID (thread ID): 2

Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off

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.

禅道版本:禅道专业版 2.1

安装包类型:Windows安装包

操作系统:Windows Server 2008

客户端浏览器:

设置备注
内容
答案列表
2024-11-20 17:29:32

在my.cnf 配置文件中增加或修改启动级别,设置 innodb_force_recovery 的值。这个值的范围是1到6,数字越大,恢复的级别越高,但可能会丢失更多的数据。例如,可以设置innodb_force_recovery=1,然后尝试启动数据库,如果不能启动,逐步递增该值。

另外可以检查禅道代码目录 zentao/tmp/backup/目录下是否有备份,可以利用备份进行还原数据。

🚂
2024/11/20
尝试过innodb_force_recovery = 1-6 这个设置,重启仍然失败。
2024/11/20
检查下服务器内存是否正常,如果硬件都没问题,看下备份目录下是否有自动产生的备份,利用备份重新安装后还原下数据。
联系我们
联系人
刘斌/高级客户经理
电话(微信)
17685869372
QQ号码
526288068
联系邮箱
liubin@chandao.com
返回顶部
刘斌
高级客户经理
17685869372
526288068
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。