Fwd: DBD::Oracle memory leak

Hilmar Lapp Wed, 07 Jul 2004 16:39:36 -0700

In case it helps anyone figuring out what's wrong (Tim?) I created a trace with level 9 for the loop 1..3.

DBI 1.38-ithread dispatch trace level set to 9 -> DBI->connect(dbi:Oracle:blahh, lapp, ****, HASH(0x1801180)) -> DBI->install_driver(Oracle) for darwin perl=5.008001 pid=8122 ruid=502 euid=502 install_driver: DBD::Oracle version 1.15 loaded from /Library/Perl/5.8.1/darwin-thread-multi-2level/DBD/Oracle.pm New DBI::dr (for DBD::Oracle::dr, parent=, id=) dbih_setup_handle(DBI::dr=HASH(0x180785c)=>DBI::dr=HASH(0x1860470), DBD::Oracle::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::Oracle::dr, 108, 0) thr#1800200 dbih_setup_attrib(DBI::dr=HASH(0x1860470), Err, Null!) SCALAR(0x1812948) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x1860470), State, Null!) SCALAR(0x1807a48) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x1860470), Errstr, Null!) SCALAR(0x1812990) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x1860470), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x1860470), FetchHashKeyName, Null!) 'NAME' (already defined) >> STORE DISPATCH (DBI::dr=HASH(0x180785c) rc1/1 @3 g0 ima418 pid#8122) at /Library/Perl/5.8.1/darwin-thread-multi-2level/DBD/Oracle.pm line 64 -> STORE in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x180785c)~0x1860470 'ShowErrorStatement' 1) thr#1800200 STORE DBI::dr=HASH(0x1860470) 'ShowErrorStatement' => 1 <- STORE= 1 at /Library/Perl/5.8.1/darwin-thread-multi-2level/DBD/Oracle.pm line 64 <- install_driver= DBI::dr=HASH(0x180785c) >> connect DISPATCH (DBI::dr=HASH(0x180785c) rc2/3 @5 g0 ima1 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 585 -> connect for DBD::Oracle::dr (DBI::dr=HASH(0x180785c)~0x1860470 'blahh' 'lapp' **** HASH(0x1858c54)) thr#1800200 New DBI::db (for DBD::Oracle::db, parent=DBI::dr=HASH(0x1860470), id=) dbih_setup_handle(DBI::db=HASH(0x1860440)=>DBI::db=HASH(0x1858cc0), DBD::Oracle::db, 18075b0, Null!) dbih_make_com(DBI::dr=HASH(0x1860470), 333e40, DBD::Oracle::db, 136, 0) thr#1800200 dbih_setup_attrib(DBI::db=HASH(0x1858cc0), Err, DBI::dr=HASH(0x1860470)) SCALAR(0x1807df0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x1858cc0), State, DBI::dr=HASH(0x1860470)) SCALAR(0x1807e50) (already defined) dbih_setup_attrib(DBI::db=HASH(0x1858cc0), Errstr, DBI::dr=HASH(0x1860470)) SCALAR(0x1807e20) (already defined) dbih_setup_attrib(DBI::db=HASH(0x1858cc0), TraceLevel, DBI::dr=HASH(0x1860470)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x1858cc0), FetchHashKeyName, DBI::dr=HASH(0x1860470)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x1858cc0), HandleError, DBI::dr=HASH(0x1860470)) undef (not defined) Environment variables: SECURITYSESSIONID=210ec0 HOME=/Users/hlapp SHELL=/bin/tcsh USER=hlapp PATH=/sw/bin:/sw/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/ usr/X11R6/bin:/usr/local/mysql/bin:/usr/local/postgres/bin:/usr/local/ oracle/9iR2/orahome/bin __CF_USER_TEXT_ENCODING=0x1F6:0:0 TERM_PROGRAM=Apple_Terminal TERM_PROGRAM_VERSION=100 TERM=xterm-color LOGNAME=hlapp HOSTTYPE=powermac VENDOR=apple OSTYPE=darwin MACHTYPE=powerpc SHLVL=1 PWD=/Users/hlapp/Devel/perl GROUP=hlapp HOST=vanya PAGER=less CVS_RSH=ssh MANPATH=/sw/share/man:/usr/share/man:/usr/local/man:/usr/X11R6/man INFOPATH=/sw/share/info:/sw/info:/usr/share/info:/usr/local/info CLASSPATH=/sw/share/java/db42-java/db.jar PERL5LIB=/sw/lib/perl5:/sw/lib/perl5/darwin SQLPATH=/Users/hlapp/Devel/sql ORACLE_SID=blahh ORACLE_HOME=/usr/local/oracle/9iR2/orahome DYLD_LIBRARY_PATH=/usr/local/oracle/9iR2/orahome/lib:/usr/local/oracle/ 9iR2/orahome/rdbms:/usr/local/oracle/9iR2/orahome/lib:/usr/local/ oracle/9iR2/orahome/rdbms DBI_TRACE=9=dbd-ora.trace OCIInitialize(3,0,0,0,0)=SUCCESS OCIEnvInit(333e94,0,0,0)=SUCCESS OCIHandleAlloc(36000,500978,OCI_HTYPE_ERROR,0,0)=SUCCESS OCIHandleAlloc(36000,50097c,OCI_HTYPE_SERVER,0,0)=SUCCESS OCIHandleAlloc(36000,500980,OCI_HTYPE_SVCCTX,0,0)=SUCCESS OCIServerAttach(3c02c, 1877524, "blahh", 5, 0)=SUCCESS OCIAttrSet(18774b0,OCI_HTYPE_SVCCTX,3c02c,0,6,1877524)=SUCCESS OCIHandleAlloc(36000,500984,OCI_HTYPE_SESSION,0,0)=SUCCESS OCIAttrSet(7ef14,OCI_HTYPE_SESSION,500660,4,22,1877524)=SUCCESS OCIAttrSet(7ef14,OCI_HTYPE_SESSION,500690,6,23,1877524)=SUCCESS OCISessionBegin(18774b0,1877524,7ef14,1,0)=SUCCESS OCIAttrSet(18774b0,OCI_HTYPE_SVCCTX,7ef14,0,7,1877524)=SUCCESS <- connect= DBI::db=HASH(0x1860440) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 585 >> STORE DISPATCH (DBI::db=HASH(0x1858cc0) rc2/1 @3 g0 ima418 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 -> STORE for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'RaiseError' 1) thr#1800200 STORE DBI::db=HASH(0x1858cc0) 'RaiseError' => 1 <- STORE= 1 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 >> STORE DISPATCH (DBI::db=HASH(0x1858cc0) rc2/1 @3 g0 ima418 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 -> STORE for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'PrintError' 1) thr#1800200 STORE DBI::db=HASH(0x1858cc0) 'PrintError' => 1 <- STORE= 1 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 >> STORE DISPATCH (DBI::db=HASH(0x1858cc0) rc2/1 @3 g0 ima418 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 -> STORE for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'AutoCommit' 0) thr#1800200 <- STORE= 1 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 628 >> STORE DISPATCH (DBI::db=HASH(0x1858cc0) rc2/1 @3 g0 ima418 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 631 -> STORE for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'Username' 'lapp') thr#1800200 STORE DBI::db=HASH(0x1858cc0) 'Username' => 'lapp' <- STORE= 1 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 631 <- connect= DBI::db=HASH(0x1860440) >> STORE DISPATCH (DBI::db=HASH(0x1858cc0) rc2/1 @3 g0 ima418 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 645 via dbd-ora.pl line 4 -> STORE for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'dbi_connect_closure' CODE(0x1860554)) thr#1800200 STORE DBI::db=HASH(0x1858cc0) 'dbi_connect_closure' => CODE(0x1860554) <- STORE= 1 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 645 via dbd-ora.pl line 4 >> do DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @2 g0 ima201 pid#8122) at dbd-ora.pl line 8 via dbd-ora.pl line 7 -> do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0x1860440)~0x1858cc0 'DROP TABLE A1') thr#1800200 >> prepare DISPATCH (DBI::db=HASH(0x1858cc0) rc1/2 @3 g0 ima201 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1382 via dbd-ora.pl line 8 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'DROP TABLE A1' undef) thr#1800200 New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x1858cc0), id=) dbih_setup_handle(DBI::st=HASH(0x1858d50)=>DBI::st=HASH(0x1858cb4), DBD::Oracle::st, 1858d5c, Null!) dbih_make_com(DBI::db=HASH(0x1858cc0), 500910, DBD::Oracle::st, 208, 0) thr#1800200 dbih_setup_attrib(DBI::st=HASH(0x1858cb4), Err, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807df0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858cb4), State, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e50) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858cb4), Errstr, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e20) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858cb4), TraceLevel, DBI::db=HASH(0x1858cc0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858cb4), FetchHashKeyName, DBI::db=HASH(0x1858cc0)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858cb4), HandleError, DBI::db=HASH(0x1858cc0)) undef (not defined) OCIHandleAlloc(36000,50a740,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(7dabc,1877524,'DROP TABLE A1',13,1,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,50a744,0,24,1877524)=SUCCESS dbd_st_prepare'd sql DROP (pl1, al1, cs1) dbd_describe skipped for DROP 1 <- prepare= DBI::st=HASH(0x1858d50) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1382 via dbd-ora.pl line 8 >> execute DISPATCH (DBI::st=HASH(0x1858d50) rc1/1 @1 g0 ima41 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1383 via dbd-ora.pl line 8 -> execute for DBD::Oracle::st (DBI::st=HASH(0x1858d50)~0x1858cb4) thr#1800200 dbd_st_execute DROP (out0, lob0)... OCIStmtExecute(18774b0,7dabc,1877524,1,0,0,0,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb64,0,9,1877524)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb60,0,10,1877524)=SUCCESS dbd_st_execute DROP returned (SUCCESS, rpc0, fn8, out0) <- execute= '0E0' at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1383 via dbd-ora.pl line 8 >> rows DISPATCH (DBI::st=HASH(0x1858d50) rc1/1 @1 g0 ima4 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1384 via dbd-ora.pl line 8 -> rows for DBD::Oracle::st (DBI::st=HASH(0x1858d50)~0x1858cb4) thr#1800200 OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb70,0,9,1877524)=SUCCESS <- rows= 0 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1384 via dbd-ora.pl line 8 >> DESTROY DISPATCH (DBI::st=HASH(0x1858d50) rc1/1 @1 g0 ima4 pid#8122) at dbd-ora.pl line 8 <> DESTROY ignored for outer handle DBI::st=HASH(0x1858d50) (inner DBI::st=HASH(0x1858cb4)) >> DESTROY DISPATCH (DBI::st=HASH(0x1858cb4) rc1/1 @1 g0 ima4 pid#8122) at dbd-ora.pl line 8 -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x1858cb4)~INNER) thr#1800200 dbd_st_destroy OCIHandleFree(7dabc,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= undef at dbd-ora.pl line 8 DESTROY (dbih_clearcom) (sth 0x1858d50 0x0, com 0x50a6c0, imp DBD::Oracle::st): FLAGS 0x2191: COMSET Warn RaiseError PrintError ShowErrorStatement PARENT DBI::db=HASH(0x1858cc0) KIDS 0 (0 Active) IMP_DATA undef NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 dbih_clearcom 0x1858d50 (com 0x50a6c0, type 3) done.

<- do= '0E0' at dbd-ora.pl line 8 via dbd-ora.pl line 7 >> do DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @2 g0 ima201 pid#8122) at dbd-ora.pl line 12 -> do for DBD::Oracle::db (DBI::db=HASH(0x1860440)~0x1858cc0 'CREATE TABLE A1 (C1 INTEGER)') thr#1800200 >> prepare DISPATCH (DBI::db=HASH(0x1858cc0) rc1/2 @3 g0 ima201 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1382 via dbd-ora.pl line 12 1 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER 'CREATE TABLE A1 (C1 INTEGER)' undef) thr#1800200 New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x1858cc0), id=) dbih_setup_handle(DBI::st=HASH(0x1858de0)=>DBI::st=HASH(0x1858d44), DBD::Oracle::st, 1858dec, Null!) dbih_make_com(DBI::db=HASH(0x1858cc0), 500910, DBD::Oracle::st, 208, 0) thr#1800200 dbih_setup_attrib(DBI::st=HASH(0x1858d44), Err, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807df0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858d44), State, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e50) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858d44), Errstr, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e20) (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858d44), TraceLevel, DBI::db=HASH(0x1858cc0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858d44), FetchHashKeyName, DBI::db=HASH(0x1858cc0)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x1858d44), HandleError, DBI::db=HASH(0x1858cc0)) undef (not defined) OCIHandleAlloc(36000,50a730,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(7dabc,1877524,'CREATE TABLE A1 (C1 INTEGER)',28,1,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,50a734,0,24,1877524)=SUCCESS dbd_st_prepare'd sql CREATE (pl1, al1, cs1) dbd_describe skipped for CREATE 1 <- prepare= DBI::st=HASH(0x1858de0) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1382 via dbd-ora.pl line 12 >> execute DISPATCH (DBI::st=HASH(0x1858de0) rc1/1 @1 g0 ima41 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1383 via dbd-ora.pl line 12 -> execute for DBD::Oracle::st (DBI::st=HASH(0x1858de0)~0x1858d44) thr#1800200 dbd_st_execute CREATE (out0, lob0)... OCIStmtExecute(18774b0,7dabc,1877524,1,0,0,0,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb64,0,9,1877524)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb60,0,10,1877524)=SUCCESS dbd_st_execute CREATE returned (SUCCESS, rpc0, fn1, out0) <- execute= '0E0' at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1383 via dbd-ora.pl line 12 >> rows DISPATCH (DBI::st=HASH(0x1858de0) rc1/1 @1 g0 ima4 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1384 via dbd-ora.pl line 12 -> rows for DBD::Oracle::st (DBI::st=HASH(0x1858de0)~0x1858d44) thr#1800200 OCIAttrGet(7dabc,OCI_HTYPE_STMT,bfffeb70,0,9,1877524)=SUCCESS <- rows= 0 at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 1384 via dbd-ora.pl line 12 >> DESTROY DISPATCH (DBI::st=HASH(0x1858de0) rc1/1 @1 g0 ima4 pid#8122) at dbd-ora.pl line 12 <> DESTROY ignored for outer handle DBI::st=HASH(0x1858de0) (inner DBI::st=HASH(0x1858d44)) >> DESTROY DISPATCH (DBI::st=HASH(0x1858d44) rc1/1 @1 g0 ima4 pid#8122) at dbd-ora.pl line 12 -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x1858d44)~INNER) thr#1800200 dbd_st_destroy OCIHandleFree(7dabc,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= undef at dbd-ora.pl line 12 DESTROY (dbih_clearcom) (sth 0x1858de0 0x0, com 0x50a6b0, imp DBD::Oracle::st): FLAGS 0x2191: COMSET Warn RaiseError PrintError ShowErrorStatement PARENT DBI::db=HASH(0x1858cc0) KIDS 0 (0 Active) IMP_DATA undef NUM_OF_FIELDS 0 NUM_OF_PARAMS 0 dbih_clearcom 0x1858de0 (com 0x50a6b0, type 3) done.

<- do= '0E0' at dbd-ora.pl line 12 >> prepare DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @2 g0 ima201 pid#8122) at dbd-ora.pl line 17 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x1860440)~0x1858cc0 'INSERT INTO A1 (c1) VALUES (?)') thr#1800200 New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x1858cc0), id=) dbih_setup_handle(DBI::st=HASH(0x1858e94)=>DBI::st=HASH(0x18012f4), DBD::Oracle::st, 1858ef4, Null!) dbih_make_com(DBI::db=HASH(0x1858cc0), 500910, DBD::Oracle::st, 208, 0) thr#1800200 dbih_setup_attrib(DBI::st=HASH(0x18012f4), Err, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807df0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x18012f4), State, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e50) (already defined) dbih_setup_attrib(DBI::st=HASH(0x18012f4), Errstr, DBI::db=HASH(0x1858cc0)) SCALAR(0x1807e20) (already defined) dbih_setup_attrib(DBI::st=HASH(0x18012f4), TraceLevel, DBI::db=HASH(0x1858cc0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x18012f4), FetchHashKeyName, DBI::db=HASH(0x1858cc0)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x18012f4), HandleError, DBI::db=HASH(0x1858cc0)) undef (not defined) dbd_preparse scanned 1 distinct placeholders OCIHandleAlloc(36000,50a6f0,OCI_HTYPE_STMT,0,0)=SUCCESS OCIStmtPrepare(7dabc,1877524,'INSERT INTO A1 (c1) VALUES (:p1)',32,1,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,50a6f4,0,24,1877524)=SUCCESS dbd_st_prepare'd sql INSERT (pl1, al1, cs1) dbd_describe skipped for INSERT <- prepare= DBI::st=HASH(0x1858e94) at dbd-ora.pl line 17 >> execute DISPATCH (DBI::st=HASH(0x1858e94) rc1/1 @2 g0 ima41 pid#8122) at dbd-ora.pl line 19 -> execute for DBD::Oracle::st (DBI::st=HASH(0x1858e94)~0x18012f4 1) thr#1800200 bind :p1 <== 1 (type 0) binding :p1 with ftype 1 bind :p1 <== 1 (size 1/2/0, ptype 5, otype 1) bind :p1 <== '1' (size 1/1, otype 1, indp 0, at_exec 1) OCIBindByName(7dabc,50ae4c,1877524,": p1",3,50a4a0,1,1,50ae5e,0,50ae5c,0,0,2)=SUCCESS OCIBindDynamic(7d8d4,1877524,50ae30,216be0,50ae30,216dbc)=SUCCESS bind :p1 done with ftype 1 dbd_st_execute INSERT (out0, lob0)... in ':p1' [0,0]: len 1, ind 0 OCIStmtExecute(18774b0,7dabc,1877524,1,0,0,0,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff274,0,9,1877524)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff270,0,10,1877524)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) <- execute= 1 at dbd-ora.pl line 19 >> execute DISPATCH (DBI::st=HASH(0x1858e94) rc1/1 @2 g0 ima41 pid#8122) at dbd-ora.pl line 19 -> execute for DBD::Oracle::st (DBI::st=HASH(0x1858e94)~0x18012f4 2) thr#1800200 bind :p1 <== 2 (type 0) binding :p1 with ftype 1 bind :p1 <== 2 (size 1/2/0, ptype 5, otype 1) bind :p1 <== '2' (size 1/1, otype 1, indp 0, at_exec 1) bind :p1 done with ftype 1 dbd_st_execute INSERT (out0, lob0)... in ':p1' [0,0]: len 1, ind 0 OCIStmtExecute(18774b0,7dabc,1877524,1,0,0,0,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff274,0,9,1877524)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff270,0,10,1877524)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) <- execute= 1 at dbd-ora.pl line 19 >> execute DISPATCH (DBI::st=HASH(0x1858e94) rc1/1 @2 g0 ima41 pid#8122) at dbd-ora.pl line 19 -> execute for DBD::Oracle::st (DBI::st=HASH(0x1858e94)~0x18012f4 3) thr#1800200 bind :p1 <== 3 (type 0) binding :p1 with ftype 1 bind :p1 <== 3 (size 1/2/0, ptype 5, otype 1) bind :p1 <== '3' (size 1/1, otype 1, indp 0, at_exec 1) bind :p1 done with ftype 1 dbd_st_execute INSERT (out0, lob0)... in ':p1' [0,0]: len 1, ind 0 OCIStmtExecute(18774b0,7dabc,1877524,1,0,0,0,0)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff274,0,9,1877524)=SUCCESS OCIAttrGet(7dabc,OCI_HTYPE_STMT,bffff270,0,10,1877524)=SUCCESS dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0) <- execute= 1 at dbd-ora.pl line 19 >> commit DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @1 g0 imac81 pid#8122) at dbd-ora.pl line 23 -> commit for DBD::Oracle::db (DBI::db=HASH(0x1860440)~0x1858cc0) thr#1800200 OCITransCommit(18774b0,1877524,0)=SUCCESS <- commit= 1 at dbd-ora.pl line 23 >> disconnect DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @1 g0 imac01 pid#8122) at dbd-ora.pl line 25 -> disconnect for DBD::Oracle::db (DBI::db=HASH(0x1860440)~0x1858cc0) thr#1800200 OCISessionEnd(18774b0,1877524,7ef14,0)=SUCCESS OCIServerDetach(3c02c,1877524,0)=SUCCESS <- disconnect= 1 at dbd-ora.pl line 25 >> DESTROY DISPATCH (DBI::st=HASH(0x1858e94) rc1/1 @1 g0 ima4 pid#8122) <> DESTROY ignored for outer handle DBI::st=HASH(0x1858e94) (inner DBI::st=HASH(0x18012f4)) >> DESTROY DISPATCH (DBI::st=HASH(0x18012f4) rc1/1 @1 g0 ima4 pid#8122) -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x18012f4)~INNER) thr#1800200 dbd_st_destroy OCIHandleFree(7dabc,OCI_HTYPE_STMT)=SUCCESS <- DESTROY= undef DESTROY (dbih_clearcom) (sth 0x1858e94 0x0, com 0x50a670, imp DBD::Oracle::st): FLAGS 0x2191: COMSET Warn RaiseError PrintError ShowErrorStatement PARENT DBI::db=HASH(0x1858cc0) KIDS 0 (0 Active) IMP_DATA undef NUM_OF_FIELDS 0 NUM_OF_PARAMS 1 dbih_clearcom 0x1858e94 (com 0x50a670, type 3) done.

>> DESTROY DISPATCH (DBI::db=HASH(0x1860440) rc1/1 @1 g0 ima4 pid#8122) <> DESTROY ignored for outer handle DBI::db=HASH(0x1860440) (inner DBI::db=HASH(0x1858cc0)) >> DESTROY DISPATCH (DBI::db=HASH(0x1858cc0) rc1/1 @1 g0 ima4 pid#8122) -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x1858cc0)~INNER) thr#1800200 OCIHandleFree(7ef14,OCI_HTYPE_SESSION)=SUCCESS OCIHandleFree(3c02c,OCI_HTYPE_SERVER)=SUCCESS OCIHandleFree(18774b0,OCI_HTYPE_SVCCTX)=SUCCESS OCIHandleFree(1877524,OCI_HTYPE_ERROR)=SUCCESS <- DESTROY= undef DESTROY (dbih_clearcom) (dbh 0x1860440 0x0, com 0x500910, imp DBD::Oracle::db): FLAGS 0x2191: COMSET Warn RaiseError PrintError ShowErrorStatement PARENT DBI::dr=HASH(0x1860470) KIDS 0 (0 Active) IMP_DATA undef dbih_clearcom 0x1860440 (com 0x500910, type 2) done.

-- DBI::END >> disconnect_all DISPATCH (DBI::dr=HASH(0x180785c) rc1/3 @1 g0 ima801 pid#8122) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 653 via dbd-ora.pl line 0 -> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x180785c)~0x1860470) thr#1800200 <- disconnect_all= (not implemented) at /sw/lib/perl5/5.8.1/darwin-thread-multi-2level/DBI.pm line 653 via dbd-ora.pl line 0 ! >> DESTROY DISPATCH (DBI::dr=HASH(0x1860470) rc1/1 @1 g0 ima4 pid#8122) during global destruction ! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x1860470)~INNER) thr#1800200 ! <- DESTROY= (not implemented) during global destruction DESTROY (dbih_clearcom) (drh 0x180785c 0x0, com 0x333e40, imp DBD::Oracle::dr): FLAGS 0x2215: COMSET Active Warn ShowErrorStatement AutoCommit PARENT undef KIDS 0 (0 Active) IMP_DATA undef dbih_clearcom 0x180785c (com 0x333e40, type 1) done.

! >> DESTROY DISPATCH (DBI::dr=HASH(0x180785c) rc1/1 @1 g0 ima4 pid#8122) during global destruction ! <> DESTROY for DBI::dr=HASH(0x180785c) ignored (inner handle gone)


Begin forwarded message:

From: Hilmar Lapp <[EMAIL PROTECTED]>
Date: July 7, 2004 3:07:43 PM PDT
To: [EMAIL PROTECTED]
Subject: DBD::Oracle memory leak
If I run the test case code enclosed below against an Oracle database (first arg dbi:Oracle:blah) the memory consumption goes continuously up from a few MB to eventually more than 100MB.

If I run the same code against a MySQL database (first arg dbi:mysql:database=blah, using DBD::mysql v2.9003), the memory consumption remains at its initial level.

The issue seems to have been reported before, even though in different variants. A patch has been posted on the CPAN page that seems to address only LOB handling, which clearly is not involved here. Tim responded to an earlier bug report there that he can't reproduce it.

I'm on Mac OSX Panther, using perl 5.8.1RC3 (the one that comes with the system), DBI 1.38, DBD::Oracle 1.15, and the Oracle client libraries from the Oracle preview for MacOSX (there's just one AFAIK: 9.2.0.1.0 Developer's release).
Is there a solution/fix/patch known already that escaped my attention?
Tim, if you can't reproduce this, I'd be perfectly willing to help track down the cause if you provide guidance as to how I would best go about this.
Thanks in advance for any help, suggestions, patch(es).
        -hilmar
--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------
use DBI;
my $dbh = DBI->connect($ARGV[0], $ARGV[1], $ARGV[2], { RaiseError=> 1, AutoCommit => 0, PrintError => 1 }); print "dropping possibly left over test table A1 ...\n"; eval { $dbh->do("DROP TABLE A1"); }; print "\tfyi, table A1 doesn't exist yet\n" if $@; print "creating test table ...\n"; $dbh->do('CREATE TABLE A1 (C1 INTEGER)');
my $sql = 'INSERT INTO A1 (c1) VALUES (?)';
print "about to insert 100k numbers with one statement:\n";
my $sth = $dbh->prepare($sql);
for (my $i = 1; $i < (1024*128); $i++) {
    $sth->execute($i);
    print "\t$i rows ...\n" if ($i % 5000) == 0;
}
print "done, committing this step\n";
$dbh->commit;
$dbh->disconnect;

--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------

Fwd: DBD::Oracle memory leak

Reply via email to