На виртуальной маышине Vbitrix 7.4.3 перенес каталог /var/lib/mysql на отдельный диск.
Перенос выполнялся по инструкции
После переноса mysql не запускается.
В файле /var/log/mysql/error.log повторяется такое содержимое
2020-05-24T21:28:46.833898Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-05-24T21:28:46.834241Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-05-24T21:28:47.012646Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-05-24T21:28:47.012760Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.012808Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30-33) starting as process 30056 ...
2020-05-24T21:28:47.015958Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.015973Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.023474Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-05-24T21:28:47.023535Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-24T21:28:47.023541Z 0 [Note] InnoDB: Uses event mutexes
2020-05-24T21:28:47.023546Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-05-24T21:28:47.023550Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-05-24T21:28:47.023554Z 0 [Note] InnoDB: Using Linux native AIO
2020-05-24T21:28:47.023820Z 0 [Note] InnoDB: Number of pools: 1
2020-05-24T21:28:47.023976Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-05-24T21:28:47.024450Z 0 [ERROR] InnoDB: Failed to create check sector file, errno:13 Please confirm O_DIRECT is supported and remove the file ./check_sector_size if it exists.
2020-05-24T21:28:47.026030Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-05-24T21:28:47.120422Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-24T21:28:47.143859Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-05-24T21:28:47.163366Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-05-24T21:28:47.164500Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-24T21:28:47.190009Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-05-24T21:28:47.190042Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-05-24T21:28:47.190066Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-05-24T21:28:47.190071Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-05-24T21:28:47.190078Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-05-24T21:28:52.299172Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-24T21:28:52.299251Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-24T21:28:52.299259Z 0 [ERROR] Failed to initialize builtin plugins.
2020-05-24T21:28:52.299267Z 0 [ERROR] Aborting
Причем, что странно 2 года назад выполнял то же самое на vmbitrix 7.3.1 там проблем не возникало.
Сравниваю настройки с той Vm вроде все одинаково настроено.
Содержимое fstab
LABEL=bxRoot / ext4 defaults,noatime 1 1
LABEL=bxBoot /boot ext4 defaults 1 2
LABEL=bxSwap swap swap defaults 0 0
UUID=1dce14ec-b0f2-44ac-8bd5-c380c17af5ea /var/lib/mysql ext4 defaults,noatime 1 1
Сравнил с работающей системой все одинаковое ( UUID дисков разные разумеется)
права у пользователя mysql есть.
Подключился из WinSCP. Попробовал записать под пользователем root создаю файлы в каталогах /var/lib/mysql, /var/lib/mysql/sitemanager проблем не возникает.
Как можно понять в чем проблема ?
Перенос выполнялся по инструкции
После переноса mysql не запускается.
В файле /var/log/mysql/error.log повторяется такое содержимое
2020-05-24T21:28:46.833898Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-05-24T21:28:46.834241Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-05-24T21:28:47.012646Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-05-24T21:28:47.012760Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.012808Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30-33) starting as process 30056 ...
2020-05-24T21:28:47.015958Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.015973Z 0 [Warning] Can't create test file /var/lib/mysql/server1.lower-test
2020-05-24T21:28:47.023474Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-05-24T21:28:47.023535Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-24T21:28:47.023541Z 0 [Note] InnoDB: Uses event mutexes
2020-05-24T21:28:47.023546Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-05-24T21:28:47.023550Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-05-24T21:28:47.023554Z 0 [Note] InnoDB: Using Linux native AIO
2020-05-24T21:28:47.023820Z 0 [Note] InnoDB: Number of pools: 1
2020-05-24T21:28:47.023976Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-05-24T21:28:47.024450Z 0 [ERROR] InnoDB: Failed to create check sector file, errno:13 Please confirm O_DIRECT is supported and remove the file ./check_sector_size if it exists.
2020-05-24T21:28:47.026030Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-05-24T21:28:47.120422Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-24T21:28:47.143859Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-05-24T21:28:47.163366Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-05-24T21:28:47.164500Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-24T21:28:47.190009Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-05-24T21:28:47.190042Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-05-24T21:28:47.190066Z 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-05-24T21:28:47.190071Z 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-05-24T21:28:47.190078Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-05-24T21:28:52.299172Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-24T21:28:52.299251Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-24T21:28:52.299259Z 0 [ERROR] Failed to initialize builtin plugins.
2020-05-24T21:28:52.299267Z 0 [ERROR] Aborting
Причем, что странно 2 года назад выполнял то же самое на vmbitrix 7.3.1 там проблем не возникало.
Сравниваю настройки с той Vm вроде все одинаково настроено.
Содержимое fstab
LABEL=bxRoot / ext4 defaults,noatime 1 1
LABEL=bxBoot /boot ext4 defaults 1 2
LABEL=bxSwap swap swap defaults 0 0
UUID=1dce14ec-b0f2-44ac-8bd5-c380c17af5ea /var/lib/mysql ext4 defaults,noatime 1 1
Сравнил с работающей системой все одинаковое ( UUID дисков разные разумеется)
права у пользователя mysql есть.
Подключился из WinSCP. Попробовал записать под пользователем root создаю файлы в каталогах /var/lib/mysql, /var/lib/mysql/sitemanager проблем не возникает.
Как можно понять в чем проблема ?