Can't upgrade MySQL after update to Custombuild 2 .pid file missing

C

csgo

Verified User
Joined
Feb 29, 2012
Messages
47
I updated to Custombuild 2 and all went fine other than MySQL would not start. I get a MySQL server PID file could not be found! When I check /var/lib/mysql/ there is no .pid file. I had do downgrade all the way back to MySQL 5.1 to get MySQL to run (and has a .pid file).

When I do an ./build update_versions I get the following error as well:
Updating phpMyAdmin.
phpMyAdmin 4.2.7.1-all-languages requires MySQL 5.5+, but 5.1.73 is installed
Dropping phpMyAdmin version down to 4.0.10.2

Anyone have any insight how to resolve this issue?

Thanks in advance!

-Joe
 
Please check MySQL error log in /var/lib/mysql/*err. That must have been caused by incompatible settings in /etc/my.cnf.
 
Here is what I see in SSH:

Stopping mysqld ...
Shutting down MySQL... [ OK ]
Upgrading MySQL 5.1 to 5.5
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [ 25%]
2:MySQL-server ########################################### [ 50%]
3:MySQL-devel ########################################### [ 75%]
4:MySQL-client ########################################### [100%]
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/redacted.pid). [FAILED]
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.

Here is the error log:

140819 12:00:01 mysqld_safe mysqld from pid file /var/lib/mysql/redacted.pid ended
140819 12:00:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140819 12:00:16 [Note] Plugin 'FEDERATED' is disabled.
140819 12:00:16 InnoDB: The InnoDB memory heap is disabled
140819 12:00:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140819 12:00:16 InnoDB: Compressed tables use zlib 1.2.3
140819 12:00:16 InnoDB: Using Linux native AIO
140819 12:00:16 InnoDB: Initializing buffer pool, size = 128.0M
140819 12:00:16 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
140819 12:00:16 [ERROR] Plugin 'InnoDB' init function returned error.
140819 12:00:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140819 12:00:16 [ERROR] Unknown/unsupported storage engine: InnoDB
140819 12:00:16 [ERROR] Aborting

140819 12:00:16 [Note] /usr/sbin/mysqld: Shutdown complete

140819 12:00:16 mysqld_safe mysqld from pid file /var/lib/mysql/redacted.pid ended

Hope this helps!

Thanks,
-Joe
 
FYI, this is a dedicated server with 16GB RAM and plenty of disk space. Very low loads.

-Joe
 
I checked the contents of /etc/my.cnf and here's all that's in the file:

[mysqld]
local-infile=0
bind-address = 127.0.0.1
query_cache_size = 8M
thread_cache_size = 4
table_cache = 500
 
Your error states:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!

It doesn't like innodb log file size.

Adding line:
innodb_log_file_size = 50331648
to /etc/my.cnf would fix that error.
 
csgo said:
FYI, this is a dedicated server with 16GB RAM and plenty of disk space. Very low loads.
Click to expand...

You should choose another Directadmin mirror with:

Code: 
cd /usr/local/directadmin/custombuild
./build set_fastest


to make fetching of files even quicker.
 
You must log in or register to reply here.
Back
Top