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.

Reply via email to