That's not a deadlock, that's just a slow SQL command that is causing your
other SQL commands to back up.
There is no cure for this beyond performance tuning.
Also your thread pool implementation does not seem to be doing it's job of limiting the number of active threads
properly, since you have a ton of threads sitting waiting.
The point of a thread-pool is to prevent spawning too many threads, because
when you are in a slowdown situation,
it is better to queue the extra tasks, rather than making the VM run even
slower by spawning more threads.
"CommonThreadPool-16-busy" - Thread t@80
java.lang.Thread.State: TIMED_WAITING
at java.lang.Object.wait(Native Method)
- waiting on <602f0380> (a com.alcatel.ov1.util.shared.StateSemaphore)
at com.alcatel.ov1.util.shared.StateSemaphore.semaWait(Unknown Source)
at
com.alcatel.ov1.pmisam.server.PmIsamQueue$SavePmIsamFileTaskPerformer.performTask(Unknown
Source)
at
com.alcatel.ov1.util.shared.BatchQueue$BatchQueueInternalTaskPerformer.performTask(Unknown
Source)
at com.alcatel.ov1.util.shared.TaskInfo.performTask(Unknown Source)
at
com.alcatel.ov1.util.shared.TaskQueue$TaskQueuePerformer.performTask(Unknown
Source)
at com.alcatel.ov1.util.shared.TaskInfo.performTask(Unknown Source)
at com.alcatel.ov1.util.shared.ThreadPoolWorkThread.run(Unknown Source)
- locked <4edf574b> (a com.alcatel.ov1.util.shared.ThreadPoolWorkThread)
On 2015-03-04 05:42 AM, Duc Nguyen wrote:
Hi,
This problem happen for the same customer of this topic
https://groups.google.com/forum/#!topic/h2-database/gZZGshxYgFs
Our application has suffered lots of slowness, unresponsive. We took a thread
dump and found a deadlock caused by an h2
database file access.
Please see the attachment for the thread-dump file and see if you have any idea
what happened.
We use Embedded H2 version 1.3.169 for our application.
Thanks
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
[email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
