RE: table locking with forking

Jeremy Kister <[email protected]> Thu, 25 Oct 2007 18:19:13 -0400

Newsgroups	gmane.comp.db.mysql.perl
Message-ID	<[email protected]>

On Sep 19, 2007; 12:19pm, John Trammel wrote:
 > I don't understand the behavior of the original script; it looks like
 > the INSERT from the child process gets queued up by MySQL, and the
 > killing of the child doesn't affect it.

For the archives, I've figured it out:

the answer is to use Sys::SigAction instead of $SIG{ALRM}

see http://search.cpan.org/~lbaxter/Sys-SigAction/lib/Sys/SigAction.pm

everything now works the way i expected.

-- 

Jeremy Kister
http://jeremy.kister.net./


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]