DBD::Oracle puts junk into the recyclebin
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.comReceived on Sun Nov 06 2011 - 01:16:35 CDT