groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Price <danprice...@gmail.com>
Subject Re: Groovy Script withBatch() Hang?
Date Mon, 13 Jul 2015 20:24:22 GMT
A bit more info:

     I'm running this script on the same DB table with the same data, on
the same machines, over and over--trying to find out why it's hanging so I
want to minimize variables.  The only variable I can think of is network
traffic....

Thanks,
D

On Mon, Jul 13, 2015 at 4:16 PM, Daniel Price <danprice303@gmail.com> wrote:

> This is my relevant code:
>
>  db.withBatch(25000, spString)  { ps ->
>     list.each{
>        ps.addBatch(it)
>     }
>     ps.executeBatch()
>  }
>
> list contains variables used to compose stored procedure
>
> Thanks!
>
> On Mon, Jul 13, 2015 at 4:07 PM, Owen Rubel <orubel@gmail.com> wrote:
>
>> wouldn't be able to help without showing some code.
>>
>> Owen Rubel
>> 415-971-0976
>> orubel@gmail.com
>>
>> On Mon, Jul 13, 2015 at 1:06 PM, Daniel Price <danprice303@gmail.com>
>> wrote:
>>
>>> Good Afternoon,
>>>
>>>      I'm experiencing infrequent (1/20) hangs with a Groovy script that
>>> uses withBatch() to insert and update a SQL Server DB using stored
>>> procedures.  In each case (insert or update), the batch completes as
>>> indicated by database content, but the script hangs and does not continue
>>> until I ctrl-c it.  This script is the only user of the table, so DB
>>> locking isn't involved.  The batches are only about 200k rows, but I set
>>> the withBatch() parameter to 25k to be nice to the DB.  Has anybody seen
>>> this before?  Any suggestions?  Thanks!
>>>
>>> D
>>>
>>
>>
>

Mime
View raw message