Solved

unexpected EOF on client connection connecting to PostGRE

Posted on 2006-07-12
12
2,805 Views
Last Modified: 2008-01-09
I am attempting to connect an Access frontend to a PostgreSQL backend.  This process has been mostly painless with one exception so far.  On of the forms simply crashes when attempting to load.  There is of course no error produced by Access.  I have included a portion of the PostgreSQL log that I believe begins just before I attempt to open the form and concludes just after the error is returned.

I'm completely lost on this one.  Does anyone have a clue as to whats going wrong?

2006-07-11 17:12:30 DEBUG:  00000: forked new backend, pid=29675 socket=8
LOCATION:  BackendStartup, postmaster.c:2235
2006-07-11 17:12:30 LOG:  00000: statement: set DateStyle to 'ISO'
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: set geqo to 'OFF'
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: set extra_float_digits to 2
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: select oid, typbasetype from pg_type where typname = 'lo'
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: select pg_client_encoding()
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT Config, nValue FROM MSysConf
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 ERROR:  42P01: relation "msysconf" does not exist
LOCATION:  RangeVarGetRelid, namespace.c:193
2006-07-11 17:12:30 DEBUG:  00000: AbortCurrentTransaction
LOCATION:  PostgresMain, postgres.c:2722
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "public"."Content"."ID" FROM "public"."Content"
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID","RecordIDType","OtherID","DateCreated","DateModified","Collection Number","Title","Subtitle","ResourceType","Language1","Language2","Location","Abstract","TOC","ContentNotes"  FROM "public"."Content"  WHERE "ID" = 1
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "NameDetail"."ContentID","NameDetail"."Name" FROM "public"."NameDetail" "NameDetail" WHERE (("ContentID" =  1 ) AND ("ContentID" =  1 ) )
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ContentID","Name","Role","RoleTerm"  FROM "public"."NameDetail"  WHERE "ContentID" = 1 AND "Name" = 38 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37 OR "ContentID" = 1 AND "Name" = 37
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID" ,"Name"  FROM "public"."Name"
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID" ,"Name"  FROM "public"."Name" ORDER BY "public"."Name"."Name"
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "MS1"."ID" FROM "public"."SourceSound" "MS1" WHERE ( 1 = "Content#" )
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID","Form","ReelSize","DimensionNote","Disposition","Gauge","Generation","Length","SourceNote","SoundField","Speed","Stock","TapeThick","TrackFormat","RelatedItem","ItemLocation","Content#","Housing","ConservationHistory","SourceDate","PublicationDate","TransferEngineer"  FROM "public"."SourceSound"  WHERE "ID" = 32
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "MS1"."ContentID","MS1"."ConditionID" FROM "public"."ConditionDetail" "MS1" WHERE ("ContentID" =  32 )
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID","Form","ReelSize","DimensionNote","Disposition","Gauge","Generation","Length","SourceNote","SoundField","Speed","Stock","TapeThick","TrackFormat","RelatedItem","ItemLocation","Content#","Housing","ConservationHistory","SourceDate","PublicationDate","TransferEngineer"  FROM "public"."SourceSound"  WHERE "ID" = 32
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID" ,"Housing description Film"  FROM "public"."Housing" WHERE ("Housing description Film" LIKE '%sound%' ) ORDER BY "public"."Housing"."Housing description Film"
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "TechSound Subform"."ID" FROM "public"."TechSound" "TechSound Subform" WHERE ( 1 = "Content#" )
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:30 LOG:  00000: statement: SELECT "ID","Content#","FormatName","ByteOrder","CompressionScheme","FileSize","CodecCreator","CodecQuality","Methodology","BitsPerSample","SamplingFrequency","SoundNote","Duration","SoundClip","DateCaptured","FileLoc"  FROM "public"."TechSound"  WHERE "ID" = 282
LOCATION:  pg_parse_query, postgres.c:464
2006-07-11 17:12:31 LOG:  08006: could not receive data from client: Connection reset by peer
LOCATION:  pq_recvbuf, pqcomm.c:678
2006-07-11 17:12:31 LOG:  08P01: unexpected EOF on client connection
LOCATION:  SocketBackend, postgres.c:281
2006-07-11 17:12:31 DEBUG:  00000: child process (PID 29675) exited with exit code 0
LOCATION:  LogChildExit, postmaster.c:2078
0
Comment
Question by:whitej8
  • 7
  • 3
12 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17091155
its saying

msysconf  does not exist


when u issue

SELECT Config, nValue FROM MSysConf

its falling on that, as MSysConf does not exist
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17091167
well that could be one part of the total problem !
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17091191
the last sql is this

statement: SELECT "ID","Content#","FormatName","ByteOrder","CompressionScheme","FileSize","CodecCreator","CodecQuality","Methodology","BitsPerSample","SamplingFrequency","SoundNote","Duration","SoundClip","DateCaptured","FileLoc"  FROM "public"."TechSound"  WHERE "ID" = 282


Have u tried to run this SQL outside Access and in Postgress? How long does it take to run


When u run this in Access, does it take a while to respond? looking at your logs, it returns with a message 1 minute later

could your timeout setting be set to 60 seconds somewhere?

Have u tried increasing your timeout setting
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 65

Expert Comment

by:rockiroads
ID: 17091200
Are you using ODBC? Is there a connection timeout settng there?
Access has a timeout also Tools/Options/Advanced
0
 

Author Comment

by:whitej8
ID: 17092357
I am using PGSQL ODBC version 8.02.  There are many forms in this MDB and the others can access the PostGRE tables without problem.  I did execute the last SQL statement in PostGRE and it completes with data in about 600 ms.  The access form fails instantly so I doubt it is a timeout issue.
0
 

Author Comment

by:whitej8
ID: 17101149
I've posted this question to the PostGRE section as well so a correct answer is worth 1000 pts.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17109871
Ive been trying to find a solution but cant find much on it

can u try simplify the query, perhaps its something to do with that?

e.g.

SELECT "ID", "FormatName"  FROM "public"."TechSound"  WHERE "ID" = 282

How does Postgres handle column names like Content#

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17109879
Is it also worth correcting the one failure u get earlier, perhaps that is impacting the result somehow
0
 

Author Comment

by:whitej8
ID: 17122633
After some very tedious exhaustive testing I was able to isolate the error to an OLE object field from the original database.  OLE objects are MS specific and are not supported by postGRE, removing this field has stopped the crashing problem.  In order to maintain the functionality I will replace the OLE object with a filesystem pointer.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17126807
Good find, sorry I couldnt be much help. Niot having Postges is somewhat of a stumbling block!

I suggest close, no delete as this info is useful
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 17157700
Closed, 500 points refunded.
Netminder
Site Admin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question