Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.0
-
None
-
debian 8.7
Description
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?