Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread 1005 error question
Fri, Dec 11 2020 3:34 AMPermanent Link

Hershcu Sorin

Hello
When I got that error how I can find
which users or what session is responsible for that locking?

Thanks, Sorin
Fri, Dec 11 2020 3:46 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hershcu


If you're using client/server this may help

https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&msg=11682

Roy Lambert
Fri, Dec 11 2020 4:29 AMPermanent Link

Hershcu Sorin

If you're using client/server this may help
https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&msg=11682

Thanks, Roy
Yes I am using client/server
From the old thread, I learn about the ServerSessionLock table
I query that table and it's empty.

Still, I'm getting the #1005 error
Any more suggestions?
Fri, Dec 11 2020 5:12 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hershcu

>Thanks, Roy
>Yes I am using client/server
>From the old thread, I learn about the ServerSessionLock table
>I query that table and it's empty.

Did you test it in a clean environment where you knew what was locked or are you examining live tables?

>Still, I'm getting the #1005 error
>Any more suggestions?

Only trapping for the error and handling it gracefully. Also check for disconnected sessions that have left a lock dangling.

How many users are there on the system?

Roy

Fri, Dec 11 2020 5:37 AMPermanent Link

Hershcu Sorin

>Only trapping for the error and handling it gracefully. Also check for disconnected sessions that have left a lock >dangling.

>How many users are there on the system?

>Roy

The application has a maximum of 5 users but all are logged off.
Meanwhile, I solved these problems by stopping and starting the EdbSrvr service.
So probably it was a lock dangling. Can I avoid it?
Thanks for the support.
Fri, Dec 11 2020 8:47 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hershcu


If you're using pessimistic locking then you can try optimistic (which brings its own issues).

With 5 users I personally would start by finding out who was doing what when the lock was found and trying to stop it happening. It may be that you have a hardware problem or the server settings need tweaking.


Roy Lambert
Image