How to connect to H2 database from database tool like dbveaver

shahab2 years ago

Hello everyone,
Recently i have been testing one traccar server and there is one error i got

2023-04-20 12:24:28  INFO: Clearing database change log checksums
2023-04-20 12:24:32  INFO: Waiting for changelog lock....
2023-04-20 12:24:42  INFO: Waiting for changelog lock....
2023-04-20 12:24:52  INFO: Waiting for changelog lock....
2023-04-20 12:25:02  INFO: Waiting for changelog lock....
2023-04-20 12:25:12  INFO: Waiting for changelog lock....
2023-04-20 12:25:22  INFO: Waiting for changelog lock....
2023-04-20 12:25:34  INFO: Waiting for changelog lock....
2023-04-20 12:25:44  INFO: Waiting for changelog lock....
2023-04-20 12:25:54  INFO: Waiting for changelog lock....
2023-04-20 12:26:05  INFO: Waiting for changelog lock....
2023-04-20 12:26:15  INFO: Waiting for changelog lock....
2023-04-20 12:26:25  INFO: Waiting for changelog lock....
2023-04-20 12:26:35  INFO: Waiting for changelog lock....
2023-04-20 12:26:45  INFO: Waiting for changelog lock....
2023-04-20 12:26:56  INFO: Waiting for changelog lock....
2023-04-20 12:27:06  INFO: Waiting for changelog lock....
2023-04-20 12:27:16  INFO: Waiting for changelog lock....
2023-04-20 12:27:27  INFO: Waiting for changelog lock....
2023-04-20 12:27:37  INFO: Waiting for changelog lock....
2023-04-20 12:27:47  INFO: Waiting for changelog lock....
2023-04-20 12:27:57  INFO: Waiting for changelog lock....
2023-04-20 12:28:08  INFO: Waiting for changelog lock....
2023-04-20 12:28:18  INFO: Waiting for changelog lock....
2023-04-20 12:28:28  INFO: Waiting for changelog lock....
2023-04-20 12:28:38  INFO: Waiting for changelog lock....
2023-04-20 12:28:49  INFO: Waiting for changelog lock....
2023-04-20 12:28:59  INFO: Waiting for changelog lock....
2023-04-20 12:29:09  INFO: Waiting for changelog lock....
2023-04-20 12:29:20  INFO: Waiting for changelog lock....
2023-04-20 12:29:30 ERROR: Main method error - Could not acquire change log lock.  Currently locked by ip-172-31-12-200 (172.31.12.200) since 4/20/23, 12:22 PM - LockException (... < DatabaseModule:95 < <gener:-1 < *:-1 < ... < Main:126 < ...)

I know I have to run a query on H2 database change lock but i don't know how to connect and since i have being running test server for a quite time i dont want to waste that data, so please tell me how can i connect t that db?
Thank you

Anton Tananaev2 years ago

Someone already posted details instructions on the forum. You just need to search.

shahab2 years ago

hey @Anton Tananaev, I have already searched forum regarding this and was not able to find any refrence, Could you please give me the link of that forum

Anton Tananaev2 years ago