JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » Microsoft SQL Server  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to postflat modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 sql 2005出現connect reset之問題
supercpu1000





發文: 1
積分: 0
於 2008-11-06 03:05 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
各位好:

小弟的環境是Windows 2003 R2 SP2+ SQL 2005
JVM為jdk1.4.2_08
jdbc為1.2版
之前小弟使用small business沒有什麼錯誤訊息,自從DB升級到SQL 2005 STD之後,最近就常在半夜出現Connection reset等錯誤訊息,已經多次發生系統半夜產生聯節中斷問題
造成整個agentflow client端無法登入 ,不知道是什麼原因?

以下是擷取的錯誤訊息:
---------------------------------------------------------------------------------------------------------------------------------------------------------------

@{2008/10/16 星期四 04:30:11} {錯誤} {objectbroker.i} {MSSQLAdapter:loadValue error : I/O Error: Connection reset
java.sql.SQLException: I/O Error: Connection reset
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
  at objectbroker.i.c(Unknown Source)
  at pase.server.b.b(Unknown Source)
  at pase.server.b.a(Unknown Source)
  at pase.server.cron.j.b(Unknown Source)
  at pase.server.cron.a.run(Unknown Source)
  at pase.server.fc.runIt(Unknown Source)
  at org.apache.jcs.utils.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:638)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.SocketException: Connection reset
  at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
  at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  at java.io.DataOutputStream.write(DataOutputStream.java:85)
  at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
  at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
  at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
  ... 10 more
}
@{2008/10/16 星期四 04:30:11} {錯誤} {objectbroker.i} {sql:SELECT Name FROM Company}
@{2008/10/16 星期四 04:30:11} {執行} {java.lang.Class} {SQLException: SQLState=[08S01], ErrorCode=[0]}
@{2008/10/16 星期四 04:30:11} {訊息} {objectbroker.i} {Driver Name:  jTDS Type 4 JDBC Driver for MS SQL Server and Sybase}
@{2008/10/16 星期四 04:30:11} {訊息} {objectbroker.i} {Driver Version:  1.2}
@{2008/10/16 星期四 04:30:11} {訊息} {objectbroker.i} {Database:    jdbc:jtds:sqlserver://192.168.x.x:1433/BPM;}
@{2008/10/16 星期四 04:30:11} {訊息} {objectbroker.i} {Database Product Name:  Microsoft SQL Server}
@{2008/10/16 星期四 04:30:11} {訊息} {objectbroker.i} {Database Product Version:  09.00.1399}
@{2008/10/16 星期四 04:30:12} {執行} {pase.server.RMIServer} {啟動流程: [administrator] [發信系統通知][Tsk000001436657][Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {[0:00:00.137] RMIServer:InitRootProcess END [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {開始 [Server PreAction][PRO00011216777383812][自動通知考勤異常], [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {結束 [Server PreAction][PRO00011216777383812][自動通知考勤異常], [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {[0:00:00.012] RMIServer:PreAction END [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {Start Task : Tsk000001436658, [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {[0:00:00.006] RMIServer:StartTask END [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {執行} {pase.server.RMIServer} {開始 [Server Action][PRO00011216777383812][自動通知考勤異常], [Thread[Td.5,1,main]][28175024]}
@{2008/10/16 星期四 04:30:13} {INFO} {root} {All threads are busy, waiting. status Thread Current : 20 Thread Max : 20}

@{2008/10/16 星期四 05:30:53} {錯誤} {objectbroker.i} {MSSQLAdapter:loadValue error : I/O Error: Connection reset
java.sql.SQLException: I/O Error: Connection reset
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
  at objectbroker.i.c(Unknown Source)
  at objectbroker.e.h(Unknown Source)
  at objectbroker.e.gd(Unknown Source)
  at objectbroker.e.pb(Unknown Source)
  at objectbroker.DBManager.zb(Unknown Source)
  at pase.server.xb.vc(Unknown Source)
  at pase.server.RMIServer.getMemberAccess(RMIServer.java:7356)
  at pase.server.RMIServer.doLogin(RMIServer.java:1193)
  at pase.server.RMIServer.doLogin(RMIServer.java:1143)
  at pase.server.RMIServer.login(RMIServer.java:10068)
  at pase.server.UtilityServiceImpl.login(UtilityServiceImpl.java:105)
  at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
  at sun.rmi.transport.Transport$1.run(Transport.java:148)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.SocketException: Connection reset
  at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
  at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  at java.io.DataOutputStream.write(DataOutputStream.java:85)
  at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
  at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
  at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
  ... 23 more
}
@{2008/10/16 星期四 05:30:53} {錯誤} {objectbroker.i} {sql:SELECT Task, Process, Monitor, Message, Bbs, OnLineUser, TaskSearch, TaskSearchAll, TaskSearchView, ArtiSearch, ArtiSearchAll, ArtiSearchView, Schedule, ScheduleAll, ScheduleView FROM Mem_Right WHERE MemID='MEM11211110356305250'}
@{2008/10/16 星期四 05:30:53} {執行} {java.lang.Class} {SQLException: SQLState=[08S01], ErrorCode=[0]}
@{2008/10/16 星期四 05:30:53} {訊息} {objectbroker.i} {Driver Name:  jTDS Type 4 JDBC Driver for MS SQL Server and Sybase}
@{2008/10/16 星期四 05:30:53} {訊息} {objectbroker.i} {Driver Version:  1.2}
@{2008/10/16 星期四 05:30:53} {訊息} {objectbroker.i} {Database:    jdbc:jtds:sqlserver://192.168.x.x:1433/BPM;}
@{2008/10/16 星期四 05:30:53} {訊息} {objectbroker.i} {Database Product Name:  Microsoft SQL Server}
@{2008/10/16 星期四 05:30:53} {訊息} {objectbroker.i} {Database Product Version:  09.00.1399}
@{2008/10/16 星期四 05:30:53} {執行} {pase.server.RMIServer} {使用者登入:cjcheng}
@{2008/10/16 星期四 05:30:53} {錯誤} {objectbroker.i} {MSSQLAdapter:updateValue error : I/O Error: Connection reset
java.sql.SQLException: I/O Error: Connection reset
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:478)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)
  at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)
  at objectbroker.i.d(Unknown Source)
  at objectbroker.b.bb(Unknown Source)
  at objectbroker.b.rc(Unknown Source)
  at objectbroker.b.p(Unknown Source)
  at objectbroker.b.b(Unknown Source)
  at objectbroker.DBManager.b(Unknown Source)
  at pase.server.xb.b(Unknown Source)
  at pase.server.RMIServer.addSSORecord(RMIServer.java:10712)
  at pase.server.UtilityServiceImpl.addSSORecord(UtilityServiceImpl.java:566)
  at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
  at sun.rmi.transport.Transport$1.run(Transport.java:148)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
  at java.lang.Thread.run(Thread.java:534)
Caused by: java.net.SocketException: Connection reset
  at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
  at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  at java.io.DataOutputStream.write(DataOutputStream.java:85)
  at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
  at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
  at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
  at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
  ... 23 more


reply to postreply to post
話題樹型展開
人氣 標題 作者 字數 發文時間
3433 sql 2005出現connect reset之問題 supercpu1000 9090 2008-11-06 03:05
2295 Re:sql 2005出現connect reset之問題 simontiis 224 2008-12-10 16:47
» JWorld@TW »  JDBC/SQL討論區 » Microsoft SQL Server

reply to postflat modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8