nuxsmin
commented
5 years ago Hello, why did you notice MariaDB is stopped?. This message tells that is running:
syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] mysqld: ready for connections.
Please note that applications in Docker containers run in another way, so some usual commands won't display the current state of the application.
sysPass Version 3.1.0
Describe the question I problems that the MariadB won't start. If I log in to the db-container and try /etc/init.d/mysql start all I get is fail.
Also, running: /etc/init.d/mysql status Results in * MariaDB is stopped.
There are no files in the /var/log/mysql directory.
Screenshots If applicable, add screenshots to help explain your problem.
Platform (please complete the following information):
Additional context These are the logs from when initializing the DB: syspass-db | MySQL init process in progress... syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] mysqld (mysqld 10.2.26-MariaDB-1:10.2.26+maria~bionic) starting as process 105 ... syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Uses event mutexes syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Compressed tables use zlib 1.2.11 syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Using Linux native AIO syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Number of pools: 1 syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Using SSE2 crc32 instructions syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Completed initialization of buffer pool syspass-db | 2019-09-12 17:00:05 140714267793152 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Highest supported file format is Barracuda. syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: 128 out of 128 rollback segments are active. syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Creating shared tablespace for temporary tables syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: File './ibtmp1' size is now 12 MB. syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] InnoDB: 5.7.27 started; log sequence number 1619987 syspass-db | 2019-09-12 17:00:05 140713966679808 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool syspass-db | 2019-09-12 17:00:05 140713966679808 [Note] InnoDB: Buffer pool(s) load completed at 190912 17:00:05 syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] Plugin 'FEEDBACK' is disabled. syspass-db | 2019-09-12 17:00:05 140714989835584 [Warning] 'user' entry 'root@45a312d00d0d' ignored in --skip-name-resolve mode. syspass-db | 2019-09-12 17:00:05 140714989835584 [Warning] 'proxies_priv' entry '@% root@45a312d00d0d' ignored in --skip-name-resolve mode. syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] Reading of all Master_info entries succeeded syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] Added new Master_info '' to hash table syspass-db | 2019-09-12 17:00:05 140714989835584 [Note] mysqld: ready for connections. syspass-db | Version: '10.2.26-MariaDB-1:10.2.26+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution syspass-db | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. syspass-db | 2019-09-12 17:00:12 140714806019840 [Warning] 'proxies_priv' entry '@% root@45a312d00d0d' ignored in --skip-name-resolve mode. syspass-db | syspass-db | 2019-09-12 17:00:12 140714206791424 [Note] mysqld (initiated by: unknown): Normal shutdown syspass-db | 2019-09-12 17:00:12 140714206791424 [Note] Event Scheduler: Purging the queue. 0 events syspass-db | 2019-09-12 17:00:12 140714215184128 [Note] InnoDB: FTS optimize thread exiting. syspass-db | 2019-09-12 17:00:12 140714206791424 [Note] InnoDB: Starting shutdown... syspass-db | 2019-09-12 17:00:12 140713966679808 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool syspass-db | 2019-09-12 17:00:12 140713966679808 [Note] InnoDB: Buffer pool(s) dump completed at 190912 17:00:12 syspass-db | 2019-09-12 17:00:13 140714206791424 [Note] InnoDB: Shutdown completed; log sequence number 1620015 syspass-db | 2019-09-12 17:00:13 140714206791424 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" syspass-db | 2019-09-12 17:00:13 140714206791424 [Note] mysqld: Shutdown complete syspass-db | syspass-db | syspass-db | MySQL init process done. Ready for start up. syspass-db | syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] mysqld (mysqld 10.2.26-MariaDB-1:10.2.26+maria~bionic) starting as process 1 ... syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Uses event mutexes syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Compressed tables use zlib 1.2.11 syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Using Linux native AIO syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Number of pools: 1 syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Using SSE2 crc32 instructions syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Completed initialization of buffer pool syspass-db | 2019-09-12 17:00:13 140586520360704 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). syspass-db | 2019-09-12 17:00:13 140587249276224 [Note] InnoDB: Highest supported file format is Barracuda. syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] InnoDB: 128 out of 128 rollback segments are active. syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] InnoDB: Creating shared tablespace for temporary tables syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] InnoDB: File './ibtmp1' size is now 12 MB. syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] InnoDB: 5.7.27 started; log sequence number 1620015 syspass-db | 2019-09-12 17:00:14 140586283689728 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] Plugin 'FEEDBACK' is disabled. syspass-db | 2019-09-12 17:00:14 140586283689728 [Note] InnoDB: Buffer pool(s) load completed at 190912 17:00:14 syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] Server socket created on IP: '::'. syspass-db | 2019-09-12 17:00:14 140587249276224 [Warning] 'proxies_priv' entry '@% root@45a312d00d0d' ignored in --skip-name-resolve mode. syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] Reading of all Master_info entries succeeded syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] Added new Master_info '' to hash table syspass-db | 2019-09-12 17:00:14 140587249276224 [Note] mysqld: ready for connections. syspass-db | Version: '10.2.26-MariaDB-1:10.2.26+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution