ERROR 1005 (HY000): Can't create table 'sphinx' (errno: 6 "No such device or address") when trying to create Sphinx proxy table
Any idea where is the problem?
Using MariaDB 10.1.21 and Sphinx 2.2.11
Answer Answered by Anthony in this comment.
This may relative to 32 bit dump file to 64 bit machine, or the other way around. I got the same error when load a dump file from 32 bit machines to a 64 bit machine, need to modify the dump file's create sphinx part from `id` int(11) NOT NULL, to `id` BIGINT UNSIGNED NOT NULL, then it load correctly without error.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
