The Ultimate Guide to High Availability with MariaDB

Comments - ERROR 1005 (HY000): Can't create table 'sphinx' (errno: 6 "No such device or address") when trying to create Sphinx proxy table

7 years, 1 month ago Dimitar Angelkov
Re: ERROR 1005 (HY000): Can't create table 'sphinx' (errno: 6 "No such device or address") when trying to create Sphinx proxy table

Here is the create table code:

CREATE TABLE IF NOT EXISTS `sphinx` ( `id` bigint(20) unsigned NOT NULL, `weight` int(11) NOT NULL, `query` varchar(2048) NOT NULL, `group_id` int(11) DEFAULT NULL ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx:127.0.0.1:9312/index';

 
6 years, 9 months ago Anthony
Re: ERROR 1005 (HY000): Can't create table 'sphinx' (errno: 6 "No such device or address") when trying to create Sphinx proxy table [Answer]

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.