https://bugzilla.novell.com/show_bug.cgi?id=852451 https://bugzilla.novell.com/show_bug.cgi?id=852451#c0 Summary: MySQL temporary directory deleted by systemd, causing MySQL errors Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: VMWare OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: archie@dellroad.org QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:25.0) Gecko/20100101 Firefox/25.0 I ran into this problem: $ mysqldump -u root magnolia > file.sql mysqldump: Error: 'Can't create/write to file '/var/tmp/mysql.qcB0v4/#sql_4ec5_2.MAI' (Errcode: 2)' when trying to dump tablespaces mysqldump: Couldn't execute 'show fields from `PM_CATEGORY_BINVAL`': Can't create/write to file '/var/tmp/mysql.qcB0v4/#sql_4ec5_0.MAI' (Errcode: 2) (1) This was weird and inexplicable. The answer finally came from stackoverflow.com: http://stackoverflow.com/a/14455782/263801 What's happening is that MySQL's temp folder in /var/tmp is getting deleted by the systemd temp file cleaner thing. Not 100% sure but I think the solution is to include the appropriate file under /usr/lib/tmpfiles.d/ in the mysql and mariadb packages. Reproducible: Always Steps to Reproduce: 1. Install and run mariadb on openSUSE 13.1 2. Wait a long time 3. Try to mysqldump any database Actual Results: mysqldump: Error: 'Can't create/write to file '/var/tmp/mysql.qcB0v4/#sql_4ec5_2.MAI' (Errcode: 2)' when trying to dump tablespaces mysqldump: Couldn't execute 'show fields from `PM_CATEGORY_BINVAL`': Can't create/write to file '/var/tmp/mysql.qcB0v4/#sql_4ec5_0.MAI' (Errcode: 2) (1) Expected Results: Successful dump. mariadb-5.5.32-1.12.1.x86_64 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.