Doug,
If there are functions embedded within the value
list or SELECT statement, there would be added processing to each INSERT.
Are there functions defined?
Please share the INSERT command.
Also, have you tried increasing the INTERVAL and
WAIT settings in small increments?
Very Best R:egards,
Razzak.
At 05:39 PM 6/30/2022, Doug Hamilton wrote:
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
--
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/1N33hJ-1ndop53Cij-013JYW%40mrelay.perfora.net.
