Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0, Cheshire-Cat
-
7.0.0-1569
-
Untriaged
-
No
Description
The basic pull scenario in auto prepare tests is broken.
2 node cluster (both with n1ql services)
prepare statement p1:
PREPARE P1 FROM select * from default limit 5
delete prepare statement p1 from node2:
delete from system:prepareds where node = '172.23.104.173:8091'
run prepare statement p1 on node2 via node1:
execute '[172.23.104.110:8091]P1'
"code": 4040,
"msg": "No such prepared statement: \"[172.23.104.110:8091]P1\", context ",
"query": "execute '[172.23.104.110:8091]P1'"
You get this error, however this prepared statement is indeed in the system:prepareds (see attatched screenshot)
here is select * from system:prepareds output(it has two uses because i was checking if it can be used straight up on node1, which it can be):
"prepareds": {
"avgElapsedTime": "108.860281ms",
"avgServiceTime": "108.785859ms",
"encoded_plan": "H4sIAAAAAAAA/7SSwYrbMBCGX8X8ewu6pG0o6BbKLhS21CSllxKCsCeOurLkHY2XpEZ99iLbS9jd5lR6s2d+fUjfzADyVaip3nfOeGhA4UBGeqZPwQsHF6GX7xSsr+m07ux34miDh/6g4E1L0CiXmL5jZ6pcqOlgeidQCB2xkcDQA24uP1j3cgxsfxEUOrZP1lFDMafubRToHwO+GW5ILjR9oZZsn6A/pl1S+F0dratf87f02JOvMn4KMPmR+n9CJdvW8HlbGf8esyto3HRT/bm07zj8pEpGfwPm7v6BztDCPSWFBzq/tehsa7OJ1VXPfbS+gUYTLZJ6ebk7kuqIK+i/4V4DSsPGOXL4J9ufvRVrXDkpgAJT7J3shbiNY5pOXQ5GcgcoRDE8a9mlXcrDfgm8H62o52MrvI1shcm0uZEUHnvic15qOsm06NE2flz1/KAFNBZICnO/3NyW681tUS6Lu83XL0UkR5UUi+LAoS1mV8U4mmKF9CcAAP//3vYj2EkDAAA=",
"featureControls": 12,
"indexApiVersion": 4,
"lastUse": "2020-03-17 13:11:07.284861128 -0700 PDT m=+165.500305632",
"maxElapsedTime": "208.083856ms",
"maxServiceTime": "208.025426ms",
"minElapsedTime": "9.636706ms",
"minServiceTime": "9.546293ms",
"name": "P1",
"node": "172.23.104.110:8091",
"statement": "PREPARE P1 FROM select * from default limit 5",
"uses": 2
Logs attached