Sharon,

This job works fine on Postgres.

If it's some kind of blocking I would have the same problem on Postgres. What do you think ?

Kleyson Rios.

Hi Sharon, I don't know if it is possible to control how many concurrent load streams are created. I believe that is not possible. I will try to check again profiling data. Would be possible you simulate a case where you get more concurrency queries than PLANNEDCONCURRENCY to see if the problem also...

Hi Sharon, In both scenarios all loads are being initiated against node0001? I have just one node. I tried Data Profiling, but nothing special for me that can help me to understand the problem. I did a new configuration: High PLANNEDCONCURRENCY ( = 15 ) and Low MAXCONCURRENCY ( = 5 ). Now my process...

Hi Sharon, I truncated all tables and logs to start again. Bellow all informations about the system when the process stopped to work. select * from resource_pool_status where pool_name = 'general'; -[ RECORD 1 ]--------------+------------------ node_name | v_biprod_node0001 pool_oid | 45035996273718...

Hi Sharon, I've found the information, but it makes no sense to me. May you help me to understand it ? 2013-10-10 13:25:16.883 Init Session:0x7f805000f5b0-a000000009a3c7 [ResourceManager] <INFO> RESOURCE RESERVATION FAILURE:Timedout waiting for resource request of [a000000009a3c7,71] on general for ...

Verifying QUERY_REQUEST system table, the biggest query takes about only 36s to run. select request_id, start_timestamp, end_timestamp, (end_timestamp - start_timestamp) as time, request_duration_ms, request from QUERY_REQUESTS where user_name='bisaude' order by request_duration_ms desc; request_id ...

Hi, Is not possible to know how long each load take to complete because I'm using Pentaho Kette to load the data, and Kettle runs its step in parallel when a new record achieve the step. But, monitoring resource_pool_status table I can see that running_query_count changes frequently, I mean, queries...