[MCOL-1613] CLONE - Data missing after upgrade from 1.0.11 - 1.0.14 Created: 2018-07-30 Updated: 2019-07-10 Resolved: 2019-07-10 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | DDLProc, MariaDB Server, PrimProc |
| Affects Version/s: | 1.0.14 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | Abhinav santi | Assignee: | Unassigned |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Environment: |
AWS AMI, 4PMs, 1 UM Centos. c8.xlarge |
||
| Description |
|
Hello, I recently upgraded MCOL from 1.0.11 - 14 and after the upgrade some of the table's are truncated. When dug deeper, I found that tables without comment 'schema sync only' are missing data. I dropped and recreated the tables with comment schema sync only option but after the creation all the queries throw Error code 1815 internal error IDB-2006 TABLE DOESNOT EXISTS IN COLUMNSTORE . Thanks in Advance |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2018-07-31 ] |
|
We would have needed to see a support report generated when you hit the problem to determine the cause, my guess is some of your PM nodes did not come up correctly. Unfortunately it is unlikely we will be able to do this if you have dropped the tables. When you create a table with "schema sync only" it only creates the metadata for the table in MariaDB server, it does not create the table in ColumnStore's engine. This is usually used internally to syncronize schemas between ColumnStore UM nodes. |