lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject Re: error running dih import
Date Sun, 13 Jun 2010 20:47:05 GMT

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




Mime
View raw message