Article 5B7NP [SOLVED] MariaDB fails to start.

[SOLVED] MariaDB fails to start.

by
jmgibson1981
from LinuxQuestions.org on (#5B7NP)
I'm trying to build a fully self contained mythtv backend / mariadb in Docker, preferably with a single volume mounted. When I try to start the container I get this from attempting to start the Mariadb service. This log is from inside the Docker immediately when my service file fails on starting the sql server.

Code:# cat /var/log/syslog
Dec 4 04:19:32 mythtv rsyslogd: warning: ~ action is deprecated, consider using the 'stop' statement instead [v8.2001.0 try https://www.rsyslog.com/e/2307 ]
Dec 4 04:19:32 mythtv rsyslogd: message repeated 15 times: [warning: ~ action is deprecated, consider using the 'stop' statement instead [v8.2001.0 try https://www.rsyslog.com/e/2307 ]]
Dec 4 04:19:32 mythtv rsyslogd: imklog: cannot open kernel log (/proc/kmsg): Operation not permitted.
Dec 4 04:19:32 mythtv rsyslogd: activation of module imklog failed [v8.2001.0 try https://www.rsyslog.com/e/2145 ]
Dec 4 04:19:32 mythtv rsyslogd: rsyslogd's groupid changed to 108
Dec 4 04:19:32 mythtv rsyslogd: rsyslogd's userid changed to 106
Dec 4 04:19:32 mythtv rsyslogd: [origin software="rsyslogd" swVersion="8.2001.0" x-pid="18" x-info="https://www.rsyslog.com"] start
Dec 4 04:19:33 mythtv mysqld_safe: Starting mysqld daemon with databases from /var/lib/mythtv/sql
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 198 ...
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Using Linux native AIO
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Uses event mutexes
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Number of pools: 1
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Completed initialization of buffer pool
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: New log files created, LSN=44897
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Doublewrite buffer not found: creating new
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Doublewrite buffer created
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Creating foreign key constraint system tables.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Creating tablespace and datafile system tables.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Creating sys_virtual system tables.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: Waiting for purge to start
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] InnoDB: 10.3.25 started; log sequence number 0; transaction id 7
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 4 04:19:33 mythtv mysqld: 2020-12-04 4:19:33 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
Dec 4 04:19:33 mythtv mysqld_safe: mysqld from pid file /run/mysqld/mysqld.pid ended
Dec 4 04:20:03 mythtv /etc/init.d/mysql[517]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec 4 04:20:03 mythtv /etc/init.d/mysql[517]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Dec 4 04:20:03 mythtv /etc/init.d/mysql[517]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Dec 4 04:20:03 mythtv /etc/init.d/mysql[517]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Dec 4 04:20:03 mythtv /etc/init.d/mysql[517]:Mariadb starts just fine and everything works when I give sql it's own mounted host volume. Just trying to get everything in a single place. Linking my git so you can see what I'm working on.

https://github.com/jmgibson1981/scri...cker/mythtvsqllatest?d=yIl2AUoC8zA latest?i=nbCwqVPVXLY:V_xG27LkZ1U:F7zBnMy latest?i=nbCwqVPVXLY:V_xG27LkZ1U:V_sGLiP latest?d=qj6IDK7rITs latest?i=nbCwqVPVXLY:V_xG27LkZ1U:gIN9vFwnbCwqVPVXLY
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments