ERROR! after updating mysql 5.5 to 5.6

Dendiestdennis

Verified User
Joined
Mar 9, 2016
Messages
21
system information:
Apache 2.4.18
DirectAdmin 1.49.1
MySQL 5.6.29
Php 5.5.33

After updating Mysql with the following commands

cd /usr/local/directadmin/custombuild
./build set mysql 5.5
./build set mysql_inst mysql
./build set mysql_backup yes
./build update
./build mysql

I get the following errors....
Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/*******.***.*****.pid).
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
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.
ERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/*******.***.*****.pid).

Errors in /var/lib/mysql/*******.err


160309 12:02:03 mysqld_safe mysqld from pid file /var/lib/mysql/*****.******.pid ended
160309 12:02:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-03-09 12:02:09 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-03-09 12:02:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-09 12:02:09 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29-log) starting as process 2439 ...
2016-03-09 12:02:09 2439 [Note] Plugin 'FEDERATED' is disabled.
2016-03-09 12:02:09 2439 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-09 12:02:09 2439 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-09 12:02:09 2439 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-09 12:02:09 2439 [Note] InnoDB: Memory barrier is not used
2016-03-09 12:02:09 2439 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-09 12:02:09 2439 [Note] InnoDB: Using Linux native AIO
2016-03-09 12:02:09 2439 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-09 12:02:09 2439 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-09 12:02:09 2439 [Note] InnoDB: Completed initialization of buffer pool
2016-03-09 12:02:09 2439 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-09 12:02:09 2439 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-09 12:02:09 2439 [Note] InnoDB: Waiting for purge to start
2016-03-09 12:02:09 2439 [Note] InnoDB: 5.6.29 started; log sequence number 20034292
2016-03-09 12:02:09 2439 [ERROR] /usr/sbin/mysqld: unknown variable 'table_cache=1M'
2016-03-09 12:02:09 2439 [ERROR] Aborting

Seems there is something not compatible with Innodb but do not know what.....

Please help:confused:.
Regards,
 
my.cnf setting removed

zEitEr THX

i did not read the error file correctly.
I commented out the table_cache=1M variable in the my.cnf file, and mysql started perfectly.....
 
Back
Top