Hi!
I am trying out the new instructions of “Running Bahmni on Docker” article but I am not able to make it work yet.
OpenMRS fails to start because the MySQL server fails to start.
I have tried all the troubleshooting steps for this with no luck.
[root@e8000e4ce70e /]# service mysqld status
mysqld dead but subsys locked
[root@e8000e4ce70e /]# rm /var/lock/subsys/mysqld
[root@e8000e4ce70e /]# service mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@e8000e4ce70e /]# chown -R mysql:mysql /var/lib/mysql
[root@e8000e4ce70e /]# service mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
[root@8267fd400da9 tmp]# ./db_startup_script.sh
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
And the “innodb_force_recovery=1” as well.
Here is the server log /var/log/mysqld.log (nothing changes in this file between reboots of the server, in fact the dates in the log are dated from the first container creation)
[root@8267fd400da9 /]# cat /var/log/mysqld.log
2017-12-07 23:12:56 1493 [Note] Plugin 'FEDERATED' is disabled.
2017-12-07 23:12:56 1493 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-07 23:12:56 1493 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-07 23:12:56 1493 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-07 23:12:56 1493 [Note] InnoDB: Memory barrier is not used
2017-12-07 23:12:56 1493 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-07 23:12:56 1493 [Note] InnoDB: Using Linux native AIO
2017-12-07 23:12:56 1493 [Note] InnoDB: Using CPU crc32 instructions
2017-12-07 23:12:56 1493 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-07 23:12:56 1493 [Note] InnoDB: Completed initialization of buffer pool
2017-12-07 23:12:56 1493 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-07 23:12:56 1493 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-07 23:12:56 1493 [Note] InnoDB: Waiting for purge to start
2017-12-07 23:12:56 1493 [Note] InnoDB: 5.6.38 started; log sequence number 1625987
2017-12-07 23:12:56 1493 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0f1d87c9-db76-11e7-af42-0242ac110002.
2017-12-07 23:12:56 1493 [Note] Server hostname (bind-address): '*'; port: 3306
2017-12-07 23:12:56 1493 [Note] IPv6 is available.
2017-12-07 23:12:56 1493 [Note] - '::' resolves to '::';
2017-12-07 23:12:56 1493 [Note] Server socket created on IP: '::'.
2017-12-07 23:12:56 1493 [Note] Event Scheduler: Loaded 0 events
2017-12-07 23:12:56 1493 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
@angshuonline maybe you have info on this?