[SequenceUtil.java:242:WARN ] [SequenceUtil.SequenceBank.fillBank] Collision found for seqName [Visitor]

[vlenoir]

Hi,
I have two ofbiz servers with a common database.

I read this kind of message in logs files :
SequenceUtil.java:242:WARN ] [SequenceUtil.SequenceBank.fillBank] Collision found for seqName [Visitor].
SequenceUtil.java:257:INFO ] Got bank of sequenced IDs for [Visitor]; curSeqId=155868, maxSeqId=155869, bankSize=1

Sometimes the database is blocked like this :
-----------------------------------------------------------------------------------------------
[e-mail] (INACTIVE SID=139@FDPROD) is blocking [e-mail] (ACTIVE SID=95@FDPROD)
    OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ ROWID=AAAGC8AAEAAACxtAAA

    HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452 REQUEST=0
        OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
        LastSQLExec=No SQLStatement
    WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452 REQUEST=0
        OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
        LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET SEQ_ID=SEQ_ID+1 WHERE
        SEQ_NAME='Visitor'

[e-mail] (INACTIVE SID=139@FDPROD) is blocking [e-mail] (ACTIVE SID=120@FDPROD)
    OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ ROWID=AAAGC8AAEAAACxtAAA

    HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452 REQUEST=0
        OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
        LastSQLExec=No SQLStatement
    WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452 REQUEST=0
        OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
        LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET SEQ_ID=SEQ_ID+1 WHERE
        SEQ_NAME='Visitor''
-----------------------------------------------------------------------------------------------

Any idea about this problem ?

thanks,

Vincent

[David E Jones]

Which version of ofbiz are you using? This has been improved in the
last few months.

-David


On Mon, 24 Mar 2008 10:56:36 -0700 (PDT)
vlenoir <[hidden email]> wrote:

>
> Hi,
> I have two ofbiz servers with a common database.
>
> I read this kind of message in logs files :
> SequenceUtil.java:242:WARN ] [SequenceUtil.SequenceBank.fillBank]
> Collision found for seqName [Visitor].
> SequenceUtil.java:257:INFO ] Got bank of sequenced IDs for [Visitor];
> curSeqId=155868, maxSeqId=155869, bankSize=1
>
> Sometimes the database is blocked like this :
> -----------------------------------------------------------------------------------------------
> [hidden email] (INACTIVE
> SID=139@FDPROD) is blocking
> [hidden email] (ACTIVE SID=95@FDPROD)
>     OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ
> ROWID=AAAGC8AAEAAACxtAAA
>
>     HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452 REQUEST=0
>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>         LastSQLExec=No SQLStatement
>     WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452 REQUEST=0
>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>         LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET
> SEQ_ID=SEQ_ID+1 WHERE
>         SEQ_NAME='Visitor'
>
> [hidden email] (INACTIVE
> SID=139@FDPROD) is blocking
> [hidden email] (ACTIVE SID=120@FDPROD)
>     OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ
> ROWID=AAAGC8AAEAAACxtAAA
>
>     HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452 REQUEST=0
>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>         LastSQLExec=No SQLStatement
>     WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452 REQUEST=0
>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>         LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET
> SEQ_ID=SEQ_ID+1 WHERE
>         SEQ_NAME='Visitor''
> -----------------------------------------------------------------------------------------------
>
> Any idea about this problem ?
>
> thanks,
>
> Vincent
>

[David E Jones]

That's a really old version of OFBiz... and it's a Neogia distribution  
of OFBiz and not OFBiz itself.

If that version of Neogia has more of a user community built around it  
you might have better luck getting help with that group.

Hopefully others will have ideas, but I think the best idea I can  
offer is to look at fixes in this area of OFBiz since that revision of  
OFBiz and back-patch the fixes and improvements.

-David


On Mar 25, 2008, at 4:16 AM, Vincent LENOIR wrote:

> I found this information in the file version :
> neogia.version=0.9.6
> ofbiz.version=493703
>
>
> Vincent
>
> David E Jones a écrit :
>>
>> Which version of ofbiz are you using? This has been improved in the
>> last few months.
>>
>> -David
>>
>>
>> On Mon, 24 Mar 2008 10:56:36 -0700 (PDT)
>> vlenoir <[hidden email]> wrote:
>>
>>
>>> Hi,
>>> I have two ofbiz servers with a common database.
>>>
>>> I read this kind of message in logs files :
>>> SequenceUtil.java:242:WARN ] [SequenceUtil.SequenceBank.fillBank]
>>> Collision found for seqName [Visitor].
>>> SequenceUtil.java:257:INFO ] Got bank of sequenced IDs for  
>>> [Visitor];
>>> curSeqId=155868, maxSeqId=155869, bankSize=1
>>>
>>> Sometimes the database is blocked like this :
>>> -----------------------------------------------------------------------------------------------
>>> [hidden email] (INACTIVE
>>> SID=139@FDPROD) is blocking
>>> [hidden email] (ACTIVE SID=95@FDPROD)
>>>     OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ
>>> ROWID=AAAGC8AAEAAACxtAAA
>>>
>>>     HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452  
>>> REQUEST=0
>>>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>>>         LastSQLExec=No SQLStatement
>>>     WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452  
>>> REQUEST=0
>>>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>>>         LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET
>>> SEQ_ID=SEQ_ID+1 WHERE
>>>         SEQ_NAME='Visitor'
>>>
>>> [hidden email] (INACTIVE
>>> SID=139@FDPROD) is blocking
>>> [hidden email] (ACTIVE  
>>> SID=120@FDPROD)
>>>     OID=24764 NAME=SEQUENCE_VALUE_ITEM TYPE=TABLE OWNER=PROD_OFBIZ
>>> ROWID=AAAGC8AAEAAACxtAAA
>>>
>>>     HOLDER:    ID1=917513 ID2=138 TYPE=TX LMODE=6 CTIME=1452  
>>> REQUEST=0
>>>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>>>         LastSQLExec=No SQLStatement
>>>     WAITER:    ID1=917513 ID2=138 TYPE=TX LMODE=0 CTIME=1452  
>>> REQUEST=0
>>>         OSUSER=ftpdata PID=1234 Program=JDBC Thin Client
>>>         LastSQLExec=UPDATE PROD_OFBIZ.SEQUENCE_VALUE_ITEM SET
>>> SEQ_ID=SEQ_ID+1 WHERE
>>>         SEQ_NAME='Visitor''
>>> -----------------------------------------------------------------------------------------------
>>>
>>> Any idea about this problem ?
>>>
>>> thanks,
>>>
>>> Vincent
>>>
>>>
>>
>>
>>
>