Hello,
Recently we make one more attempt to upgrade to the last H2 version in a
hope that the performance degradation we reported two years back has gone.
Turned out however that it's still there both in 1.3.176 and even 1.4.184
versions.
Analyzing diffs between 1.3.164 and 1.3.165 turned out that the problem was
introduced in revision 4139. After *ignoreBigLog *flag is set to true it is
never reset back to false resulting in situation that the following
condition is always true and commit() function returns before ever updating
logSizeBase. Likely it leads to checkpoint() function to be called later on
each commit().
Always true condition:
if (ignoreBigLog) {
return;
}
With the below modification the testcase attached to the issue which keeps
inserting BLOB data in single transaction starts working like a charm:
if (ignoreBigLog) {
logSizeBase = log.getSize();
return;
}
Not sure we understood completely the role of *ignoreBigLog* flag but the
fact that session rollback logic is executed only once during PageStore
instance lifecycle looks suspicious.
--
Alexander Nesterov
On Tuesday, February 12, 2013 7:53:41 AM UTC+4, Noel Grandin wrote:
>
> You could help by doing a binary search through the SVN revisions to find
> where the problem was introduced.
>
> On Monday, 11 February 2013, Oleg Alexeyev wrote:
>
>> Hi,
>>
>> Could someone look into this issue? It really stops us from upgrading to
>> newer versions...
>>
>> Yours,
>> --
>> oleg
>>
>> --
>> 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 [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/h2-database?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.