Grab size refers to the number of consecutive values from which the sequence manager issues primary keys until it reaches a value equal to the max_key - 1. Then the max_key is increased by the grab size, and the sequence manager continues to issue primary keys until it exhausts the sequence again.

Pulat

Daniel Perry wrote:
Hi,
I've been trying to debug some problems in our software, and it seems that
the High Low Sequence Manager has gone a bit mad!

I am seeing some wierd stuff going on - the sequence manager has NO
settings, so should be acting in the default configuration.  The OJB_HL_SEQ
is showing grabsizes of 20, and multiples of 20 in the max column, but it
doesnt seem to be using them.  eg, i initialise the app and in OJB_HL_SEQ i
see:

SEQ_pdp,deprecatedColumn,160,209

But when i insert data, i get id's of 161,162,163.  I would expect
180,200,220.  When i go to the HL_SEQ table after shutting down the app, i
see that the MAX_KEY is only 180.  I've turned on debugging and i see
messages like the following, which look right to me, except that it comes up
with the same message each time - it should be incremented right?

[org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl] DEBUG: new
sequence was
[EMAIL PROTECTED]
p,fieldName=deprecatedColumn,grabSize=20,version=9,maxKey=180,currentKey=160
]

Anyone seen this kind of problem before?

Daniel.

--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to