Skip to content

pg_dump gives columnar AM dependency loop warnings #5510

@marcocitus

Description

@marcocitus

When I run pg_dump against a database with Citus I get a series of warnings:

$ pg_dump
pg_dump: warning: could not resolve dependency loop among these items:
pg_dump:   ACCESS METHOD columnar  (ID 1769 OID 361215)
pg_dump:   INDEX stripe_pkey  (ID 3323 OID 361190)
pg_dump:   CONSTRAINT stripe_pkey  (ID 3324 OID 361191)                                  
pg_dump:   POST-DATA BOUNDARY  (ID 3482)    
pg_dump:   TABLE DATA test  (ID 3478 OID 361296)
pg_dump:   PRE-DATA BOUNDARY  (ID 3481)     
pg_dump: warning: could not resolve dependency loop among these items:
pg_dump:   ACCESS METHOD columnar  (ID 1769 OID 361215)                                  
pg_dump:   INDEX options_pkey  (ID 3319 OID 361185)
pg_dump:   CONSTRAINT options_pkey  (ID 3320 OID 361186)    
pg_dump:   POST-DATA BOUNDARY  (ID 3482)    
pg_dump:   TABLE DATA test  (ID 3478 OID 361296)
pg_dump:   PRE-DATA BOUNDARY  (ID 3481)
pg_dump: warning: could not resolve dependency loop among these items:
pg_dump:   ACCESS METHOD columnar  (ID 1769 OID 361215)
pg_dump:   INDEX chunk_group_pkey  (ID 3325 OID 361195)
pg_dump:   CONSTRAINT chunk_group_pkey  (ID 3326 OID 361196)
pg_dump:   POST-DATA BOUNDARY  (ID 3482)    
pg_dump:   TABLE DATA test  (ID 3478 OID 361296)
pg_dump:   PRE-DATA BOUNDARY  (ID 3481)                                                  
pg_dump: warning: could not resolve dependency loop among these items:                   
pg_dump:   ACCESS METHOD columnar  (ID 1769 OID 361215)
pg_dump:   INDEX chunk_pkey  (ID 3327 OID 361207)
pg_dump:   CONSTRAINT chunk_pkey  (ID 3328 OID 361208)
pg_dump:   POST-DATA BOUNDARY  (ID 3482)    
pg_dump:   TABLE DATA test  (ID 3478 OID 361296)
pg_dump:   PRE-DATA BOUNDARY  (ID 3481)     
pg_dump: warning: could not resolve dependency loop among these items:
pg_dump:   ACCESS METHOD columnar  (ID 1769 OID 361215)
pg_dump:   INDEX stripe_first_row_number_idx  (ID 3321 OID 361286)
pg_dump:   CONSTRAINT stripe_first_row_number_idx  (ID 3322 OID 361287)
pg_dump:   POST-DATA BOUNDARY  (ID 3482)                                                 
pg_dump:   TABLE DATA test  (ID 3478 OID 361296)
pg_dump:   PRE-DATA BOUNDARY  (ID 3481) 

fwiw, test is not a columnar table.

Metadata

Metadata

Labels

bugcolumnardev_reportedto track issues reported by the development team

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions