Pg_restore failed

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Pg_restore failed

avinash varma
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


Thanks & Regards,
Avinash.
Reply | Threaded
Open this post in threaded view
|

Re: Pg_restore failed

Magnus Hagander-2


On Fri, Aug 28, 2020 at 6:55 PM avinash varma <[hidden email]> 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.

--
Reply | Threaded
Open this post in threaded view
|

Re: Pg_restore failed

avinash varma
Thanks Magnus.

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

Thanks,
Avinash

On Fri, Aug 28, 2020 at 10:39 PM Magnus Hagander <[hidden email]> wrote:


On Fri, Aug 28, 2020 at 6:55 PM avinash varma <[hidden email]> 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.

--


--
Thanks & Regards,

Avinash.
Reply | Threaded
Open this post in threaded view
|

Re: Pg_restore failed

Magnus Hagander-2

(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 <[hidden email]> 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 <[hidden email]> wrote:


On Fri, Aug 28, 2020 at 6:55 PM avinash varma <[hidden email]> 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.

--


--
Thanks & Regards,

Avinash.


--