Re: Safely timing out DBI queries

2006-09-16 Thread Henri Asseily
Use the great Sys::SigAction by Lincoln Baxter. It has never failed me. Take a look at DBIx::HA for sample usage. On Sep 16, 2006, at 2:27 AM, CAMPBELL, BRIAN D (BRIAN) wrote: I've done something similar to what you did... It went something like this... - Run query in a separate thread. -

Re: Safely timing out DBI queries

2006-09-16 Thread Sam Tregar
On Sat, 16 Sep 2006, Henri Asseily wrote: Use the great Sys::SigAction by Lincoln Baxter. That's just a wrapper around POSIX sigaction(), right? As I understand it that's equivalent to the old unsafe signals in Perl before 5.8. I'd rather avoid that if it all possible! -sam

Re: Safely timing out DBI queries

2006-09-16 Thread Henri Asseily
On Sep 16, 2006, at 8:58 PM, Sam Tregar wrote: On Sat, 16 Sep 2006, Henri Asseily wrote: Use the great Sys::SigAction by Lincoln Baxter. That's just a wrapper around POSIX sigaction(), right? As I understand it that's equivalent to the old unsafe signals in Perl before 5.8. I'd rather

Re: Safely timing out DBI queries

2006-09-16 Thread Henri Asseily
On Sep 17, 2006, at 12:05 AM, Henri Asseily wrote: On Sep 16, 2006, at 8:58 PM, Sam Tregar wrote: On Sat, 16 Sep 2006, Henri Asseily wrote: Use the great Sys::SigAction by Lincoln Baxter. That's just a wrapper around POSIX sigaction(), right? As I understand it that's equivalent to the

Re: Safely timing out DBI queries

2006-09-16 Thread Sam Tregar
On Sun, 17 Sep 2006, Henri Asseily wrote: You've got a catch-22: If you ALWAYS want the signal to fire on time, then you should expect unsafe signals. Just clean up after yourself. It's hard to clean up after the kind of problems unsafe signals can cause. For example, imagine the DB client

Memory leak with DBI 1.52 Oracle - Please Help

2006-09-16 Thread Simon
Hi, I'm no Perl expert, but I also would not consider myself a newbie. I seem to have a memory leak issue with the DBI module (1.52) on Windows connecting to Oracle (10gR2). For reasons I won't go into at this time, I need to have a continuous loop that will connect to many Oracle instances.

Re: Safely timing out DBI queries

2006-09-16 Thread Dean Arnold
I'm not really qualified to comment on DBD::mysql, but... I just saw your note on mysql internals, and suspect your request there is unlikely to be given serious consideration. I think your best bet might be to work with the DBD::mysql maintainers to implement some driver-specific nonblocking

Re: Safely timing out DBI queries

2006-09-16 Thread Sam Tregar
On Sat, 16 Sep 2006, Dean Arnold wrote: I just saw your note on mysql internals, and suspect your request there is unlikely to be given serious consideration. Always a possibility. Maybe they'd be more interested in a patch. (For the curious, I wrote a message to the MySQL internals

New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-16 Thread Lane
Hi, I'm using DBI for a proof of concept project that I thought should be rather quick. But I see DBI is rather quirky to the novice :) I'm on FreeBSD 5.4 using perl 5.8.8 and DBI 1.52 Using the connection string in the Subject line, I created a table as follows: Create Table Folders

Re: New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-16 Thread Jeff Zucker
Lane wrote: my $dbh = DBI-connect('dbi:DBM:mldbm=Storable;f_dir=/foo/bar'); $dbh-{RaiseError} = 1; I can't reproduce your problem. Please run the following script and send the output back to the list. #!/usr/bin/perl -w use strict; use DBI; my $dbh =

Re: New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-16 Thread Lane
On Saturday 16 September 2006 20:23, Jeff Zucker wrote: Lane wrote: my $dbh = DBI-connect('dbi:DBM:mldbm=Storable;f_dir=/foo/bar'); $dbh-{RaiseError} = 1; I can't reproduce your problem. Please run the following script and send the output back to the list. #!/usr/bin/perl -w

Re: New here. dbi:DBM:mldbm=Storable;f_dir=/foo/bar. Inserts when asked to update and other weirdness

2006-09-16 Thread Lane
On Saturday 16 September 2006 20:23, Jeff Zucker wrote: Lane wrote: my $dbh = DBI-connect('dbi:DBM:mldbm=Storable;f_dir=/foo/bar'); $dbh-{RaiseError} = 1; I can't reproduce your problem. Please run the following script and send the output back to the list. #!/usr/bin/perl -w

ANNOUNCE: DBIx::Timeout v1.00

2006-09-16 Thread Sam Tregar
Changes - First release! Description This module provides a safe method of timing out DBI requests. An unsafe method is described in the DBI docs: http://search.cpan.org/~timb/DBI/DBI.pm#Signal_Handling_and_Canceling_Operations The problem with using POSIX sigaction()