vsbace commented on issue #1850: URL: https://github.com/apache/cloudberry/issues/1850#issuecomment-4971095849
Hi > Thanks for reporting this, could you share a bit more information? > > 1. Version & Environment > > * Exact Cloudberry version / commit hash > * OS version <img width="1675" height="303" alt="Image" src="https://github.com/user-attachments/assets/d49494e7-2f24-410f-beee-d0d5297acff7"; /> <img width="573" height="254" alt="Image" src="https://github.com/user-attachments/assets/c1ee0142-406d-4df0-9469-656427fb9d20"; /> > > 2. Full error output > > * The complete autovacuum error messages from the master log (a few lines of surrounding context would be really helpful, rather than a single line) > * If there's a crash / core dump, a gdb backtrace (bt / thread apply all bt) would be great > Avtovacuum working without errors. Errors was happen when i tried to run command VACUUM without parameters on problem database. > 3. Reproduction details > > * Minimal steps to reproduce (how many PXF tables, and the DDL used to create them) > * Is it consistently reproducible, or intermittent? It is consistently reproducible. <img width="514" height="389" alt="Image" src="https://github.com/user-attachments/assets/e778fb33-6821-469c-8dee-8e7ae660c7f5"; /> F TABLE DDL "CREATE FOREIGN TABLE cbv1.pxf_delta_hdfs_t_consent_audit ( "SN" numeric(5,0), "S_ID" numeric(38,0), "EN_TS" timestamp without time zone, "EN_REASON" numeric(5,0), "FUNCTION_NUMBER" numeric(5,0), "CHECK_RESULT" numeric(5,0), "CS_FLAG" text, "DATE_CS_GIVEN" timestamp without time zone, "DATE_CS_EXPIRY" timestamp without time zone, "CS_POSE" text, "CS_POSE_DETAILS" text, "CS_BILITY_FLAG" text, "CS_USR_DETAILS" text, "MD5HASH" bytea, "DELETION_MARK" numeric(1,0), "VALID_FROM_DATE" timestamp without time zone, "VALID_TO_DATE" timestamp without time zone, "SOURCE_SYSTEM" text, "PYD" numeric(38,0) ) SERVER gp_exttable_server OPTIONS ( encoding '6', format_type 'b', execute_on 'ALL_SEGMENTS', format 'custom', formatter 'pxfwritable_import', is_writable 'false', location_uris 'pxf:///hdfs/astore/t_cs_audit?PROFILE=hdfs&SERVER=default', log_errors 'disable' );" > > 4. Table metadata (run against the affected database) > SELECT relname, relkind, relfrozenxid, age(relfrozenxid) > FROM pg_class > WHERE relname = '<table_name>'; > <img width="923" height="322" alt="Image" src="https://github.com/user-attachments/assets/ef868ed4-9df5-422c-a1a8-fb149f4c1770"; /> > * Whether these PXF tables are standard foreign tables or go through gp_exttable_fdw (\d+ <table_name>, or check pg_foreign_table / pg_foreign_server) <img width="1529" height="133" alt="Image" src="https://github.com/user-attachments/assets/a5b4e1fd-8228-4802-9ec6-d23359840227"; /> > > 5. Autovacuum behavior > > * If possible, set log_autovacuum_min_duration = 0 and share the log showing which tables autovacuum actually selects and processes — this would confirm it's indeed acting on the foreign tables Log output is very high. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
