On 13.06.2010, at 16:46, Lukas Kahwe Smith wrote: > Hi, > > what could cause this issue? > i cannot reproduce it on my dev machine, but i am pretty sure its not an > access control issue in either the file system nor the database. > > INFO: Creating a connection for entity entitydelete with URL: > jdbc:mysql://localhost/foo > Jun 13, 2010 4:06:54 PM org.apache.solr.handler.dataimport.JdbcDataSource$1 > call > rImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:246) > ... 12 more > Jun 13, 2010 4:13:47 PM org.apache.solr.update.DirectUpdateHandler2 rollback > INFO: start rollback > Jun 13, 2010 4:13:47 PM org.apache.solr.update.DirectUpdateHandler2 rollback > INFO: end_rollback
it seems the issue was caused by NULL values that i was referencing inside a nested query. generally the error messages generated by DIH could be a lot better. in the end i managed to fix the issue by reducing my DIH script to one entity tag and then going through each of them one after each other. oddly then i finally got a different error message, which included the query inside the nested entity. fixed that issue and now the import worked through. weird. regards, Lukas Kahwe Smith m...@pooteeweet.org
