From: <pa...@pa...> - 2004-11-25 18:28:27
|
Hello all,<br />I downloaded the last version from CVS today. When trying to run GBParser on a test dataset (one GenBank entry of D. melanogaster), I got this=A0 "ORA-01000: maximum open cursors exceeded" error.= <br /><br />Have you heard of this before? Is there any new modification that could have caused this? For instance, the main class that queries Oracle is opening and not closing connections?<br /><br />Below is the complete error.<br /><br />Thanks for any help,<br />Pablo<br /><br />[pablo@kineto2 pablo]$ ga GUS::Common::Plugin::GBParser --gbRel=3D144 --file=3D/home/pablo/batchseq.genbank --db_rel_id=3D145<br />Thu Nov 25 16:31:59 2004=A0=A0=A0=A0=A0=A0=A0 COMMIT=A0 commit off<br />Maximum numb= er of=A0 objects set to 50000<br />Thu Nov 25 16:31:59 2004=A0=A0=A0=A0=A0=A0=A0 RELEASE 1= 44<br />=A0<br />Thu Nov 25 16:31:59 2004=A0=A0=A0=A0=A0=A0=A0 FILE=A0=A0=A0 /home/pablo= /batchseq.genbank<br /><br />(...)<br /><br />DBD::Oracle::st execute failed: ORA-00604: error occurred at recursive SQL level 1<br />ORA-01000: maximum open cursors exceeded (DBD ERROR: OCIStmtExecute) [for statement ``select DoTS.NAFeatureNAProtein_SQ.NEXTVAL from DUAL'' with params: ]) at /usr/local/gus/gus_home/lib/perl/GUS/ObjRelP/DbiTable.pm line 554, <GEN0> line 5038.<br />Thu Nov 25 16:32:02 2004=A0=A0=A0=A0=A0=A0=A0= Genbank entries inserted=3D 0;=A0 updated=3D 0; total #(inserted::updated::deleted)=3D389::::<br />=A0<br />Thu Nov 25 16:32:02 2004=A0=A0=A0=A0=A0=A0=A0 FAILURES=A0=A0=A0=A0=A0=A0=A0 Unable to process= 2 entries. See gbparserFailures/<br />Thu Nov 25 16:32:02 2004=A0=A0=A0=A0=A0=A0=A0 RESU= LT=A0 Genbank entries inserted=3D 0;=A0 updated=3D 0;=A0 failed=3D 2<br /><br /><br /><= br /> |