Re: BUG #17867: pg_dump intermittently hangs

> On 24 Mar 2023, at 09:02, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 17867
> Logged by: Mayur Lokare
> Email address: mayur(dot)lokare%veritas(dot)com(at)gtempaccount(dot)com
> PostgreSQL version: 14.6
> Operating system: Red Hat Universal Base Image 8/ UBI8
> Description:
>
> Database demo contains 667 tables and around 30 GB of data.
>
> pg_dump command :
> pg_dump host=server.postgres.database.azure.com -p 5432
> username=admin1(at)server -w -F c -dbname=demo -v -f /root/out.dump
>
> Getting below stack:
> (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 ()

Is is really hanging and not just waiting on IO?

--
Daniel Gustafsson