[MDEV-19920] Mysql_upgrade fails, table is corrupted Created: 2019-07-01 Updated: 2019-09-02 Resolved: 2019-09-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | David Tran | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Windows 7 64 bit |
||
| Description |
|
I have a mariaDB, version 10.2.6-MariaDB mariadb.org binary distribution, with a table that is corrupted. It's useless data to me, so I've tried to drop the schema but it won't drop. Instead, it gives me this error when trying to drop it: "Error Code: 1805. Column count of mysql.proc is wrong. Expected 20, found 21. The table is probably corrupted." I've read on here that I should try to run a mysql_upgrade to fix this issue. But this also has failed when I point to the MariaDB bin directory and run this command line: C:\Program Files\MariaDB 10.2\bin>mysql_upgrade --force -h localhost -uroot -p - Phase 1/7: Checking and upgrading mysql database |
| Comments |
| Comment by Elena Stepanova [ 2019-07-30 ] |
|
"Expected 20, found 21" suggests you downgraded from a different major version. Downgrade is never guaranteed to work and rarely does. That said, it's unclear why dropping a table would require mysql.proc. Can you paste the unabridged output from DROP TABLE comment in the client, and attach your error log? |