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.
