MySQL 5.5.30 update issue

TheVisitors

TheVisitors

Verified User
Joined
Mar 21, 2012
Messages
41
Location
Its my world, you all just live here
PHP: 
 ./build update_versions
rm: cannot remove `/usr/local/directadmin/custombuild/php-5.5.0alpha4': Is a directory
Updating MySQL.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
--2013-02-05 07:06:26--  http://files2.directadmin.com/services/all/mysql/debian/64-bit/mysql-5.5.30-linux2.6-x86_64.tar.gz
Resolving files2.directadmin.com... 69.30.193.202
Connecting to files2.directadmin.com|69.30.193.202|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 186641309 (178M) [application/x-gzip]
Saving to: `mysql-5.5.30-linux2.6-x86_64.tar.gz'

100%[===================================================================================================================>] 186,641,309 9.77M/s   in 19s

2013-02-05 07:06:45 (9.40 MB/s) - `mysql-5.5.30-linux2.6-x86_64.tar.gz' saved [186641309/186641309]

Stopping mysqld ...
Stopping mysqld:                [ OK ]
Starting mysqld:                [ OK ]
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
*** Linking libmysqlclient.so.16 to libmysqlclient.so.18
Restarting MySQL.
Stopping mysqld:                [ FAILED ]
Starting mysqld:                [ OK ]
rm: cannot remove `/usr/local/directadmin/custombuild/php-5.5.0alpha4': Is a directory

Do I thought yo update MySQL and got the following above issue.
 
Hello,

Why do you need php-5.5.0alpha4?

From what version did you upgrade MySQL?
 
zEitEr said:
Hello,

Why do you need php-5.5.0alpha4?

From what version did you upgrade MySQL?
Click to expand...

Not really using php 5.5 ... Have it installed as only as a 2nd option (not the default). Its there for production reasons (so we can follow it's progress in development and test compatibility for developing software).

That little error is harmless. It seem as if it wants to delete the temp extracted folder (that came from the zip) that it used to install it, but its full so it's using the wrong command. I guess we could delete it manually, but we've not gotten around to it.

Back on topic.....

MySQL was originally 5.5.29 (the one before this one).
 
Last edited:
I may have solved it. Not exactly sure as to why this worked, but it did.

I removed that temp folder php-5.5.0alpha4 and then decided to clear the mysql error logs. I cleared the logs as to get a fresh view of it (easier to read).

Ran this command

invoke-rc.d mysqld restart

Expecting everything to not start up and was going to read those logs (from a fresh point of view).... But....

Everything seems to be working. Rebooted the server, just to make sure everything would load fine (double check that it wasn't just good luck) and it did.

Huh? Linux is funny sometimes. lol

Resolved.
 
usr/local/mysql/data/server.err

Following those sim links brings you to here

/home/mysql/sever.err

Shows this in it at the moment. But all is working so I guess no worries?

PHP: 
130205 17:17:27 [Warning] IP address '180.215.205.213' could not be resolved: Name or service not known
130205 17:18:13 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

130205 17:18:13 [Note] Event Scheduler: Purging the queue. 0 events
130205 17:18:14  InnoDB: Starting shutdown...
130205 17:18:14  InnoDB: Shutdown completed; log sequence number 27477792
130205 17:18:14 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

130205 17:18:15 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.pid ended
130205 17:18:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
130205 17:18:19 [Note] Plugin 'FEDERATED' is disabled.
130205 17:18:19 InnoDB: The InnoDB memory heap is disabled
130205 17:18:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130205 17:18:19 InnoDB: Compressed tables use zlib 1.2.3
130205 17:18:19 InnoDB: Using Linux native AIO
130205 17:18:19 InnoDB: Initializing buffer pool, size = 128.0M
130205 17:18:19 InnoDB: Completed initialization of buffer pool
130205 17:18:19 InnoDB: highest supported file format is Barracuda.
130205 17:18:19  InnoDB: Waiting for the background threads to start
130205 17:18:20 InnoDB: 5.5.30 started; log sequence number 27477792
130205 17:18:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130205 17:18:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130205 17:18:20 [Note] Server socket created on IP: '0.0.0.0'.
130205 17:18:21 [Note] Event Scheduler: Loaded 0 events
130205 17:18:21 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.30'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130205 17:21:58 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

130205 17:21:59 [Note] Event Scheduler: Purging the queue. 0 events
130205 17:21:59  InnoDB: Starting shutdown...
130205 17:22:04  InnoDB: Shutdown completed; log sequence number 27482147
130205 17:22:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

130205 17:22:04 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.pid ended
130205 17:22:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
130205 17:22:20 [Note] Plugin 'FEDERATED' is disabled.
130205 17:22:20 InnoDB: The InnoDB memory heap is disabled
130205 17:22:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130205 17:22:20 InnoDB: Compressed tables use zlib 1.2.3
130205 17:22:20 InnoDB: Using Linux native AIO
130205 17:22:20 InnoDB: Initializing buffer pool, size = 128.0M
130205 17:22:20 InnoDB: Completed initialization of buffer pool
130205 17:22:20 InnoDB: highest supported file format is Barracuda.
130205 17:22:21  InnoDB: Waiting for the background threads to start
130205 17:22:22 InnoDB: 5.5.30 started; log sequence number 27482147
130205 17:22:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130205 17:22:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130205 17:22:22 [Note] Server socket created on IP: '0.0.0.0'.
130205 17:22:22 [Note] Event Scheduler: Loaded 0 events
130205 17:22:22 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.30'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
130205 17:25:41 [Warning] IP address '112.242.63.166' could not be resolved: Name or service not known
 
Last edited:
You must log in or register to reply here.
Back
Top