Re: [h2] deadlock with clob data types?
Updating to 1.4 is a drop in and go replacement as long as you turn off
mvstore in the url
On Sun, 14 Jun 2015 at 19:09, Adam McMahon wrote:
> I guess another route would be to change the datatype to varchar. Is this
> possible? Is it safe?
>
>
> -Adam
>
>
>
> On Sunday, June 14, 2015 at 12:46:55 PM UTC-4, Adam McMahon wrote:
>>
>> Noel,
>>
>> Thanks for the suggestion. When you say latest version, do you mean
>> latest stable version, or the latest build?
>>
>> Would the upgrade process be to simple replace the jar and restart the
>> DB? Or is it best to restore a fresh DB from sql script?
>>
>> -Adam
>>
>> On Sunday, June 14, 2015 at 2:54:40 AM UTC-4, Noel Grandin wrote:
>>>
>>> We have fixed a bunch of stuff around LOB'S since then. I suggest you
>>> update to the latest version but run with mvstore disabled
>>> On Sun, 14 Jun 2015 at 02:31, Adam McMahon wrote:
>>>
Hi,
I am using H2 to store text as clobs.
The operations go like this:
The clobs are read into a String from the DB
The String is transformed into a json ojbect
the json object is modified
the object is transformed into a json string and saved back into H2 as
a clob
Multiple threads are performing the above operations at the same time.
I am running into thread dead locks when doing this. If I synchronize
around my methods which Select and Execute into the database, I do not run
into the deadlocks. Thus, I am avoiding the problem by making sure that
all my calls to H2 are synchronized in my code, which makes me wonder if
there is a synchronization problem somewhere in H2. Are there any known
deadlock problems in h2 with regard to clobs or the such.
H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)}
Thanks,
-Adam
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
>>> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
Re: [h2] deadlock with clob data types?
I guess another route would be to change the datatype to varchar. Is this
possible? Is it safe?
-Adam
On Sunday, June 14, 2015 at 12:46:55 PM UTC-4, Adam McMahon wrote:
>
> Noel,
>
> Thanks for the suggestion. When you say latest version, do you mean
> latest stable version, or the latest build?
>
> Would the upgrade process be to simple replace the jar and restart the
> DB? Or is it best to restore a fresh DB from sql script?
>
> -Adam
>
> On Sunday, June 14, 2015 at 2:54:40 AM UTC-4, Noel Grandin wrote:
>>
>> We have fixed a bunch of stuff around LOB'S since then. I suggest you
>> update to the latest version but run with mvstore disabled
>> On Sun, 14 Jun 2015 at 02:31, Adam McMahon wrote:
>>
>>> Hi,
>>>
>>> I am using H2 to store text as clobs.
>>> The operations go like this:
>>>
>>> The clobs are read into a String from the DB
>>> The String is transformed into a json ojbect
>>> the json object is modified
>>> the object is transformed into a json string and saved back into H2 as a
>>> clob
>>>
>>> Multiple threads are performing the above operations at the same time.
>>>
>>> I am running into thread dead locks when doing this. If I synchronize
>>> around my methods which Select and Execute into the database, I do not run
>>> into the deadlocks. Thus, I am avoiding the problem by making sure that
>>> all my calls to H2 are synchronized in my code, which makes me wonder if
>>> there is a synchronization problem somewhere in H2. Are there any known
>>> deadlock problems in h2 with regard to clobs or the such.
>>>
>>> H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)}
>>>
>>> Thanks,
>>> -Adam
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "H2 Database" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to h2-database...@googlegroups.com.
>>> To post to this group, send email to h2-da...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/h2-database.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
Re: [h2] deadlock with clob data types?
Noel,
Thanks for the suggestion. When you say latest version, do you mean latest
stable version, or the latest build?
Would the upgrade process be to simple replace the jar and restart the DB?
Or is it best to restore a fresh DB from sql script?
-Adam
On Sunday, June 14, 2015 at 2:54:40 AM UTC-4, Noel Grandin wrote:
>
> We have fixed a bunch of stuff around LOB'S since then. I suggest you
> update to the latest version but run with mvstore disabled
> On Sun, 14 Jun 2015 at 02:31, Adam McMahon > wrote:
>
>> Hi,
>>
>> I am using H2 to store text as clobs.
>> The operations go like this:
>>
>> The clobs are read into a String from the DB
>> The String is transformed into a json ojbect
>> the json object is modified
>> the object is transformed into a json string and saved back into H2 as a
>> clob
>>
>> Multiple threads are performing the above operations at the same time.
>>
>> I am running into thread dead locks when doing this. If I synchronize
>> around my methods which Select and Execute into the database, I do not run
>> into the deadlocks. Thus, I am avoiding the problem by making sure that
>> all my calls to H2 are synchronized in my code, which makes me wonder if
>> there is a synchronization problem somewhere in H2. Are there any known
>> deadlock problems in h2 with regard to clobs or the such.
>>
>> H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)}
>>
>> Thanks,
>> -Adam
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to h2-database...@googlegroups.com .
>> To post to this group, send email to h2-da...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
Re: [h2] deadlock with clob data types?
We have fixed a bunch of stuff around LOB'S since then. I suggest you
update to the latest version but run with mvstore disabled
On Sun, 14 Jun 2015 at 02:31, Adam McMahon wrote:
> Hi,
>
> I am using H2 to store text as clobs.
> The operations go like this:
>
> The clobs are read into a String from the DB
> The String is transformed into a json ojbect
> the json object is modified
> the object is transformed into a json string and saved back into H2 as a
> clob
>
> Multiple threads are performing the above operations at the same time.
>
> I am running into thread dead locks when doing this. If I synchronize
> around my methods which Select and Execute into the database, I do not run
> into the deadlocks. Thus, I am avoiding the problem by making sure that
> all my calls to H2 are synchronized in my code, which makes me wonder if
> there is a synchronization problem somewhere in H2. Are there any known
> deadlock problems in h2 with regard to clobs or the such.
>
> H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)}
>
> Thanks,
> -Adam
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
[h2] deadlock with clob data types?
Hi,
I am using H2 to store text as clobs.
The operations go like this:
The clobs are read into a String from the DB
The String is transformed into a json ojbect
the json object is modified
the object is transformed into a json string and saved back into H2 as a
clob
Multiple threads are performing the above operations at the same time.
I am running into thread dead locks when doing this. If I synchronize
around my methods which Select and Execute into the database, I do not run
into the deadlocks. Thus, I am avoiding the problem by making sure that
all my calls to H2 are synchronized in my code, which makes me wonder if
there is a synchronization problem somewhere in H2. Are there any known
deadlock problems in h2 with regard to clobs or the such.
H2 version: {name=info.VERSION, value=1.3.176 (2014-04-05)}
Thanks,
-Adam
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
