[CONJ-169] MariaDB RT data insert/update with MVA fields Created: 2015-07-21  Updated: 2017-03-30  Resolved: 2017-03-30

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Nagaraju Movva Assignee: Diego Dupin
Resolution: Incomplete Votes: 0
Labels: Sphinx


 Description   

I have create one rt table in MariaDB. data not geting inserted in MariaDB. Same query is
running fine in sphinxQL.

Please help me in this issue for MariaDB RT data insert/update.

CREATE TABLE `rt1` (
`id` BIGINT UNSIGNED NOT NULL,
`title` VARCHAR(100) NOT NULL,
`content` VARCHAR(5000) NOT NULL,
`gid` INT UNSIGNED,
`skills` BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=SPHINX CONNECTION='sphinxql://192.168.2.10:9306/rt1';

Query: INSERT INTO rt1 (id,title,content, gid ) VALUES (40,'sales', 'sales
manager','(2,3)')

Error Code: 1430
There was a problem processing the query on the foreign data source. Data source error:
row 1, column 5: non-MVA value specified for a MVA column

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.060 sec
---------------------------------------------------

MySQL [(none)]> INSERT INTO rt1 (id,title,content,skills ) VALUES (40,'sales', 'sales
manager',(2,3));
Query OK, 1 row affected (0.00 sec)

MySQL [(none)]> select * from rt1;
----------------------------------

id gid title content skills

----------------------------------

40 0 sales sales manager 2,3

----------------------------------
1 row in set (0.00 sec)

MySQL [(none)]>

 Comments   
Comment by Diego Dupin [ 2015-07-21 ]

I'm no expert in sphinxQL, but could you please provide the sphinx configuration to permit to reproduce the problem ?
specifically the "sql_attr_multi" configurations.

Comment by Nagaraju Movva [ 2015-07-21 ]

Hi Diego,

Thanks for your replay. please check over sphinx config file with real time (RT index) & DESCRIBE rt table structure.
#sphinx.conf
index rt
{
type = rt
path = /var/lib/sphinx/rt
dict = keywords
rt_field = title
rt_field = content
rt_attr_string = title
rt_attr_string = content
rt_attr_uint = gid
rt_attr_multi = skills
}

searchd
{
listen = 9312
listen = 9306:mysql41
log = /var/log/sphinx/searchd.log
query_log = /var/log/sphinx/query.log
read_timeout = 5
max_children = 30
pid_file = /var/run/sphinx/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
binlog_path = /var/lib/sphinx/
}

-------------------------------------------------------------------------

MySQL [(none)]> desc rt;
---------------+

Field Type

---------------+

id bigint
title field
content field
gid uint
title string
content string
skills mva

---------------+
7 rows in set (0.01 sec)

Comment by Vladislav Vaintroub [ 2015-07-28 ]

Nagaraju Movva, you queries are different. On the command line you have no quotes around (2,3), in JDBC you passing a string '(2,3)' .

Comment by Diego Dupin [ 2017-03-30 ]

closing since no answer

Generated at Thu Feb 08 03:13:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.