[Exist-open] RE:exception adding collections and data to MySql

[Kaveri C. <kch...@tu...>]

hi,

The tmp directory does exist in EXIST_HOME and exist has access to it. But I
still have the same Exceptions.

This time I tried to add documents rather than collections. The collections
got added to the database when I restarted tomcat. But they are added only
if I restart tomcat. But with adding documents, I get the following
exceptions:

DEBUG [getCollection] getting collection /db
DEBUG [getDocument] document /db/shakespeare/plays/play/hamlet.xml not found
- java.lang.NullPointerException
	at org.exist.storage.RelationalBroker.flush(RelationalBroker.java:750)
	at org.exist.xmlrpc.RpcServer$RpcConnection.parse(RpcServer.java:1465)
	at org.exist.xmlrpc.RpcServer.parse(RpcServer.java:460)
	at org.exist.xmlrpc.RpcServer.parse(RpcServer.java:443)
	at java.lang.reflect.Method.invoke(Native Method)
	at org.apache.xmlrpc.Invoker.execute(Unknown Source)
	at org.apache.xmlrpc.XmlRpcServer$Worker.executeInternal(Unknown Source)
	at org.apache.xmlrpc.XmlRpcServer$Worker.execute(Unknown Source)
	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
	at org.exist.xmlrpc.RpcServlet.doPost(RpcServlet.java:58)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)



thanks,
Kaveri









Hi,

 it looks like eXist is not able to write temporary data during indexing.
When
 using the relational backend, eXist usually writes all added index data to
a
 file and later loads it into MySQL with LOAD DATA INFILE (this is faster
than
 processing thousands of INSERT statements).

 By default, eXist writes temporary data files to the ./tmp directory in
 EXIST_HOME. Does this directory exist and does eXist have write access to
it?

 Regards,

 Wolfgang


hi,

 I am trying to make eXist work with MySql. I did not have any problems with
 the native backend. Now I changed the conf.xml to use Mysql, created the
 tables using the nysql.sql file.

 once I try to add a collection, I get Exceptions, but I can find the entry
 for it in the table.
 For Example, I added the shakespeare collections to the db, i got the
 exceptions but it was created. But when i tried to add plays it didn't
 create. I am having the same problem while adding documents. What is wrong?

 thanks,
 Kaveri

 Here are the exceptions I am getting:

 DEBUG [getCollection] get: /db
 DEBUG [getCollection] subcollection: shakespeare
 DEBUG [getCollection] subcollection: shakespeare
 DEBUG [getCollection] getting collection /db
 DEBUG [getOrCreateCollection] getting subcollection shakespeare
 DEBUG [getCollection] get: /db/shakespeare
 DEBUG [getCollection] subcollection: plays
 DEBUG [getCollection] getting collection /db/shakespeare
 DEBUG [getOrCreateCollection] getting subcollection plays
 DEBUG [getCollection] get: /db/shakespeare/plays
 DEBUG [getCollection] getting collection /db/shakespeare/plays
 - java.lang.NullPointerException
 	at org.exist.storage.RelationalBroker.flush(RelationalBroker.java:750)
 	at

org.exist.xmlrpc.RpcServer$RpcConnection.createCollection(RpcServer.java:109
 5)
 	at org.exist.xmlrpc.RpcServer.createCollection(RpcServer.java:116)
 	at java.lang.reflect.Method.invoke(Native Method)
 	at org.apache.xmlrpc.Invoker.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer$Worker.executeInternal(Unknown Source)
at
 org.apache.xmlrpc.XmlRpcServer$Worker.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
 	at org.exist.xmlrpc.RpcServlet.doPost(RpcServlet.java:58)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 	at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
 FilterChain.java:247)
 	at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
 ain.java:193)
 	at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
 va:243)
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 66)
 	at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
 va:190)
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 66)
 	at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
 org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
 	at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
 )
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 66)
 	at

org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
 java:170)
 		at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 64)
 	at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
 )
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 64)
 	at
 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 64)
 	at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
 :174)
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 66)
 	at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at

org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
 1012)
 	at

org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107
 )
 	at java.lang.Thread.run(Thread.java:484)

 ERROR [handleException] java.lang.NullPointerException
 	at org.exist.storage.RelationalBroker.flush(RelationalBroker.java:750)
 	at

org.exist.xmlrpc.RpcServer$RpcConnection.createCollection(RpcServer.java:109
 5)
 	at org.exist.xmlrpc.RpcServer.createCollection(RpcServer.java:116)
 	at java.lang.reflect.Method.invoke(Native Method)
 	at org.apache.xmlrpc.Invoker.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer$Worker.executeInternal(Unknown Source)
at
 org.apache.xmlrpc.XmlRpcServer$Worker.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
 	at org.apache.xmlrpc.XmlRpcServer.execute(Unknown Source)
 	at org.exist.xmlrpc.RpcServlet.doPost(RpcServlet.java:58)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 	at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
 FilterChain.java:247)
 	at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
 ain.java:193)
 	at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
 va:243)
 	at

org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
 66)
 	at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
 va:190)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:566)
 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
 a:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
 2343)
 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
 ava:180)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:566)
 	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche
 rValve.java:170)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:564)
 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
 ava:170)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:564)
 	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
 468)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:564)
 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
 a:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
 ve.java:174)
 	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
 .java:566)
 	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
 a:472)
 	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
 r.java:1012)
 	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
 va:1107)
 	at java.lang.Thread.run(Thread.java:484)