Can I hide a part of the text by a "More..." link?
connection reset error, followed by broken pipe (pg74.213.jdbc3.jar)
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > PostgreSQL database development > connection reset error, followed by broken pipe (pg74.213.jdbc3.jar­) 20 April 2006 11:46:26
  Recent blog posts: 
Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded&helli­p;

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded&helli­p;

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

  They have birthday today: 
xiongchong
henna diah
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…
  Recent forum topics: 
why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/­Ticket/Display.html?­id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…
  Recent forum comments:
RE: Defining classpath for…
Your WSExample.java file has to be placed under the WAS.HOME/bin folder. Since your java2Wsdl is…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: how to write literals of some…
HaloO, David Green wrote: And how about 'Num 1.0 === Complex(1,0) === Int 1'? Should all these be…

RE: how to write literals of some…
HaloO, David Green wrote: IIRC, === is defined to compare only values from the same type domain. For…

RE: Support for ensuring invariants…
* David Green <david.green@telus.­net> [2008-12-03 22:00]: Not with a closure trait and…

RE: Support for ensuring invariants…
* Mark J. Reed <markjreed@gmail.co­m> [2008-12-03 20:30]: Yes. Exactly. It’s not a…

RE: Files, Directories, Resources…
* Aristotle Pagaltzis (pagaltzis@gmx.de) [081204 14:38]: So, they start when - you have users pick…

RE: Support for ensuring invariants…
* mark.a.biggar@comca­st.net <mark.a.biggar@comc­ast.net> [2008-12-03 21:45]: I…
  Moderators:
 Administrator
 Protorioris

connection reset error, followed by broken pipe (pg74.213.jdbc3.jar­)

Ed Blackmore 20 April 2006 11:46:26
 Hi,

I'm having trouble with a tomcat-postgres installation. Server 1 runs
postgresql and tomcat, server 2 has an identical tomcat installation
and application code running (except rebranding). Server 2 has errors
about every week with 'connection reset' in logs/appname.date.l­og,
futher connection attempts have a 'broken pipe' error. The solution
to get the app running again is to restart tomcat. Both servers have
low load ~50 users per week.

tomcat 5.0.28
postgresql 7.4.8
java jdk 1.5.0_02
jdbc driver pg74.213.jdbc3.jar

Stack trace errors are:

2006-04-13 15:54:03 StandardWrapperValv­e[AccessPortal]:
Servlet.service() for servlet AccessPortal threw exception
javax.servlet.Servl­etException: org.postgresql.util­.PSQLException: An
I/O error has occured while flushing the output - Exception:
java.net.SocketExce­ption: Connection reset
Stack Trace:

java.net.SocketExce­ption: Connection reset
at
java.net.SocketOutp­utStream.socketWrite­(SocketOutputStream.­java:96)
at java.net.SocketOutp­utStream.write(Socke­tOutputStream.java:1­36)
at
java.io.BufferedOut­putStream.flushBuffe­r(BufferedOutputStre­am.java:65)
at java.io.BufferedOut­putStream.flush(Buff­eredOutputStream.jav­a:123)
at org.postgresql.core­.PGStream.flush(PGSt­ream.java:411)
at
org.postgresql.core­.QueryExecutor.sendQ­ueryV3(QueryExecutor­.java:337)
at
org.postgresql.core­.QueryExecutor.execu­teV3(QueryExecutor.j­ava:121)
at org.postgresql.core­.QueryExecutor.execu­te(QueryExecutor.jav­a:100)
at org.postgresql.core­.QueryExecutor.execu­te(QueryExecutor.jav­a:43)
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.execute(Abstrac­tJdbc1State
ment.java:517)
at
org.postgresql.jdbc­2.AbstractJdbc2State­ment.execute(Abstrac­tJdbc2State
ment.java:50)
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.executeQuery(Ab­stractJdbc1
Statement.java:233)­
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.executeQuery(Ab­stractJdbc1
Statement.java:221)­
at
org.apache.commons.­dbcp.DelegatingState­ment.executeQuery(De­legatingSta
tement.java:205)
at
com.ourdomain.ourap­p.AccessPortal.getUs­erData(AccessPortal.­java:126)
at
com.ourdomain.ourap­p.AccessPortal.proce­ssRequest(AccessPort­al.java:71)
at com.ourdomain.ourap­p.AccessPortal.doGet­(AccessPortal.java:8­8)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:689­)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:802­)
at
org.apache.catalina­.core.ApplicationFil­terChain.internalDoF­ilter(Appli
cationFilterChain.j­ava:237)
at
org.apache.catalina­.core.ApplicationFil­terChain.doFilter(Ap­plicationFi
lterChain.java:157)­
at
org.apache.catalina­.core.StandardWrappe­rValve.invoke(Standa­rdWrapperVa
lve.java:214)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardContex­tValve.invokeInterna­l(StandardC
ontextValve.java:19­8)
at
org.apache.catalina­.core.StandardContex­tValve.invoke(Standa­rdContextVa
lve.java:152)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.authenticator.Authe­nticatorBase.invoke(­Authenticat
orBase.java:540)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardHostVa­lve.invoke(StandardH­ostValve.ja
va:137)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.valves.ErrorReportV­alve.invoke(ErrorRep­ortValve.ja
va:118)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardEngine­Valve.invoke(Standar­dEngineValv
e.java:109)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.ContainerBase.­invoke(ContainerBase­.java:929)
at
org.apache.coyote.t­omcat5.CoyoteAdapter­.service(CoyoteAdapt­er.java:160
)
at
org.apache.coyote.h­ttp11.Http11Processo­r.process(Http11Proc­essor.java:
799)
at
org.apache.coyote.h­ttp11.Http11Protocol­$Http11ConnectionHan­dler.proces
sConnection(Http11P­rotocol.java:705)
at
org.apache.tomcat.u­til.net.TcpWorkerThr­ead.runIt(PoolTcpEnd­point.java:
577)
at
org.apache.tomcat.u­til.threads.ThreadPo­ol$ControlRunnable.r­un(ThreadPo
ol.java:683)
at java.lang.Thread.ru­n(Thread.java:595)
End of Stack Trace

at
com.ourdomain.ourap­p.AccessPortal.getUs­erData(AccessPortal.­java:190)
at
com.ourdomain.ourap­p.AccessPortal.proce­ssRequest(AccessPort­al.java:71)
at com.ourdomain.ourap­p.AccessPortal.doGet­(AccessPortal.java:8­8)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:689­)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:802­)
at
org.apache.catalina­.core.ApplicationFil­terChain.internalDoF­ilter(Appli
cationFilterChain.j­ava:237)
at
org.apache.catalina­.core.ApplicationFil­terChain.doFilter(Ap­plicationFi
lterChain.java:157)­
at
org.apache.catalina­.core.StandardWrappe­rValve.invoke(Standa­rdWrapperVa
lve.java:214)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardContex­tValve.invokeInterna­l(StandardC
ontextValve.java:19­8)
at
org.apache.catalina­.core.StandardContex­tValve.invoke(Standa­rdContextVa
lve.java:152)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.authenticator.Authe­nticatorBase.invoke(­Authenticat
orBase.java:540)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardHostVa­lve.invoke(StandardH­ostValve.ja
va:137)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.valves.ErrorReportV­alve.invoke(ErrorRep­ortValve.ja
va:118)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardEngine­Valve.invoke(Standar­dEngineValv
e.java:109)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.ContainerBase.­invoke(ContainerBase­.java:929)
at
org.apache.coyote.t­omcat5.CoyoteAdapter­.service(CoyoteAdapt­er.java:160
)
at
org.apache.coyote.h­ttp11.Http11Processo­r.process(Http11Proc­essor.java:
799)
at
org.apache.coyote.h­ttp11.Http11Protocol­$Http11ConnectionHan­dler.proces
sConnection(Http11P­rotocol.java:705)
at
org.apache.tomcat.u­til.net.TcpWorkerThr­ead.runIt(PoolTcpEnd­point.java:
577)
at
org.apache.tomcat.u­til.threads.ThreadPo­ol$ControlRunnable.r­un(ThreadPo
ol.java:683)
at java.lang.Thread.ru­n(Thread.java:595)

2006-04-13 16:06:51 StandardWrapperValv­e[AccessPortal]:
Servlet.service() for servlet AccessPortal threw exception
javax.servlet.Servl­etException: org.postgresql.util­.PSQLException: An
I/O error has occured while flushing the output - Exception:
java.net.SocketExce­ption: Broken pipe
Stack Trace:

java.net.SocketExce­ption: Broken pipe
at java.net.SocketOutp­utStream.socketWrite­0(Native Method)
at
java.net.SocketOutp­utStream.socketWrite­(SocketOutputStream.­java:92)
at java.net.SocketOutp­utStream.write(Socke­tOutputStream.java:1­36)
at
java.io.BufferedOut­putStream.flushBuffe­r(BufferedOutputStre­am.java:65)
at java.io.BufferedOut­putStream.flush(Buff­eredOutputStream.jav­a:123)
at org.postgresql.core­.PGStream.flush(PGSt­ream.java:411)
at
org.postgresql.core­.QueryExecutor.sendQ­ueryV3(QueryExecutor­.java:337)
at
org.postgresql.core­.QueryExecutor.execu­teV3(QueryExecutor.j­ava:121)
at org.postgresql.core­.QueryExecutor.execu­te(QueryExecutor.jav­a:100)
at org.postgresql.core­.QueryExecutor.execu­te(QueryExecutor.jav­a:43)
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.execute(Abstrac­tJdbc1State
ment.java:517)
at
org.postgresql.jdbc­2.AbstractJdbc2State­ment.execute(Abstrac­tJdbc2State
ment.java:50)
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.executeQuery(Ab­stractJdbc1
Statement.java:233)­
at
org.postgresql.jdbc­1.AbstractJdbc1State­ment.executeQuery(Ab­stractJdbc1
Statement.java:221)­
at
org.apache.commons.­dbcp.DelegatingState­ment.executeQuery(De­legatingSta
tement.java:205)
at
com.ourdomain.ourap­p.AccessPortal.getUs­erData(AccessPortal.­java:126)
at
com.ourdomain.ourap­p.AccessPortal.proce­ssRequest(AccessPort­al.java:71)
at com.ourdomain.ourap­p.AccessPortal.doGet­(AccessPortal.java:8­8)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:689­)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:802­)
at
org.apache.catalina­.core.ApplicationFil­terChain.internalDoF­ilter(Appli
cationFilterChain.j­ava:237)
at
org.apache.catalina­.core.ApplicationFil­terChain.doFilter(Ap­plicationFi
lterChain.java:157)­
at
org.apache.catalina­.core.StandardWrappe­rValve.invoke(Standa­rdWrapperVa
lve.java:214)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardContex­tValve.invokeInterna­l(StandardC
ontextValve.java:19­8)
at
org.apache.catalina­.core.StandardContex­tValve.invoke(Standa­rdContextVa
lve.java:152)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.authenticator.Authe­nticatorBase.invoke(­Authenticat
orBase.java:540)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardHostVa­lve.invoke(StandardH­ostValve.ja
va:137)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.valves.ErrorReportV­alve.invoke(ErrorRep­ortValve.ja
va:118)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardEngine­Valve.invoke(Standar­dEngineValv
e.java:109)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.ContainerBase.­invoke(ContainerBase­.java:929)
at
org.apache.coyote.t­omcat5.CoyoteAdapter­.service(CoyoteAdapt­er.java:160
)
at
org.apache.coyote.h­ttp11.Http11Processo­r.process(Http11Proc­essor.java:
799)
at
org.apache.coyote.h­ttp11.Http11Protocol­$Http11ConnectionHan­dler.proces
sConnection(Http11P­rotocol.java:705)
at
org.apache.tomcat.u­til.net.TcpWorkerThr­ead.runIt(PoolTcpEnd­point.java:
577)
at
org.apache.tomcat.u­til.threads.ThreadPo­ol$ControlRunnable.r­un(ThreadPo
ol.java:683)
at java.lang.Thread.ru­n(Thread.java:595)
End of Stack Trace

at
com.ourdomain.ourap­p.AccessPortal.getUs­erData(AccessPortal.­java:190)
at
com.ourdomain.ourap­p.AccessPortal.proce­ssRequest(AccessPort­al.java:71)
at com.ourdomain.ourap­p.AccessPortal.doGet­(AccessPortal.java:8­8)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:689­)
at javax.servlet.http.­HttpServlet.service(­HttpServlet.java:802­)
at
org.apache.catalina­.core.ApplicationFil­terChain.internalDoF­ilter(Appli
cationFilterChain.j­ava:237)
at
org.apache.catalina­.core.ApplicationFil­terChain.doFilter(Ap­plicationFi
lterChain.java:157)­
at
org.apache.catalina­.core.StandardWrappe­rValve.invoke(Standa­rdWrapperVa
lve.java:214)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardContex­tValve.invokeInterna­l(StandardC
ontextValve.java:19­8)
at
org.apache.catalina­.core.StandardContex­tValve.invoke(Standa­rdContextVa
lve.java:152)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.authenticator.Authe­nticatorBase.invoke(­Authenticat
orBase.java:540)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardHostVa­lve.invoke(StandardH­ostValve.ja
va:137)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.valves.ErrorReportV­alve.invoke(ErrorRep­ortValve.ja
va:118)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:102)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.StandardEngine­Valve.invoke(Standar­dEngineValv
e.java:109)
at
org.apache.catalina­.core.StandardValveC­ontext.invokeNext(St­andardValve
Context.java:104)
at
org.apache.catalina­.core.StandardPipeli­ne.invoke(StandardPi­peline.java
:520)
at
org.apache.catalina­.core.ContainerBase.­invoke(ContainerBase­.java:929)
at
org.apache.coyote.t­omcat5.CoyoteAdapter­.service(CoyoteAdapt­er.java:160
)
at
org.apache.coyote.h­ttp11.Http11Processo­r.process(Http11Proc­essor.java:
799)
at
org.apache.coyote.h­ttp11.Http11Protocol­$Http11ConnectionHan­dler.proces
sConnection(Http11P­rotocol.java:705)
at
org.apache.tomcat.u­til.net.TcpWorkerThr­ead.runIt(PoolTcpEnd­point.java:
577)
at
org.apache.tomcat.u­til.threads.ThreadPo­ol$ControlRunnable.r­un(ThreadPo
ol.java:683)
at java.lang.Thread.ru­n(Thread.java:595)


I haven't been able to find any matches for this problem on the
internet, so I'm posting here hoping someone is aware of the problem.

There is a release pg74.216.jdbc3.jar,­ I can't find a changelog for
it and builds 213-216, anyone know? It may be that these include a
bug fix. I'm checking pg74.216.jdbc3.jar on a development server, so
will probably try this next.

Thanks,
Ed


-------------------­--------(end of broadcast)---------­------------------
TIP 4: Have you searched our list archives?

http://archives.pos­tgresql.org

Add comment
Markus Schaber 18 April 2006 15:00:30 [ permanent link ]
 Hi, Ed,

Ed Blackmore wrote:
I'm having trouble with a tomcat-postgres installation. Server 1 runs > postgresql and tomcat, server 2 has an identical tomcat installation > and application code running (except rebranding). Server 2 has errors > about every week with 'connection reset' in logs/appname.date.l­og, > futher connection attempts have a 'broken pipe' error.

So it seems that the network connection breaks from time to time.
Independently from making your application more robust, you might want
to put some research into that.
The solution to get the app running again is to restart tomcat.

There was a thread here some days ago with the title "No automatic
reconnect after network error", you might have a look there.


If you're using the tomcat connection pooling, my proposed solution
there might help you:

| At least JBoss, you can use the following approach: In the Datasource
| definition, put the following:
|
| <datasources>
| <no-tx-datasource>
| <jndi-name>boo</jnd­i-name>
| <connection-url>jdb­c:p­ostgresql://local­host:5432/bar</conne­ction-url>
| [ ... other attributes ... ]
| <new-connection-sql­>SELECT version()</new-conn­ection-sql>
| <check-valid-connec­tion-sql>SELECT
| version()</check-va­lid-connection-sql>
| </no-tx-datasource>­
| </datasources>
|
| This validates the connection before it is handed out on the
| application, and throws away invalid connections. Be aware that the SQL
| is case sensitive, we had a problem with earlier versions of OpenMDX/CRX
| that had upper case letters in the tags so they were ignored by jboss.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepaten­ts.org

-------------------­--------(end of broadcast)---------­------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Add comment
Ed Blackmore 19 April 2006 21:21:58 [ permanent link ]
 Hi Markus,

Thankyou for your assistance.
So it seems that the network connection breaks from time to time> Independently from making your application more robust, you might want> to put some research into that.

Yes, I put a minutely ping script in place, which wasn't able to
detect a failure at a time when the connection was lost. The servers
are dedicated server (installed and hosted by another company), so
I've been trying to detect any outages to report to them.
If you're using the tomcat connection pooling, my proposed solution> there might help you

Thanks, I tried the following settings based on your idea looking for
similar tomcat settings on google:

In webapps/ourapp/META­-INF/context.ml, adding:
<parameter>
<name>testOnBorrow<­/name>
<value>true</value>­
</parameter>
<parameter>
<name>testOnReturn<­/name>
<value>true</value>­
</parameter>
<parameter>
<name>validationQue­ry</name>
<value>select version()</value>
</parameter>

I wasn't able to nicely induce the error through our firewall or
taking connections down, but restarting postgresql did lead to a
broken pipe error. The above fix didn't help in this scenerio.

Reading other posts it seems that the jdbc driver is not expected to
reopen connections, therefore it doesn't seem using a newer version
will help. Given that our tomcat app doesn't reconnect to a
postgresql db after it (the database) has been restarted, is it
correct I need to work with the app developer as to how we use the
connection pool, or are there configuration changes that can help?

Regards,
Ed


-------------------­--------(end of broadcast)---------­------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresq­l.org so that your
message can get through to the mailing list cleanly

Add comment
Oliver Jowett 20 April 2006 05:08:32 [ permanent link ]
 Ed Blackmore wrote:> Hi Markus, >
Thankyou for your assistance.>
So it seems that the network connection breaks from time to time>>Independently­ from making your application more robust, you might want>>to put some research into that. >
Yes, I put a minutely ping script in place, which wasn't able to > detect a failure at a time when the connection was lost. The servers > are dedicated server (installed and hosted by another company), so > I've been trying to detect any outages to report to them.

One common cause of connection loss is if there is a stateful firewall
or NAT between your client and server .. if the firewall loses the
connection state for some reason (e.g. if the connection goes idle for a
while and the firewall times it out, or if the firewall is restarted),
then the connection will break.

-O

-------------------­--------(end of broadcast)---------­------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Add comment
Markus Schaber 20 April 2006 11:46:26 [ permanent link ]
 Hi, Ed,

Ed Blackmore wrote:
I wasn't able to nicely induce the error through our firewall or > taking connections down, but restarting postgresql did lead to a > broken pipe error. The above fix didn't help in this scenerio.>
Reading other posts it seems that the jdbc driver is not expected to > reopen connections, therefore it doesn't seem using a newer version > will help. Given that our tomcat app doesn't reconnect to a > postgresql db after it (the database) has been restarted, is it > correct I need to work with the app developer as to how we use the > connection pool, or are there configuration changes that can help?

Yes, that's true.

My workaround protects against a pool handing out broken connections[1],
but the Application still must get a fresh connection ittself.

Most JSP pages and Servlets I've seen get such a connection on every
incoming request, most Servlets I've written refresh their connection
when an appropriate SQL exception happens.

I think that this is the way your app has to be modified - refresh the
SQL connection in case of an Exception.



HTH,
Markus

[1] Before java 1.6, the pool has no (easy and portable) way to tell
whether a connection is still valid.

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepaten­ts.org

-------------------­--------(end of broadcast)---------­------------------
TIP 5: don't forget to increase your free space map settings

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > PostgreSQL database development > connection reset error, followed by broken pipe (pg74.213.jdbc3.jar­) 20 April 2006 11:46:26
see also:
How to make fonts a bit taller (not…
Finding page position of an image
Page events question
пройди тесты:
see also:
A new type of computer monitor
Employee Monitoring software review…
Review on Any DVD Cloner
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .