[MCOL-1136] Inconsistent engine typecode warning after upgrade from InfiniDB 4.x to MariaDB ColumnStore 1.1.3 Created: 2018-01-05  Updated: 2019-02-28  Resolved: 2018-01-31

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: 1.1.3
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Sasha V Assignee: Andrew Hutchings (Inactive)
Resolution: Fixed Votes: 0
Labels: Documentation
Environment:

Ubuntu 16 multi-server setup


Issue Links:
Relates
relates to MCOL-304 MariaDB ColumnStore Package Repository Closed
Sprint: 2018-01, 2018-02, 2018-03

 Description   

I upgraded multi-server system from InfiniDB 4.x to MariaDB ColumnStore 1.1.3 (from the Ubuntu16 repository Jan 2 build). Queries work, but log warnings in /usr/local/mariadb/columnstore/mysql/db/hostname.err
like

2018-01-05  0:45:51 139826582976256 [Warning] ./facts/solditems.frm is inconsistent: engine typecode 42, engine name InfiniDB (45)
2018-01-05  0:50:08 139826582976256 [Warning] ./dimensions/buyers.frm is inconsistent: engine typecode 42, engine name InfiniDB (45)
2018-01-05  0:50:08 139826582976256 [Warning] ./dimensions/sellers.frm is inconsistent: engine typecode 42, engine name InfiniDB (45)



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-01-05 ]

Hi Sasha,

How did you perform the upgrade? Did you follow the steps from here?: https://mariadb.com/kb/en/library/migrating-from-infinidb-4x-to-mariadb-columnstore/

Comment by Sasha V [ 2018-01-05 ]

No, I only did https://mariadb.com/kb/en/library/upgrade-from-infinidb-4x-to-mariadb-columnstore
Perhaps a link to the migration page should be added on the upgrade page.

Comment by Andrew Hutchings (Inactive) [ 2018-01-05 ]

Thanks for reporting. I've dug into this and the warnings are harmless. They are only fixable by editing the .frm files in a hex editor and changing the 4th byte from 2A to 2D which I would not recommend doing. We will update the documentation accordingly.

Comment by Andrew Hutchings (Inactive) [ 2018-01-31 ]

Added note to about the warning to: https://mariadb.com/kb/en/library/upgrade-from-infinidb-4x-to-mariadb-columnstore/

Comment by Zdravelina Sokolovska (Inactive) [ 2019-02-28 ]

Inconsistent engine typecode engine name Columnstore Warnings messages was observed on cs1.2.3 after upgrading from cs1.1.7
[Warning] ./*db_name/*table_name.frm is inconsistent: engine typecode 44, engine name Columnstore (45)

Generated at Thu Feb 08 02:26:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.