Mariadb is stoped

Keywords: WordPress - AWS - Technical issue - Services (Apache, MariaDB, MySQL…)

bnsupport ID: 81140146-caae-82d1-8324-0fff206a821e

bndiagnostic output:

? Apache: Found possible issues
? Mariadb: Found possible issues
? Wordpress: Found possible issues
? Resources: Found possible issues
? Processes: Found possible issues
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-errors-apache/
https://docs.bitnami.com/bch/apps/moodle/troubleshooting/deny-connections-bots-apache/
https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/

bndiagnostic failure reason: "You can try to restart the process with the following command:

$ sudo /opt/bitnami/ctlscript.sh start mariadb", the suggestion doesn’t solve the problem.

Description:
I tried start but I can’t. I need dump file to transfer to other WordPress packaged by Bitnami 5.8.1-18.

Hello @helder_rangel,

The support tool was not able to gather mariadb logs. Could you please share with us the output of the following command?

tail -n 100 /opt/bitnami/mariadb/logs/mysqld.log

https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/

Regards

2021-10-01 15:03:51 41851 [Warning] Aborted connection 41851 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 15:03:51 41850 [Warning] Aborted connection 41850 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:42:47 43238 [Warning] Aborted connection 43238 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:42:47 43239 [Warning] Aborted connection 43239 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:42:48 43240 [Warning] Aborted connection 43240 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:42:48 43241 [Warning] Aborted connection 43241 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:42:48 43243 [Warning] Aborted connection 43243 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-01 21:51:39 43255 [Warning] Aborted connection 43255 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:04:54 45236 [Warning] Aborted connection 45236 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:04:54 45240 [Warning] Aborted connection 45240 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Can't create/write to file '/opt/bitnami/mariadb/tmp/#sql_53a_1.)
2021-10-02 11:08:28 45249 [Warning] Aborted connection 45249 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:40 45257 [Warning] Aborted connection 45257 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:40 45258 [Warning] Aborted connection 45258 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:40 45259 [Warning] Aborted connection 45259 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:40 45260 [Warning] Aborted connection 45260 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:40 45261 [Warning] Aborted connection 45261 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:08:41 45262 [Warning] Aborted connection 45262 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:18:27 45305 [Warning] Aborted connection 45305 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:18:27 45304 [Warning] Aborted connection 45304 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:22:16 45316 [Warning] Aborted connection 45316 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:22:16 45318 [Warning] Aborted connection 45318 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 11:22:17 45317 [Warning] Aborted connection 45317 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error writing communication packets)
2021-10-02 13:54:09 46553 [Warning] Aborted connection 46553 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 14:13:19 46563 [Warning] Aborted connection 46563 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 14:19:00 46586 [Warning] Aborted connection 46586 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 14:19:04 46588 [Warning] Aborted connection 46588 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error writing communication packets)
2021-10-02 14:19:08 46587 [Warning] Aborted connection 46587 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-02 14:19:16 46589 [Warning] Aborted connection 46589 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53390 [Warning] Aborted connection 53390 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53392 [Warning] Aborted connection 53392 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53391 [Warning] Aborted connection 53391 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53394 [Warning] Aborted connection 53394 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53396 [Warning] Aborted connection 53396 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53397 [Warning] Aborted connection 53397 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53398 [Warning] Aborted connection 53398 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:13 53399 [Warning] Aborted connection 53399 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:34:14 53393 [Warning] Aborted connection 53393 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error writing communication packets)
2021-10-04 12:40:23 53446 [Warning] Aborted connection 53446 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:43:35 53459 [Warning] Aborted connection 53459 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-04 12:51:12 53489 [Warning] Aborted connection 53489 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:24:52 62332 [Warning] Aborted connection 62332 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:24:55 62334 [Warning] Aborted connection 62334 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:24:55 62335 [Warning] Aborted connection 62335 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:24:56 62341 [Warning] Aborted connection 62341 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:25:49 62352 [Warning] Aborted connection 62352 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:28:22 62350 [Warning] Aborted connection 62350 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:28:22 62348 [Warning] Aborted connection 62348 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:28:22 62353 [Warning] Aborted connection 62353 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:37:42 62364 [Warning] Aborted connection 62364 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:37:42 62360 [Warning] Aborted connection 62360 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:37:42 62363 [Warning] Aborted connection 62363 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-07  2:37:43 62362 [Warning] Aborted connection 62362 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-09  2:59:18 72379 [Warning] Aborted connection 72379 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-09  2:59:18 72381 [Warning] Aborted connection 72381 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-09  2:59:18 72380 [Warning] Aborted connection 72380 to db: 'autentetica' user: 'bn_wordpress' host: 'localhost' (Got an error reading communication packets)
2021-10-09 13:47:45 74387 [Warning] Access denied for user 'bitnami'@'localhost' (using password: NO)
2021-10-09 13:48:58 74396 [Warning] Access denied for user 'bitnami'@'localhost' (using password: YES)
2021-10-09 13:52:03 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2021-10-09 13:52:03 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-10-09 13:52:03 0 [Note] InnoDB: FTS optimize thread exiting.
2021-10-09 13:52:03 0 [Note] InnoDB: Starting shutdown...
2021-10-09 13:52:03 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2021-10-09 13:52:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 211009 13:52:03
2021-10-09 13:52:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-10-09 13:52:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1163266092; transaction id 871560
2021-10-09 13:52:04 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete

Hi @helder_rangel,

Aborted connections happen because a connection was not closed properly. Can you try manually starting MariaDB by running the command below and letting us know the output you get?

/opt/bitnami/mariadb/bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --mysqld=mysqld --socket=/opt/bitnami/mariadb/tmp/mysql.sock  --datadir=/opt/bitnami/mariadb/data --log-error=/opt/bitnami/mariadb/logs/mysqld.log  --pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid --lower-case-table-names=1
bitnami@ip-172-31-8-34:~$ /opt/bitnami/mariadb/bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --mysqld=mysqld --socket=/opt/bitnami/mariadb/tmp/mysql.sock  --datadir=/opt/bitnami/mariadb/data --log-error=/opt/bitnami/mariadb/logs/mysqld.log  --pid-file=/opt/bitnami/mariadb/tmp/mysqld.pid --lower-case-table-names=1
211013 11:20:56 mysqld_safe Logging to '/opt/bitnami/mariadb/logs/mysqld.log'.
211013 11:20:56 mysqld_safe Starting mysqld daemon with databases from /opt/bitnami/mariadb/data

++++

bitnami@ip-172-31-8-34:~$ sudo /opt/bitnami/ctlscript.sh status mariadb
Cannot find any running daemon to contact. If it is running, make sure you are pointing to the right pid file (/var/run/gonit.pid)
bitnami@ip-172-31-8-34:~$ sudo gonit
Starting gonit daemon
bitnami@ip-172-31-8-34:~$ sudo /opt/bitnami/ctlscript.sh status apache
apache already running
bitnami@ip-172-31-8-34:~$ sudo /opt/bitnami/ctlscript.sh status mariadb
mariadb not running
bitnami@ip-172-31-8-34:~$

Hello @helder_rangel,

There seem to be some permissions errors:

sudo chown mysql:mysql /opt/bitnami/mysql/tmp
sudo chown mysql:mysql /opt/bitnami/mysql/logs
sudo chmod 777 /opt/bitnami/mysql/tmp
sudo chmod g+w /opt/bitnami/mysql/tmp/mysql.sock

Could you please try these commands and then try to run it again? If you face an issue, provide us again with all the info (new support tool code ID and separately commands output, the content of /opt/bitnami/mariadb/logs/mysqld.log …)

I hope it helps

Perfect. Thank’s a lot.

I chaged permissions directory to mariadb, same user and group.
sudo chown mysql:mysql /opt/bitnami/mysql/tmp

sudo chown mysql:mysql /opt/bitnami/mysql/logs

sudo chmod 777 /opt/bitnami/mariadbl/tmp

sudo chmod g+w /opt/bitnami/mariadb/tmp/mysql.sock

Hi @helder_rangel,

Do you still receive the same error when trying to start the database service after modifying the permissions? What’s the output of these commands?

sudo gonit
sudo gonit status
sudo /opt/bitnami/ctlscript.sh status

Thanks