Re: Pg_restore failed

(please avoid top-posting on the PostgreSQL lists. It makes replies harder
to read..)

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

> Thanks Magnus.
>
> Could you please point me if we have any supporting docs for postgres
> recommended storage options.
>
>

https://www.postgresql.org/docs/12/creating-cluster.html talks about it in
general. It mentions NFS specifically, Anything mentioned under that
applies to any networked filesystem. It would perhaps be good to expand on
that documentation to mention other networked filesystems.

My recommendation to avoid cifs is not based on what's documented in
PostgreSQL, but rather with personal experience (which has not been
particularly pretty).

//Magnus

> On Fri, Aug 28, 2020 at 10:39 PM Magnus Hagander <magnus(at)hagander(dot)net>
> wrote:
>
>>
>>
>> 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/>
>>
>
>
> --
> Thanks & Regards,
>
> Avinash.
>

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