Bitnami Shopware production down - MySql not running

Dear Bitnami,

Our Bitnami Shopware stack is broken :frowning:
mysql is suddenly not willing to start after a reboot.

  • Which version of the application are you using?:
    Bitnami Shopware 6.1.5-1

  • Please choose how you got the application: Installer (Windows, Linux, macOS), cloud image (AWS, GCE, Azure, …) or VM (VMDK, VBOX):
    AWS cloud image

  • Describe here your question/suggestion/issue (expected and actual results):

/opt/btinami/mysql/data/mysqld.log: open for read: permission denied

  • Copy the apache log (if relevant):
[Wed Sep 09 18:12:09.659663 2020] [proxy_fcgi:error] [pid 1803:tid 140511281125120] [client 15.177.58.34:42016] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught RuntimeException: Could not connect to database. Message from SQL Server: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory in /opt/bitnami/apps/shopware/htdocs/vendor/shopware/core/HttpKernel.php:83\nStack trace:\n#0 /opt/bitnami/apps/shopware/htdocs/public/index.php(83): Shopware\\Core\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))\n#1 {main}\n  thrown in /opt/bitnami/apps/shopware/htdocs/vendor/shopware/core/HttpKernel.php on line 83'

bitnami@ip-172-31-XX-81:~$ sudo /opt/bitnami/ctlscript.sh restart mysql
Unmonitored mysql
/opt/bitnami/mysql/scripts/ctl.sh : mysql not running
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
Monitored mysql

What can we do?

bitnami@ip-172-31-XX-81:~$ sudo /opt/bitnami/ctlscript.sh start
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
/opt/bitnami/php/scripts/ctl.sh : php-fpm (pid 19871) already running
Syntax OK
/opt/bitnami/apache2/scripts/ctl.sh : httpd (pid 19878) already running
bitnami@ip-172-31-40-81:~$ sudo /opt/bitnami/mysql/bin/mysqld_safe
2020-09-10T22:33:06.198310Z mysqld_safe Logging to ‘/opt/bitnami/mysql/data/ip-172-31-40-81.err’.
2020-09-10T22:33:06.216507Z mysqld_safe Starting mysqld daemon with databases from /opt/bitnami/mysql/data
2020-09-10T22:33:07.230467Z mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-172-31-40-81.pid ended

Hi @rietveldt,

We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please execute it on the machine where the stack is running by following the steps described in the guide below?

Please note that you need to paste the code ID that is shown at the end.

Regards,
Michiel

1 Like

Thank you for your response!

c362a1c2-c7b1-e799-d3af-a7f1df86272f

WKR

Hi,

From the Bitnami support tool information, I saw this in the MySQL’s log

2020-09-09T20:46:47.356341Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 7340032, 1048576 bytes should have been written, only 647168 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2020-09-09T20:46:47.357388Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
2020-09-09T20:46:47.359523Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space
2020-09-09T20:46:47.360583Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary.
2020-09-09T20:46:47.361658Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2020-09-09T20:46:47.579365Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-09-09T20:46:47.580562Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-09T20:46:47.582899Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-09T20:46:47.583421Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-09-10T08:41:29.897599Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2020-09-10T08:41:29.897731Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld.bin (mysqld 8.0.18) starting as process 16417

It seems you ran into a disk space issue. However, it seems you already resolved that but there is not any new entry in the MySQL’s log regarding a new start. Did you try to start the server again?

sudo /opt/bitnami/ctlscript.sh start

If the database can’t be started, let’s try to recover the permissions configuration

1 Like

Thank you! MYSQL is running now :slight_smile:

But now I still face an 500 internal server error.,

With systemctl I see the bitnami.service failed to start.

Sep 16 22:10:22 ip-172-31-40-81 bitnami[13066]: ## 2020-09-16 22:10:22+00:00 ## INFO ## Running /opt/bitnami/va
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: ## 2020-09-16 22:14:34+00:00 ## INFO ## Running /opt/bitnami/va
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: ## 2020-09-16 22:14:34+00:00 ## INFO ## Running /opt/bitnami/va
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: ## 2020-09-16 22:14:34+00:00 ## INFO ## Running /opt/bitnami/va
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: daemon with PID 2376 awakened
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: Cannot find check with id php-fpm
Sep 16 22:14:34 ip-172-31-40-81 bitnami[13066]: ## 2020-09-16 22:14:34+00:00 ## INFO ## Running /opt/bitnami/va
Sep 16 22:14:34 ip-172-31-40-81 systemd[1]: bitnami.service: Control process exited, code=exited, status=3/NOTI
Sep 16 22:14:34 ip-172-31-40-81 systemd[1]: bitnami.service: Failed with result ‘exit-code’.
Sep 16 22:14:34 ip-172-31-40-81 systemd[1]: Failed to start LSB: bitnami init script.

Ok @rietveld,

Let’s take a look at the Apache’s log now to see if there are more information there

tail -n 50 /opt/bitnami/apache2/logs/error_log

Thanks

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.