[Techtalk] postgres, ODBC, connections

[Michelle Murrain]

At 5:40 PM -0800 2/22/03, Nicole Zimmerman wrote:
>When running a report that takes a long time, involves a lot of queries,
>and returns a lot of data, the application on the client side crashes
>(possibly running out of memory on either end?). When this happens, the
>application on the client side completely closes (posting events to the
>System Log in Win2k that indicates it unexpectedly quit) and there are no
>connections showing through 'netstat' on that machine.
>
>However, on the postgres server, the connection to the client is still
>shown as "ESTABLISHED" and insertions into the same database stop
>happening (through another process). The account running the report is a
>read-only user, the account attempting inserts obviously is not. Reports
>that run and exit correctly do not cause this problem, only reports that
>crash.
>
>Obviously this poses problems to database-driven applications that need to
>be able to insert data no matter what is happening on the reports side.
>Restarting postgres clears the connection from the user forceably, but
>this isn't a very practical solution.
>
>Has anyone using postgres seen this before? Is there a workaround either
>through postgres or through the ODBC driver itself?

Can you give a bit more detail? I have recently set up a fairly 
complex (with a fair number of records) database application with 
Crystal Reports on the front end and Postgresql on the back end, and 
have not seen this problem.

How many tables are you trying to get data from? how many records? 
What are the specs of the client machine?

Could be a combination of factors - but could also be a bug the 
postgresODBC folks need to know about.

Also - do you know whether other factors which might crash the client 
have the same effect?
-- 
.Michelle

--------------------------
Michelle Murrain, Technology Consulting
tech at murrain.net     http://www.murrain.net
413-253-2874 ph
413-222-6350 cell
413-825-0288 fax
AIM:pearlbear0 Y!:pearlbear9 ICQ:129250575

"A vocation is where the world's hunger & your great gladness meet."  
Frederick Buechner

XINA version 0.6 is out! http://www.xinasoft.org