DBD::Oracle puts junk into the recyclebin

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 6 Nov 2011 06:16:35 +0000 (UTC)
Message-ID: <pan.2011.11.06.06.16.34_at_gmail.com>



I decided that it would be the right time to update my DBD::Oracle 1.28 to the latest and the greatest version, which is 1.34. I ran "make test", an old habit which stuck with me since I've encountered some not so well tested modules, and everything was peachy. The module got properly installed but the recycle bin was full of junk:

SQL> select owner,object_name,original_name,can_undrop,can_purge   2 from dba_recyclebin;

OWNER OBJECT_NAME ORIGINAL_NAME CAN CAN

----- -------------------- -------------------------------- --- ---
SCOTT BIN$sNwS4xrmQ+rgQ2QB SYS_C0038375 		    NO	YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrnQ+rgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrpQ+rgQ2QB SYS_C0038376 		    NO	YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrqQ+rgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrsQ+rgQ2QB SYS_C0038377 		    NO	YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrtQ+rgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrvQ+rgQ2QB SYS_C0038378 		    NO	YES
      qMBihQ==$0

SCOTT BIN$sNwS4xrwQ+rgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBihQ==$0

SCOTT BIN$sNwTFEcqQ+7gQ2QB DBD_ORA__DROP_ME		    YES YES
      qMDJYg==$0

SCOTT BIN$sNwTG+2YQ/DgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMB2mw==$0

SCOTT BIN$sNwTJoRpQ/LgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMDCcA==$0

SCOTT BIN$sNwTLAXVQ/TgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBMnw==$0

SCOTT BIN$sNwTMt7FQ/bgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMDadA==$0

SCOTT BIN$sNwTOL0pQ/jgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMA76A==$0

SCOTT BIN$sNwTQaEKQ/7gQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBltg==$0

SCOTT BIN$sNwTQaELQ/7gQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBltg==$0

SCOTT BIN$sNwTjSilRALgQ2QB SYS_C0038379 		    NO	YES
      qMAecg==$0

SCOTT BIN$sNwTjSimRALgQ2QB PERL_DBD_EXECUTE_ARRAY	    YES YES
      qMAecg==$0

SCOTT BIN$sNwTjSioRALgQ2QB SYS_C0038380 		    NO	YES
      qMAecg==$0

SCOTT BIN$sNwTjSipRALgQ2QB PERL_DBD_EXECUTE_ARRAY2	    YES YES
      qMAecg==$0

SCOTT BIN$sNwTmZRgRATgQ2QB TRG_ARRAY_IN_OUT_TESTST	    NO	NO
      qMDH0g==$0

SCOTT BIN$sNwTmZRhRATgQ2QB ARRAY_IN_OUT_TEST		    YES YES
      qMDH0g==$0

SCOTT BIN$sNwTpVRaRAbgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAHiw==$0

SCOTT BIN$sNwTpVRbRAbgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAHiw==$0

SCOTT SYS_IL0000107205C000 SYS_IL0000107205C00002$$	    NO	NO
      02$$

SCOTT SYS_LOB0000107205C00 SYS_LOB0000107205C00002$$	    NO	NO
      002$$

SCOTT BIN$sNwTpVRcRAbgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAHiw==$0

SCOTT SYS_IL0000107208C000 SYS_IL0000107208C00002$$	    NO	NO
      02$$

SCOTT SYS_LOB0000107208C00 SYS_LOB0000107208C00002$$	    NO	NO
      002$$

SCOTT BIN$sNwTpVRdRAbgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAHiw==$0

SCOTT SYS_IL0000107211C000 SYS_IL0000107211C00002$$	    NO	NO
      02$$

SCOTT SYS_LOB0000107211C00 SYS_LOB0000107211C00002$$	    NO	NO
      002$$

SCOTT BIN$sNwTpVReRAbgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAHiw==$0

SCOTT SYS_IL0000107214C000 SYS_IL0000107214C00002$$	    NO	NO
      02$$

SCOTT SYS_LOB0000107214C00 SYS_LOB0000107214C00002$$	    NO	NO
      002$$

SCOTT BIN$sNwUFPboRAjgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMCUFA==$0

SCOTT SYS_IL0000107218C000 SYS_IL0000107218C00003$$	    NO	NO
      03$$

SCOTT SYS_LOB0000107218C00 SYS_LOB0000107218C00003$$	    NO	NO
      003$$

SCOTT BIN$sNwU0s+4RArgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMDWNg==$0

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00002$$	    NO	NO
      02$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00003$$	    NO	NO
      03$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00004$$	    NO	NO
      04$$

SCOTT SYS_IL0000107221C000 SYS_IL0000107221C00005$$	    NO	NO
      05$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00002$$	    NO	NO
      002$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00003$$	    NO	NO
      003$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00004$$	    NO	NO
      004$$

SCOTT SYS_LOB0000107221C00 SYS_LOB0000107221C00005$$	    NO	NO
      005$$

SCOTT BIN$sNwU58qqRAzgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMAOzg==$0

SCOTT BIN$sNwVC1JxRBjgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMBPiQ==$0

SCOTT BIN$sNwX+7oIRCTgQ2QB DBD_ORA__DROP_ME		    YES YES
      qMCF/Q==$0

SCOTT BIN$sNwZmHenRC7gQ2QB DBD_ORA__DROP_ME		    YES YES
      qMDFHA==$0


51 rows selected.

Elapsed: 00:00:00.12
SQL> Everything can be cleaned manually, but I believe that the testing procedure should run "purge recyclebin" at the end: SQL> connect scott/tiger
Connected.
SQL> purge recyclebin;

Recyclebin purged.

Elapsed: 00:00:05.21

After that, there was nothing left:

SQL> select object_name,original_name,can_undrop,can_purge   2 from user_recyclebin;

no rows selected

Elapsed: 00:00:00.04
SQL> perl -e 'use DBD::Oracle;print "$DBD::Oracle::VERSION\n";' 1.34

BTW, the Makefile.PL complained because of not being able to find demo.mk but I circumvented it by using the instant client which was OK. My version is 11.2.0.3 on Linux x86.

-- 
http://mgogala.byethost5.com
Received on Sun Nov 06 2011 - 01:16:35 CDT

Original text of this message