Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.4.1
-
None
-
RHEL 7 Linux with 48 cores 6TB SSD storage
Description
When loading a text data file I faced this issue intermittently that says a particular timestamp column has an invalid default value in the system catalog.
[root@mariadb02 data]# cpimport csdb t_master_cs t_master_trim.2m -s '|' |
Locale is : C
|
Using table OID 3783 as the default JOB ID |
Input file(s) will be read from : /mariadb/data
|
Job description file : /var/lib/columnstore/data/bulk/tmpjob/3783_D20200109_T000730_S069986_Job_3783.xml
|
2020-01-09 00:07:30 (67436) ERR : Error loading job file /var/lib/columnstore/data/bulk/tmpjob/3783_D20200109_T000730_S069986_Job_3783.xml; Column issue_date in table csdb.t_master_cs has an invalid default value in system catalog. [1154] |
Error in loading job information; An XML Parsing error; cpimport.bin is terminating.
|
The column is defined as `ISSUE_DATE timestamp(6) NOT NULL`
Rerunning the same cpimport script a second or a third-time always works successfully.