Re: [luciddb-users] LucidDB Gets Stuck Processing Many Concurrent Queries

[victor.savkin <vic...@tr...>]

This is the query I use:

select
  oi.order_id,
  oi.trnx_type,
  oi.branch_id,
  pc.category,
  pr.product_description

from
  svv.order_item oi,
  svv.order_header oh,
  svv.prod_cat pc,
  svv.product pr

where
      oi.prod_code = pr.prod_code and oi.branch_id = pr.branch_id
  and oi.prod_code = pc.prod_code and oi.branch_id = pc.branch_id
  and oi.order_id = oh.order_id and oi.branch_id = oh.branch_id
  and oh.modified_date between TIMESTAMP'2010-01-01 00:00:00' and
TIMESTAMP'2010-02-01 00:00:00'


I investigated a bit further and I have more information. All threads are
able to get a result set (which is about 33000 rows). 7 threads can iterate
over the result set. But the 8th thread can only iterate over 5000 (each
time it's a bit different) rows and than it gets blocked on
resultSet.next(). Killing the application doesn't help. The session remains
open.

Thanks,
Victor




--
View this message in context: http://luciddb-users.1374590.n2.nabble.com/LucidDB-Gets-Stuck-Processing-Many-Concurrent-Queries-tp6424597p6431504.html
Sent from the luciddb-users mailing list archive at Nabble.com.