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 пользователь Антон Чехов написал: > > 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]. 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.
