many database connections causes Can't locate Carp/Heavy.pm

From: Kirill Richine (krichine_at_juno.com)
Date: 10/28/03

  • Next message: Tim Harsch: "Re: Trouble Installing DBD::Oracle on Red Hat 8" 
    Date: 28 Oct 2003 13:38:11 -0800

    Hi,

    I am purposefully attempting to open ~1000 database connections using
    DBI (1.38) and DBD-Oracle (1.14).

    After about 255 connections I am getting

    Can't locate Carp/Heavy.pm in @INC ...

    Here is the code:

    for $i (0..$connections-1) {
      my $dbh = DBI->connect ("dbi:Oracle:",$connect_string,$password,{
    ora_module_n
    ame => "$0 connection $i"})
        or die "Can't connect to Oracle database: $DBI::errstr\n";
      push @connection_pool, $dbh;
    }

    Is there some kind of limitation that DBI or DBD-Oracle imposes on the
    number of connections allowed to be open?

    Thanks.
    Kirill

  • Next message: Tim Harsch: "Re: Trouble Installing DBD::Oracle on Red Hat 8"

    Relevant Pages

    • DBI Module.
      ... We are trying to implement a better "timeout" for the DBI connections, ... the one incorporated in the DBI module only has a granularity of seconds. ...
      (perl.dbi.users)
    • Re: Rows returned are out of sync with the request.
      ... When I make a call to an Oracle 10g database using DBI and SQLRelay ... (for connection pooling) ... I cannot switch to direct connections across the board ...
      (perl.dbi.users)
    • Measuring wait time for openning a new connection
      ... using DBI) which opens many connections to ... the database. ... Will I see the effect of the connections on the wait events? ...
      (comp.databases.oracle.server)
    • Re: Implications of not closing db connection?
      ... The error I got from them was that I had an applet re-initialising ... > Yes you should close your connections. ... > its database connections was causing these problems. ...
      (comp.lang.java.programmer)
    • Re: Too many sessions already active
      ... the database connections were never ... Dim myConn As New ... Could not start session. ...
      (microsoft.public.dotnet.framework.aspnet)