Обсуждение: Please Help JDBC Error!!
Hi I have been using postgres database since last 7 months working on a involving JBoss server as an application server and postgres database at backend lately.. i noticed as the database started growing larger.. today encountered some error while firing this query select firstname , last name from mycustomers where firstname between 'A%' and 'Z%' the above query returns 6000 + records ;-) I am using PostgreSQL 7.1.2 and JBoss2.2.2 with jetty 3.1 The error stack trace is : [Jetty] An I/O error occured while reading from backend - Exception: java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream read Stack Trace: java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream read at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181) at org.postgresql.Connection.ExecSQL(Connection.java:473) at org.postgresql.jdbc2.Statement.execute(Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1 08) at org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat ementInPool.java:71) at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab aseServerLoginModule.java:94) at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo rdLoginModule.java:82) at java.lang.reflect.Method.invoke(Native Method) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528) at javax.security.auth.login.LoginContext.login(LoginContext.java:449) at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana ger.java:333) at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana ger.java:301) at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j ava:193) at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) at com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler. java:259) at com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler .java:192) at com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163) at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) at com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107) at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) at java.lang.Thread.run(Unknown Source) End of Stack Trace [Jetty] at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184) [Jetty] at org.postgresql.Connection.ExecSQL(Connection.java:473) [Jetty] at org.postgresql.jdbc2.Statement.execute(Statement.java:294) [Jetty] at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) [Jetty] at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1 08) [Jetty] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat ementInPool.java:71) [Jetty] at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab aseServerLoginModule.java:94) [Jetty] at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo rdLoginModule.java:82) [Jetty] at java.lang.reflect.Method.invoke(Native Method) [Jetty] at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) [Jetty] at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) [Jetty] at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) [Jetty] at java.security.AccessController.doPrivileged(Native Method) [Jetty] at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528) [Jetty] at javax.security.auth.login.LoginContext.login(LoginContext.java:449) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana ger.java:333) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana ger.java:301) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j ava:193) [Jetty] at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler. java:259) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler .java:192) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163) [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) [Jetty] at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) [Jetty] at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) [Jetty] at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) [Jetty] at com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107) [Jetty] at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) [Jetty] at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) [Jetty] at java.lang.Thread.run(Unknown Source) I guess this is a jdbc error and i am stuck without the problem solved.. is there any body who has faced this kind of problem yet.. and do you have a probable solution please let me know Cheers :-) Binoy Rishabh Software (India)
Hi, First of call can you make sure you are using the latest source. There are binaries at http://jdbc.fastcrypt.com Second, my instincts are telling me that there is some sort of overflow occurring with 6k records. Is there some way to reduce the size of the resultset? Dave -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Binoy Sent: July 30, 2001 11:48 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Please Help JDBC Error!! Hi I have been using postgres database since last 7 months working on a involving JBoss server as an application server and postgres database at backend lately.. i noticed as the database started growing larger.. today encountered some error while firing this query select firstname , last name from mycustomers where firstname between 'A%' and 'Z%' the above query returns 6000 + records ;-) I am using PostgreSQL 7.1.2 and JBoss2.2.2 with jetty 3.1 The error stack trace is : [Jetty] An I/O error occured while reading from backend - Exception: java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream read Stack Trace: java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream read at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181) at org.postgresql.Connection.ExecSQL(Connection.java:473) at org.postgresql.jdbc2.Statement.execute(Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.ja va:1 08) at org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(Prepared Stat ementInPool.java:71) at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(D atab aseServerLoginModule.java:94) at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePa sswo rdLoginModule.java:82) at java.lang.reflect.Method.invoke(Native Method) at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:52 8) at javax.security.auth.login.LoginContext.login(LoginContext.java:449) at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurity Mana ger.java:333) at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurity Mana ger.java:301) at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManag er.j ava:193) at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) at com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHand ler. java:259) at com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHan dler .java:192) at com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163 ) at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) at com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107 ) at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) at java.lang.Thread.run(Unknown Source) End of Stack Trace [Jetty] at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184) [Jetty] at org.postgresql.Connection.ExecSQL(Connection.java:473) [Jetty] at org.postgresql.jdbc2.Statement.execute(Statement.java:294) [Jetty] at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) [Jetty] at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.ja va:1 08) [Jetty] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(Prepared Stat ementInPool.java:71) [Jetty] at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(D atab aseServerLoginModule.java:94) [Jetty] at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePa sswo rdLoginModule.java:82) [Jetty] at java.lang.reflect.Method.invoke(Native Method) [Jetty] at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) [Jetty] at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) [Jetty] at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) [Jetty] at java.security.AccessController.doPrivileged(Native Method) [Jetty] at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:52 8) [Jetty] at javax.security.auth.login.LoginContext.login(LoginContext.java:449) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurity Mana ger.java:333) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurity Mana ger.java:301) [Jetty] at org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManag er.j ava:193) [Jetty] at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHand ler. java:259) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHan dler .java:192) [Jetty] at com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163 ) [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) [Jetty] at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) [Jetty] at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) [Jetty] at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) [Jetty] at com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107 ) [Jetty] at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) [Jetty] at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) [Jetty] at java.lang.Thread.run(Unknown Source) I guess this is a jdbc error and i am stuck without the problem solved.. is there any body who has faced this kind of problem yet.. and do you have a probable solution please let me know Cheers:-) Binoy Rishabh Software (India) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Binoy, What would be more informative is what error was reported on the postgresql server (I am assuming you have logging for the server enabled). This JDBC client trace only indicates that the server dropped the socket connection. The real issue is why the server did that. thanks, --Barry Binoy wrote: > Hi > I have been using postgres database since last 7 months working on a > involving JBoss server as an application server and postgres database at > backend lately.. i noticed as the database started growing larger.. today > encountered some error while firing this query > > select firstname , last name from mycustomers where firstname between 'A%' > and 'Z%' > > the above query returns 6000 + records ;-) > > I am using PostgreSQL 7.1.2 and JBoss2.2.2 with jetty 3.1 > > The error stack trace is : > [Jetty] An I/O error occured while reading from backend - Exception: > java.net.SocketException: Connection reset by peer: JVM_recv in socket input > stream read > Stack Trace: > > java.net.SocketException: Connection reset by peer: JVM_recv in socket input > stream read > at java.net.SocketInputStream.socketRead(Native Method) > at java.net.SocketInputStream.read(Unknown Source) > at java.io.BufferedInputStream.fill(Unknown Source) > at java.io.BufferedInputStream.read(Unknown Source) > at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:181) > at org.postgresql.Connection.ExecSQL(Connection.java:473) > at org.postgresql.jdbc2.Statement.execute(Statement.java:294) > at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) > at > org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1 > 08) > at > org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat > ementInPool.java:71) > at > org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab > aseServerLoginModule.java:94) > at > org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo > rdLoginModule.java:82) > at java.lang.reflect.Method.invoke(Native Method) > at javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) > at javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) > at javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) > at java.security.AccessController.doPrivileged(Native Method) > at > javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528) > at javax.security.auth.login.LoginContext.login(LoginContext.java:449) > at > org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana > ger.java:333) > at > org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana > ger.java:301) > at > org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j > ava:193) > at org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) > at > com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler. > java:259) > at > com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler > .java:192) > at > com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163) > at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) > at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) > at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) > at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) > at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) > at > com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107) > at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) > at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) > at java.lang.Thread.run(Unknown Source) > End of Stack Trace > > [Jetty] at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:184) > [Jetty] at org.postgresql.Connection.ExecSQL(Connection.java:473) > [Jetty] at org.postgresql.jdbc2.Statement.execute(Statement.java:294) > [Jetty] at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59) > [Jetty] at > org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:1 > 08) > [Jetty] at > org.opentools.minerva.jdbc.PreparedStatementInPool.executeQuery(PreparedStat > ementInPool.java:71) > [Jetty] at > org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(Datab > aseServerLoginModule.java:94) > [Jetty] at > org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswo > rdLoginModule.java:82) > [Jetty] at java.lang.reflect.Method.invoke(Native Method) > [Jetty] at > javax.security.auth.login.LoginContext.invoke(LoginContext.java:595) > [Jetty] at > javax.security.auth.login.LoginContext.access$000(LoginContext.java:125) > [Jetty] at > javax.security.auth.login.LoginContext$3.run(LoginContext.java:531) > [Jetty] at java.security.AccessController.doPrivileged(Native Method) > [Jetty] at > javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:528) > [Jetty] at > javax.security.auth.login.LoginContext.login(LoginContext.java:449) > [Jetty] at > org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityMana > ger.java:333) > [Jetty] at > org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityMana > ger.java:301) > [Jetty] at > org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.j > ava:193) > [Jetty] at > org.jboss.jetty.JBossUserRealm$User.authenticate(JBossUserRealm.java:46) > [Jetty] at > com.mortbay.HTTP.Handler.SecurityHandler.basicAuthenticated(SecurityHandler. > java:259) > [Jetty] at > com.mortbay.HTTP.Handler.SecurityHandler.authenticatedInRole(SecurityHandler > .java:192) > [Jetty] at > com.mortbay.HTTP.Handler.SecurityHandler.handle(SecurityHandler.java:163) > [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:956) > [Jetty] at com.mortbay.HTTP.HandlerContext.handle(HandlerContext.java:913) > [Jetty] at com.mortbay.HTTP.HttpServer.service(HttpServer.java:703) > [Jetty] at com.mortbay.HTTP.HttpConnection.service(HttpConnection.java:508) > [Jetty] at com.mortbay.HTTP.HttpConnection.handle(HttpConnection.java:347) > [Jetty] at > com.mortbay.HTTP.SocketListener.handleConnection(SocketListener.java:107) > [Jetty] at com.mortbay.Util.ThreadedServer.handle(ThreadedServer.java:294) > [Jetty] at > com.mortbay.Util.ThreadPool$PoolThreadRunnable.run(ThreadPool.java:613) > [Jetty] at java.lang.Thread.run(Unknown Source) > > I guess this is a jdbc error and i am stuck without the problem solved.. is > there any body who has faced this kind of problem yet.. and do you have a > probable solution please let me know > > Cheers :-) > > Binoy > > Rishabh Software > (India) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > >