How to approach a Got minus one from a read call error when connecting to an Amazon RDS Oracle instance

Question

I m running Oracle 11GR2 on an Amazon RDS instance  occasionally I get an IO Error  Got minus one from a read call when making a call to DriverManager getConnection getUrl    and I m not sure why  Other applications work correctly    To further confuse things  the error will correct itself on occasion  following next iteration of the program     How should I approach a  Got minus one from a read call  error   Full stack trace    java sql SQLRecoverableException  IO Error  Got minus one from a read call     at oracle jdbc driver T4CConnection logon T4CConnection java 489      at oracle jdbc driver PhysicalConnection  lt init gt  PhysicalConnection java 553      at oracle jdbc driver T4CConnection  lt init gt  T4CConnection java 254      at oracle jdbc driver T4CDriverExtension getConnection T4CDriverExtension java 32      at oracle jdbc driver OracleDriver connect OracleDriver java 528      at java sql DriverManager getConnection DriverManager java 579      at java sql DriverManager getConnection DriverManager java 243      at com cwd facile db Database  lt init gt  Database java 44      at com cwd facile ns NetSuiteRequestBased  lt init gt  NetSuiteRequestBased java 29      at com cwd facile ns CommonOperations isInventoryItem CommonOperations java 205      at com cwd facile ns CommonOperations findItemIdByName CommonOperations java 188      at com cwd facile ns CommonOperations createSalesOrder CommonOperations java 970      at com cwd facile Main main Main java 47  Caused by  oracle net ns NetException  Got minus one from a read call     at oracle net ns Packet receive Packet java 311      at oracle net ns NSProtocol connect NSProtocol java 300      at oracle jdbc driver T4CConnection connect T4CConnection java 1140      at oracle jdbc driver T4CConnection logon T4CConnection java 340          12 more   Database java line 44  setConn DriverManager getConnection getUrl       Other info     I thought it was a bad JDBC url  but it does work  sometimes for days on end before failing   Amazon RDS is a managed instance and configuration changes may not be possible I am using ojdbc6 jar for connectivity

User · Answer

We faced the same issue and fixed it  Below is the reason and solution   Problem  When the connection pool mechanism is used  the application server  in our case  it is JBOSS  creates connections according to the min-connection parameter  If you have 10 applications running  and each has a min-connection of 10  then a total of 100 sessions will be created in the database  Also  in every database  there is a max-session parameter  if your total number of connections crosses that border  then you will get Got minus one from a read call   FYI  Use the query below to see your total number of sessions   SELECT username  count username  FROM v session  WHERE username IS NOT NULL group by username   Solution  With the help of our DBA  we increased that max-session parameter  so that all our application min-connection can accommodate

User · Answer

I would like to augment to Stephen C s answer  my case was on the first dot  So since we have DHCP to allocate IP addresses in the company  DHCP changed my machine s address without of course asking neither me nor Oracle  So out of the blue oracle refused to do anything and gave the minus one dreaded exception  So if you want to workaround this once and for ever  and since TCP INVITED NODES of SQLNET ora file does not accept wildcards as stated here  you can add you machine s hostname instead of the IP address

User · Answer

The immediate cause of the problem is that the JDBC driver has attempted to read from a network Socket that has been closed by  the other end    This could be due to a few things    If the remote server has been configured  e g  in the  SQLNET ora  file  to not accept connections from your IP  If the JDBC url is incorrect  you could be attempting to connect to something that isn t a database  If there are too many open connections to the database service  it could refuse new connections    Given the symptoms  I think the  too many connections  scenario is the most likely   That suggests that your application is leaking connections  i e  creating connections and then failing to  always  close them

User · Answer

in my case  I got the same exception because the user that I configured in the app did not existed in the DB  creating the user and granting needed permissions solved the problem

User · Answer

I got this error message from using an oracle database in a docker despite the fact i had  publish port to host option  quot -p 1521 1521 quot     I was using jdbc url that was using  ip address 127 0 0 1   i changed it to the host machine real ip address and everything worked then

[java] How to approach a "Got minus one from a read call" error when connecting to an Amazon RDS Oracle instance

Examples related to java

Examples related to oracle