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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.1
    • Fix Version/s: Icebox
    • Component/s: cpimport
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            Faisal Faisal Saeed
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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