Esteemed ones,
I have written a collection of cgi programs - 10 in total - all being run on one webserver. 7 for the backend (agenda, cms, administration, contract creation etc.) and 3 index.pl's for the websites that the backend drives.
All programs look to a lock mechanism as described in the camel book, (with my addition of timing out the process to catch the stragglers) and all share the same berkeley DB's.
# OPEN THE LOCK FILE
    my $LCK    =    "$lock_path/dblock.lockfile";
    sysopen(DBLOCK, $LCK, O_RDONLY | O_CREAT) or die divert("Couldn't 
+open $LCK (lock_database_for_writing): $!");

# ATTEMPT TO LOCK THE LOCK FILE
    eval {
        local $SIG{ALRM} = sub { die "TIMEDOUT" };
        alarm(30);
            flock(DBLOCK, LOCK_EX) or die divert("Couldn't LOCK_EX $LC
+K (lock_database_for_writing): $!");
        alarm(0);
    };
    
    if ($@) {
        if( $@ =~ /TIMEDOUT/ ) {
            divert("Connection too busy. Error: $!");
        }
    }

[download]

note: divert() is my output for the browser
Now, the problem is, that every now and again and for no apparent reason it does take more than the allowed 30 seconds to get a lock on the lockfile.
A runaway process I suspected? Executing the same script with the same input from my 4 browsers runs smoothly. Time after time.
Too many people trying to connect at once? No-one else trying within minutes
Particular browser?: No, several different types have the same delay. Even the same user can experience fast and slow execution times but more generally bunched with snowball effect: 2.5 secs, 7 secs, 17 secs
Perl is busy on the webserver? No, I'm the only one using perl.
Ask the ISP? No help, no idea what it could be. "Yeah but in the logs"... "Sure we'll look into it for you"...

Every run of any program writes basic info to my own log files: date, time, browser, processID and the time it took to run the whole script
( time->attempt lock->do stuff->release lock->get time).
Examining the logs only reveals that a random user can take much longer to execute the script than normal. Average script execution is 0.5 seconds - "strange" users exec time between 2.5 and 30+ seconds. What does become apparent is how many processes are being run in between executions.

I'm assuming that if you have a slow internet connection that the webserver will buffer the output of the script until the client has received the content.

My question is: What can cause one browser/user/connection to take longer to execute a script than another?

Any ideas?

Help greatly appreciated.


An excerpt from one occasion:
24-05-2005 10:33:05 -> xxx.xxx.xxx.xxx
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; SV
+1; .NET CLR 1.1.4322)
 p=&bandID=&search_phrase= (26197) exec 16.3432 WARNING
24-05-2005 10:33:56 -> xxx.xxx.xxx.xxx, p=artist_list (26299) exec 7.8
+034 WARNING
24-05-2005 10:34:42 -> xxx.xxx.xxx.xxx, p=artist_list&style=7 (26384) 
+exec 8.0844 WARNING
24-05-2005 10:35:30 -> xxx.xxx.xxx.xxx, p=artist&bandID=109&style=7&l=
+ (26460) exec 8.2451 WARNING
24-05-2005 10:36:17 -> xxx.xxx.xxx.xxx, p=artist&bandID=109&imageID=1&
+searchID=&content= (26524) exec 5.0702 WARNING
24-05-2005 10:36:36 -> xxx.xxx.xxx.xxx, p=artist&bandID=109&style=7&l=
+&content=repertoire&searchID= (26547) exec 4.4575 WARNING
24-05-2005 10:37:18 -> xxx.xxx.xxx.xxx, p=artist&bandID=109&style=7&l=
+&content=lineup&searchID= (26612) exec 3.4035 WARNING
24-05-2005 10:37:40 -> xxx.xxx.xxx.xxx, p=artist&bandID=109&imageID=1&
+searchID=&content=lineup (26640) exec 3.3868 WARNING
24-05-2005 10:37:54 -> xxx.xxx.xxx.xxx, p=book&bandID=109&searchID= (2
+6657) exec 0.0929

[download]

In reply to what can delay the execution of a cgi script? by traxlog

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.