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

ALTER TABLE ADD COLUMN creates a column with incorrect width for a varchar columns.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.6, 1.2.2
    • 1.1.7
    • PrimProc
    • None
    • 2018-21

    Description

      There is a table used for ETL purposes, that is recreated on regular basis.
      Whilst processing select * from table limit 0,100, there was a failure:

      Apr 12 10:12:12 dbusa ExeMgr[74153]: 12.510096 |1855|0|0| D 16 CAL0041: Start SQL statement: select * from dbusa.table limit 0, 1000; |dbusa|
      Apr 12 10:12:16 dbusa PrimProc[74097]: 16.789519 |0|0|0| I 28 CAL0061: PrimProc error reading file for OID 8242; retry updateptrs for /usr/local/mariadb/columnstore/data1/000.dir/000.dir/032.dir/050.dir/000.dir/FILE000.cdf. rc=0, idx=4, ptr.size=4
      Apr 12 10:12:16 dbusa PrimProc[74097]: 16.793821 |0|0|0| C 28 CAL0000: Invalid Range from HWM for lbid 13379328, range size should be <= blocksReadAhead: HWM 2047, dbroot 1, highfbo 3071, lowfbo 2560, blocksReadAhead 512, range size -512
      Apr 12 10:12:16 dbusa ExeMgr[74153]: 16.802872 |1855|0|0| D 16 CAL0042: End SQL statement

      The problem presumably caused by a block saved by versioning but is absent in dbroot involved.

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              drrtuy Roman
              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.