Oracle Java stack trace files
B HallFeb 13 2013 — edited Mar 1 2013Possibly someone's been down this road before. This is a first for me with this particular issue, thanks in advance for looking.
Issue: Oracle is dumping about 3-4 Java stack trace's per minute due to a bad call (according to support) to FROM_WKTGEOMETRY. But - v$sql does not show anything, and unless I am missing something, there is not enough information in the trace file to discover WHO or WHAT is causing this problem (looking up the PID shown does no good - as the one that caused it is now gone). Yes it is most likely bad input - but from what?
Fortunately the trace files are all small, so disk space isn't really an issue. And from what I can tell, the system's been doing this for a long time, but no one noticed before because Java-based trace files are not recorded in the alert log.
Any ideas at this point are very welcome as support has no suggestions.
Example dump (with a few things blanked with XXX's to protect the innocent):
Trace file /okcgisrwprdsg/u01/app/oracle/diag/rdbms/gisrwprd/gisrwprd/trace/gisrwprd_ora_23920962.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1
System name: AIX
Node name: okcaixprd300a
Release: 1
Version: 6
Machine: 00F618644C00
Instance name: gisrwprd
Redo thread mounted by this instance: 1
Oracle process number: 1281
Unix process pid: 23920962, image: oracle@okcaixprd300a
*** 2013-02-13 14:00:26.249
*** SESSION ID:(103.56321) 2013-02-13 14:00:26.249
*** CLIENT ID:() 2013-02-13 14:00:26.249
*** SERVICE NAME:(gisrwprd.XXX) 2013-02-13 14:00:26.249
*** MODULE NAME:(php-cgi.exe) 2013-02-13 14:00:26.249
*** ACTION NAME:() 2013-02-13 14:00:26.249
java.lang.RuntimeException: 41
at oracle.spatial.util.WKT$WKTInputStream.readDouble(WKT.java)
at oracle.spatial.util.WKBasis.readDouble(WKBasis.java)
at oracle.spatial.util.WKBasis.toJGeometry_WKB_POINT(WKBasis.java)
at oracle.spatial.util.WKBasis.toJGeometry(WKBasis.java)
at oracle.spatial.util.WKBasis.toJGeometry(WKBasis.java)
at oracle.spatial.util.WKBasis.toSTRUCT(WKBasis.java)
at oracle.spatial.util.Adapters.wktToSTRUCT2(Adapters.java)
at oracle.spatial.util.Adapters.wktToSTRUCT(Adapters.java)
at oracle.spatial.util.Adapters.wktToSTRUCT(Adapters.java)
Exception in thread "Root Thread" java.sql.SQLException
at oracle.spatial.util.Adapters.wktToSTRUCT(Adapters.java)