Details
-
Bug
-
Resolution: Fixed
-
Critical
-
7.6.0, 7.2.1, 7.2.2
-
7.6.0-1568
-
Triaged
-
0
-
Unknown
-
KV 2023-4
Description
Steps To Recreate:
- Create a 2 node cluster
- Create a magma bucket(bucket_name = travel-sample, bucket_ram_quota=300MB)
- Load few documents
- Run below queries
1) SELECT COUNT(*) FROM `travel-sample`
2) SELECT * FROM system:indexes WHERE indexes.bucket_id is missing
3) SELECT * FROM system:indexes where name='def_primary'
4) select raw name from system:indexes WHERE indexes.bucket_id is missing
5) SELECT ADVISOR({'action':'list'}) as List
6) SELECT ADVISOR({'action':'purge', 'session':'0e070045-3fb3-4db7-bb86-7745ad69645f'}) as Purge
7) SELECT ADVISOR({'action':'purge', 'session':'62c88dc9-e131-4697-9f89-968746079aa0'}) as Purge
8) SELECT * FROM system:indexes WHERE indexes.bucket_id is missing
9) SELECT * FROM system:keyspaces WHERE keyspaces.`bucket` is missing
10) SELECT COUNT(*) FROM `travel-sample`
11) SELECT ADVISOR("SELECT airportname FROM `travel-sample` WERE type = \"airport\"") as Advisor
- Observed below errors in memcached logs
Below error was found on node 172.23.109.60
Memcached Logs:
ERROR 9263: Exception occurred during DCP step(). Closing connection [ {"ip":"172.23.109.60","port":54482} - {"ip":"172.23.109.60","port":11210} (System, @projector) ]: Monotonic<m> (ActiveStream(eq_dcpq:secidx:proj-INIT_STREAM_TOPIC_0dcc0ce7dad4cbd476f442baa974a588-9490838748024550633/0 (vb:868))::curChkSeqno) invariant failed: new value (83) breaks invariant on current value (86). Cookies: [] Exception thrown from: ["#0 /opt/couchbase/bin/memcached() [0x400000+0x13aeee]","#1 /opt/couchbase/bin/memcached() [0x400000+0x5ba904]","#2 /opt/couchbase/bin/memcached() [0x400000+0x5bb0d1]","#3 /opt/couchbase/bin/memcached() [0x400000+0x5c16da]","#4 /opt/couchbase/bin/memcached() [0x400000+0x5bf79c]","#5 /opt/couchbase/bin/memcached() [0x400000+0x5c624d]","#6 /opt/couchbase/bin/memcached() [0x400000+0x4accf7]","#7 /opt/couchbase/bin/memcached() [0x400000+0x4ad94c]","#8 /opt/couchbase/bin/memcached() [0x400000+0x3372fd]","#9 /opt/couchbase/bin/memcached() [0x400000+0x20767b]","#10 /opt/couchbase/bin/memcached() [0x400000+0x20a2f0]","#11 /opt/couchbase/bin/memcached() [0x400000+0x214397]","#12 /opt/couchbase/bin/../lib/libevent_core-2.1.so.7() [0x7f7baccf6000+0xf84e]","#13 /opt/couchbase/bin/../lib/libevent_core-2.1.so.7() [0x7f7baccf6000+0x18b99]","#14 /opt/couchbase/bin/../lib/libevent_core-2.1.so.7(event_base_loop+0x357) [0x7f7baccf6000+0x19287]","#15 /opt/couchbase/bin/memcached() [0x400000+0x97d5c6]","#16 /opt/couchbase/bin/memcached() [0x400000+0x97dace]","#17 /opt/couchbase/bin/memcached() [0x400000+0x97ff98]","#18 /opt/couchbase/bin/memcached() [0x400000+0x1c4829]","#19 /opt/couchbase/bin/memcached() [0x400000+0x8f0d9c]","#20 /opt/couchbase/bin/../lib/libstdc++.so.6() [0x7f7babf42000+0xe4aa3]","#21 /lib/x86_64-linux-gnu/libpthread.so.0() [0x7f7bac69f000+0x7fa3]","#22 /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f7babbd8000+0xf906f]"]
|
QE-TEST:
./testrunner -i /data/workspace/debian-p0-query-vset00-00-advisor_7.0_P1/testexec.25694.ini -p bucket_size=300,nodes_init=2,doc-per-day=1,bucket_name=travel-sample,load_sample=True,skip_primary_index=true,get-cbcollect-info=True,sirius_url=http://172.23.120.103:4000 -t tuqquery.tuq_advisor.QueryAdvisorTests.test_negative_query_syntax_error,bucket_size=300,nodes_init=2,doc-per-day=1,bucket_name=travel-sample,load_sample=True,skip_primary_index=true,get-cbcollect-info=True,sirius_url=http://172.23.120.103:4000
|
Job: http://qa.sc.couchbase.com/job/test_suite_executor/623873/consoleFull
Attachments
Issue Links
- is duplicated by
-
MB-58621 ERROR 8347: ERROR 8347: Exception occurred during DCP step(). Closing connection Monotonic<m> (ActiveStream(eq_dcpq:secidx:proj-INIT_STREAM_TOPIC_688679a879ea150eeec8592c8a290cec-14660100701909649276/0 (vb:360))::curChkSeqno)
- Closed