Hi, Yes, use
SELECT * FROM INFORMATION_SCHEMA.LOCKS; SELECT * FROM INFORMATION_SCHEMA.SESSIONS; To cancel a transaction of a different connection, see http://h2database.com/html/functions.html#cancel_session Regards, Thomas On Tue, Apr 7, 2015 at 12:20 PM, Антон Чехов <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > 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 пользователь Антон Чехов > написал: > >> 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 >> >> Timeout trying to lock table ; SQL statement: >> 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[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.
