Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

unexpected EOF on client connection connecting to PostGRE

Posted on 2006-07-12
12
Medium Priority
?
2,989 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 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