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