Timeline for Table partitioning on external directory hitting "can't create table" error
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 14, 2021 at 13:45 | vote | accept | WAX | ||
| Aug 12, 2021 at 13:55 | answer | added | WAX | timeline score: 1 | |
| Aug 12, 2021 at 13:53 | comment | added | WAX | Thanks @mustaccio for pointing me in the right direction. I realised one of the security policy was blocking mysqld from creating the mysql directories | |
| Aug 12, 2021 at 12:28 | comment | added | WAX | Indeed, there is something interesting on the mariaDB error logs: [ERROR] InnoDB: Operating system error number 13 in a file operation. [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. this is weird, given that I have already sudo chown the target directory to mysql: drwxr-xr-x. 2 mysql mysql 6 Aug 12 xx:xx mysql_p | |
| Aug 12, 2021 at 12:27 | comment | added | WAX | Hi Mustaccio, thanks for responding. I checked INFORMATION_SCHEMA.PLUGINS and the partition engine is enabled and active. | |
| Aug 12, 2021 at 12:22 | comment | added | mustaccio | Are there any interesting messages in the MariaDB error log? Is the partition engine enabled? | |
| Aug 12, 2021 at 12:16 | review | First posts | |||
| Aug 12, 2021 at 12:22 | |||||
| Aug 12, 2021 at 12:13 | history | asked | WAX | CC BY-SA 4.0 |