bug(storev3): can't advance cursor

[richard-ramos]

Problem

For this criteria in /dns4/store-01.do-ams3.shards.test.status.im/tcp/30303/p2p/16Uiu2HAmAUdrQ3uwzuE4Gy4D56hX6uLKEeerJAnhKEHZ3DxF1EfT, there should be around ~510 messages

{
 "request_id": "test1"
 "include_data":true,
 "pubsub_topic":"/waku/2/rs/16/32",
 "time_start":1717038870472334766,
 "time_end":1717038999574854537,
 "pagination_limit":100
}

If I execute the query, I get the first 100 results succesfully, and the cursor (represented here in std base64): Mlnwx3p1TukFi+UnxSc++5XjVLUBjBxMByRDjc+jgV8=

If i proceed to ask for the next page of results:

{
 "request_id": "test2",
 "include_data":true,
 "pubsub_topic":"/waku/2/rs/16/32",
 "time_start":1717038870472334766,
 "time_end":1717038999574854537,
 "pagination_cursor":"Mlnwx3p1TukFi+UnxSc++5XjVLUBjBxMByRDjc+jgV8=",
 "pagination_limit":100
}

I get the following response:

 {"request_id":"test2","status_code":200,"status_desc":"OK"}

which is not okay because there are more messages (i verified with legacy store)

Interestingly enough, if I change the pagination limit to 10, i still see the same behavior: 10 results on first page, and no messages on second page.

This problem is likely fixed with @SionoiS archive refactor.

[Ivansete-status]

Closing as per #2761
I tested it with the message-finde establishing pages of 2 and it worked fine.

Used the following to validate that:

while true
do

  timeEnd=$(date +%s%N)
  timeBegin=$[ ${timeEnd} - 86400000000000 ]
#  timeBegin=$[ ${timeEnd} - 111000000000 ]

  timeBegin=1720796905323670344
  #    --content-topic=/waku/1/0xd811cd50/rfc26 \
    #    --content-topic=/waku/1/0x89bed93d/rfc26 \
      #  --content-topic=/waku/1/0xc95d2429/rfc26 \
       # --content-topic=/waku/1/0xa0a6b41b/rfc26 \
   
  echo "=================================="
  echo " Before query "
  ./build/query \
      --cluster-id=2 \
      --storenode=/ip4/127.0.0.1/tcp/60000/p2p/16Uiu2HAmVFXtAfSj4EiR7mL2KvL4EE2wztuQgUSBoj2Jx2KeXFLN \
      --pubsub-topic=/waku/2/rs/2/1 \
      --content-topic=my-ctopic-1 \
      --start-time=${timeBegin} \
      --end-time=${timeEnd} \
      --pagesize=2 

  echo "=================================="
  echo ""
  sleep 10
done