maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Kevin!

When did it start?

Did you, for example, upgrade from 10.3.13 to 10.3.14 and then noticed
it? (I'm not saying this is a known bug in 10.3.14, it was just an example)

What filesystem is it?

And, don't forget, if it looks like a bug to you, report it at
jira.mariadb.org to get it fixed

On Aug 07, Kevin DG wrote:
> Hello all,
> 
> MariaDB version -> 10.3.14
> 
> Recently, we had a new problem with our MariaDB instance. Indeed,
> suddenly the size of the tmp directory has increased almost
> instantaneously, to finish saturating the disk.
> 
> We have encountered this problem twice and don't understand currently the
> problem origin.
> 
> The result of 'ls -l /tmp' during the problem:
> 
> mysql@16c212e7dbb5:/tmp# ls -l
> total 126786988
> -rw-rw---- 1 mysql mysql 14190428160 Jul  8 15:18 '#sql_1_1.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_1.MAI'
> -rw-rw---- 1 mysql mysql 13344178176 Jul  8 15:18 '#sql_1_11.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_11.MAI'
> -rw-rw---- 1 mysql mysql 13344546816 Jul  8 15:18 '#sql_1_14.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_14.MAI'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:18 '#sql_1_2.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:18 '#sql_1_2.MAI'
> -rw-rw---- 1 mysql mysql 12613459968 Jul  8 15:20 '#sql_1_25.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:03 '#sql_1_25.MAI'
> -rw-rw---- 1 mysql mysql 12221440000 Jul  8 15:20 '#sql_1_26.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:03 '#sql_1_26.MAI'
> -rw-rw---- 1 mysql mysql 12220719104 Jul  8 15:20 '#sql_1_29.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:03 '#sql_1_29.MAI'
> -rw-rw---- 1 mysql mysql 12220907520 Jul  8 15:20 '#sql_1_36.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:03 '#sql_1_36.MAI'
> -rw-rw---- 1 mysql mysql 14190247936 Jul  8 15:18 '#sql_1_4.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_4.MAI'
> -rw-rw---- 1 mysql mysql 12220588032 Jul  8 15:18 '#sql_1_47.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:03 '#sql_1_47.MAI'
> -rw-rw---- 1 mysql mysql 13350912000 Jul  8 15:18 '#sql_1_6.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_6.MAI'
> 
> 
> We failed to identify the origin of this behaviour.
> 
> Does anyone know what can trigger this behavior ? We also failed to find a
> configuration paramater to avoid and limit the size of these files, any
> ideas about that ?
> 
> Thanks for your help,

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx