MD не перезагружается!

Если вы только начинаете осваивать систему MajorDoMo и чего-то не знаете или не можете понять, то задавайте свои вопросы в этой ветке.

Модератор: immortal

Ответить
Yashalta
Сообщения: 315
Зарегистрирован: Вс май 20, 2018 9:27 am
Благодарил (а): 160 раз
Поблагодарили: 29 раз

MD не перезагружается!

Сообщение Yashalta » Пт май 24, 2019 2:33 pm

Я посмотрел лог /var/log/mysql/
и вот, что пишет

Код: Выделить всё

2019-05-24 13:27:05 1776534336 [Note] /usr/sbin/mysqld: Normal shutdown
2019-05-24 13:27:05 1776534336 [Note] Event Scheduler: Purging the queue. 0 events
2019-05-24 13:27:06 1447019328 [Note] InnoDB: FTS optimize thread exiting.
2019-05-24 13:27:06 1776534336 [Note] InnoDB: Starting shutdown...
2019-05-24 13:27:06 1776534336 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-05-24 13:27:07 1776534336 [Note] InnoDB: Shutdown completed; log sequence number 1601145
2019-05-24 13:27:07 1776534336 [Note] /usr/sbin/mysqld: Shutdown complete

2019-05-24 13:33:55 1995943728 [ERROR] mysqld: File '/tmp/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
2019-05-24 13:33:55 1995943728 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/tmp/mysql/aria_log_control'
2019-05-24 13:33:55 1995943728 [ERROR] Plugin 'Aria' init function returned error.
2019-05-24 13:33:55 1995943728 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-05-24 13:33:55 1995943728 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-05-24 13:33:55 1995943728 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-05-24 13:33:55 1995943728 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 13:33:55 1995943728 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Using Linux native AIO
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Using generic crc32 instructions
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 13:33:55 1995943728 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 13:33:55 1995943728 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2019-05-24 13:33:55 1995943728 [ERROR] InnoDB: The system tablespace must be writable!
2019-05-24 13:33:55 1995943728 [ERROR] Plugin 'InnoDB' init function returned error.
2019-05-24 13:33:55 1995943728 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-05-24 13:33:55 1995943728 [Note] Plugin 'FEEDBACK' is disabled.
2019-05-24 13:33:55 1995943728 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-05-24 13:33:55 1995943728 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2019-05-24 13:33:55 1995943728 [ERROR] Aborting

2019-05-24 13:41:09 1995706160 [ERROR] mysqld: File '/tmp/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
2019-05-24 13:41:09 1995706160 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/tmp/mysql/aria_log_control'
2019-05-24 13:41:09 1995706160 [ERROR] Plugin 'Aria' init function returned error.
2019-05-24 13:41:09 1995706160 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-05-24 13:41:09 1995706160 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-05-24 13:41:09 1995706160 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-05-24 13:41:09 1995706160 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 13:41:09 1995706160 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Using Linux native AIO
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Using generic crc32 instructions
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 13:41:09 1995706160 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 13:41:09 1995706160 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2019-05-24 13:41:09 1995706160 [ERROR] InnoDB: The system tablespace must be writable!
2019-05-24 13:41:09 1995706160 [ERROR] Plugin 'InnoDB' init function returned error.
2019-05-24 13:41:09 1995706160 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-05-24 13:41:09 1995706160 [Note] Plugin 'FEEDBACK' is disabled.
2019-05-24 13:41:09 1995706160 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-05-24 13:41:09 1995706160 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2019-05-24 13:41:09 1995706160 [ERROR] Aborting

2019-05-24 13:46:45 1995484976 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-05-24 13:46:45 1995484976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-05-24 13:46:45 1995484976 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 13:46:45 1995484976 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Using Linux native AIO
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Using generic crc32 instructions
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-24 13:46:45 1995484976 [Note] InnoDB: The log sequence number 0 in ibdata file do not match the log sequence number 1601145 in the ib_logfiles!
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-05-24 13:46:45 1995484976 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-24 13:46:45 1995484976 [Note] InnoDB: Waiting for purge to start
2019-05-24 13:46:45 1995484976 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 1601145
2019-05-24 13:46:45 1379922752 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-05-24 13:46:45 1995484976 [Note] Plugin 'FEEDBACK' is disabled.
2019-05-24 13:46:45 1995484976 [Note] Recovering after a crash using tc.log
2019-05-24 13:46:45 1995484976 [Note] Starting crash recovery...
2019-05-24 13:46:45 1995484976 [Note] Crash recovery finished.
2019-05-24 13:46:45 1995484976 [Note] Server socket created on IP: '127.0.0.1'.
2019-05-24 13:46:45 1978950464 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2019-05-24 13:46:45 1978950464 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2019-05-24 13:46:45 1995484976 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.38-MariaDB-0+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Raspbian 9.0
2019-05-24 14:14:52 1947886400 [Note] /usr/sbin/mysqld: Normal shutdown
2019-05-24 14:14:52 1947886400 [Note] Event Scheduler: Purging the queue. 0 events
2019-05-24 14:14:53 1442825024 [Note] InnoDB: FTS optimize thread exiting.
2019-05-24 14:14:53 1947886400 [Note] InnoDB: Starting shutdown...
2019-05-24 14:14:53 1947886400 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-05-24 14:14:55 1947886400 [Note] InnoDB: Shutdown completed; log sequence number 1601155
2019-05-24 14:14:55 1947886400 [ERROR] mysqld: Error on delete of './tc.log' (Errcode: 2 "No such file or directory")
2019-05-24 14:14:55 1947886400 [Note] /usr/sbin/mysqld: Shutdown complete

2019-05-24 14:22:13 1996115760 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-05-24 14:22:13 1996115760 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-05-24 14:22:13 1996115760 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-24 14:22:13 1996115760 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Using Linux native AIO
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Using generic crc32 instructions
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Completed initialization of buffer pool
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-24 14:22:13 1996115760 [Note] InnoDB: The log sequence number 0 in ibdata file do not match the log sequence number 1601145 in the ib_logfiles!
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-05-24 14:22:13 1996115760 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-24 14:22:13 1996115760 [Note] InnoDB: Waiting for purge to start
2019-05-24 14:22:13 1996115760 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 1601145
2019-05-24 14:22:13 1379922752 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-05-24 14:22:13 1996115760 [Note] Plugin 'FEEDBACK' is disabled.
2019-05-24 14:22:13 1996115760 [Note] Recovering after a crash using tc.log
2019-05-24 14:22:13 1996115760 [Note] Starting crash recovery...
2019-05-24 14:22:13 1996115760 [Note] Crash recovery finished.
2019-05-24 14:22:13 1996115760 [Note] Server socket created on IP: '127.0.0.1'.
2019-05-24 14:22:13 1954333504 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2019-05-24 14:22:13 1954333504 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2019-05-24 14:22:13 1996115760 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.38-MariaDB-0+deb9u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Raspbian 9.0

Нужно несколько раз включить, выключить Raspberry после чего все заведется...
Может есть решение?
Husky
Сообщения: 59
Зарегистрирован: Ср мар 06, 2019 8:46 am
Благодарил (а): 5 раз
Поблагодарили: 7 раз

Re: MD не перезагружается!

Сообщение Husky » Пн окт 07, 2019 8:52 pm

У меня такая же ошибка, никто не решил?

После перезапуска малинки MySQL не поднимается с этим же логом как у ТС.

Но если зайти через putty и запустить сервис вручную, то все стабильно заводится. (service mysql start)

Мне кажется на момент старта малинки может еще не успевает подключиться /tmp или что-то в этом духе. Проверил права на все каталоги на пути к "/tmp/mysql/aria_log_control" везде права есть. владелец папки mysql - mysql
Logrus
Сообщения: 2084
Зарегистрирован: Пт апр 07, 2017 12:20 pm
Благодарил (а): 313 раз
Поблагодарили: 457 раз

Re: MD не перезагружается!

Сообщение Logrus » Вт окт 08, 2019 12:29 am

тоже не читатели (
Telegram | Блог
Raspberry Pi3, с образа от Сергея 3.31, PHP 7, флешка 16 Гб работает с 10.09.2017
Почти всё время уходит на исправление ошибок, оставшееся - на их повторение. (с) ))) Спасибо
Ответить