Не запускается MySql - MySQL (219547)

Узнай цену своей работы

Формулировка задачи:

Используется:

Windows - 7x64; MySQl - MySQL-5.7-x64; Пользователь - администратор; Антивирусы - Аваст (отключён).

Расположения:

Сервер - e:\srw\webopsrvr; MySQl - e:\srw\webopsrvr\modules\database\MySQL-5.7-x64\; Таблицы MySQl - "\\\\Server\\e\\srv\\db\\webopsrvr\\userdata\\MySQL-5.7-x64" (локальная сеть);

Логи

Листинг программы 
  1. [syntax=mysql]
  2. Запрос
  3. e:\srw\webopsrvr\modules\database\MySQL-5.7-x64\bin\mysqld.exe, Version: 5.7.16-log (MySQL Community Server (GPL)). started with:
  4. TCP Port: 3306, Named Pipe: (null)
  5. Time                 Id Command    Argument
  6.  
  7. 2017-08-06T04:06:31.932785Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
  8. 2017-08-06T04:06:31.933786Z 0 [Note] e:\srw\webopsrvr\modules\database\MySQL-5.7-x64\bin\mysqld.exe (mysqld 5.7.16-log) starting as process 4300 ...
  9. 2017-08-06T04:06:31.978788Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
  10. 2017-08-06T04:06:31.980788Z 0 [Note] InnoDB: Uses event mutexes
  11. 2017-08-06T04:06:31.980788Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
  12. 2017-08-06T04:06:31.980788Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
  13. 2017-08-06T04:06:31.981788Z 0 [Note] InnoDB: Number of pools: 1
  14. 2017-08-06T04:06:31.981788Z 0 [Note] InnoDB: Not using CPU crc32 instructions
  15. 2017-08-06T04:06:31.984788Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
  16. 2017-08-06T04:06:32.001789Z 0 [Note] InnoDB: Completed initialization of buffer pool
  17. 2017-08-06T04:06:32.397812Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
  18. 2017-08-06T04:06:32.408813Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 91192078032
  19. 2017-08-06T04:06:32.408813Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 91192078041
  20. 2017-08-06T04:06:32.416813Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 91192078041
  21. 2017-08-06T04:06:32.417813Z 0 [Note] InnoDB: Database was not shutdown normally!
  22. 2017-08-06T04:06:32.417813Z 0 [Note] InnoDB: Starting crash recovery.
  23.  
  24. 2017-08-06T04:06:44.464502Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
  25. 2017-08-06T04:06:44.465502Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
  26. 2017-08-06T04:06:44.465502Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
  27. 2017-08-06T04:06:44.465502Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\sys\sys_config.ibd' OS error: 103
  28. 2017-08-06T04:06:44.465502Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `sys/sys_config`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  29.  
  30. 2017-08-06T04:06:44.465502Z 0 [Warning] InnoDB: Ignoring tablespace `sys/sys_config` because it could not be opened.
  31. 2017-08-06T04:06:46.703630Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
  32. 2017-08-06T04:06:46.703630Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
  33. 2017-08-06T04:06:46.703630Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
  34. 2017-08-06T04:06:46.703630Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\tst_rb_mn_02_1\002_tst_01_vr_05_tbl_frm2_ssl.ibd' OS error: 103
  35. 2017-08-06T04:06:46.703630Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_02_1/002_tst_01_vr_05_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  36.  
  37. 2017-08-06T04:06:46.704630Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_02_1/002_tst_01_vr_05_tbl_frm2_ssl` because it could not be opened.
  38. 2017-08-06T04:06:46.706631Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
  39. 2017-08-06T04:06:46.706631Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
  40. 2017-08-06T04:06:46.706631Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
  41. 2017-08-06T04:06:46.706631Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\tst_rb_mn_02_1\002_tst_02_vr_08_tbl_frm2_ssl.ibd' OS error: 103
  42. 2017-08-06T04:06:46.706631Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_02_1/002_tst_02_vr_08_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  43.  
  44. 2017-08-06T04:06:46.706631Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_02_1/002_tst_02_vr_08_tbl_frm2_ssl` because it could not be opened.
  45. 2017-08-06T04:06:46.709631Z 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
  46. 2017-08-06T04:06:46.709631Z 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
  47. 2017-08-06T04:06:46.709631Z 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
  48. 2017-08-06T04:06:46.709631Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\tst_rb_mn_02_1\002_tst_03_vr_11_tbl_frm2_ssl.ibd' OS error: 103
  49. 2017-08-06T04:06:46.710631Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_02_1/002_tst_03_vr_11_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  50.  
  51. 2017-08-06T04:06:46.710631Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_02_1/002_tst_03_vr_11_tbl_frm2_ssl` because it could not be opened.
  52. 2017-08-06T04:06:46.719631Z 0 [ERROR] InnoDB: In file '.\tst_rb_mn_03\002_tst_01_vr_05_tbl_frm2_ssl.ibd', tablespace id and flags are 429 and 33, but in the InnoDB data dictionary they are 480 and 33. Have you moved InnoDB .ibd files around without using the commands DISCARD TABLESPACE and IMPORT TABLESPACE? Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  53. 2017-08-06T04:06:46.720631Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_03/002_tst_01_vr_05_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  54.  
  55. 2017-08-06T04:06:46.720631Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_03/002_tst_01_vr_05_tbl_frm2_ssl` because it could not be opened.
  56. 2017-08-06T04:06:46.730632Z 0 [ERROR] InnoDB: In file '.\tst_rb_mn_03\002_tst_02_vr_08_tbl_frm2_ssl.ibd', tablespace id and flags are 430 and 33, but in the InnoDB data dictionary they are 481 and 33. Have you moved InnoDB .ibd files around without using the commands DISCARD TABLESPACE and IMPORT TABLESPACE? Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  57. 2017-08-06T04:06:46.730632Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_03/002_tst_02_vr_08_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  58.  
  59. 2017-08-06T04:06:46.730632Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_03/002_tst_02_vr_08_tbl_frm2_ssl` because it could not be opened.
  60. 2017-08-06T04:06:46.740632Z 0 [ERROR] InnoDB: In file '.\tst_rb_mn_03\002_tst_03_vr_11_tbl_frm2_ssl.ibd', tablespace id and flags are 431 and 33, but in the InnoDB data dictionary they are 482 and 33. Have you moved InnoDB .ibd files around without using the commands DISCARD TABLESPACE and IMPORT TABLESPACE? Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  61. 2017-08-06T04:06:46.740632Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `tst_rb_mn_03/002_tst_03_vr_11_tbl_frm2_ssl`. Please refer to [url]http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url] for how to resolve the issue.
  62.  
  63. 2017-08-06T04:06:46.741633Z 0 [Warning] InnoDB: Ignoring tablespace `tst_rb_mn_03/002_tst_03_vr_11_tbl_frm2_ssl` because it could not be opened.
  64.  
  65. 2017-08-06T04:07:08.867898Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
  66. 2017-08-06T04:07:08.867898Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
  67. 2017-08-06T04:07:08.867898Z 0 [Note] InnoDB: Setting file 'e:\srw\webopsrvr\userdata\MySQL-5.7-x64\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
  68. 2017-08-06T04:07:09.207918Z 0 [Note] InnoDB: File 'e:\srw\webopsrvr\userdata\MySQL-5.7-x64\ibtmp1' size is now 12 MB.
  69. 2017-08-06T04:07:09.229919Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
  70. 2017-08-06T04:07:09.229919Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
  71. 2017-08-06T04:07:09.231919Z 0 [Note] InnoDB: Waiting for purge to start
  72. 2017-08-06T04:07:09.283922Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37274ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
  73. 2017-08-06T04:07:09.283922Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 91192078041
  74. 2017-08-06T04:07:09.284922Z 0 [Note] InnoDB: Loading buffer pool(s) from e:\srw\webopsrvr\userdata\MySQL-5.7-x64\ib_buffer_pool
  75. 2017-08-06T04:07:09.284922Z 0 [Note] Plugin 'FEDERATED' is disabled.
  76. 2017-08-06T04:07:09.509935Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  77. 2017-08-06T04:07:09.511935Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
  78. 2017-08-06T04:07:09.511935Z 0 [Note] Server socket created on IP: '127.0.0.1'.
  79. 2017-08-06T04:07:09.923958Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170806  7:07:09
  80. 2017-08-06T04:07:11.037022Z 0 [Note] Event Scheduler: Loaded 0 events
  81. 2017-08-06T04:07:11.038022Z 0 [Note] e:\srw\webopsrvr\modules\database\MySQL-5.7-x64\bin\mysqld.exe: ready for connections.
  82. Version: '5.7.16-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
  83.  
  84. [/syntax]

Вопрос

Как исправить ошибку?

Решение задачи: «Не запускается MySql»

textual
Листинг программы 
  1. character-sets-dir    = "e:\\srw\\webopsrvr\\modules\\database\\MySQL-5.7-x64\\share\\charsets"
  2. no-auto-rehash
  3. no-beep
  4.  
  5. [mysqld]
  6. #skip-character-set-client-handshake
  7. #skip-name-resolve
  8. #sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  9. general_log = 1
  10. general_log_file = "e:\\srw\\webopsrvr\\userdata\\logs\\MySQL-5.7-x64_queries.log"
  11. back_log = 100
  12. basedir = "e:\\srw\\webopsrvr\\modules\\database\\MySQL-5.7-x64"
  13.  
  14. #работает
  15. #bind-address = 127.0.0.1
  16. #bind-address = 192.168.1.1
  17. #bind-address = 0.0.0.0
  18.  
  19. #работает
  20. bind-address = 127.0.0.1
  21.  
  22. #binlog_row_event_max_size=8K
  23. bulk_insert_buffer_size = 2M
  24. character-set-server=utf8
  25. character-sets-dir    = "e:\\srw\\webopsrvr\\modules\\database\\MySQL-5.7-x64\\share\\charsets"
  26. collation-server=utf8_general_ci
  27. connect_timeout = 5
  28. #datadir = "e:\\srw\\webopsrvr\\userdata\\MySQL-5.7-x64"
  29. datadir = "\\\\Server\\e\\srv\\db\\webopsrvr\\userdata\\MySQL-5.7-x64"
  30. default-storage-engine=InnoDB
  31. expire_logs_days = 2
  32. explicit_defaults_for_timestamp = TRUE
  33. flush_time=0
  34. ft_min_word_len=4
  35. init-connect="SET NAMES utf8"
  36. interactive_timeout=30
  37. join_buffer_size = 1M
  38. key_buffer_size = 25M
  39. local-infile=0
  40. #secure-file-priv = "e:\\srw\\webopsrvr\\userdata\\temp"
  41. ssl-cert="e:\\srw\\webopsrvr\\userdata\\config\\cert_files\\server.crt"
  42. ssl-key="e:\\srw\\webopsrvr\\userdata\\config\\cert_files\\server.key"
  43. log-error = "e:\\srw\\webopsrvr\\userdata\\logs\\MySQL-5.7-x64_error.log"
  44. lower_case_table_names = 2
  45. max_allowed_packet = 32M
  46. max_connect_errors = 10
  47. max_connections = 30
  48. max_heap_table_size = 25M
  49. max_tmp_tables = 25
  50. myisam-recover-options=backup,force
  51. myisam_max_sort_file_size = 256M
  52. myisam_repair_threads = 1
  53. open_files_limit=4110
  54. pid_file = "e:\\srw\\webopsrvr\\userdata\\temp\\mysql.pid"
  55. port = 3307
  56. query_cache_limit = 256K
  57. query_cache_size=25M
  58. query_cache_type=1
  59. read_buffer_size=2M
  60. read_rnd_buffer_size=4M
  61. server-id = 1
  62. skip-external-locking
  63. skip-innodb_adaptive_hash_index
  64. sort_buffer_size = 1M
  65. table_definition_cache = 400
  66. table_open_cache = 400
  67. thread_cache_size = 4
  68. tmp_table_size = 25M
  69. tmpdir = "e:\\srw\\webopsrvr\\userdata\\temp"
  70. transaction-isolation = READ-COMMITTED
  71. wait_timeout=60
  72.  
  73. #innodb_fast_shutdown
  74. #innodb_file_per_table = 1
  75. #innodb_force_recovery=1
  76. #skip-innodb_doublewrite
  77. innodb_buffer_pool_instances=1
  78. innodb_buffer_pool_size = 128M
  79. innodb_checksum_algorithm=0
  80. innodb_concurrency_tickets=5000
  81. innodb_data_file_path = ibdata1:10M:autoextend
  82. innodb_data_home_dir = "e:\\srw\\webopsrvr\\userdata\\MySQL-5.7-x64"
  83. innodb_flush_log_at_trx_commit = 2
  84. innodb_lock_wait_timeout = 30
  85. innodb_log_buffer_size = 1M
  86. innodb_log_file_size = 64M
  87. innodb_log_files_in_group = 2
  88. innodb_max_dirty_pages_pct = 90
  89. innodb_old_blocks_time=1000
  90. innodb_read_io_threads = 8
  91. innodb_stats_on_metadata=0
  92. innodb_thread_concurrency=4
  93. innodb_write_io_threads = 8
  94.  
  95. [mysqldump]
  96. quick
  97. max_allowed_packet = 16M
  98.  
  99. [myisamchk]
  100. key_buffer_size = 50M
  101. sort_buffer_size = 50M
  102. read_buffer = 8M
  103. write_buffer = 8M
  104.  
  105. [mysqlhotcopy]
  106. interactive-timeout
  107.  
  108. [mysqld_safe]
  109. open-files-limit = 2048

ИИ поможет Вам:

  • решить любую задачу по программированию
  • объяснить код
  • расставить комментарии в коде
  • и т.д
Попробуйте бесплатно

Оцени полезность:

11   голосов , оценка 4.545 из 5

Нужна аналогичная работа?

Оформи быстрый заказ и узнай стоимость

Бесплатно
Оформите заказ и авторы начнут откликаться уже через 10 минут