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.
