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

ColumnStore breaks on S3 NFS mounts

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None

      Description

      When running the query:

      MariaDB [tradealert]> SELECT sio.`id` AS option_id, o.`date` AS market_date, o.`time`, o.`size`, o.`price`, o.`spot`, o.open_int, o.theo, o.ivol, o.delta, o.vega, o.theta, o.`secid` FROM onelots AS o LEFT JOIN securities_occ AS so ON o.secid = so.secid LEFT JOIN dds_main.`sec_instrument_option` AS sio ON so.`occ_identifier` = sio.`occ_identifier` WHERE o.date = '2018-01-19' limit 10;

      and this is what I got back:

      ERROR 1815 (HY000): Internal error: IDB-2039: Data file does not exist, please contact your system administrator for more information.
      I expected this amount of records to come back (well only 10 as I limited it but at least they would travel from PM to UM and I would know that it is OK):

      MariaDB [tradealert]> SELECT count(1) FROM onelots AS o LEFT JOIN securities_occ AS so ON o.secid = so.secid LEFT JOIN dds_main.`sec_instrument_option` AS sio ON so.`occ_identifier` = sio.`occ_identifier` WHERE o.date = '2018-01-19';
      ----------

      count(1)

      ----------

      1501056

      ----------
      1 row in set (3.22 sec)

      In the stretch of all market dates of Q1 2018 it happened on Jan 19., Feb 5., Feb. 21. and from Mar 5. all the way through Mar 29. All other queries for all other days in this stretch (across the Q1) returned valid and full resultsets.

      Attached is zipped support report file.

      We also ran redistributeData but there was not much to distribute because of the configuration. So it ran for 10 ms and it did not help.
      after that we created 2 extra DBROOTS and then re-run redistributeData - this time successfully but it did not help resolving an issue.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              madamec Martin Adamec
              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.