DIH errors

[Midas A <te...@gmail.com>]

Please help us

a)

java.sql.SQLException: Streaming result set
com.mysql.jdbc.RowDataDynamic@755ea675 is still active. No statements
may be issued when any streaming result sets are open and in use on a
given connection. Ensure that you have called .close() on any active
streaming result sets before attempting more queries.

b) java.lang.RuntimeException: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
to execute query: SELECT pf.feature_id,
REPLACE(REPLACE(REPLACE(pfd.filter, '\n', ''), '', ''), '\r','') as
COLcolor_col, pfv.variant_id,
CONCAT(pfv.variant_id,'_',(REPLACE(REPLACE(REPLACE(fvd.variant, '\n',
''), '', ''), '\r',''))) as COLcolor_col_val  FROM
cscart_product_filters pf  inner join
cscart_product_filter_descriptions pfd on pfd.filter_id = pf.filter_id
inner join cscart_categories c on find_in_set (c.category_id,
pf.categories_path) inner join cscart_products_categories pc on
pc.category_id = c.category_id left join
cscart_product_features_values pfv on pfv.feature_id = pf.feature_id
and pfv.product_id = pc.product_id left join
cscart_product_feature_variant_descriptions fvd on fvd.variant_id =
pfv.variant_id where pf.feature_id != 53 and pc.product_id =
'72664486' and pf.status = 'A' order by pf.position asc Processing
Document # 517710

	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:266)
	at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:451)
	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:489)
	at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:468)
Caused by: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
to execute query: SELECT pf.feature_id,
REPLACE(REPLACE(REPLACE(pfd.filter, '\n', ''), '', ''), '\r','') as
COLcolor_col, pfv.variant_id,
CONCAT(pfv.variant_id,'_',(REPLACE(REPLACE(REPLACE(fvd.variant, '\n',
''), '', ''), '\r',''))) as COLcolor_col_val  FROM
cscart_product_filters pf  inner join
cscart_product_filter_descriptions pfd on pfd.filter_id = pf.filter_id
inner join cscart_categories c on find_in_set (c.category_id,
pf.categories_path) inner join cscart_products_categories pc on
pc.category_id = c.category_id left join
cscart_product_features_values pfv on pfv.feature_id = pf.feature_id
and pfv.product_id = pc.product_id left join
cscart_product_feature_variant_descriptions fvd on fvd.variant_id =
pfv.variant_id where pf.feature_id != 53 and pc.product_id =
'72664486' and pf.status = 'A' order by pf.position asc Processing
Document # 517710
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:406)
	at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:353)
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:219)
	... 3 more
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query: SELECT pf.feature_id,
REPLACE(REPLACE(REPLACE(pfd.filter, '\n', ''), '', ''), '\r','') as
COLcolor_col, pfv.variant_id,
CONCAT(pfv.variant_id,'_',(REPLACE(REPLACE(REPLACE(fvd.variant, '\n',
''), '', ''), '\r',''))) as COLcolor_col_val  FROM
cscart_product_filters pf  inner join
cscart_product_filter_descriptions pfd on pfd.filter_id = pf.filter_id
inner join cscart_categories c on find_in_set (c.category_id,
pf.categories_path) inner join cscart_products_categories pc on
pc.category_id = c.category_id left join
cscart_product_features_values pfv on pfv.feature_id = pf.feature_id
and pfv.product_id = pc.product_id left join
cscart_product_feature_variant_descriptions fvd on fvd.variant_id =
pfv.variant_id where pf.feature_id != 53 and pc.product_id =
'72664486' and pf.status = 'A' order by pf.position asc Processing
Document # 517710
	at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
	at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
	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:243)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:465)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:491)
	at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
	... 5 more