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

Can't create/write to file '/tmp/#sql_xxx_x.MAI' (Errcode: 2 "No such file or directory")

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 10.0.19-galera
    • Fix Version/s: N/A
    • Component/s: Galera
    • Labels:
    • Environment:
      Debian 8 / docker 1.5

      Description

      When doint a select, at a random time, the select returns Can't create/write to file '/tmp/#sql_16d_0.MAI' (Errcode: 2 "No such file or directory"), and if retried it returns a "normal" result.

      The issue occurs on 1 outta 3 master servers.

      The table structure is :

      > SHOW CREATE TABLE push;
      +-------+-------------+
      | Table | Create Table |
      +-------+-------------+
      | push  | CREATE TABLE `push` (
        `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
        `Token` varchar(200) DEFAULT NULL,
        `Visibility` int(11) DEFAULT '1',
        `BundleId` int(11) DEFAULT NULL,
        `Language` varchar(2) DEFAULT NULL,
        `Title` blob,
        `Content` blob,
        `isLocal` tinyint(1) DEFAULT '0',
        `Count` int(11) DEFAULT '0',
        `InstallId` int(11) DEFAULT NULL,
        `ReceiveDate` timestamp NULL DEFAULT NULL,
        PRIMARY KEY (`Id`),
        KEY `Token` (`Token`),
        KEY `bundle` (`InstallId`),
        KEY `visibility` (`Visibility`),
        KEY `ReceiveDate` (`ReceiveDate`),
        KEY `BundleId` (`BundleId`)
      ) ENGINE=InnoDB AUTO_INCREMENT=561491 DEFAULT CHARSET=utf8 |
      +-------+-------------+

      Cluster is stable :

      show status like "wsrep_clu%";
      +--------------------------+--------------------------------------+
      | Variable_name            | Value                                |
      +--------------------------+--------------------------------------+
      | wsrep_cluster_conf_id    | 194                                  |
      | wsrep_cluster_size       | 3                                    |
      | wsrep_cluster_state_uuid | d13c363c-e443-11e4-a1fc-6b0c6015d8c4 |
      | wsrep_cluster_status     | Primary                              |
      +--------------------------+--------------------------------------+

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ArnaudB. Arnaudb
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.