Hi,
Sorry I can't reproduce the problem. In my test, the lock gets released as
soon as the connection is closed.
Could you post a reproducible test case?
Regards,
Thomas
On Friday, May 18, 2012, 齐哲之 wrote:
> Hi,
>
> I had a problem.
> Lock_mode 1 or Lock_mode 2.
>
> Two or more session on one database, test1 for example.
>
> session_id 1:
> select * from t1
> session_id 2:
> select * from t1
>
> select * from information_schema.locks
> then there are two read locks.
>
> then I close session_id 2 without commit.
> select * from information_schema.locks
> then also there are two read locks,session_id 1 and session_id 2.
> *So I can't do anything on table t1 anymore on lock_mode 1 or 2.*
>
>
> Could you please tell me
> How to solve the problem?
>
> very emergency,thanks
>
> Best Regards,
> Jason.qi
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to
> h2-database@googlegroups.com<javascript:_e({}, 'cvml',
> 'h2-database@googlegroups.com');>
> .
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com <javascript:_e({}, 'cvml',
> 'h2-database%2bunsubscr...@googlegroups.com');>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
