Which version of Solr are you using? Is it possible that the query you ran returns 0 results?
On Thu, Dec 26, 2013 at 5:44 PM, PeterKerk <vettepa...@hotmail.com> wrote: > I'm trying to setup Solr with a Wordpress database running on MySQL. > > But on trying a full import: > `http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import` > > > The error is: > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to > execute query > > > **data-config.xml** > > <dataConfig> > <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql@localhost:3306/wptalkman" user="root" password="****" /> > <document name="articles"> > <entity pk="id" name="article" query="SELECT * FROM > wp_posts WHERE > post_status='publish';"> > <field name="id" column="ID" /> > <field name="post_title" column="post_title" > /> > <field name="post_author" > column="post_author" /> > </entity> > </document> > </dataConfig> > > > I also tried including the database name in the SQL statement: > > SELECT * FROM wptalkman.wp_posts WHERE post_status='publish'; > > and change the connection url to `jdbc:mysql@localhost:3306` > > But I'm still unable to execute the query. > > > **console output** > > 194278 [Thread-22] INFO org.apache.solr.update.UpdateHandler û start > rollback{ > } > 194279 [Thread-22] INFO org.apache.solr.update.DefaultSolrCoreState û > Creating > new IndexWriter... > 194279 [Thread-22] INFO org.apache.solr.update.DefaultSolrCoreState û > Waiting > until IndexWriter is unused... core=tv-wordpress > 194280 [Thread-22] INFO org.apache.solr.update.DefaultSolrCoreState û > Rollback > old IndexWriter... core=tv-wordpress > 194282 [Thread-22] INFO org.apache.solr.core.SolrCore û > SolrDeletionPolicy.onI > nit: commits:num=1 > > commit{dir=NRTCachingDirectory(org.apache.lucene.store.SimpleFSDirectory > > @C:\Dropbox\Databases\solr-4.3.1\example\example-DIH\solr\tv-wordpress\data\inde > x lockFactory=org.apache.lucene.store.SingleInstanceLockFactory@10ff234; > maxCach > eMB=48.0 > maxMergeSizeMB=4.0),segFN=segments_3l,generation=129,filenames=[_3o.nvd > , _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip, _3o.fdt, > _3o_Lucene4 > 1_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si] > 194283 [Thread-22] INFO org.apache.solr.core.SolrCore û newest commit > = 129[_3 > o.nvd, _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip, > _3o.fdt, _3o_Lu > cene41_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si] > 194283 [Thread-22] INFO org.apache.solr.update.DefaultSolrCoreState û > New Inde > xWriter is ready to be used. > 194283 [Thread-22] INFO org.apache.solr.update.UpdateHandler û > end_rollback > 194669 [qtp32398134-13] INFO > org.apache.solr.handler.dataimport.DataImporter û > Loading DIH Configuration: wordpress-data-config.xml > 194672 [qtp32398134-13] INFO > org.apache.solr.handler.dataimport.DataImporter û > Data Configuration loaded successfully > 194676 [Thread-23] INFO org.apache.solr.handler.dataimport.DataImporter > û Star > ting Full Import > 194676 [qtp32398134-13] INFO org.apache.solr.core.SolrCore û > [tv-wordpress] we > bapp=/solr path=/dataimport params={command=full-import} status=0 > QTime=8 > 194680 [Thread-23] INFO > org.apache.solr.handler.dataimport.SimplePropertiesWrit > er û Read dataimport.properties > 194681 [Thread-23] INFO org.apache.solr.core.SolrCore û [tv-wordpress] > REMOVIN > G ALL DOCUMENTS FROM INDEX > 194686 [Thread-23] INFO > org.apache.solr.handler.dataimport.JdbcDataSource û Cr > eating a connection for entity article with URL: > jdbc:mysql@localhost:3306/wptal > kman > 194686 [Thread-23] INFO > org.apache.solr.handler.dataimport.JdbcDataSource û Ti > me taken for getConnection(): 0 > 194687 [Thread-23] ERROR org.apache.solr.handler.dataimport.DocBuilder > û Except > ion while processing: article document : > SolrInputDocument[]:org.apache.solr.han > dler.dataimport.DataImportHandlerException: Unable to execute query: > select * fr > om wp_posts WHERE post_status='publish' Processing Document # 1 > at > org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd > Throw(DataImportHandlerException.java:71) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< > init>(JdbcDataSource.java:253) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou > rce.java:210) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou > rce.java:38) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn > tityProcessor.java:59) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti > tyProcessor.java:73) > at > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent > ityProcessorWrapper.java:243) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde > r.java:465) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde > r.java:404) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j > ava:319) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java > :227) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo > rter.java:422) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j > ava:487) > at > org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.ja > va:468) > Caused by: java.lang.NullPointerException > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< > init>(JdbcDataSource.java:241) > ... 12 more > > 194689 [Thread-23] INFO > org.apache.solr.update.processor.LogUpdateProcessor û > [tv-wordpress] webapp=/solr path=/dataimport > params={command=full-import} status > =0 QTime=8 {deleteByQuery=*:*} 0 8 > 194690 [Thread-23] ERROR org.apache.solr.handler.dataimport.DataImporter > û Full > Import failed:java.lang.RuntimeException: java.lang.RuntimeException: > org.apach > e.solr.handler.dataimport.DataImportHandlerException: Unable to execute > query: s > elect * from wp_posts WHERE post_status='publish' Processing Document # > 1 > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java > :266) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo > rter.java:422) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j > ava:487) > at > org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.ja > va:468) > Caused by: java.lang.RuntimeException: > org.apache.solr.handler.dataimport.DataIm > portHandlerException: Unable to execute query: select * from wp_posts > WHERE post > _status='publish' Processing Document # 1 > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde > r.java:406) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j > ava:319) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java > :227) > ... 3 more > Caused by: > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable > to execute query: select * from wp_posts WHERE post_status='publish' > Processing > Document # 1 > at > org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd > Throw(DataImportHandlerException.java:71) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< > init>(JdbcDataSource.java:253) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou > rce.java:210) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou > rce.java:38) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn > tityProcessor.java:59) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti > tyProcessor.java:73) > at > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent > ityProcessorWrapper.java:243) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde > r.java:465) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde > r.java:404) > ... 5 more > Caused by: java.lang.NullPointerException > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< > init>(JdbcDataSource.java:241) > ... 12 more > > 194699 [Thread-23] INFO org.apache.solr.update.UpdateHandler û start > rollback{ > } > 194700 [Thread-23] INFO org.apache.solr.update.DefaultSolrCoreState û > Creating > new IndexWriter... > 194700 [Thread-23] INFO org.apache.solr.update.DefaultSolrCoreState û > Waiting > until IndexWriter is unused... core=tv-wordpress > 194700 [Thread-23] INFO org.apache.solr.update.DefaultSolrCoreState û > Rollback > old IndexWriter... core=tv-wordpress > 194703 [Thread-23] INFO org.apache.solr.core.SolrCore û > SolrDeletionPolicy.onI > nit: commits:num=1 > > commit{dir=NRTCachingDirectory(org.apache.lucene.store.SimpleFSDirectory > > @C:\Dropbox\Databases\solr-4.3.1\example\example-DIH\solr\tv-wordpress\data\inde > x lockFactory=org.apache.lucene.store.SingleInstanceLockFactory@10ff234; > maxCach > eMB=48.0 > maxMergeSizeMB=4.0),segFN=segments_3l,generation=129,filenames=[_3o.nvd > , _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip, _3o.fdt, > _3o_Lucene4 > 1_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si] > 194704 [Thread-23] INFO org.apache.solr.core.SolrCore û newest commit > = 129[_3 > o.nvd, _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip, > _3o.fdt, _3o_Lu > cene41_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si] > 194704 [Thread-23] INFO org.apache.solr.update.DefaultSolrCoreState û > New Inde > xWriter is ready to be used. > 194704 [Thread-23] INFO org.apache.solr.update.UpdateHandler û > end_rollback > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227.html > Sent from the Solr - User mailing list archive at Nabble.com. -- Regards, Shalin Shekhar Mangar.
