MySQL Forums
Forum List  »  General

Re: mysqld upgrade=FORCE with error code = 1136, error message = 'Column count doesn't match value count at row 1'
Posted by: Susan Koerner
Date: October 29, 2019 07:34AM

Hi Rob -

Yes, you are using the binaries that I indicated, but, it seems that the server already progressed far enough through the upgrade process and the datadir believes that it is 8.0.18. If you had removed columns from the users table, the internal upgrade process could have fixed that. If you added columns, then you would get the scenario and failure that you see.

One suggestion is to try start the server using the 8.0.18 binaries using both --upgrade=minimal and --skip-grant-tables. This should make the server start without ACL. Once started, you could cleanup the user table, and restart the server to complete the upgrade. You may want to check other tables in the mysql schema to be sure that there were no other manual changes.

I hope that this helps -


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.