Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0.19-galera
-
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 |
|
+--------------------------+--------------------------------------+
|