You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by "jsung11 (via GitHub)" <gi...@apache.org> on 2026/10/08 15:58:11 UTC
[I] [Bug] [cloudberry]
jsung11 opened a new issue, #2098:
URL: https://github.com/apache/cloudberry/issues/2098
### Apache Cloudberry version
Apache Cloudberry 2.1.0-incubating build bdf90c5518f
### What happened
gpcheckcat is reporting issues on a database with materialized views
Relation oid: 7016964
Relation schema: XXXX
Relation name: XXXXXX
Name of test which found this issue: inconsistent_pg_class
relmvrefcount is '1' on content -1 (XXXXXX:5432)
relmvrefcount is '0' on all other segments
Gpcheckcat is showing no errors before creation of materialized view
After a materialized view is created and run the gpcheckcat is reporting inconsistencies in pg_class
Seems like relmvrefcount is not being updated on the segments
### What you think should happen instead
Either relmvrefcount is updated correctly or gpcheckcat should ignore this test. We have multiple CB clusters with multiple databases. And our daily online catalog check is failing on any database with MV
### How to reproduce
CREATE TABLE public.test_table (
col1 int,
col2 int
)
DISTRIBUTED randomly;
run gpcheckcat <db> This shows no error
CREATE MATERIALIZED VIEW public.test_table_mv
WITH (appendonly = true, blocksize='32768', compresslevel='3', compresstype=zstd, checksum='true') AS
SELECT * from public.test_table;
run gpcheckcat <db>
Relation oid: 7018655
Relation schema: public
Relation name: test_table
Name of test which found this issue: inconsistent_pg_class
relmvrefcount is '1' on content -1 (XXXXXX:5432)
relmvrefcount is '0' on all other segments
### Operating System
NAME="Red Hat Enterprise Linux" VERSION="9.7 (Plow)"
### Anything else
Every time. We can reproduce this at will
### Are you willing to submit PR?
- [x] Yes, I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org
Re: [I] [Bug] [cloudberry]
Posted by "tuhaihe (via GitHub)" <gi...@apache.org>.
tuhaihe closed issue #2098: [Bug]
URL: https://github.com/apache/cloudberry/issues/2098
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org
Re: [I] [Bug] [cloudberry]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #2098:
URL: https://github.com/apache/cloudberry/issues/2098#issuecomment-6064855216
Hi, @jsung11 welcome!🎊 Thanks for taking the time to point this out.🙌
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org