Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5905

Creating tmp. memory table kills the server

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.36, 10.0.9
    • Fix Version/s: 5.5.37, 10.0.10
    • Component/s: None
    • Labels:
    • Environment:
      FC 20, Tokudb installed from binary distribution found on tokudb website

      Description

      Version: 5.5.36-tokudb-7.1.5-MariaDB-log
      Don't know if that's the right bugtracker to submit it, as now we're trying mariadb with toku enabled.

      It seems that's data or structure dependent, if i do SELECT `domain` instead of `id` it won't crash. Also when i switch to other table, and do SELECT `id` it won't crash.

      Table:

      CREATE TABLE `raw_stats_lookup` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `network_id` tinyint(11) NOT NULL,
        `creative_id` int(11) NOT NULL,
        `domain` varchar(90) NOT NULL,
        `__last_used` date NOT NULL,
        PRIMARY KEY (`id`),
        UNIQUE KEY `_uk` (`domain`,`network_id`,`creative_id`) USING BTREE,
        KEY `creative_id` (`creative_id`)
      ) ENGINE=Aria AUTO_INCREMENT=763772 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=0 TRANSACTIONAL=0;

      After issuing this query the DB is killed

      CREATE TEMPORARY TABLE ___tmp_raw_stats_lookup ENGINE=MEMORY
          SELECT id
          FROM `stats`.raw_stats_lookup
          WHERE domain = 'x.com'

      I made some other steps:

      • duplicated the table and switched the engine to innodb (crashing again)
      • moved the table to another server (just the table, not all data), same hardware and settings (keeps crashing)
      • changed the ENGINE=MEMORY to ENGINE=MYISAM => no crash
      • moved the data to machine with normal mariadb (5.5.35-MariaDB-log) - it WONT crash

      For DB dump please contact me on email if you like to see, sorry, there's some domain data so don't want to share in public. pslawek83 !a-t! o2.pl ... if you want to look into this (in dump it said to report errors to you).

      Attaching dump...

      BTW: We had problems with making mariadb with toku running on FC20, compilation error then we compiled using mysql_release (instead of Release) but we ended up with debug version. Anything you can suggest that's tested? (OS + compile? OS + binary?)

      Thanks everyone as always

        Attachments

        1. mysql-dump.txt
          2 kB
        2. version .34 - dead completely.txt
          5 kB
        3. version .34 - restarted.txt
          6 kB
        4. version .35 - restarted.txt
          5 kB
        5. _testing44.sql
          110 kB
        6. mdev5905.test
          109 kB

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              pslawek83 Slawomir Pryczek
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: