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 Jeff Zhang <zj...@gmail.com> on 2011/03/07 05:52:49 UTC

Exception happened when using DataImportHandler

Hi all,

When I use DataImportHandler, weird SQLException exception happens
(java.sql.SQLException: Illegal value for setFetchSize(). )and I google this
problem but did not found any answers. Could anyone help me to point out
what's the problem ?

*This is the error exception*

org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute
 query:  select group_concat(ITEM_RANK separator ' ') as ITEM_RANK,
group_concat
(ITEM_SALE_TYPE separator ' ') as ITEM_SALE_TYPE, group_concat(ITEM_ID
separator
 ' ') as ITEM_ID, group_concat(KEYWORD separator ' ') as KEYWORD from
sessioneve
nt group by SESSION_SKEY Processing Document # 1
        at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd
Throw(DataImportHandlerException.java:72)
        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:39)
        at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.
java:184)
        at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn
tityProcessor.java:58)
        at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti
tyProcessor.java:71)
        at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent
ityProcessorWrapper.java:237)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde
r.java:357)
        at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j
ava:242)
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java
:180)
        at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo
rter.java:331)
        at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j
ava:389)
        at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBod
y(DataImportHandler.java:203)
        at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:131)
        at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
        at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:338)
        at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:241)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1089)
        at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
65)
        at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
        at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
81)
        at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
12)
        at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

        at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:211)
        at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
        at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
39)
        at org.mortbay.jetty.Server.handle(Server.java:285)
        at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
2)
        at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
nnection.java:821)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
        at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
java:226)
        at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
.java:442)
Caused by: java.sql.SQLException: Illegal value for setFetchSize().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at
com.mysql.jdbc.StatementImpl.setFetchSize(StatementImpl.java:2496)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
init>(JdbcDataSource.java:242)
        ... 33 more
Mar 7, 2011 12:50:44 PM org.apache.solr.handler.dataimport.DataImporter
doFullIm
port
SEVERE: Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute
 query:  select group_concat(ITEM_RANK separator ' ') as ITEM_RANK,
group_concat
(ITEM_SALE_TYPE separator ' ') as ITEM_SALE_TYPE, group_concat(ITEM_ID
separator
 ' ') as ITEM_ID, group_concat(KEYWORD separator ' ') as KEYWORD from
sessioneve
nt group by SESSION_SKEY Processing Document # 1
        at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd
Throw(DataImportHandlerException.java:72)
        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:39)
        at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.
java:184)
        at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn
tityProcessor.java:58)
        at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti
tyProcessor.java:71)
        at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent
ityProcessorWrapper.java:237)
        at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde
r.java:357)
        at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j
ava:242)
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java
:180)
        at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo
rter.java:331)
        at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j
ava:389)
        at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBod
y(DataImportHandler.java:203)
        at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.java:131)
        at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
        at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter
.java:338)
        at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilte
r.java:241)
        at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1089)
        at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
65)
        at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
        at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
81)
        at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
12)
        at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

        at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:211)
        at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
        at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
39)
        at org.mortbay.jetty.Server.handle(Server.java:285)
        at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
2)
        at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
nnection.java:821)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
        at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
java:226)
        at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
.java:442)
Caused by: java.sql.SQLException: Illegal value for setFetchSize().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at
com.mysql.jdbc.StatementImpl.setFetchSize(StatementImpl.java:2496)
        at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<
init>(JdbcDataSource.java:242)
        ... 33 more
Mar 7, 2011 12:50:44 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: start rollback
Mar 7, 2011 12:50:44 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: end_rollback
Mar 7, 2011 12:50:44 PM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/select
params={clean=on&commit=on&start=0&dataConfig
=<dataConfig>%0d%0a%09<dataSource+name%3D"jdbc"+driver%3D"com.mysql.jdbc.Driver"
%0d%0a%09%09url%3D"jdbc:mysql://localhost:3306/test"+user%3D"root"+password%3D"z
jf19820408"%0d%0a%09%09readOnly%3D"true"+autoCommit%3D"false"+/>%0d%0a%09<docume
nt>%0d%0a%09%09<entity+name%3D"session_event_agg"+dataSource%3D"jdbc"+query%3D"%
0d%0aselect+group_concat(ITEM_RANK+separator+'+')+as+ITEM_RANK,%0d%0agroup_conca
t(ITEM_SALE_TYPE+separator+'+')+as+ITEM_SALE_TYPE,%0d%0agroup_concat(ITEM_ID+sep
arator+'+')+as+ITEM_ID,%0d%0agroup_concat(KEYWORD+separator+'+')+as+KEYWORD%0d%0
afrom+sessionevent+group+by+SESSION_SKEY"%0d%0a%09%09%09transformer%3D"RegexTran
sformer,DateFormatTransformer,%0d%0aTemplateTransformer">%0d%0a%09%09%09<field+c
olumn%3D"ITEM_RANK"+name%3D"attr_ITEM_RANK"+/>%0d%0a%09%09%09<field+column%3D"IT
EM_SALE_TYPE"+name%3D"attr_ITEM_SALE_TYPE"+/>%0d%0a%09%09%09<field+column%3D"ITE
M_ID"+template%3D"attr_ITEM_ID"+/>%0d%0a%09%09%09<field+column%3D"KEYWORD"+templ
ate%3D"attr_KEYWORD"+/>%0d%0a%09%09</entity>%0d%0a%09</document>%0d%0a</dataConf
ig>&verbose=on&command=full-import&debug=on&qt=/dataimport&rows=10} status=0
QTi
me=47
-- 
Best Regards

Jeff Zhang