[ https://issues.apache.org/jira/browse/SOLR-11348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Dyer updated SOLR-11348: ------------------------------ Attachment: SOLR-11348.patch [~janhoy] Please try it with [^SOLR-11348.patch] . If it seems good to you, I'll commit this, or you can. I am not very familiar with hsqldb, but this seems to be like it will work. "git diff" didn't include these, but I also think we should add 2 more .gitignore files: - at solr/example/example-DIH {noformat} /logs/ {noformat} - at solr/example/example-DIH/hsqldb {noformat} /ex.tmp/ ex.log ex.lck {noformat} Otherwise, running this example will pollute your checkout. > DIH 'db' example broken in 7.0.0 > -------------------------------- > > Key: SOLR-11348 > URL: https://issues.apache.org/jira/browse/SOLR-11348 > Project: Solr > Issue Type: Bug > Security Level: Public(Default Security Level. Issues are Public) > Components: contrib - DataImportHandler, examples > Affects Versions: 7.0.0 > Reporter: Jan Høydahl > Priority: Blocker > Fix For: 7.0.0 > > Attachments: SOLR-11348.patch > > > The DIH 'db' example is broken in 7.0.0, also in RC3. > h2. Steps to reproduce > # bin/solr -e dih > # open http://localhost:8983/solr/#/db/dataimport//dataimport > # Click "execute" button > # See that "Fetched: 0", should be 16 > # Open {{/solr/example/example-DIH/logs/solr.log}} and see exception > {noformat} > INFO - 2017-09-11 08:16:59.663; [ x:db] > org.apache.solr.handler.dataimport.DataImporter; Data Configuration loaded > successfully > INFO - 2017-09-11 08:16:59.671; [ x:db] org.apache.solr.core.SolrCore; > [db] webapp=/solr path=/dataimport > params={core=db&optimize=false&indent=on&commit=true&name=dataimport&clean=true&wt=json&command=full-import&_=1505117815960&verbose=false} > status=0 QTime=24 > INFO - 2017-09-11 08:16:59.671; [ x:db] > org.apache.solr.handler.dataimport.DataImporter; Starting Full Import > INFO - 2017-09-11 08:16:59.676; [ x:db] org.apache.solr.core.SolrCore; > [db] webapp=/solr path=/dataimport > params={indent=on&wt=json&command=status&_=1505117815960} status=0 QTime=0 > WARN - 2017-09-11 08:16:59.687; [ x:db] > org.apache.solr.handler.dataimport.SimplePropertiesWriter; Unable to read: > dataimport.properties > INFO - 2017-09-11 08:16:59.764; [ x:db] > org.apache.solr.handler.dataimport.JdbcDataSource$1; Creating a connection > for entity item with URL: > jdbc:hsqldb:/Users/janhoy/git/lucene-solr-2/solr/example/example-DIH/hsqldb/ex > ERROR - 2017-09-11 08:17:00.417; [ x:db] > org.apache.solr.common.SolrException; Exception while processing: item > document : SolrInputDocument(fields: > []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to > execute query: select * from item Processing Document # 1 > at > org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:69) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:327) > at > org.apache.solr.handler.dataimport.JdbcDataSource.createResultSetIterator(JdbcDataSource.java:288) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:283) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:52) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73) > at > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:267) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:330) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:233) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:415) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:474) > at > org.apache.solr.handler.dataimport.DataImporter.lambda$runAsync$0(DataImporter.java:457) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.sql.SQLException: error in script file line: 2 > /Users/janhoy/git/lucene-solr-2/solr/example/example-DIH/hsqldb/ex system > object cannot be modified in statement [CREATE CACHED TABLE ITEM(ID > CHAR(8),NAME VARCHAR(100),MANU VARCHAR(50),WEIGHT REAL,PRICE REAL,POPULARITY > INTEGER,INCLUDES VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW)] > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:192) > at > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:528) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:317) > ... 14 more > Caused by: org.hsqldb.HsqlException: error in script file line: 2 > /Users/janhoy/git/lucene-solr-2/solr/example/example-DIH/hsqldb/ex system > object cannot be modified in statement [CREATE CACHED TABLE ITEM(ID > CHAR(8),NAME VARCHAR(100),MANU VARCHAR(50),WEIGHT REAL,PRICE REAL,POPULARITY > INTEGER,INCLUDES VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW)] > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source) > at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) > at org.hsqldb.persist.Log.processScript(Unknown Source) > at org.hsqldb.persist.Log.open(Unknown Source) > at org.hsqldb.persist.Logger.open(Unknown Source) > at org.hsqldb.Database.reopen(Unknown Source) > at org.hsqldb.Database.open(Unknown Source) > at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) > at org.hsqldb.DatabaseManager.newSession(Unknown Source) > ... 21 more > Caused by: org.hsqldb.HsqlException: system object cannot be modified > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.StatementSchema.checkSchemaUpdateAuthorisation(Unknown > Source) > at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source) > at org.hsqldb.StatementSchema.getResult(Unknown Source) > at org.hsqldb.StatementSchema.execute(Unknown Source) > at org.hsqldb.Session.executeCompiledStatement(Unknown Source) > ... 30 more > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org