MariaDB mysqldump may fail on Red Hat Enterprise Linux 7 when process name-space directory is removed
Issue
- We ran into this problem with one of our RHEL 7 boxes with MariaDB on top:
# mysqldump -u root -p foobar > file.sql
Enter password:
mysqldump: Error: 'Can't create/write to file '/var/tmp/#sql_6b9b_2.MAI' (Errcode: 2)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `foobar_blabla`': Can't create/write to file '/var/tmp/#sql_6b9b_0.MAI' (Errcode: 2) (1)
- What is the cause for this issue and how we avoid the same?
Environment
- Red Hat Enterprise Linux 7 (RHEL)
- MariaDB
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.