This is more a "fix" than an actual issue for those of you using MySQL Partitioning and are/have looking at upgrading MySQL.
The special case here is I partition the highly active tables in Zabbix to a seperate (SSD) partition using the DATA DIRECTORY= option.
I noticed this error in the logs when I try to (fortnightly) create database partitions :
"2015-11-10 09:32:34 7f6ae11777002015-11-10 09:32:34 23283 [ERROR] InnoDB: Failure of system call pwrite(). Operating system error number is 22.
InnoDB: Error number 22 means 'Invalid argument'."
A bit of googling and found this :
https://bugs.mysql.com/bug.php?id=79200
This is the culprit :
innodb_flush_method=O_DIRECT
Commented this out of my.cnf and restarted mysql and back to normal.
The special case here is I partition the highly active tables in Zabbix to a seperate (SSD) partition using the DATA DIRECTORY= option.
I noticed this error in the logs when I try to (fortnightly) create database partitions :
"2015-11-10 09:32:34 7f6ae11777002015-11-10 09:32:34 23283 [ERROR] InnoDB: Failure of system call pwrite(). Operating system error number is 22.
InnoDB: Error number 22 means 'Invalid argument'."
A bit of googling and found this :
https://bugs.mysql.com/bug.php?id=79200
This is the culprit :
innodb_flush_method=O_DIRECT
Commented this out of my.cnf and restarted mysql and back to normal.