Re: Pg_restore failed

On Fri, Aug 28, 2020 at 6:55 PM avinash varma <avinashvarma443(at)gmail(dot)com>
wrote:

> Hi Team,
>
> Could you please help me with the below error msg. The same dump works
> well with NFS storage. But it is failing with CIFS.
>
> pg_restore: error: could not execute query: PANIC: could not fdatasync
> file "0000000100000001000000E9": Bad file descriptor
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> Command was: ALTER TABLE ONLY nsp_contact
> ADD CONSTRAINT nsp_contact_casnum_constraint PRIMARY KEY (casnum);
> --
>
> Below are error msgs from OS
>
> Aug 28 08:27:54 nid-2021-2 kernel: [ 1830.678930] CIFS VFS: No task to
> wake, unknown frame received! NumMids 5
> Aug 28 08:27:54 nid-2021-2 kernel: [ 1830.679229] 00000000: 23000000
> 424d53ff 00000124 c00180c0 ...#.SMB$.......
> Aug 28 08:27:54 nid-2021-2 kernel: [ 1830.679231] 00000010: 00000000
> 00000000 00000000 3f230002 ..............#?
> Aug 28 08:27:54 nid-2021-2 kernel: [ 1830.679233] 00000020: 01 00 b0 54 00
> ...T.
> Aug 28 08:28:07 nid-2021-2 kernel: [ 1843.879397] CIFS VFS: No task to
> wake, unknown frame received! NumMids 5
> Aug 28 08:28:07 nid-2021-2 kernel: [ 1843.879698] 00000000: 23000000
> 424d53ff 00000124 c00180c0 ...#.SMB$.......
> Aug 28 08:28:07 nid-2021-2 kernel: [ 1843.879700] 00000010: 00000000
> 00000000 00000000 00780002 ..............x.
> Aug 28 08:28:07 nid-2021-2 kernel: [ 1843.879702] 00000020: 01 00 cd 7a 00
> ...z.
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.615625] CIFS VFS: Error -104
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.615940] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.616147] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.616336] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.616546] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.616725] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.616911] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.617083] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:10 nid-2021-2 kernel: [ 1846.617253] CIFS VFS: Error -32
> sending data on socket to server
> Aug 28 08:28:22 nid-2021-2 kernel: [ 1859.070931] cifs_vfs_err: 11
> callbacks suppressed
> Aug 28 08:28:22 nid-2021-2 kernel: [ 1859.071232] CIFS VFS: Send error in
> Flush = -9
>
>
That is not a PostgreSQL problem, that is a kernel problem related to your
cifs mount. You'll need to check that with the kernel people.

That said, I would strongly advise you *not* to run PostgreSQL on a cifs
mounted partition in general. This type of filesystem errors being one of
the reasons for that.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>