Hi, Since upgrading to 6.1.5 mysql will not start. I have no idea why at the mo.
Any help appreciated. I'm getting :
root@StudioReadyNAS:~# /etc/init.d/mysql start [....] Starting mysql (via systemctl): mysql.service Job failed. See system journal and 'systemctl status' for details. failed!
systemctl status says:
root@StudioReadyNAS:/var/lib/mysql# systemctl status mysqld.service mysqld.service Loaded: error (Reason: No such file or directory) Active: inactive (dead)
root@StudioReadyNAS:/lib/systemd/system# systemctl start mysqlr6 Failed to issue method call: Unit mysqlr6.service failed to load: No such file or directory. See system logs and 'systemctl status mysqlr6.service' for details. root@StudioReadyNAS:/lib/systemd/system# systemctl status mysqlr6.service mysqlr6.service Loaded: error (Reason: No such file or directory) Active: inactive (dead)
There is stuff in /var/lib/mysql :
root@StudioReadyNAS:/var/lib/mysql# ls -al total 61444 drwx------ 1 mysql mysql 290 Jan 2 11:56 . drwxr-xr-x 1 root root 324 Jan 2 10:54 .. drwx------ 1 mysql mysql 414 Nov 25 06:29 baika -rw-r--r-- 1 root root 0 Nov 24 21:02 debian-5.5.flag drwx------ 1 mysql mysql 30120 Nov 25 00:26 glpi -rw-rw---- 1 mysql mysql 52428800 Jan 2 11:56 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jan 2 11:56 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jan 2 11:56 ib_logfile1 drwx------ 1 mysql mysql 28 Dec 2 15:46 instaxmas drwx------ 1 mysql root 2094 Nov 24 21:02 mysql -rw------- 1 root root 6 Nov 24 21:02 mysql_upgrade_info drwx------ 1 mysql mysql 5926 Nov 24 23:58 orangehrm_mysql drwx------ 1 mysql mysql 868 Nov 24 21:02 performance_schema drwx------ 1 mysql mysql 96 Dec 2 18:27 Syslog drwx------ 1 mysql root 0 Nov 24 21:02 test drwx------ 1 mysql mysql 42 Dec 2 15:46 twitter_christmas
Ran journalctl while trying to start up mysql to see what I got. The IP of the machine has changed since the install of the app:
Jan 02 16:07:52 StudioReadyNAS mysqld_safe[13078]: Starting mysqld daemon with databases from /var/lib/mysql Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 [Note] Plugin 'FEDERATED' is disabled. Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: The InnoDB memory heap is disabled Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Compressed tables use zlib 1.2.7 Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Using Linux native AIO Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Initializing buffer pool, size = 128.0M Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Completed initialization of buffer pool Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: highest supported file format is Barracuda. Jan 02 16:07:52 StudioReadyNAS mysqld[13082]: 140102 16:07:52 InnoDB: Waiting for the background threads to start Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 InnoDB: 5.5.31 started; log sequence number 58284487 Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note] Server hostname (bind-address): '192.168.0.... 3306 Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note] - '192.168.0.23' resolves to '192.168.0.23'; Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [Note] Server socket created on IP: '192.168.0.23'. Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Can't start server: Bind on TCP/IP port: C...dress Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Do you already have another mysqld server ...306 ? Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 [ERROR] Aborting Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: Jan 02 16:07:53 StudioReadyNAS mysqld[13082]: 140102 16:07:53 InnoDB: Starting shutdown... Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: 140102 16:07:54 InnoDB: Shutdown completed; log sequence number 58284487 Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: 140102 16:07:54 [Note] /usr/sbin/mysqld: Shutdown complete Jan 02 16:07:54 StudioReadyNAS mysqld[13082]: Jan 02 16:07:54 StudioReadyNAS mysqld_safe[13129]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
It was on a reserved DHCP address but the DHCP server seems to have started giving the MAC address 192.168.0.30 instead of 192.168.0.23. I'm using both network interfaces in a bonded pair in adaptive load balancing mode.
I rebooted the DHCP server and renewed the DHCP lease and everything is back to normal - but why is the installation tied to the IP that was assigned at the time of installing the app?
One other question: MySQL doesn't seem to start automatically on a reboot - how do I get it to do that?
Super_Poussin, OUT-Freaking-Standing 😄 Please maintain your plan. I come from a Scottish background. and I cry every time I hear a rendition of "Amazing Grace" done on a cadre of bagpipes. The pipes seem to run in my blood. :oops:
