[MDEV-23302] Restore of database from MariaDB 10.3.17 to MariaDB 10.2.22 fails Created: 2020-07-27 Updated: 2020-07-27 Resolved: 2020-07-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Update |
| Affects Version/s: | 10.2.22, 10.3.17 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Abhishek | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
MariaDB 10.3.17 was installed on RHEL 8.2, x86, 64 bit system |
||
| Issue Links: |
|
||||||||
| Description |
|
Backup was taken on 10.3.17 MariaDB - copied /var/lib/mysql directory Restarted mariadb db service using the below command, This method of backup/restore of mariadb databases worked in our product. But in this particular scenario we see that once the mariadb service is restarted, the table updates fail. Below are the logs & other information. ----------------------------------------------------------------------------------------------- in index `local_user_id` of table `keystone`.`password` is greater than the global counter 6661! The table is corrupted. To report this bug, see https://mariadb.com/kb/en/reporting-bugs MariaDB [(none)]> CHECK TABLE keystone.password;
------------------
------------------ One more thing which was observed was is frequent connection errors. |
| Comments |
| Comment by Elena Stepanova [ 2020-07-27 ] |
|
Downgrade between major versions is not supported and almost never works even by luck. Downgrade between minor versions isn't guaranteed to work, either. |