[
https://issues.apache.org/jira/browse/SOLR-1842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12851722#action_12851722
]
Lance Norskog commented on SOLR-1842:
-------------------------------------
Could the DIH shut down all Datasources & EntityProcessors before calling
commit? After all, they are finished at that point.
> DataImportHandler ODBC keeps lock on the source table while optimisatising is
> being run...
> ------------------------------------------------------------------------------------------
>
> Key: SOLR-1842
> URL: https://issues.apache.org/jira/browse/SOLR-1842
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 1.5
> Reporter: Marcin
>
> Hi Guys,
> I don't know if its really a bug but I think its quite good place for it.
> The problem is with dataImportHandler and DB queries.
> For example:
> Let's have a big table which keeps docs to being indexed, we are running
> query against it on a datimporthandler and query locks table which is quite
> obvius and desire behaviour from the SQL points of view but while
> optimisation is being done its should not allow to issue query because in
> that case table is being locked till optimisation process will finish which
> can take a time...
> As a workaround you can use "select SQL_BUFFER_RESULT..." statment which will
> move everything into temp table and release all locks but still
> dataImportHandlerwill be waiting for optimisation to finish. Which means you
> will be able to insert new docs into main table at least.
> cheers
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
