[MDEV-11032] mysql_upgrade fails after upgrade to 10.1.18-1 Created: 2016-10-11 Updated: 2016-10-12 Resolved: 2016-10-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients |
| Affects Version/s: | 10.1.18 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Elliot Johnson | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | upgrade | ||
| Environment: |
CentOS 7 MariaDB: 10.1.18-MariaDB MariaDB Server |
||
| Description |
|
Hello, I have just upgraded our MariaDB server 10.1.17 to 10.1.18 and routinely ran the mysql_upgrade script. I am receiving the following: " I have tried:
Regardless of these actions, I still get a failed upgrade result. Can't say I've ever seen this before following previous MariaDB upgrades. |
| Comments |
| Comment by Elena Stepanova [ 2016-10-11 ] | ||||||
|
This is very strange that general_log.CSV and slow_log.CSV did not exist, do you know how it happened? Did somebody remove them manually?
It should work unless somebody previously tried to convert general_log and slow_log tables into InnoDB, in this case things can be a bit more complicated. | ||||||
| Comment by Elliot Johnson [ 2016-10-12 ] | ||||||
|
Hi, Thanks for the response. There's only myself who manages the MariaDB service on this server (or who even has root access), so I don't suspect any one else has been messing around - i.e.: trying to convert to InnoDB. My MariaDB configuration has slow_query_log and general_log disabled, so should these files even exist anyway? We would only enable them for troubleshooting (this is a Magento production server). I will try and move the files you mentioned to /tmp/ and observe the outcome. Regards, Elliot | ||||||
| Comment by Elliot Johnson [ 2016-10-12 ] | ||||||
|
Hello again, I moved the following files to /tmp/: and flushed the tables as per your suggestion and the mysql_upgrade went through fine. Yipee! Obviously this doesn't look like a bug then, but more to do with something weird at my end regarding the existence of the *.CSV files. Thank you very much for your time and assistance. Best Regards, Elliot | ||||||
| Comment by Elliot Johnson [ 2016-10-12 ] | ||||||
|
Heh, feeling like a bit of an idiot, but how do I close this ticket/issue now? Thank you! Elliot | ||||||
| Comment by Elena Stepanova [ 2016-10-12 ] | ||||||
|
Closing is our duty, don't worry about that. So, if you notice that the files disappeared again without your doing anything for it, please feel free to comment on this issue (it will be possible even after closing) or to create a new one. | ||||||
| Comment by Elliot Johnson [ 2016-10-12 ] | ||||||
|
Okay, cool. Well I can confirm that the three general_log.* and slow_log.* files now exist on my system, so I will keep an eye on them. Thank you. Best Regards, Elliot |