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 PeterKerk <ve...@hotmail.com> on 2013/12/26 13:14:36 UTC
org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
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.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by PeterKerk <ve...@hotmail.com>.
Shalin Shekhar Mangar wrote
> Can you try using the debug mode and paste its response?
Ok, thanks. How do I enabled and use the debug mode?
--
View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108248.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by PeterKerk <ve...@hotmail.com>.
This is all I see in the XML response:
This XML file does not appear to have any style information associated with
it. The document tree is shown below.
<response>
<script/>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">39</int>
</lst>
<lst name="initArgs">
<lst name="defaults">
<str name="config">wordpress-data-config.xml</str>
</lst>
</lst>
<str name="command">full-import</str>
<str name="mode">debug</str>
<arr name="documents"/>
<lst name="verbose-output"/>
<str name="status">idle</str>
<str name="importResponse"/>
<lst name="statusMessages">
<str name="Time Elapsed">0:0:0.57</str>
<str name="Total Requests made to DataSource">1</str>
<str name="Total Rows Fetched">0</str>
<str name="Total Documents Processed">0</str>
<str name="Total Documents Skipped">0</str>
<str name="Full Dump Started">2013-12-30 12:21:49</str>
<str name="">Indexing failed. Rolled back all changes.</str>
<str name="Rolledback">2013-12-30 12:21:49</str>
</lst>
<str name="WARNING">
This response format is experimental. It is likely to change in the future.
</str>
</response>
--
View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108682.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
I'm sorry I meant that you should see the XML response returned in
debug mode. The debug mode won't log anything extra but it will
collect information such as the SQL queries executed per entity and
per row. It will also show a stacktrace if there was an error.
On Mon, Dec 30, 2013 at 3:58 PM, PeterKerk <ve...@hotmail.com> wrote:
> I ran the query in debug mode:
> http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import&debug=true
>
> Here's the output, what can you tell from this?
>
> 22432 [qtp33142123-13] INFO
> org.apache.solr.handler.dataimport.JdbcDataSource
> û Creating a connection for entity article with URL:
> jdbc:mysql@localhost:3306/w
> ptalkman
> 22435 [qtp33142123-13] INFO
> org.apache.solr.handler.dataimport.JdbcDataSource
> û Time taken for getConnection(): 3
> 22436 [qtp33142123-13] ERROR org.apache.solr.handler.dataimport.DocBuilder
> û Ex
> ception while processing: article document :
> SolrInputDocument[]:org.apache.solr
> .handler.dataimport.DataImportHandlerException: Unable to execute query:
> SELECT
> * FROM wptalkman.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.DataImportHandler.handleRequestBod
> y(DataImportHandler.java:179)
> at
> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
> erBase.java:135)
> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
> at
> org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
> .java:656)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> r.java:359)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> r.java:155)
> at
> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> Handler.java:1307)
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
> :453)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
> ava:137)
> at
> org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
> a:560)
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
> er.java:231)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
> er.java:1072)
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
> 382)
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
> r.java:193)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
> r.java:1006)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
> ava:135)
> at
> org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Cont
> extHandlerCollection.java:255)
> at
> org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColl
> ection.java:154)
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
> .java:116)
> at org.eclipse.jetty.server.Server.handle(Server.java:365)
> at
> org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac
> tHttpConnection.java:485)
> at
> org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(Blockin
> gHttpConnection.java:53)
> at
> org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(Abstra
> ctHttpConnection.java:926)
> at
> org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.header
> Complete(AbstractHttpConnection.java:988)
> at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
> at
> org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
>
> at
> org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpCo
> nnection.java:72)
> at
> org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(So
> cketConnector.java:264)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
> l.java:608)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
> .java:543)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
> init>(JdbcDataSource.java:241)
> ... 42 more
>
> 22478 [qtp33142123-13] INFO
> org.apache.solr.update.processor.LogUpdateProcessor
> û [tv-wordpress] webapp=/solr path=/dataimport
> params={command=full-import&deb
> ug=true} {} 0 148
> 22479 [qtp33142123-13] ERROR org.apache.solr.handler.dataimport.DataImporter
> û
> Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException:
> org.a
> pache.solr.handler.dataimport.DataImportHandlerException: Unable to execute
> quer
> y: SELECT * FROM wptalkman.wp_posts WHERE post_status='publish' Processing
> Docum
> ent # 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.DataImportHandler.handleRequestBod
> y(DataImportHandler.java:179)
> at
> org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
> erBase.java:135)
> at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
> at
> org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
> .java:656)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> r.java:359)
> at
> org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
> r.java:155)
> at
> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
> Handler.java:1307)
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
> :453)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
> ava:137)
> at
> org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
> a:560)
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
> er.java:231)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
> er.java:1072)
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
> 382)
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
> r.java:193)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
> r.java:1006)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
> ava:135)
> at
> org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Cont
> extHandlerCollection.java:255)
> at
> org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColl
> ection.java:154)
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
> .java:116)
> at org.eclipse.jetty.server.Server.handle(Server.java:365)
> at
> org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac
> tHttpConnection.java:485)
> at
> org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(Blockin
> gHttpConnection.java:53)
> at
> org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(Abstra
> ctHttpConnection.java:926)
> at
> org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.header
> Complete(AbstractHttpConnection.java:988)
> at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
> at
> org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
>
> at
> org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpCo
> nnection.java:72)
> at
> org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(So
> cketConnector.java:264)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
> l.java:608)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
> .java:543)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataIm
> portHandlerException: Unable to execute query: SELECT * FROM
> wptalkman.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)
> ... 33 more
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable
> to execute query: SELECT * FROM wptalkman.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)
> ... 35 more
> Caused by: java.lang.NullPointerException
> at
> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
> init>(JdbcDataSource.java:241)
> ... 42 more
>
> 22501 [qtp33142123-13] INFO org.apache.solr.update.UpdateHandler û start
> rollb
> ack{}
> 22502 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
> Crea
> ting new IndexWriter...
> 22503 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
> Wait
> ing until IndexWriter is unused... core=tv-wordpress
> 22523 [qtp33142123-13] INFO org.apache.solr.core.SolrCore û
> SolrDeletionPolicy
> .onInit: 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@e8b2d0;
> maxCache
> MB=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_Lucene41
> _0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si]
> 22524 [qtp33142123-13] INFO org.apache.solr.core.SolrCore û newest commit
> = 12
> 9[_3o.nvd, _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip,
> _3o.fdt, _3
> o_Lucene41_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si]
> 22524 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
> New
> IndexWriter is ready to be used.
> 22525 [qtp33142123-13] INFO org.apache.solr.update.UpdateHandler û
> end_rollbac
> k
>
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108672.html
> Sent from the Solr - User mailing list archive at Nabble.com.
--
Regards,
Shalin Shekhar Mangar.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by PeterKerk <ve...@hotmail.com>.
I ran the query in debug mode:
http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import&debug=true
Here's the output, what can you tell from this?
22432 [qtp33142123-13] INFO
org.apache.solr.handler.dataimport.JdbcDataSource
û Creating a connection for entity article with URL:
jdbc:mysql@localhost:3306/w
ptalkman
22435 [qtp33142123-13] INFO
org.apache.solr.handler.dataimport.JdbcDataSource
û Time taken for getConnection(): 3
22436 [qtp33142123-13] ERROR org.apache.solr.handler.dataimport.DocBuilder
û Ex
ception while processing: article document :
SolrInputDocument[]:org.apache.solr
.handler.dataimport.DataImportHandlerException: Unable to execute query:
SELECT
* FROM wptalkman.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.DataImportHandler.handleRequestBod
y(DataImportHandler.java:179)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:135)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:656)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:359)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:155)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1307)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:453)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:137)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:560)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
er.java:231)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:1072)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
382)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
r.java:193)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:1006)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:135)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Cont
extHandlerCollection.java:255)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColl
ection.java:154)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:365)
at
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac
tHttpConnection.java:485)
at
org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(Blockin
gHttpConnection.java:53)
at
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(Abstra
ctHttpConnection.java:926)
at
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.header
Complete(AbstractHttpConnection.java:988)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
at
org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at
org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpCo
nnection.java:72)
at
org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(So
cketConnector.java:264)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
l.java:608)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:543)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
init>(JdbcDataSource.java:241)
... 42 more
22478 [qtp33142123-13] INFO
org.apache.solr.update.processor.LogUpdateProcessor
û [tv-wordpress] webapp=/solr path=/dataimport
params={command=full-import&deb
ug=true} {} 0 148
22479 [qtp33142123-13] ERROR org.apache.solr.handler.dataimport.DataImporter
û
Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException:
org.a
pache.solr.handler.dataimport.DataImportHandlerException: Unable to execute
quer
y: SELECT * FROM wptalkman.wp_posts WHERE post_status='publish' Processing
Docum
ent # 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.DataImportHandler.handleRequestBod
y(DataImportHandler.java:179)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:135)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:656)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:359)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:155)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1307)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java
:453)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:137)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:560)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandl
er.java:231)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandl
er.java:1072)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:
382)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandle
r.java:193)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandle
r.java:1006)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.j
ava:135)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(Cont
extHandlerCollection.java:255)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColl
ection.java:154)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper
.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:365)
at
org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(Abstrac
tHttpConnection.java:485)
at
org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(Blockin
gHttpConnection.java:53)
at
org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(Abstra
ctHttpConnection.java:926)
at
org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.header
Complete(AbstractHttpConnection.java:988)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
at
org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at
org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpCo
nnection.java:72)
at
org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(So
cketConnector.java:264)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPoo
l.java:608)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool
.java:543)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataIm
portHandlerException: Unable to execute query: SELECT * FROM
wptalkman.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)
... 33 more
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable
to execute query: SELECT * FROM wptalkman.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)
... 35 more
Caused by: java.lang.NullPointerException
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
init>(JdbcDataSource.java:241)
... 42 more
22501 [qtp33142123-13] INFO org.apache.solr.update.UpdateHandler û start
rollb
ack{}
22502 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
Crea
ting new IndexWriter...
22503 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
Wait
ing until IndexWriter is unused... core=tv-wordpress
22523 [qtp33142123-13] INFO org.apache.solr.core.SolrCore û
SolrDeletionPolicy
.onInit: 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@e8b2d0;
maxCache
MB=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_Lucene41
_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si]
22524 [qtp33142123-13] INFO org.apache.solr.core.SolrCore û newest commit
= 12
9[_3o.nvd, _3o_Lucene41_0.tim, _3o.fnm, _3o.nvm, _3o_Lucene41_0.tip,
_3o.fdt, _3
o_Lucene41_0.pos, segments_3l, _3o.fdx, _3o_Lucene41_0.doc, _3o.si]
22524 [qtp33142123-13] INFO org.apache.solr.update.DefaultSolrCoreState û
New
IndexWriter is ready to be used.
22525 [qtp33142123-13] INFO org.apache.solr.update.UpdateHandler û
end_rollbac
k
--
View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108672.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
I was reading the code and it looks like it could throw an NPE if
java.sql.Statement#execute() returns false which can happen if there
are no results (although most drivers return an empty resultset
instead):
if (stmt.execute(query)) {
resultSet = stmt.getResultSet();
}
LOG.trace("Time taken for sql :"
+ (System.currentTimeMillis() - start));
colNames = readFieldNames(resultSet.getMetaData());
Can you try using the debug mode and paste its response?
On Thu, Dec 26, 2013 at 7:29 PM, PeterKerk <ve...@hotmail.com> wrote:
> Solr 4.3.1
>
> When I run the statement in MySQL Workbench or console the statement
> executes successfully and returns 2 results.
>
> FYI: I placed the mysql-connector-java-5.1.27-bin.jar in the \lib folder.
>
> Also: it should not throw this error even when 0 results are returned right?
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108233.html
> Sent from the Solr - User mailing list archive at Nabble.com.
--
Regards,
Shalin Shekhar Mangar.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by PeterKerk <ve...@hotmail.com>.
Solr 4.3.1
When I run the statement in MySQL Workbench or console the statement
executes successfully and returns 2 results.
FYI: I placed the mysql-connector-java-5.1.27-bin.jar in the \lib folder.
Also: it should not throw this error even when 0 results are returned right?
--
View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-tp4108227p4108233.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query
Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
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 <ve...@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.