[MDEV-9285] Select count(*) on spider table gives wrong result Created: 2015-12-14  Updated: 2016-01-25  Resolved: 2016-01-25

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.0.21
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mauro Odino Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Spider node: mariadb 10.0.21, spider version 3.2.21, so windows server 2007
data nodes: mariadb 10.0.21, so RHEL 6.6


 Description   

I have a cluster with a master node running spider engine + 3 data nodes. I created a table (test_table)sharded on the three data nodes, with one (or more) secondary index. Running a select count(*) where ... from test_table on the spider node I have a result different from the sum of the same query executed directly on the three data nodes. Removing the secondary index from the table the query gives the right result.

 Comments   
Comment by Elena Stepanova [ 2015-12-28 ]

mauro.odino,

We'll need a lot more than this to find out what goes wrong.
Please provide the exact table definition on all nodes (master and data), the data that you insert into the table, configuration files from all nodes, the exact query that you are running, and the result of the query.

Thanks.

Generated at Thu Feb 08 07:33:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.