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 <vettepa...@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.
