Hi,
I am running into a rather perplexing issue and am hoping someone can be of help.
We are encountering a problem that has our database locking up when a native sql query is being run at the same time a Talend based process is running. It looks like the Talend job is blocking access to a table that is being read by the native sql call and the Talend job and this in turn is backing up all other calls to the database. But before you say, it is a dba thing... the problem is only occurring when this one Talend job runs at the same time this particular native sql query runs (is a select only statement).
The Talend job is a rather straightforward one that uses a tMySQLInput component to read the data, a tMap component to map the data, and a tMySQLOutput component to load the data. Nothing complex here.
Onto my question... is anyone aware of any locking that may take place by a Talend job for tables it reads? The key word here is reads. The table that gets loaded is a basic extract table used only by the job mentioned above and the tables common between the Talend job and the native sql are used for reads only. I do not see any options in the job that indicates whether a table read should be shared or exclusive and am not sure why this job is bringing the database to a standstill.
Any input is greatly appreciated.
Regards,
Tom G.