pg_dump hang observed: Need help

From: Atul Dhole <Atul(dot)Dhole(at)veritas(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: pg_dump hang observed: Need help
Date: 2023-03-27 12:08:10
Message-ID: CH0PR20MB4204B7E3EB5E30F9C451C99F938B9@CH0PR20MB4204.namprd20.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi PGSQL Team,

While taking backup of PostgreSQL DB, observed hang in pg_dump.

The PostgreSQL version is 14.6

Need help understand if this is a known issue. If not, need help in resolving the hang seen.

The command that has hung is as follows

pg_dump --host=DBSERVER.postgres.database.azure.com -p 5432 --username=USER1 -w -F c --dbname=DB1 -v -f PATH/DBNAME/DB1.dump

Details of hang are as follows

I]. DB1 - Table count: 667, size around 30 GB

STACK1

————

(gdb) bt

#0 0x00007f6ab8ea6bc8 in write () from /lib64/libc.so.6

#1 0x00007f6ab8e18dad in _IO_file_write@@GLIBC_2.2.5 () from /lib64/libc.so.6

#2 0x00007f6ab8e1811f in new_do_write () from /lib64/libc.so.6

#3 0x00007f6ab8e194de in __GI__IO_file_xsputn () from /lib64/libc.so.6

#4 0x00007f6ab8e0e56c in fwrite () from /lib64/libc.so.6

#5 0x000000000043d861 in flushbuffer ()

#6 0x000000000043f064 in pg_vfprintf ()

#7 0x000000000043f148 in pg_fprintf ()

#8 0x000000000043bf4a in pg_log_generic_v ()

#9 0x000000000043c1d8 in pg_log_generic ()

#10 0x00000000004090d9 in dumpTableData_copy ()

#11 0x000000000043195b in WriteDataChunksForTocEntry ()

#12 0x00000000004319e6 in WriteDataChunks ()

#13 0x0000000000433199 in _CloseArchive ()

#14 0x000000000042c92e in CloseArchive ()

#15 0x0000000000406536 in main ()

II] DB2 - table count : 5193, size around 60 MB

Command fired: pg_dump --host=DBSERVER.postgres.database.azure.com -p 5432 --username=USER1 -w -F c --dbname=DB2 -v -f PATH/DBNAME/DB2.dump

STACK2

————

(gdb) bt

#0 0x00007fe6a9920bc8 in write () from /lib64/libc.so.6

#1 0x00007fe6a9892dad in _IO_file_write@@GLIBC_2.2.5 () from /lib64/libc.so.6

#2 0x00007fe6a989211f in new_do_write () from /lib64/libc.so.6

#3 0x00007fe6a98934de in __GI__IO_file_xsputn () from /lib64/libc.so.6

#4 0x00007fe6a988856c in fwrite () from /lib64/libc.so.6

#5 0x000000000043d861 in flushbuffer ()

#6 0x000000000043f064 in pg_vfprintf ()

#7 0x000000000043f148 in pg_fprintf ()

#8 0x000000000043bf4a in pg_log_generic_v ()

#9 0x000000000043c1d8 in pg_log_generic ()

#10 0x0000000000421db1 in getTableAttrs ()

#11 0x0000000000425431 in getSchemaData ()

#12 0x00000000004059a1 in main ()

Regards,
Atul D.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2023-03-27 12:33:37 Re: pg_dump hang observed: Need help
Previous Message Daniel Gustafsson 2023-03-27 11:49:01 Re: BUG #17695: Failed Assert in logical replication snapbuild.