Skip to main content
Question

PostGIS - Bulk copy failed, server closed connection

  • March 5, 2013
  • 5 replies
  • 218 views
H
Hi Fme:ers,

 

I have a problem inserting data into PostGIS with FME2013.

 

Sometimes it fails after 500 000 objects and sometimes it occur after 5 000 000 objects. Feels like a server/network problem but cant figure it out. Anyone experienced this?

 

 

2013-03-01 14:51:07| 102.1|  0.3|ERROR |Bulk copy failed on table 'public.Infra_import' using delimiter ':'. Error was 'server closed the connection unexpectedly

 

                This probably means the server terminated abnormally

 

                before or while processing the request.

 

'

 

2013-03-01 14:51:07| 102.1|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details

 

2013-03-01 14:51:07| 102.1|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details

 

2013-03-01 14:51:07| 102.1|  0.0|ERROR |Bulk copy failed on table 'public.Infra_import' using delimiter ':'. Error was 'no COPY in progress

 

'

 

2013-03-01 14:51:07| 102.1|  0.0|INFORM|Successfully closed PostgresConn database reader

 

2013-03-01 14:51:07| 102.1|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details

 

2013-03-01 14:51:07| 102.1|  0.0|ERROR |... Last line repeated 2 times ...

 

 

 

Henrik Rinne
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

david_r
Celebrity
  • david_rCelebrity
  • March 5, 2013
Hi Henrik,

 

 

I suggest you take a look in the PostgreSQL log file on the database server, you will probably find a better description of the error there. Particularly if this really is a server-side error.

 

 

David
H
  • hrinne
  • Author
  • April 23, 2013
Thanks!

 

A server restart was enough:-)
L

Bulk copy failed on table 'public.match_tt' using delimiter ':'. Error was 'ERROR: extra data after last expected column

 

To solve this there is an parameter under that Advance and Bulk insert : NO . bulk insert should be set as no that solved my problem

H
  • hry9849
  • January 16, 2020

Bulk copy failed on table 'public.match_tt' using delimiter ':'. Error was 'ERROR: extra data after last expected column

 

To solve this there is an parameter under that Advance and Bulk insert : NO . bulk insert should be set as no that solved my problem

Would you like share more detail about it? Where can set the Advance and Bulk insert.

jovitaatsafe
Safer
Forum|alt.badge.img+11

Would you like share more detail about it? Where can set the Advance and Bulk insert.

Hi @hry9849, I believe you can find the Advanced parameters in the PostGIS Writer parameters when you first add your PostGIS Writer.

If you run into any snags afterwords, please feel free to post a new question as that will have much better visibility and will provide you with more answers and suggestions. It's easy for the Community to overlook new posts to older questions. Thanks!

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.