|
From: jose l. f. d. <jos...@ho...> - 2020-11-24 18:21:56
|
Hi, Client gone stalled for 30 minutes while writing. This is the log: 2020-11-23 21:20:29,651 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:25:29,710 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:30:29,783 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:35:29,848 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:40:29,944 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-23 21:45:30,024 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:27:00,644 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:27:00,981 [Session Connection Keep-Alive (FACC)] 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-11-24 08:32:01,014 [Session Connection Keep-Alive (FACC)] 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-11-24 08:37:01,022 [Session Connection Keep-Alive (FACC)] ERROR net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - run: unexpected exception while executing sql (select 1 from dual 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-11-24 08:42:01,025 [Session Connection Keep-Alive (FACC)] 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-11-24 08:46:30,821 [Thread-2] 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-11-24 08:46:33,470 [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.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) 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-11-24 08:46:34,307 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Successfully restored database meta data 2020-11-24 08:46:34,309 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:51:34,409 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 08:53:29,010 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.parser.ParserEventsProcessor$$Lambda$186/1854716438@784a69bf,notifier=null,catchExceptions=false,when=1606204409009] on sun.awt.windows.WToolkit@5578757b net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 8, column 66. Encountered: <EOF> after : "\'100469351\nminus\nselect cta_facturac, cod_factura, cod_factreal, tot_baseimpo_e, tot_impemi, COD_LOCSEGREGADA, cod_causaemi from PFA_PCOBFACTMES_NUBICO \n\n\n\n\ninsert into PFA_PCOBFACTMES_NUBICO select * from PFA_PCOBFACTMES" at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:4572) at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:21414) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_66(CCJSqlParser.java:17638) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_139(CCJSqlParser.java:18005) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_253(CCJSqlParser.java:18082) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_137(CCJSqlParser.java:18246) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_59(CCJSqlParser.java:18329) at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_59(CCJSqlParser.java:14315) at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:7079) at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:7060) at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:7031) at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:6028) at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:3614) at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3787) at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:3469) at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:3462) at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:119) at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:70) at net.sourceforge.squirrel_sql.client.session.parser.kernel.JSqlParserAdapter.executeParsing(JSqlParserAdapter.java:31) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread._onParse(ParserThread.java:100) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.onParse(ParserThread.java:68) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.lambda$parseInBackground$1(ParserThread.java:59) 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) 2020-11-24 08:53:30,759 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.client.session.parser.ParserEventsProcessor$$Lambda$186/1854716438@2aad8431,notifier=null,catchExceptions=false,when=1606204410757] on sun.awt.windows.WToolkit@5578757b net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 8, column 66. Encountered: <EOF> after : "\'100469351\nminus\nselect cta_facturac, cod_factura, cod_factreal, tot_baseimpo_e, tot_impemi, COD_LOCSEGREGADA, cod_causaemi from PFA_PCOBFACTMES_NUBICO \n\n\n\n\ninsert into PFA_PCOBFACTMES_NUBICO select * from PFA_PCOBFACTMES" at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:4572) at net.sf.jsqlparser.parser.CCJSqlParser.jj_scan_token(CCJSqlParser.java:21414) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_66(CCJSqlParser.java:17638) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_139(CCJSqlParser.java:18005) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_253(CCJSqlParser.java:18082) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3R_137(CCJSqlParser.java:18246) at net.sf.jsqlparser.parser.CCJSqlParser.jj_3_59(CCJSqlParser.java:18329) at net.sf.jsqlparser.parser.CCJSqlParser.jj_2_59(CCJSqlParser.java:14315) at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:7079) at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:7060) at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:7031) at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:6028) at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:3614) at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3787) at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:3469) at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:3462) at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:119) at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:70) at net.sourceforge.squirrel_sql.client.session.parser.kernel.JSqlParserAdapter.executeParsing(JSqlParserAdapter.java:31) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread._onParse(ParserThread.java:100) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.onParse(ParserThread.java:68) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.lambda$parseInBackground$1(ParserThread.java:59) 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) 2020-11-24 08:56:34,493 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 09:01:33,571 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual 2020-11-24 09:06:33,370 [Thread-4] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual |
