|
From: jose l. f. d. <jos...@ho...> - 2020-08-24 22:46:31
|
Hi, When I was doing the client stalled from 20 minutes. This is the log: 2020-08-24 22:38:11,555 [Thread-2] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:38:11,571 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Excepción de E/S: Connection reset by peer: socket write error java.sql.SQLException: Excepción de E/S: Connection reset by peer: socket write error at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:820) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:78) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:43:11,626 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual ): Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:780) at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:756) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.createStatement(SQLConnection.java:277) at net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:74) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:46:00,725 [Thread-4] ERROR net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter - getErrorPosition: Unexpected exception - Conexión cerrada java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:977) at oracle.jdbc.driver.PhysicalConnection.prepareCall(PhysicalConnection.java:943) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.getErrorPosition(OracleExceptionFormatter.java:206) at net.sourceforge.squirrel_sql.plugins.oracle.exception.OracleExceptionFormatter.format(OracleExceptionFormatter.java:152) at net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68) at net.sourceforge.squirrel_sql.client.session.Session.formatException(Session.java:1195) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlExecutionException(SQLExecutionHandler.java:458) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleError(SQLExecuterTask.java:621) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.runDirect(SQLExecuterTask.java:264) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:137) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2020-08-24 22:46:02,976 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.fw.sql.SQLConnection - Error while closing connection java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.close(SQLConnection.java:122) at net.sourceforge.squirrel_sql.client.session.Session.closeSQLConnection(Session.java:548) at net.sourceforge.squirrel_sql.client.session.Session.reconnect(Session.java:588) at net.sourceforge.squirrel_sql.client.session.action.reconnect.ReconnectAction.actionPerformed(ReconnectAction.java:55) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.AbstractButton.doClick(AbstractButton.java:356) at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677) at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307) at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293) at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974) at javax.swing.JComponent.processKeyBindings(JComponent.java:2966) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) Caused by: java.lang.RuntimeException: java.sql.SQLException: Conexión cerrada at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:181) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection.lambda$close$0(SQLConnection.java:120) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: Conexión cerrada at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1195) at net.sourceforge.squirrel_sql.fw.sql.SQLConnection._closeIntern(SQLConnection.java:160) ... 6 more 2020-08-24 22:46:03,648 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Intro,keyChar=Intro,modifiers=Ctrl,extModifiers=Ctrl,keyLocation=KEY_LOCATION_STANDARD,rawCode=13,primaryLevelUnicode=13,scancode=28,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelRSyntaxTextArea[,0,0,1761x1640,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.basic.BasicBorders$MarginBorder@3aded2a0,flags=16777576,maximumSize=,minimumSize=,preferredSize=,caretColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],disabledTextColor=javax.swing.plaf.ColorUIResource[r=184,g=207,b=229],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=sun.swing.PrintColorUIResource[r=51,g=51,b=51],selectionColor=java.awt.Color[r=200,g=200,b=255],colums=0,columWidth=0,rows=0,rowHeight=20,word=true,wrap=false] java.lang.NullPointerException at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoUpdateCheck.<init>(SchemaInfoUpdateCheck.java:61) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.<init>(SQLExecuterTask.java:100) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.<init>(SQLExecutionHandler.java:77) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.executeSQL(SQLResultExecuterPanel.java:283) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.executeSQL(SQLResultExecuterPanel.java:258) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel.execute(SQLResultExecuterPanel.java:227) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel._runExecuter(SQLPanel.java:340) at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.runCurrentExecuter(SQLPanel.java:320) at net.sourceforge.squirrel_sql.client.session.SQLPanelAPI.executeCurrentSQL(SQLPanelAPI.java:479) at net.sourceforge.squirrel_sql.client.session.action.ExecuteSqlAction.actionPerformed(ExecuteSqlAction.java:56) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.AbstractButton.doClick(AbstractButton.java:356) at javax.swing.plaf.basic.BasicMenuItemUI$Actions.actionPerformed(BasicMenuItemUI.java:811) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668) at javax.swing.JComponent.processKeyBinding(JComponent.java:2882) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:699) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processBindingForKeyStrokeRecursive(JMenuBar.java:706) at javax.swing.JMenuBar.processKeyBinding(JMenuBar.java:677) at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:307) at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:293) at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2974) at javax.swing.JComponent.processKeyBindings(JComponent.java:2966) at javax.swing.JComponent.processKeyEvent(JComponent.java:2845) at java.awt.Component.processEvent(Component.java:6316) at java.awt.Container.processEvent(Container.java:2239) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800) at java.awt.Component.dispatchEventImpl(Component.java:4760) at java.awt.Container.dispatchEventImpl(Container.java:2297) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) 2020-08-24 22:46:04,231 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Successfully restored database meta data 2020-08-24 22:46:04,232 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:51:04,785 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-08-24 22:56:05,146 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual Regards, Jose Luis. |
