[ERROR] Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored #2803

Closed
opened 2026-02-05 05:15:13 +03:00 by OVERLORD · 2 comments
Owner

Originally created by @abensimon86 on GitHub (May 19, 2022).

Attempted Debugging

  • I have read the debugging page

Searched GitHub Issues

  • I have searched GitHub for the issue.

Describe the Scenario

I ran BookStack via Azure AppService - docker-compose

Everything worked very well for three weeks, and this morning, I got DB errors; nothing was changed

Need help to solve this issue

Exact BookStack Version

v22.04

Log Content

Log Content
/appsvctmp/volatile/logs/runtime/d7d02f3fe07852a88a6e119136e9d20f145d0356378d927011a6599cc2ad154e.log
2022-05-19T07:03:57.585982034Z: [INFO]  220519 08:03:57 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'.

2022-05-19T07:03:57.705999904Z: [INFO]  220519 08:03:57 mysqld_safe Starting mariadbd daemon with databases from /config/databases

2022-05-19T07:04:31.185524243Z: [ERROR]  Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored

2022-05-19T07:04:31.191516952Z: [ERROR]  Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored

2022-05-19T07:04:31.222684599Z: [INFO]  220519 08:04:31 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'.

2022-05-19T07:04:31.294065906Z: [INFO]  220519 08:04:31 mysqld_safe Starting mariadbd daemon with databases from /config/databases

2022-05-19T07:05:04.600761687Z: [ERROR]  Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored

2022-05-19T07:05:04.609398996Z: [ERROR]  Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored

2022-05-19T07:05:04.647087037Z: [INFO]  220519 08:05:04 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'.

2022-05-19T07:05:04.721104315Z: [INFO]  220519 08:05:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases

PHP Version

No response

Hosting Environment

docker-compose

If I download the db .err file :

Log Content
220509 07:09:38 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored
2022-05-09  7:09:38 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB) starting as process 413 ...
2022-05-09  7:09:39 0 [ERROR] mariadbd: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-05-09  7:10:09 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/config/databases/aria_log_control'
2022-05-09  7:10:09 0 [ERROR] Plugin 'Aria' init function returned error.
2022-05-09  7:10:09 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-05-09  7:10:09 0 [Note] InnoDB: Uses event mutexes
2022-05-09  7:10:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-09  7:10:09 0 [Note] InnoDB: Number of pools: 1
2022-05-09  7:10:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-09  7:10:09 0 [Note] InnoDB: Using Linux native AIO
2022-05-09  7:10:09 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-05-09  7:10:09 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-09  7:10:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2628390,2628390
2022-05-09  7:10:09 0 [Note] InnoDB: 128 rollback segments are active.
2022-05-09  7:10:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-05-09  7:10:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-09  7:10:10 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2022-05-09  7:10:10 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2022-05-09  7:10:10 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-05-09  7:10:10 0 [ERROR] InnoDB: File ./ibtmp1: 'open' returned OS error 71. Cannot continue operation
220509  7:10:10 [ERROR] mysqld got signal 6 ;
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.5.15-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467872 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...
Cannot determine thread, fp=0x6, backtrace may not be correct.
Bogus stack limit or frame pointer, fp=0x6, stack_bottom=0x7ffc48070000, thread_stack=299008, aborting backtrace.
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /config/databases
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            8388608              unlimited            bytes     
Max core file size        unlimited            unlimited            bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             unlimited            unlimited            processes 
Max open files            1048576              1048576              files     
Max locked memory         67108864             67108864             bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       13582                13582                signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us        
Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E

220509 07:10:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
220509 07:10:11 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored
2022-05-09  7:10:11 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB) starting as process 512 ...
2022-05-09  7:10:11 0 [ERROR] mariadbd: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2022-05-09  7:10:37 0 [ERROR] mariadbd: Can't seek in file '/config/databases/aria_log_control' (Errcode: 19 "No such device")
2022-05-09  7:10:37 0 [ERROR] mariadbd: Got error 'Can't read size' when trying to use aria control file '/config/databases/aria_log_control'
2022-05-09  7:10:37 0 [ERROR] Plugin 'Aria' init function returned error.
2022-05-09  7:10:37 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-05-09  7:10:37 0 [ERROR] InnoDB: Operating system error number 19 in a file operation.
2022-05-09  7:10:37 0 [ERROR] InnoDB: Error number 19 means 'No such device'
2022-05-09  7:10:37 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-05-09  7:10:37 0 [ERROR] InnoDB: File ./ibdata1: 'stat' returned OS error 219.
2022-05-09  7:10:38 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions
2022-05-09  7:10:38 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-05-09  7:10:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-05-09  7:10:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-09  7:10:38 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-05-09  7:10:38 0 [ERROR] Failed to initialize plugins.
2022-05-09  7:10:38 0 [ERROR] Aborting
Originally created by @abensimon86 on GitHub (May 19, 2022). ### Attempted Debugging - [X] I have read the debugging page ### Searched GitHub Issues - [X] I have searched GitHub for the issue. ### Describe the Scenario I ran BookStack via Azure AppService - docker-compose Everything worked very well for three weeks, and this morning, I got DB errors; nothing was changed Need help to solve this issue ### Exact BookStack Version v22.04 ### Log Content <details> <summary>Log Content</summary> ``` /appsvctmp/volatile/logs/runtime/d7d02f3fe07852a88a6e119136e9d20f145d0356378d927011a6599cc2ad154e.log 2022-05-19T07:03:57.585982034Z: [INFO] 220519 08:03:57 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'. 2022-05-19T07:03:57.705999904Z: [INFO] 220519 08:03:57 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-05-19T07:04:31.185524243Z: [ERROR] Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-19T07:04:31.191516952Z: [ERROR] Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-19T07:04:31.222684599Z: [INFO] 220519 08:04:31 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'. 2022-05-19T07:04:31.294065906Z: [INFO] 220519 08:04:31 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2022-05-19T07:05:04.600761687Z: [ERROR] Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-19T07:05:04.609398996Z: [ERROR] Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-19T07:05:04.647087037Z: [INFO] 220519 08:05:04 mysqld_safe Logging to '/config/databases/d7d02f3fe078.err'. 2022-05-19T07:05:04.721104315Z: [INFO] 220519 08:05:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases ``` </details> ### PHP Version _No response_ ### Hosting Environment docker-compose If I download the db .err file : <details> <summary>Log Content</summary> ``` 220509 07:09:38 mysqld_safe Starting mariadbd daemon with databases from /config/databases Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-09 7:09:38 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB) starting as process 413 ... 2022-05-09 7:09:39 0 [ERROR] mariadbd: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2022-05-09 7:10:09 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/config/databases/aria_log_control' 2022-05-09 7:10:09 0 [ERROR] Plugin 'Aria' init function returned error. 2022-05-09 7:10:09 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2022-05-09 7:10:09 0 [Note] InnoDB: Uses event mutexes 2022-05-09 7:10:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-09 7:10:09 0 [Note] InnoDB: Number of pools: 1 2022-05-09 7:10:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-05-09 7:10:09 0 [Note] InnoDB: Using Linux native AIO 2022-05-09 7:10:09 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-05-09 7:10:09 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-09 7:10:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2628390,2628390 2022-05-09 7:10:09 0 [Note] InnoDB: 128 rollback segments are active. 2022-05-09 7:10:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-05-09 7:10:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-09 7:10:10 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2022-05-09 7:10:10 0 [ERROR] InnoDB: The error means the system cannot find the path specified. 2022-05-09 7:10:10 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them. 2022-05-09 7:10:10 0 [ERROR] InnoDB: File ./ibtmp1: 'open' returned OS error 71. Cannot continue operation 220509 7:10:10 [ERROR] mysqld got signal 6 ; 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.5.15-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467872 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... Cannot determine thread, fp=0x6, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0x6, stack_bottom=0x7ffc48070000, thread_stack=299008, aborting backtrace. The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /config/databases Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size unlimited unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 1048576 1048576 files Max locked memory 67108864 67108864 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 13582 13582 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E 220509 07:10:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 220509 07:10:11 mysqld_safe Starting mariadbd daemon with databases from /config/databases Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored 2022-05-09 7:10:11 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB) starting as process 512 ... 2022-05-09 7:10:11 0 [ERROR] mariadbd: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2022-05-09 7:10:37 0 [ERROR] mariadbd: Can't seek in file '/config/databases/aria_log_control' (Errcode: 19 "No such device") 2022-05-09 7:10:37 0 [ERROR] mariadbd: Got error 'Can't read size' when trying to use aria control file '/config/databases/aria_log_control' 2022-05-09 7:10:37 0 [ERROR] Plugin 'Aria' init function returned error. 2022-05-09 7:10:37 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2022-05-09 7:10:37 0 [ERROR] InnoDB: Operating system error number 19 in a file operation. 2022-05-09 7:10:37 0 [ERROR] InnoDB: Error number 19 means 'No such device' 2022-05-09 7:10:37 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/ 2022-05-09 7:10:37 0 [ERROR] InnoDB: File ./ibdata1: 'stat' returned OS error 219. 2022-05-09 7:10:38 0 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions 2022-05-09 7:10:38 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-05-09 7:10:38 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-05-09 7:10:38 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-09 7:10:38 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded 2022-05-09 7:10:38 0 [ERROR] Failed to initialize plugins. 2022-05-09 7:10:38 0 [ERROR] Aborting ``` </details>
OVERLORD added the 🐕 Support label 2026-02-05 05:15:13 +03:00
Author
Owner

@ssddanbrown commented on GitHub (May 19, 2022):

Hi @abensimon86,

This appears to be a general mariadb/docker/azure issue rather than something specific to BookStack or the code/app we provide. What appservices are you using? Is the docker-compose setup managed by yourself?

@ssddanbrown commented on GitHub (May 19, 2022): Hi @abensimon86, This appears to be a general mariadb/docker/azure issue rather than something specific to BookStack or the code/app we provide. What appservices are you using? Is the docker-compose setup managed by yourself?
Author
Owner

@ssddanbrown commented on GitHub (May 29, 2022):

Since there's been no follow-up I'm going to close this. If the issue remains and is something you still require to be fixed respond to my previous comment and this can then be re-opened.

@ssddanbrown commented on GitHub (May 29, 2022): Since there's been no follow-up I'm going to close this. If the issue remains and is something you still require to be fixed respond to my previous comment and this can then be re-opened.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#2803