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.
Search found 17 matches
- Tue Oct 29, 2013 12:55 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
- Tue Oct 29, 2013 12:43 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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...
- Mon Oct 21, 2013 4:23 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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...
- Fri Oct 18, 2013 4:38 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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...
- Thu Oct 17, 2013 12:54 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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 ...
- Wed Oct 16, 2013 3:12 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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 ...
- Wed Oct 16, 2013 12:24 pm
- Forum: Vertica Error Codes
- Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to ...
- Replies: 24
- Views: 93930
Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to
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...