[#MCOL-977] Error getting OID for table XXX does not exist in Columnstore

Hello, we have production system running on Columnstore

We notes, that sometimes have in cpimport log next error:

Unable to set default JobID; Error getting OID for table r7.log_2017_10: IDB-2006: 'r7.log_2017_10' does not exist in Columnstore.

Locale is : C

Column delimiter : ;

but this table exists and not empty

MariaDB [r7]> select count(*) from log_2017_10;

+------------+

| count(*)   |

+------------+

| 1090616765 |

+------------+

create table query

CREATE TABLE `log_2017_10` (

  `FLOW_START` bigint(20) NOT NULL,

  `FLOW_END` bigint(20) NOT NULL,

  `IPV4_SRC_ADDR` bigint(20) NOT NULL,

  `L4_SRC_PORT` int(11) NOT NULL,

  `IPV4_DST_ADDR` bigint(20) NOT NULL,

  `L4_DST_PORT` int(11) NOT NULL,

  `HTTP_HOST` varchar(50) DEFAULT NULL,

  `HTTP_URL` varchar(255) DEFAULT NULL,

  `RADIUSLOGIN` varchar(100) DEFAULT NULL,

  `IPV6_SRC_ADDR` varchar(40) DEFAULT NULL,

  `IPV6_DST_ADDR` varchar(40) DEFAULT NULL,

  `OUT_BYTES` bigint(20) NOT NULL,

  `IN_BYTES` bigint(20) NOT NULL

) ENGINE=Columnstore DEFAULT CHARSET=latin1

after mcsadmin stopSystem/startSystem this error disappears. In maria system logs the same error. For this time found this error on 3 servers with the same env. System running since October 2016. Before restart tryed to run "Select * from log_2017_10 limit 1" and after 5 minutes stoped it by timeout. After restart this query takes 2 second. Any ideas?

[MCOL-977] Error getting OID for table XXX does not exist in Columnstore Created: 2017-10-16 Updated: 2022-11-05 Resolved: 2022-11-05
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	cpimport
Affects Version/s:	1.1.0
Fix Version/s:	Icebox

[MCOL-977] Error getting OID for table XXX does not exist in Columnstore Created: 2017-10-16 Updated: 2022-11-05 Resolved: 2022-11-05