[Bug] brin index related, could not read block xxx in file when insert after cbdb binary swap
Cloudberry Database version
Swap from: PostgreSQL 14.4 (Cloudberry Database 1.6.0 build 79708 commit:81b10d5c) Swap to: PostgreSQL 14.4 (Cloudberry Database 1.6.0+dev.3.g48d76a3e build 80152 commit:48d76a3e)
What happened
psql:test.sql:38: ERROR: could not read block 16384 in file "base/16384/24584": read only 0 of 32768 bytes (seg2 127.0.0.1:7004 pid=5195)
What you think should happen instead
No response
How to reproduce
Download this file: recreate_script.zip Unzip the recreate_script.zip Install cbdb: PostgreSQL 14.4 (Cloudberry Database 1.6.0 build 79708 commit:81b10d5c) Then install another cbdb: PostgreSQL 14.4 (Cloudberry Database 1.6.0+dev.3.g48d76a3e build 80152 commit:48d76a3e) Issue the source command: source /code/cbdb_src/gpAux/gpdemo/gpdemo-env.sh Run recreate.sh
Operating System
centos7
Anything else
No response
Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
Code of Conduct
- [X] I agree to follow this project's Code of Conduct.
Can't guarantee binary swap.
Hi Mingli, According to information in release meeting, it is needed to ensure compatibility across certain versions. I'd like to re-open this issue regarding this. If you have any concerns about binary compatibility requirement, would you please work with Max on this?
Hi Mingli, According to information in release meeting, it is needed to ensure compatibility across certain versions. I'd like to re-open this issue regarding this. If you have any concerns about binary compatibility requirement, would you please work with Max on this?
Have no context about the meeting, and don't know how to fix those if there were. Only we can do is to check catalog changes to decide a release version number. I don't have that knowledge, leave this topic. No objection if release team have plan to maintain this and decide to do that work , thanks.
Already discussed. It's Lightning related, and it's not an issue but expected.