我刚刚重新启动我的开发机器,现在MySQL拒绝启动。 当我开始服务,它立即抛出一个exception,并死…
我想不出任何我可以改变之前,重新启动,可能已经影响MySQL以任何方式…
这是在Windows 2003 Server上运行的MySQL Server 5.1。
这是日志文件所说的:
090703 14:11:17 - 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. 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=26214400 read_buffer_size=65536 max_used_connections=0 max_threads=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58231 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 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... 006B8853 mysqld.exe!srv_parse_data_file_paths_and_sizes()[srv0start.c:211] 006A7E18 mysqld.exe!innobase_init()[ha_innodb.cc:1536] 00442748 mysqld.exe!ha_initialize_handlerton()[handler.cc:434] 00561253 mysqld.exe!plugin_initialize()[sql_plugin.cc:1002] 00565AE5 mysqld.exe!plugin_init()[sql_plugin.cc:1209] 004CE1B4 mysqld.exe!init_server_components()[mysqld.cc:3831] 004CE8C6 mysqld.exe!win_main()[mysqld.cc:4267] 004CECDB mysqld.exe!mysql_service()[mysqld.cc:4439] 00724593 mysqld.exe!_callthreadstart()[thread.c:293] 0072462C mysqld.exe!_threadstart()[thread.c:275] 77E6482F kernel32.dll!GetModuleHandleA() 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.
有任何想法吗?
我应该卸载并重新安装MySQL?
有什么比我能做的更快吗?
谢谢!
尝试在启动之前删除innodb日志文件(数据目录中的ib_logfileXX)。
我最终只是卸载并重新安装MySQL,现在工作正常。
谢谢!
亚历山大
差不多三年后,你仍然在帮助人们(特别是 – 我)! 感谢那。 删除ib_logfileXX'救了我'! MySQL 5.0服务不会在完全打补丁的Windows 2003服务器SP2 +上以1067的系统错误启动。 删除文件后,我能够启动服务。 我的ISP停电后出现问题。 在此之前的两年里,MySQL运行良好。
为了以防万一它在未来帮助别人find这个网页我从我的错误日志文件发布信息:
InnoDB: Log scan progressed past the checkpoint lsn 6 3854032829 120302 17:36:11 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 6 3854504678 120302 17:36:13 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 120302 17:36:13 - 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. 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=8388608 read_buffer_size=65536 max_used_connections=0 max_threads=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 36422 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 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... 006FCC74 mysqld.exe!mach_read_from_1()[mach0data.ic:37] 00707A5E mysqld.exe!rec_get_bit_field_1()[rem0rec.ic:189] 00707CAA mysqld.exe!rec_get_n_owned()[rem0rec.ic:462] 006CDEB1 mysqld.exe!page_rec_find_owner_rec()[page0page.ic:683] 007192A6 mysqld.exe!page_cur_insert_rec_low()[page0cur.c:1001] 00719940 mysqld.exe!page_cur_rec_insert()[page0cur.ic:208] 00719D3E mysqld.exe!page_cur_parse_insert_rec()[page0cur.c:847] 0071382F mysqld.exe!recv_parse_or_apply_log_rec_body()[log0recv.c:814] 007143F1 mysqld.exe!recv_recover_page()[log0recv.c:1294] 006EA57F mysqld.exe!buf_page_io_complete()[buf0buf.c:2033] 006E2BE2 mysqld.exe!fil_aio_wait()[fil0fil.c:4273] 006BB59D mysqld.exe!io_handler_thread()[srv0start.c:437] 77E6482F kernel32.dll!GetModuleHandleA() 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.
0xc0000005是什么,一个“访问冲突”的错误? 听起来像(一)有一个错误 – 一个不好的指针触发尝试“接触”受保护的内存,导致操作系统sla手指,或(二)你有一些坏RAM安装,坏点触发指针访问受保护的内存,导致与(a)相同的yada-yada。
如果您重新安装MySQL,是否可以安装v5.0而不是v5.1? 虽然我确信那些问题已经被解决了,当然,如果您使用5.1特有的function,那么5.1版本有一些稳定性问题的初步报告,这是不可能的。 。
006B8853 mysqld.exe!srv_parse_data_file_paths_and_sizes()[srv0start.c:211]
似乎表明parsingconfiguration文件时出现问题,我会用一个好的文本编辑器检查它,检查非ASCII字符并检查所有path和variables是否合理。
硬盘空间用尽后,我有这个错误。 我终于通过删除C:\ Windows \ temp中的ib * .tmp文件解决了这个问题,这些文件导致启动失败,即使是以前工作的数据目录。