Hi there,
my bitnami moodle has been running stable for a few weeks now on an amazon t1.micro instance. After trying to use moodle with a big class (27 users) the mysql-db crashed. That happened before, but a server restart fixed everything. Not this time.
Moodle still can´t connect to the database and I also can´t restart mysql with ./ctlscript.sh start mysql I´ll get the error message:
111113 13:10:33 mysqld_safe Logging to '/opt/bitnami/mysql/data/mysqld.log'.
111113 13:10:33 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111113 13:10:38 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-2 28-27-28.pid ended
/opt/bitnami/mysql/scripts/ctl.sh : mysql could not be started
Here´s the mysql-error-log:
File: mysqld.log Line 324 Col 0 24880 bytes 100%
Killed
111111 12:41:40 mysqld_safe Number of processes running now: 0
111111 12:41:56 mysqld_safe mysqld restarted
111111 12:42:40 [Note] Plugin 'FEDERATED' is disabled.
111111 12:42:40 InnoDB: Initializing buffer pool, size = 8.0M
111111 12:42:40 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 209083665
111111 12:42:40 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 209087217
111111 12:42:41 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 4
6 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
99
InnoDB: Apply batch completed
111111 12:42:41 InnoDB: Started; log sequence number 0 209087217
111111 12:42:42 [Note] Event Scheduler: Loaded 0 events
111111 12:42:42 [Note] /opt/bitnami/mysql/bin/mysqld.bin: ready for connections.
Version: '5.1.56' socket: '/opt/bitnami/mysql/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
111112 20:56:43 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111112 20:56:43 [Note] Plugin 'FEDERATED' is disabled.
111112 20:56:43 InnoDB: Initializing buffer pool, size = 8.0M
111112 20:56:43 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111112 20:56:43 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
111112 20:56:44 InnoDB: Started; log sequence number 0 209087415
111112 20:56:44 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111112 20:56:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111112 20:56:44 [ERROR] Aborting
111112 20:56:44 InnoDB: Starting shutdown...
111112 20:56:49 InnoDB: Shutdown completed; log sequence number 0 209087415
111112 20:56:49 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111112 20:56:49 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111112 21:16:50 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111112 21:16:50 [Note] Plugin 'FEDERATED' is disabled.
111112 21:16:50 InnoDB: Initializing buffer pool, size = 8.0M
111112 21:16:50 InnoDB: Completed initialization of buffer pool
111112 21:16:50 InnoDB: Started; log sequence number 0 209087415
111112 21:16:50 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111112 21:16:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111112 21:16:50 [ERROR] Aborting
111112 21:16:50 InnoDB: Starting shutdown...
111112 21:16:56 InnoDB: Shutdown completed; log sequence number 0 209087415
111112 21:16:56 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111112 21:16:56 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111112 21:35:52 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111112 21:35:52 [Note] Plugin 'FEDERATED' is disabled.
111112 21:35:52 InnoDB: Initializing buffer pool, size = 8.0M
111112 21:38:36 InnoDB: Shutdown completed; log sequence number 0 209087415
111112 21:38:36 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111112 21:38:36 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111112 21:46:01 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111112 21:46:01 [Note] Plugin 'FEDERATED' is disabled.
111112 21:46:01 InnoDB: Initializing buffer pool, size = 8.0M
111112 21:46:01 InnoDB: Completed initialization of buffer pool
111112 21:46:01 InnoDB: Started; log sequence number 0 209087415
111112 21:46:01 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111112 21:46:01 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111112 21:46:01 [ERROR] Aborting
111112 21:46:01 InnoDB: Starting shutdown...
111112 21:46:06 InnoDB: Shutdown completed; log sequence number 0 209087415
111112 21:46:06 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111112 21:46:06 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111112 22:05:04 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111112 22:05:04 [Note] Plugin 'FEDERATED' is disabled.
111112 22:05:04 InnoDB: Initializing buffer pool, size = 8.0M
111112 22:05:04 InnoDB: Completed initialization of buffer pool
111112 22:05:04 InnoDB: Started; log sequence number 0 209087415
111112 22:05:04 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111112 22:05:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111112 22:05:04 [ERROR] Aborting
111112 22:05:04 InnoDB: Starting shutdown...
111112 22:05:09 InnoDB: Shutdown completed; log sequence number 0 209087415
111112 22:05:09 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111112 22:05:09 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111113 02:54:31 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111113 2:54:31 [Note] Plugin 'FEDERATED' is disabled.
111113 2:54:31 InnoDB: Initializing buffer pool, size = 8.0M
111113 2:54:31 InnoDB: Completed initialization of buffer pool
111113 2:54:32 InnoDB: Started; log sequence number 0 209087415
111113 2:54:32 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111113 2:54:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111113 2:54:32 [ERROR] Aborting
111113 2:54:32 InnoDB: Starting shutdown...
111113 2:54:37 InnoDB: Shutdown completed; log sequence number 0 209087415
111113 2:54:37 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111113 02:54:37 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended
111113 13:10:33 mysqld_safe Starting mysqld.bin daemon with databases from /opt/bitnami/mysql/data
111113 13:10:33 [Note] Plugin 'FEDERATED' is disabled.
111113 13:10:33 InnoDB: Initializing buffer pool, size = 8.0M
111113 13:10:33 InnoDB: Completed initialization of buffer pool
111113 13:10:33 InnoDB: Started; log sequence number 0 209087415
111113 13:10:33 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
111113 13:10:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111113 13:10:33 [ERROR] Aborting
111113 13:10:33 InnoDB: Starting shutdown...
111113 13:10:38 InnoDB: Shutdown completed; log sequence number 0 209087415
111113 13:10:38 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete
111113 13:10:38 mysqld_safe mysqld from pid file /opt/bitnami/mysql/data/ip-10-228-27-28.pid ended