Hi List -
I have code that inserts a row from a temp table into a permanent table;
it's run an average of 160 times a day on three different machines.
Once a week or so, the INSERT fails because there is a legitimate remote
table lock on the permanent table that causes an SQL error code 2440,
"You reached 100% of your lock wait time. You must re-execute the
command." This occurs every time there is a remote table lock on the
permanent table.
My understanding is that INSERT will attempt to execute every 5 tenths
of a second (INTERVAL = 5) for approx 8 seconds (WAIT = 8) or until the
lock is removed, whichever occurs first.
But evidence (log table entries) indicates that it is waiting only about
2 seconds before throwing the SQL error.
This happens on any of the three machines that run this program.
They all read a common CFG file so WAIT, INTERVAL and all other settings
are identical.
Any clues for the blues?
TIA,
Doug
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/b54bd7cd-88db-f521-f300-2d594ffae4a0%40wi.rr.com.
