[
https://issues.apache.org/jira/browse/SOLR-1842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexandre Rafalovitch resolved SOLR-1842.
-----------------------------------------
Resolution: Won't Fix
> 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
> Priority: Major
>
> 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 was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
