个人中心
文章发布
退出
作者热门文章
- html - 出于某种原因，IE8 对我的 Sass 文件中继承的 html5 CSS 不友好？
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景？
26
4
我正在尝试使用在 MySQL 5.6 上运行的 Wordpress 数据库设置 Solr 4.3.1
但是在尝试完全导入时:http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import&debug=true
错误是:org.apache.solr.handler.dataimport.DataImportHandlerException:无法执行查询 SELECT * FROM wp_posts WHERE post_status='publish'
我在 MySQL Workbench 6.06 中执行了这条语句，它在那里工作。
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>
我还尝试在 SQL 语句中包含数据库名称:
SELECT * FROM wptalkman.wp_posts WHERE post_status='publish';
并将连接 url 更改为 jdbc:mysql@localhost:3306
还尝试添加日志转换器:
<entity pk="ID" name="article" query="SELECT * FROM wptalkman.wp_posts WHERE post_status='publish'"
transformer="LogTransformer" logTemplate="The name is ${e.name}" logLevel="debug" >
控制台输出
13420 [qtp16103450-12] INFO org.apache.solr.handler.dataimport.SimpleProperties
Writer û Read dataimport.properties
13506 [qtp16103450-12] INFO org.apache.solr.handler.dataimport.JdbcDataSource
û Creating a connection for entity article with URL: jdbc:mysql@localhost:3306/w
ptalkman
13510 [qtp16103450-12] INFO org.apache.solr.handler.dataimport.JdbcDataSource
û Time taken for getConnection(): 4
13510 [qtp16103450-12] 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
13546 [qtp16103450-12] INFO org.apache.solr.update.processor.LogUpdateProcessor
û [tv-wordpress] webapp=/solr path=/dataimport params={command=full-import&deb
ug=true} {} 0 150
13546 [qtp16103450-12] 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
13568 [qtp16103450-12] INFO org.apache.solr.update.UpdateHandler û start rollb
ack{}
13569 [qtp16103450-12] INFO org.apache.solr.update.DefaultSolrCoreState û Crea
ting new IndexWriter...
13569 [qtp16103450-12] INFO org.apache.solr.update.DefaultSolrCoreState û Wait
ing until IndexWriter is unused... core=tv-wordpress
13589 [qtp16103450-12] 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@13396fa; 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]
13590 [qtp16103450-12] 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]
13591 [qtp16103450-12] INFO org.apache.solr.update.DefaultSolrCoreState û New
IndexWriter is ready to be used.
13591 [qtp16103450-12] INFO org.apache.solr.update.UpdateHandler û end_rollbac
k
更新:在 JDBC 连接字符串中添加了记录器
使用此 URL url="jdbc:mysql@localhost:3306/wptalkman?logger=com.mysql.jdbc.log.Log4JLogger&profileSQL=true;"
我得到:数据配置问题:对实体“profileSQL”的引用必须以“;”结尾分隔符。
使用此网址:url="jdbc:mysql@localhost:3306/wptalkman?logger=com.mysql.jdbc.log.Log4JLogger"
我在控制台中得到这个:
5696 [qtp16103450-11] INFO org.apache.solr.handler.dataimport.JdbcDataSource û
Creating a connection for entity article with URL: jdbc:mysql@localhost:3306/wp
talkman?logger=com.mysql.jdbc.log.Log4JLogger
5700 [qtp16103450-11] INFO org.apache.solr.handler.dataimport.JdbcDataSource û
Time taken for getConnection(): 4
5700 [qtp16103450-11] ERROR org.apache.solr.handler.dataimport.DocBuilder û Exc
eption 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
5714 [qtp16103450-11] INFO org.apache.solr.update.processor.LogUpdateProcessor
û [tv-wordpress] webapp=/solr path=/dataimport params={command=full-import&debu
g=true} {} 0 122
5715 [qtp16103450-11] ERROR org.apache.solr.handler.dataimport.DataImporter û F
ull Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.ap
ache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query
: SELECT * FROM wptalkman.wp_posts WHERE post_status='publish' Processing Docume
nt # 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
5737 [qtp16103450-11] INFO org.apache.solr.update.UpdateHandler û start rollba
ck{}
5738 [qtp16103450-11] INFO org.apache.solr.update.DefaultSolrCoreState û Creat
ing new IndexWriter...
5739 [qtp16103450-11] INFO org.apache.solr.update.DefaultSolrCoreState û Waiti
ng until IndexWriter is unused... core=tv-wordpress
5776 [qtp16103450-11] 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@1a1a366; 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]
5777 [qtp16103450-11] INFO org.apache.solr.core.SolrCore û newest commit = 129
[_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]
5777 [qtp16103450-11] INFO org.apache.solr.update.DefaultSolrCoreState û New I
ndexWriter is ready to be used.
5778 [qtp16103450-11] INFO org.apache.solr.update.UpdateHandler û end_rollback
最佳答案
在这里找到:http://alvinalexander.com/java/jdbc-connection-string-mysql-postgresql-sqlserver (见页面底部)
原来在我的连接字符串中我不得不使用 :// 而不是 @现在可以了:)
关于mysql - org.apache.solr.handler.dataimport.DataImportHandlerException : Unable to execute query，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/20703785/
26
4
0
Schema.org、Goodrelations-vocabulary.org 和 Productontology.org 之间有什么关系？ Schema.org 告知，“W3C schema.org
大家好，我想知道包 org.ietf、org.omg、org.w3c 和 org 是如何实现的.xml 已进入 "official" Java classes ？ 例如，默认 JDK 不会包含 Apa
首先，我试图用来自 Schema.org 的属性定义数据库表，例如，例如，我有一个名为“JobPosting”的表，它或多或少具有与 http://schema.org/JobPosting 中定义的
我有一个 org.w3c.dom.Document 被 org.dom4j.io.DOMReader 解析。 我想通过 org.w3c.dom.Element 搜索 dom4j DOM 文档。 比方说
我正在将我的应用程序部署到 Tomcat 6.0.20。 应用程序使用 Hibernate 作为 Web 层的 ORM、Spring 和 JSF。 我还从 main() 方法制作了简单的运行器来测试
我有一个使用 hibernate > 4 的 gradle 项目。如果我在 Apache tomcat 中运行我的 war 文件，我不会收到任何错误。但是当我在 Wildfly 8.2 中部署它时，出
我正在尝试将 JaCoCo 添加到我的 Android 以覆盖 Sonar Qube。但是在运行命令 ./gradlew jacocoTestReport 时，我收到以下错误。 Task :app:
如何在 emacs 组织模式中格式化日期？ 例如，在下表中，我希望日期显示为“Aug 29”或“Wed, Aug 29”而不是“” #+ATTR_HTML: border="2" rules="all
我想使用 org 模式来写一本技术书籍。我正在寻找一种将外部文件中的现有代码插入到 babel 代码块中的方法，该代码块在导出为 pdf 时会提供很好的格式。 例如 #+BEGIN_SRC pytho
用作引用:https://support.google.com/webmasters/answer/146750?hl=en 您会注意到在“产品”下有一个属性类别，此外页面下方还有一个示例: Too
我读了这个Google doc .它说我们不使用列表中的产品。 那么对于产品列表(具有多页的类似产品的类别，如“鞋子”)，推荐使用哪种模式？ 我用这个: { "@context": "htt
我目前在做DBpedia数据集，想通过wikidata实现schema.org和DBpedia的映射。因此我想知道 schema.org 和 wikidata 之间是否存在任何映射。 最佳答案 我认为
我爱org-tables ，我用它们来记录各种事情。我现在正在为 Nix 记录一些单行代码(在阅读了 Domen Kožar 的 excellent guide 后，在 this year's Eur
如果看一下 Movie在 schema.org 中输入，actor 和 actors 属性都是允许的(actor 取代 actors)。但是 author 和 contributor 属性没有等效项。
我们有一些餐厅有多个地点或分支机构。我想包含正确的 Schema.org 标记，但找不到任何允许列出多个餐厅的内容。 每家餐厅都有自己的地址、电子邮件、电话和营业时间，甚至可能是“分店名称”。 两个分
我在一个页面中有多个综合评分片段。 有没有办法让其中之一成为默认值？将显示在搜索引擎结果中的那个？ 谢谢大家! 更新:该网页本质上是品牌的页面。它包含品牌评论的总评分及其产品列表(每个产品的总评分)。
我提到了一些相关的职位，但并没有解决我的问题。因为我正在使用maven-jar-plugin-2.4 jar。 我正在使用JBoss Developer Studio 7.1.1 GA IDE，并且正
网站的根页面(即 http://example.com/ )的特殊之处在于它是默认的着陆页。它可能包含许多不同的对象类型。 它可能被认为是一个网站，或者一个博客等... 但它是否也应该被标记为给定对象
我想将一些文本放入一个 org 文件中，当我将内容导出到其中一种目标类型(在本例中为 HTML)时，该文件不会发布。有什么方法可以实现这个目标吗？ 最佳答案 您可能想要使用 :noexport: 标签
org-mode 是否有一个键绑定(bind)可以在编号/项目符号列表项之间移动，就像您可以对标题一样？ 喜欢的功能: org-forward-heading-same-level 大纲下一个可见标题
我是一名优秀的程序员,十分优秀！