Oracle Database Is Hanging Infinitly in Update Queries

Oracle database is hanging infinitly in UPDATE queries

Most likely you have another open uncommitted transaction for the same set of records, so they are locked for that transaction.

And, most likely, you locked them, running the same UPDATE in another transaction.

Just Commit/rollback your transactions, you should be fine.

sql developer hangs on startup - what can I do?

Basing on this thread https://community.oracle.com/thread/2564842 I've created own solution.

1. Extract installation of current version SQL Developer (4.1.0.17.29)
2. At "c:\Users\MY_USER\AppData\Roaming\SQL Developer\"
   I've changed directory name system4.1.0.17.29 to system4.1.0.17.28.
3. After running newly extracted SQL Developer (4.1.0.17.29) I was prompted to let copy configuration from version 4.1.0.17.28 to 4.1.0.17.29 ;)
4. Everything works great now. I suppose that running the same (broken) installation after decreasing version could also help.

Grails' save(flush:true) hangs thread in socketRead0

Your stacktrace points at the likely problem:

oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8674)
   - locked oracle.jdbc.driver.T4CPreparedStatement@36df36e5
   - locked oracle.jdbc.driver.T4CConnection@788d1087

You have a stuck thread (or threads) on your database and the app is hanging waiting for the threads. You need to check your database status to see if you can determine which queries are hanging. It's all possible updating to the latest JDBC driver will help.

The reason this is happening when you use flush: true is because it's forcing your Hibernate session to flush to the database, where it encounters the stuck thread.

---

Related Topics