This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Do some work with a connection that causes the server to disconnect from the client. In my case it was an exception in getting some meta data. Right clicking around between connections (to try and disconnect/reconnect) causes the IDE to hang.
Created attachment 14040 [details] DB exception that caused disconnect and future hang
I guess I should also add that I'm using Netbeans 3.6 RC1, and DB module 1.8.1.
I cannot reproduce the disconnect from the client. If the connection was closed, it is probably a driver issue. The hang problem is partially driver issue and partially Database Explorer issue: From the attached stack trace it is visible that the problematic method is getIndexInfo(). It is known problem of Oracle driver. This method consumes a lot of time on tables with big number of rows. When the method finish the IDE should unfreeze. This method should not run in AWT-thread. There is already a similar issue (#37051) so I propose to close this bug as a duplicate of 37051.
The two defects do look similar and are probably related. However in my case, it wasn't that the getIndexInfo() was taking a long time, it was actually throwing an exception. This exception caused the connection state to become invalid, I think the connection was actually broken by the server. In this case, future attempts to use the connection (right click on another connection and then right click on the problem connection) causes a hang that doesn't appear to ever end. This is a major problem for me, since I use Oracle a lot. If I am going to have some problems with getIndexInfo() I don't want the IDE to freeze on me. I'll work with my DB folks on the cause of my getIndexInfo() exception, it looks like an access thing, not lag. But in the mean time it seems to be a pretty important thing that the entire IDE freeze when there is a DB connection issue. I guess what I'm saying is that no matter what number this is tracked under, I would like to see this fixed before 3.6 goes live.
If you know. Could someone please tell me what tables the Oracle getIndexInfo() call hits?
I tried to simulate your problem - I closed the connection outside of the IDE. I wasn't able to reproduce it, the IDE didn't freeze. The error message from the driver was displayed, I was informed that something wrong happened with the conection and I was able to continue to work without any problem. I tested it with oracle and PoitBase. Oracle driver showed: "Io exception: Connection reset by peer: socket write error" and PointBase driver showed: "Connection failure. sendMethodRequest(...)" In your exception is written "insufficient privileges". My colleague tried to revoke some privileges and reproduse your problem but unsuccsessfuly. I worked for him too. Try to correct your privileges and set what you need, hopefully it can prevent your problem. Attach full thread dump, please. Otherwise we are not able to see what was happening when the IDE froze and we are not able to help you.
Created attachment 14058 [details] Thread dump after hang
I should also add that the hang is not immediate. You need to right click around on a few connections. Try to disconnect the crashed connection and then right click around a few other connections. Going back to the crashed connection seems to hang things. This seems to happen after a second or so of going between connections and manipulating the crashed connection (trying to disconnect, reconnect,etc).
Waiver request and changing priority (agreed by QE).
3.6 waiver approved.
please see this issue #45513, if it is not same
Cannot reproduce with the current dev build. Closing as WORKSFORME. If you still can reproduce it with the latest dev build, feel free to reopen it.