You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Naveen <na...@gmail.com> on 2017/12/11 12:49:28 UTC
Count mismatch for a cache between ignitevisor & Sqlline
Hi
AM using 2.3
Loaded 2 caches - Customer & Account with 10 million rows.
You can see the same from the below snippet, 2.5M avg * 4 -> 10M
visor> cache -e
Time of the snapshot: 12/11/17, 17:57:11
+===========================================================================================================================+
| Name(@) | Mode | Nodes | Entries (Heap / Off-heap)
| Hits | Misses | Reads | Writes |
+===========================================================================================================================+
| Account(@c0) | PARTITIONED | 4 | min: 0 (0 / 0)
| min: 0 | min: 0 | min: 0 | min: 0 |
| | | | avg: 2500000.25 (0.50 / 2499999.75)
| avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
| | | | max: 3475957 (1 / 3475956)
| max: 0 | max: 0 | max: 0 | max: 0 |
+---------------+-------------+-------+-------------------------------------+-----------+-----------+-----------+-----------+
| Customer(@c1) | PARTITIONED | 4 | min: 0 (0 / 0)
| min: 0 | min: 0 | min: 0 | min: 0 |
| | | | avg: 2499999.75 (0.00 / 2499999.75)
| avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
| | | | max: 3475956 (0 / 3475956)
| max: 0 | max: 0 | max: 0 | max: 0 |
+---------------------------------------------------------------------------------------------------------------------------+
Also, output of the REST API also shows 10M
http://10.144.114.115:8080/ignite?cmd=size&cacheName=Account
Resp:
{"successStatus":0,"affinityNodeId":null,"sessionToken":null,"error":null,"response":9999999}
[tibusr@JMNGD1BAQ10V04 bin]$ ./sqlline.sh --color=true --verbose=true -u
jdbc:ignite:thin://127.0.0.1
issuing: !connect jdbc:ignite:thin://127.0.0.1 '' ''
org.apache.ignite.IgniteJdbcThinDriver
Connecting to jdbc:ignite:thin://127.0.0.1
Connected to: Apache Ignite (version 2.3.0#20171028-sha1:8add7fd5)
Driver: Apache Ignite Thin JDBC Driver (version
2.3.0#20171028-sha1:8add7fd5)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.3.0
0: jdbc:ignite:thin://127.0.0.1> select count(*) from "Account".ACCOUNT;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 6671907 |
+--------------------------------+
1 row selected (105.706 seconds)
I have used AffinityKey to store the Account cache, but should not cause
this issue.
For other cache Customer, I could see 10M is cache size I could see properly
from all.
Also, where do I see the back up copies held by a node?
Thanks
Naveen
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Count mismatch for a cache between ignitevisor & Sqlline
Posted by afedotov <al...@gmail.com>.
Hi,
Could you please check, what result would produce a regular Ignite
SqlFieldsQuery?
Would it be the same result as for Sqlline?
Kind regards,
Alex
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/