Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3717

cpimport fails intermittently with "invalid default value in system catalog"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.4.1
    • Icebox
    • cpimport
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Faisal Faisal Saeed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.