application hanging while commit a set of rows in ASA7.0, it doesn't show an error message and doesn't succeed, can anyone know how to resolve this asked 25 Nov '13, 05:29 kvraman03 Volker Barth |
How large was the set of rows? Committing a very large transaction can take time. answered 25 Nov '13, 13:10 John Smirnios thanks guys, thank you john, actually it happened because of too many rows(more than 6000),partially i have done commit then it worked.. so the problem was too many rows
(26 Nov '13, 07:41)
kvraman03
|
This is usually because another connection has either the data or structure locked, and your connection is waiting. Are there other connections? Look in the help file about BLOCKING. answered 25 Nov '13, 06:49 Justin Willey 2
The locks are taken as the rows are modified, not during the commit. The commit should not block.
(25 Nov '13, 13:11)
John Smirnios
Replies hidden
That's what comes of not reading the question! I failed to take on board the "commit" bit!
(26 Nov '13, 08:47)
Justin Willey
|
Is the database running with or without a transaction log?