Neon Console SQL Editor: ERROR: cannot execute XYZ in a read-only transaction
I haven't touched my Neon project for a few weeks and apparently there's a new bug now in Neon Console's SQL Editor: I'm unable to execute any query that requires write access. I have two compute instances assigned to my
main branch, one RW compute that auto-suspends, and one RO compute that's always on. Although I selected the RW compute in the SQL Editor, I always get an error when I try to execute a write query.
E.g. when I try to comment on my DB:
I get
This happens regardless whether the RW compute is currently idle or active. And it is reproducible β I just created a completely fresh project with the same setup (1 RW, 1 RO compute) and I run into the same issue!
I suspect this bug is related to the new time travel feature. Note that the time travel toggle was off during the above!
Addendum: Apparently, the compute selection drop-down in the SQL Editor is broken. When I suspend the RO compute (status: idle) and start the RW compute (status: active), write queries work again β regardless of which compute is selected in the drop-down. π2 Replies
flat-fuchsiaβ’2y ago
Thank you for the detailed bug report, and sorry for the inconvenience. I've logged it and informed the Console UI team.
noble-goldβ’2y ago
hey, the fix is on its way. probably, today/tomorrow it will be shipped