Clojurians Log v2
Clojure programming
Channels
Apps
xtdb
Xarlyle0 2025-06-02T14:01:00.359249Z
Hello! I don't understand the error I'm getting. I have an xtdb instance that works normally if I have recently done an INSERT or some sort of transaction, but If I wait a day or so, and then try and make a SELECT, I get the following error:
xtdb=> SELECT * FROM people;
ERROR: snapshot-time (2025-05-29T20:47:08.009060951Z) is after the latest completed tx (#xt/tx-key {:tx-id 5623, :system-time #xt/instant "2025-05-29T16:46:07.940618166Z"})
DETAIL: {"latest-completed-tx":{"tx-id":5623,"system-time":"2025-05-29T16:46:07.940618166Z"},"snapshot-time":"2025-05-29T20:47:08.009060951Z","category":"cognitect.anomalies\/incorrect","code":"xtdb\/unindexed-tx","message":"snapshot-time (2025-05-29T20:47:08.009060951Z) is after the latest completed tx (#xt\/tx-key {:tx-id 5623, :system-time #xt\/instant \"2025-05-29T16:46:07.940618166Z\"})"}
jarohen 2025-06-03T13:58:05.548299Z
fix out 🙂 could try re-pulling latest? or 2.0.0-beta8.4 if you're specifying manually
Xarlyle0 2025-06-03T14:02:58.698869Z
It works!
🙌 2
🎉 1
Xarlyle0 2025-06-03T14:03:48.946259Z
Thank y'all! I'm hoping to prove to my company that the ease and bitemporal features of xtdb will make our current task much much more doable.
jarohen 2025-06-03T14:04:40.253159Z
awesome 🙂 let us know if we can help!
Oliver Marshall 2025-06-02T14:48:31.360159Z
I believe you’re running into this bug: https://github.com/xtdb/xtdb/issues/4465 This is definitely not intended!
Xarlyle0 2025-06-02T14:50:50.175529Z
Ah. Yep. That's definitely it.. I hope this bug is contained to just the standalone docker..
jarohen 2025-06-02T14:57:16.483619Z
recommendation for now is to fix to beta8.2 - this issue is a prio for us to fix
👍 1
jarohen 2025-06-02T20:49:05.150189Z
sounds like we have a repro internally, let's see if we can get to the bottom of it 🙂
💪 1