cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard

[Bug] brin index related, could not read block xxx in file when insert after cbdb binary swap

Open congxuebin opened this issue 1 year ago • 3 comments

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

congxuebin avatar Aug 07 '24 02:08 congxuebin

Can't guarantee binary swap.

avamingli avatar Aug 21 '24 06:08 avamingli

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?

congxuebin avatar Sep 11 '24 03:09 congxuebin

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.

avamingli avatar Sep 12 '24 11:09 avamingli

Already discussed. It's Lightning related, and it's not an issue but expected.

my-ship-it avatar Oct 09 '24 11:10 my-ship-it