Hi,
I'm using
Sequoia 2.10 in a raidb1 configuration using 2 controllers and 2 MySQL Databases
on seperate workstations.
Due to an
invalid SQL statement, I got a lock on a database table:
mconline(admin) > debug on
Debug mode on
mconline(admin) > dump scheduler queues
Active transactions: 4
Transaction id list: 3610 562949953423211 3729 562949953423251
Pending read requests: 0
Read request id list:
Pending write requests: 4
Write request id list: 562949953425149 7476 562949953425225 7227
Debug mode on
mconline(admin) > dump scheduler queues
Active transactions: 4
Transaction id list: 3610 562949953423211 3729 562949953423251
Pending read requests: 0
Read request id list:
Pending write requests: 4
Write request id list: 562949953425149 7476 562949953425225 7227
mconline(admin) > dump backend schema mconline_node1
/locks
[...]
null.orders
Lock owner transaction id: 3610
[...]
Lock owner transaction id: 3610
[...]
How
can release this lock or release the transaction that caused the
lock???
I searched
the manuals but found no hints how to accomplish that.
Best
regards,
Wolfgang Klenk
[Software
Engineer]
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
