[
https://issues.apache.org/jira/browse/DERBY-7002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16535459#comment-16535459
]
Rick Hillegas commented on DERBY-7002:
--------------------------------------
We should also add a section to the Tuning Guide in order to raise the
visibility of this tuning parameter.
> Change the text of X0Y84 to advise users to tune the value of
> derby.language.sequence.preallocator
> --------------------------------------------------------------------------------------------------
>
> Key: DERBY-7002
> URL: https://issues.apache.org/jira/browse/DERBY-7002
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.15.0.0
> Reporter: Rick Hillegas
> Priority: Major
>
> This is the LANG_TOO_MUCH_CONTENTION_ON_SEQUENCE error message. Right now it
> says the following:
> {noformat}
> Too much contention on sequence {0}. This is probably caused by an uncommitted
> scan of the SYS.SYSSEQUENCES catalog. Do not query this catalog directly.
> Instead, use the SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function to view
> the current value of a sequence generator.
> {noformat}
> Issue DERBY-6999 suggests that it would be good if the error message
> suggested another cause for the "too much contention" exception: The value of
> derby.language.sequence.preallocator may be too low. The error message should
> suggest that the user tune this value.
> While we're at it, it might be good if the error message noted the current
> friction with Statement.getGeneratedKeys() (see DERBY-6934). Currently, there
> is no workaround for that friction. Application code should not call that
> method.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)