xampp - Xampp (Ver 3.2) Mysql 无法启动
问题描述
Xampp:从 MySQL 数据中删除某些数据库后 MySQL 无法启动,返回以下错误,在删除数据库后工作正常之前只有问题。如何解决问题。实际上从 mysql-> 数据而不是从 PhpMyadmin 中删除数据库。
错误 :
2020-05-12 18:40:20 7380 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-05-12 18:40:20 7380 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-12 18:40:20 7380 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-05-12 18:40:20 7380 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2020-05-12 18:40:20 7380 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-12 18:40:20 7380 [Note] InnoDB: Using generic crc32 instructions
2020-05-12 18:40:20 7380 [Note] InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(139984896 bytes) failed; Windows error 8
InnoDB: Error: Block 2609BCB0 incorrect state BUF_BLOCK_POOL_WATCH in buf_LRU_block_free_non_file_page()
200512 18:40:20 [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.38-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 = 787137 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 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...
mysqld.exe!parse_user()
mysqld.exe!parse_user()
mysqld.exe!parse_user()
mysqld.exe!parse_user()
mysqld.exe!parse_user()
mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
mysqld.exe!?init_net_server_extension@@YAXPAVTHD@@@Z()
mysqld.exe!?win_main@@YAHHPAPAD@Z()
mysqld.exe!?mysql_service@@YAHPAX@Z()
mysqld.exe!strxnmov()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!VerSetConditionMask()
ntdll.dll!VerSetConditionMask()
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.
解决方案
推荐阅读
- react-native - 如何使用 Flatlist 从父母那里检索数据?
- c# - 来自 appsetting.json (.NET Core) 的 WCF 服务客户端配置
- javascript - 如何将值发送到与其他 2 个类同名的输入类?
- amazon-ec2 - 即使我停止了 neo4j 服务,我的 neo4j 浏览器如何仍然工作?
- python - 如何让 buildozer 在 android 设备上安装 kivy 应用程序而不删除之前的应用程序?
- firebase - 卸载应用程序时 Flutter 注销用户
- javascript - 您不能对同一动态路径 Nextjs 使用不同的 slug 名称
- python - 基于共同的第一个元素合并二维列表中的元素
- javascript - 如何从范围外的辅助函数访问数组的值
- c - x86 - GDT - GCC 可以处理不同的段(用于代码和数据)吗?