You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Lukas Kahwe Smith <ml...@pooteeweet.org> on 2010/06/13 16:46:39 UTC

error running dih import

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

regards,
Lukas Kahwe Smith
mls@pooteeweet.org

Re: error running dih import

Posted by Lukas Kahwe Smith <ml...@pooteeweet.org>.
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
mls@pooteeweet.org