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 On Monday, April 6, 2015, Антон Чехов <[email protected]> wrote: > 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.
