several errors during bulk add (ORA-13199, ORA-12801, ORA-01652, ORA-01653)
766393Jul 15 2010 — edited Jul 15 2010Hi,
In a batch process I use a parallel bulk add to insert several millions of triples in an RDF model.
At some point, an insert failed with this message :
ORA-13199: Failed in DDL_same_rdf_indexes call:ORA-13199: step_num=6 SQLERRM=ORA-12801: error signaled in parallel query server P020
ORA-01652: unable to extend temp segment by 128 in tablespace RDF dss=ALTER INDEX "RDF_LNK_SCPM_IDX" REBUILD PARTITION MODEL_63 NOLOGGING PARALLEL ONLINE ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9223
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9428
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 9441
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 4255
ORA-06512: at "MDSYS.SDO_RDF", line 276
ORA-06512: at "MDSYS.RDF_APIS", line 693
ORA-06512: at line 1
Since the batch process continued and tried to insert later on, I got this error twice, then another one several times :
ORA-13199: During LBV:ORA-01653: unable to extend table MDSYS.RDF$TV_3F_1501FA303B1C4_56 by 128 in tablespace RDF ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1319
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1414
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3786
ORA-06512: at "MDSYS.SDO_RDF", line 276
ORA-06512: at "MDSYS.RDF_APIS", line 693
ORA-06512: at line 1
Finally, later on, the bulk insert worked with no error. I haven't had any kind of similar errors since.
Any idea what could have caused this ?
Thanks,
Regards,
Julien