Sure,
What are you doing in GlabalRoutines.pm at line 88? Are you fetching a
large result set into memory (hash or array)?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:38 AM
To:
:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 10:41 AM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory
Sure,
What are you doing in GlabalRoutines.pm at line 88? Are you fetching a
large result set into memory (hash
PROTECTED]
Sent: Tuesday, September 05, 2006 10:45 AM
To: Reidy, Ron; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
: Out of memory
Hi Ron,
I am returning approximately 3.8 million rows. Here is the code:
$sqlString = qq{ select distinct x.ptnt_gid
, Peter # PHX; Reidy, Ron; DBI-Users
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed
reserve
: Out of memory
Now I am getting the following error after fetching approximately
350,000 rows.
DBD::ODBC::st fetch failed: [unixODBC] (SQL-)(DBD: st_fetch/SQLFetch
err=-1) at /usr
@perl.org
Subject: RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed reserve
:Out of memory
On Tue, 2006-09-05 at 12:34 -0600, Reidy, Ron wrote:
So, which is it - errors at 3.8M rows, or 350K rows? When you get
errors at 350K, are you array fetching or row-at-a-time fetching?
What