GreatSQL社区

搜索

[已解决] 在配置文件my.ini中添加 skip-grants-table 参数后,程序无法启动

893 1 2023-4-5 21:26
在给别人排错时遇到的问题,8.0.32 windows客户端:
不添加skip-grants-table可以正常启动。添加后就会报下面的错误:
  1. <p class="MsoNormal"><span lang="EN-US">[ERROR] [MY-010131] [Server] TCP/IP,
  2. --shared-memory, or --named-pipe should be configured on NT OS<o:p></o:p></span></p>

  3. <p class="MsoNormal"><span lang="EN-US"> </span></p>
复制代码

解决方法:
my.ini 文件的mysqld下添加
  1. shared-memory
复制代码



附上错误日志:前半部分是正常启动的日志


log.err

5.19 KB, 下载次数: 1, 下载积分: 金币 -1

错误日志

my.ini

15.45 KB, 下载次数: 1, 下载积分: 金币 -1

配置文件

全部回复(1)
yejr 2023-4-6 10:14:22
日志中,最后一部分提示的错误原因
看起来是数据文件损坏了或其他原因导致,如果确定只是因为多加了 --skip-grants-table 就导致报错的话,可以去报bug了
  1. 2023-04-05T12:55:37.579043Z 0 [ERROR] [MY-010131] [Server] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS
  2. 2023-04-05T12:55:37.579470Z 0 [ERROR] [MY-010119] [Server] Aborting
  3. 2023-04-05T12:55:38.701829Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: trx0sys.cc:643:UT_LIST_GET_LEN(trx_sys->mysql_trx_list) == 0 thread 6320
  4. InnoDB: We intentionally generate a memory trap.
  5. InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
  6. InnoDB: If you get repeated assertion failures or crashes, even
  7. InnoDB: immediately after the mysqld startup, there may be
  8. InnoDB: corruption in the InnoDB tablespace. Please refer to
  9. InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
  10. InnoDB: about forcing recovery.
  11. 2023-04-05T12:55:38Z UTC - mysqld got exception 0x16 ;
  12. Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
  13. Thread pointer: 0x0
  14. Attempting backtrace. You can use the following information to find out
  15. where mysqld died. If you see no messages after this, something went
  16. terribly wrong...
  17. 7ff72e6a8408    mysqld.exe!?my_print_stacktrace@@YAXPEBEK@Z()
  18. 7ff72d826c01    mysqld.exe!?print_fatal_signal@@YAXH@Z()
  19. 7ff72d826943    mysqld.exe!?my_server_abort@@YAXXZ()
  20. 7ff72e68a75a    mysqld.exe!?my_abort@@YAXXZ()
  21. 7ff72e8e62a9    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
  22. 7ff72e7a982e    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
  23. 7ff72e8904ef    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z()
  24. 7ff72e78441a    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
  25. 7ff72d611dfb    mysqld.exe!?ha_finalize_handlerton@@YAHPEAUst_plugin_int@@@Z()
  26. 7ff72d62ff34    mysqld.exe!?memcached_shutdown@@YAXXZ()
  27. 7ff72d635a48    mysqld.exe!?plugin_unlock_list@@YAXPEAVTHD@@PEAPEAUst_plugin_int@@_K@Z()
  28. 7ff72d634690    mysqld.exe!?plugin_shutdown@@YAXXZ()
  29. 7ff72d5cdb02    mysqld.exe!?check_valid_arguments_processor@Item_func@@UEAA_NPEAE@Z()
  30. 7ff72d5e0c0c    mysqld.exe!?underflow@?$basic_stringbuf@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@MEAAHXZ()
  31. 7ff72d5df5bc    mysqld.exe!?setup_conn_event_handler_threads@@YAXXZ()
  32. 7ff72d5e3159    mysqld.exe!?win_main@@YAHHPEAPEAD@Z()
  33. 7ff72d5db875    mysqld.exe!?mysql_service@@YAHPEAX@Z()
  34. 7ff72d5dbe7b    mysqld.exe!?mysqld_main@@YAHHPEAPEAD@Z()
  35. 7ff72eecc9d4    mysqld.exe!?vio_write_shared_memory@@YA_KPEAUVio@@PEBE_K@Z()
  36. 7ffc705a26bd    KERNEL32.DLL!BaseThreadInitThunk()
  37. 7ffc7194a9f8    ntdll.dll!RtlUserThreadStart()
  38. The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  39. information that should help you find out what is causing the crash.
复制代码

4

主题

5

博客

62

贡献

注册会员

Rank: 2

积分
80

助人为乐(铜)

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-11-22 04:26 , Processed in 0.020796 second(s), 12 queries , Redis On.
快速回复 返回顶部 返回列表