I have a google cloud VM app using mariadb. The db is shutdown and not starting

kenny.o 2019-11-18 20:54:13 UTC #1

Keywords: MariaDB - Google Cloud Platform - Technical issue - Other
bnsupport ID: 744da798-cf8f-8673-9aaf-b99ef03d86d2
Description:
I have tried the following commands sudo /opt/bitnami/ctlscript.sh status mariadb result is mariadb not running.
Ran sudo /opt/bitnami/ctlscript.sh start mariadb i get the msg
mariadb could not be started. Further dig with
sudo systemctl status shows degraded, and sudo systemctl status bitnami.service

bitnami.service - LSB: bitnami init script
   Loaded: loaded (/etc/init.d/bitnami; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sun 2019-11-17 08:45:54 UTC; 1 day 4h ago
  Process: 19106 ExecStart=/etc/init.d/bitnami start (code=exited, status=3)
    Tasks: 7 (limit: 4915)
   CGroup: /system.slice/bitnami.service
           └─6117 /usr/bin/gonit

Dont know what to do to fix this. I dont have any backup copies of my db bot test and production.

tomasp 2019-11-19 11:06:03 UTC #2

Hi @kenny.o

According to MariaDB log there is an issue trying to init the tc.log

2019-11-18 20:50:23 140257888560640 [ERROR] Can't init tc log
2019-11-18 20:50:23 140257888560640 [ERROR] Aborting

Can you rename the current tc.log to see if MariaDB is able to create a new one?

sudo mv /opt/bitnami/mariadb/data/tc.log /opt/bitnami/mariadb/data/tc.log.old
sudo /opt/bitnami/ctlscript.sh start

I ran bench upgrade and have a server error with mariadb not starting

kenny.o 2019-11-20 11:12:49 UTC #3

Hello @tomasp
Thanks for the suggestion, i tried it and it worked. The database is running now but i still get the error SQL Error (2003) in statement #0: Can't connect to MySQL server on ip (10060)

tomasp 2019-11-21 09:26:23 UTC #4

Hi @kenny.o,

Where are you getting that error? Which application are you connecting to the database?
Can you re-run the bnsupport tool so we can check the updated configuration and logs?

system 2020-01-14 19:40:17 UTC #5

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

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!