Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to upgrade from Mysql 8.0.15 to 8.0.16 - AWS Linux

Sarang Kanfade
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 20, 2019

We tried to upgrade percona mysql from existing percona 8.0.15.6 to 8.0.16.7 (latest available) on AWS Linux System, but after installing new binaries and while restarting the mysqld services it fails, due to upgrade failure which mysql tries to perform internally.

Below is the error message logged in mysql error log file.

2019-08-20T05:53:38.755233Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'CREATE TABLE IF NOT EXISTS general_log (event_time TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host MEDIUMTEXT NOT NULL, thread_id BIGINT(21) UNSIGNED NOT NULL, server_id INTEGER UNSIGNED NOT NULL, command_type VARCHAR(64) NOT NULL, argument MEDIUMBLOB NOT NULL) engine=CSV CHARACTER SET utf8 comment="General log";

2019-08-20T05:18:44.294209Z 4 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.

' failed with error code = 13, error message = 'Can't get stat of './mysql/general_log.CSV' (OS errno 13 - Permission denied)'.

 

We tried several options, but seems to be not working

1. Tried keeping general log disabled

2. SET General log output to table.

3. Granting full permission to MySQL linux user

For Temporary we started mysql service using below mysqld option

--upgrade= MINIMAL

Also after mysql restart we are still unable to query or access slow log and general log.

Please suggest if any fix available for above issue

 

 

0 answers

Suggest an answer

Log in or Sign up to answer