[h2] Timeout trying to lock table ; SQL statement: (2024)

Permalink

Thomas Mueller

2015-04-07 05:45:00 UTC

Hi,

This error message means the table is locked by another connection.
Increasing the timeout will only help if the other connection commits the
transaction in the meantime.

Regards,
Thomas

Post by Антон Чехов
Hi All,
Could you please help.
When i login to h2 database console and try to execute this query
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06')
i get folowing error
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06') [50200-173]
<http://jira:8080/plugins/servlet/svnwebclient/console/query.do?jsessionid=1a16bddb9be915eafd2a4cde0d16639a#>
HYT00/50200
i tried to increase lock_timeout parameter but it waites and then shows
this error. Can you please help - why i can not insert data in my table?
--
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
.
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 h2-database+***@googlegroups.com.
To post to this group, send email to h2-***@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Антон Чехов

2015-04-07 10:20:33 UTC

Hi Thomas Thank you for you answer. Is there any way to see another
connection and kill it? it is hanging and i can't insert any datas

пПМеЎельМОк, 6 апреля 2015 г., 19:35:02 UTC+3 пПльзПватель АМтПМ ЧехПв

Post by Антон Чехов
Hi All,
Could you please help.
When i login to h2 database console and try to execute this query
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06')
i get folowing error
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06') [50200-173]
<http://jira:8080/plugins/servlet/svnwebclient/console/query.do?jsessionid=1a16bddb9be915eafd2a4cde0d16639a#>
HYT00/50200
i tried to increase lock_timeout parameter but it waites and then shows
this error. Can you please help - why i can not insert data in my table?

--
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 h2-database+***@googlegroups.com.
To post to this group, send email to h2-***@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Антон Чехов

2015-04-09 08:51:35 UTC

There is no other sessions except of mine
and only one read lock from my session. So noone is blocking my insert -
is it possible an insert to take so long?
this table in the database is the biggest - in other smaller tables insert
works well

пПМеЎельМОк, 6 апреля 2015 г., 19:35:02 UTC+3 пПльзПватель АМтПМ ЧехПв

Post by Антон Чехов
Hi All,
Could you please help.
When i login to h2 database console and try to execute this query
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06')
i get folowing error
insert into CLIENT_BPOW_KE0X_F3ZC_45XK.REVISIONS
values(33,6759,'xxx','2015-04-06 13:15:05.23','2015-04-06') [50200-173]
<http://jira:8080/plugins/servlet/svnwebclient/console/query.do?jsessionid=1a16bddb9be915eafd2a4cde0d16639a#>
HYT00/50200
i tried to increase lock_timeout parameter but it waites and then shows
this error. Can you please help - why i can not insert data in my table?

--
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 h2-database+***@googlegroups.com.
To post to this group, send email to h2-***@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.