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

ColumnStore breaks on S3 NFS mounts

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • N/A
    • 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

              Unassigned Unassigned
              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.