Oracle Error 17410 Java.sql.sqlexception
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
SQLException 17410 No more data from socket Oracle Database Tips by Burleson Consulting April 13, 2016 Question: What does the SQL exception 17410 error mean? I get this error intermittently in JDBC. java.sql.SQLException 17410 No more data from socket What is the fix and solution for this error? Answer: The "no more data from socket" error is sometimes caused by a bug and it is related to the client software (JDBC driver) and not a database problem. The no more data from socket error can also mean that the shadow process crashed, often with an ORA-00600 or ORA-07445 error. Also upgrade to the latest release of the JDBC driver. In Oracle 11gR1 this "no data from socket" is a hidden parameter issue with bind variable peeking, and you should make this change after contacting Oracle technical support: alter system set "_optim_peek_user_binds"=false scope=both; See my notes on bind variable peeking You should check both the "udump" and "bdump" directories for any trace files that were generated with this error and check your alert log for messages. The " No more data to read from socket" and the alert log specifies "Address not mapped to object"... was related specifically to selecting from a view, whose select statement had a column select, which used DISTINCT (using UNIQUE in that select caused the same issue). This "no more data from socket" error may also be because your database doesn't support connection sharing (shared servers, a.k.a. the multithreadedThis Site Careers Other all forums Forum: JDBC and Relational Databases java.sql.SQLRecoverableException: No more data to read from socket Tapan Prajapati Greenhorn Posts: 27 posted 4 years ago public class Orajdbc { public static void main(String args[]) throws Exception { Connection con = null; http://www.dba-oracle.com/t_sqlexception_17410_no_more_data.htm Class.forName ("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1522:orcl", "scott", "tiger"); // @//machineName:port/SID, userid, password try { Statement stmt = (Statement) conn.createStatement(); try { ResultSet rset = stmt.executeQuery("select emp_no from employee"); try { while (rset.next()) System.out.println (rset.getString(1)); // Print col https://coderanch.com/t/567161/JDBC/databases/java-sql-SQLRecoverableException-data-read 1 } finally { try { rset.close(); } catch (Exception ignore) {} } } finally { try { stmt.close(); } catch (Exception ignore) {} } } finally { try { conn.close(); } catch (Exception ignore) {} } } } Exception in thread "main" java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155) at oracle.jdbc.driver.T4C8TTIpro.receive(T4C8TTIpro.java:128) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1064) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) at oracle.jdbc.driver.PhysicalConnection.
Sign in Pricing Blog Support Search GitHub This repository Watch https://github.com/dnvriend/akka-persistence-jdbc/issues/9 7 Star 91 Fork 45 dnvriend/akka-persistence-jdbc Code Issues 5 Pull requests 1 Projects 0 Wiki Pulse Graphs New issue java.sql.SQLRecoverableException: No more http://www.websina.com/bugzero/errors/oracle-SQLException.html data to read from socket #9 Closed stevenrigbyS4N opened this Issue Dec 5, 2014 · 16 comments Projects None yet Labels None oracle error yet Milestone No milestone Assignees No one assigned 4 participants stevenrigbyS4N commented Dec 5, 2014 Hello, The project I'm currently working on uses akka cluster sharding with this plugin connected to an Oracle database. It works fine but after leaving the project running for oracle error 17410 some time or when the database is stopped it throws the following error and it is unable to recover: 2014/12/05 09:25:23.887 ERROR[t-dispatcher-14] s.StatementExecutor$$anon$1 81 --- SQL execution failed (Reason: No more data to read from socket): MERGE INTO USERSIS.snapshot snapshot USING (SELECT '/user/sharding/RequestIDRouterCoordinator/singleton/coordinator' AS persistence_id, 7 AS seq_nr from DUAL) val ON (snapshot.persistence_id = val.persistence_id and snapshot.sequence_nr = val.seq_nr) WHEN MATCHED THEN UPDATE SET snapshot='qAAAAKztAAVzcgAtYWtrYS5wZXJzaXN0ZW5jZS5zZXJpYWxpemF0aW9uLlNuYXBzaG90SGVhZGVyAAAAAAAAAAECAAJJAAxzZXJp... (1268)' WHEN NOT MATCHED THEN INSERT (PERSISTENCE_ID, SEQUENCE_NR, SNAPSHOT, CREATED) VALUES ('/user/sharding/RequestIDRouterCoordinator/singleton/coordinator', 7, 'qAAAAKztAAVzcgAtYWtrYS5wZXJzaXN0ZW5jZS5zZXJpYWxpemF0aW9uLlNuYXBzaG90SGVhZGVyAAAAAAAAAAECAAJJAAxzZXJp... (1268)', 1417789523876) 2014/12/05 09:25:23.888 ERROR[n-dispatcher-44] s.StatementExecutor$$anon$1 81 --- SQL execution failed (Reason: No more data to read from socket): DELETE FROM USERSIS.snapshot WHERE persistence_id = '/user/sharding/RequestIDRouterCoordinator/singleton/coordinator' AND sequence_nr = 7 [ERROR] [12/05/2014 09:25:23.889] [TokenCluster-akka.actor.default-dispatcher-14] [akka://TokenCluster/system/snapshot-store] No more data to read from socket java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4C
oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963) at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:375) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608) This error most likely occurs in applications that use a database connections pool. When the application checked out a connection that has been timed out or has been staled, and used it to connect to the database, this error occurs. You may need start your Oracle database server as well as your Java application. In a better designed system, however, the staled connection should be cleared out and a new connection should be establised automatically. * Reference brought to you by Bugzero, it's more than just bug tracking software!