Hey guys and gals,
I am having a strange issue with Cassandra SASI and I was hoping you could
help solve the mystery. My issue is inconsistency between returned results
and strange log errors.
The biggest issue is that when I perform a query I am getting back
inconsistent results. First few times I received between 3 and 7 results
and then I finally received 187 results. At no point in time did I change
the query statement. However, after I received the 187 results, any on
queries returned zero results.
my query:
SELECT *
FROM test.objects
WHERE mime LIKE 'ELF%';
When I look in the system.log file I see the following:
WARN [SharedPool-Worker-1] 2016-08-02 15:58:53,256
SelectStatement.java:351 - Aggregation query used without partition key
WARN [SharedPool-Worker-1] 2016-08-02 15:59:02,978
SelectStatement.java:351 - Aggregation query used without partition key
When I look in the debug.log file I see the following when zero results are
returned:
WARN [SharedPool-Worker-1] 2016-08-02 15:58:53,256
SelectStatement.java:351 - Aggregation query used without partition key
WARN [SharedPool-Worker-1] 2016-08-02 15:59:02,978
SelectStatement.java:351 - Aggregation query used without partition key
Additionally, I see a lot of errors in the log that state:
INFO [OptionalTasks:1] 2016-08-02 15:40:04,310 NoSpamLogger.java:91 -
Maximum memory usage reached (536870912 bytes), cannot allocate chunk of
1048576 bytes
INFO [OptionalTasks:1] 2016-08-02 15:55:04,387 NoSpamLogger.java:91 -
Maximum memory usage reached (536870912 bytes), cannot allocate chunk of
1048576 bytes
Any ideas?
