Page 1 of 1

SequenceGeneratorCorruptionDetection

Posted: Mon Jan 21, 2013 4:10 am
by denis
Hi,

When i start admin (or demo site) i have the following warning :

Code: Select all

[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.structure.domain.StructuredContentRuleImpl and StructuredContentRuleImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.field.domain.FieldGroupImpl and FieldGroupImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.ProductImpl and ProductImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.rating.domain.ReviewDetailImpl and ReviewDetailImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.CategoryImpl and CategoryImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.common.sandbox.domain.SandBoxImpl and SandBoxImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.UpSaleProductImpl and UpSaleProductImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.offer.domain.OfferItemCriteriaImpl and OfferItemCriteriaImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.search.domain.FieldImpl and FieldImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.rating.domain.RatingDetailImpl and RatingDetailImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.CrossSaleProductImpl and CrossSaleProductImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.page.domain.PageImpl and PageImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.search.domain.SearchFacetRangeImpl and SearchFacetRangeImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.field.domain.FieldEnumerationItemImpl and FieldEnumerationItemImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.field.domain.FieldEnumerationImpl and FieldEnumerationImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.search.domain.CategoryExcludedSearchFacetImpl and CategoryExcludedSearchFacetImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.offer.domain.OfferImpl and OfferImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.FeaturedProductImpl and FeaturedProductImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.rating.domain.RatingSummaryImpl and RatingSummaryImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.ProductAttributeImpl and ProductAttributeImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.openadmin.server.security.domain.AdminRoleImpl and AdminRoleImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.openadmin.server.security.domain.AdminPermissionImpl and AdminPermissionImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.structure.domain.StructuredContentImpl and StructuredContentImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.url.domain.URLHandlerImpl and URLHandlerImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.util.domain.CodeTypeImpl and CodeTypeId in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.page.domain.PageFieldImpl and PageFieldImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.media.domain.MediaImpl and MediaId in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.search.domain.CategorySearchFacetImpl and CategorySearchFacetImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.openadmin.server.security.domain.AdminUserImpl and AdminUserImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.field.domain.FieldDefinitionImpl and FieldDefinitionImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.offer.domain.OfferCodeImpl and OfferCodeImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.cms.structure.domain.StructuredContentFieldImpl and StructuredContentFieldImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.search.domain.SearchFacetImpl and SearchFacetImpl in SEQUENCE_GENERATOR
[ INFO] 09:58:42 SequenceGeneratorCorruptionDetection - Detecting id sequence state between org.broadleafcommerce.core.catalog.domain.SkuImpl and SkuImpl in SEQUENCE_GENERATOR


It's odd, because in sequence_generator table, data are correctly added. For instance, the max id in blc_sku is 634 and next id for SkuImpl in sequence_generator is 10000.

Have you any idea?

Re: SequenceGeneratorCorruptionDetection

Posted: Tue Jan 22, 2013 4:35 pm
by phillipuniverse
Looks like you have BLC logging set to INFO. If you pull this back to something like DEBUG or WARN in log4j.xml these should disappear. This is just outputting that the sequence corruption detection is running. The entire application would die if it actually found an inconsistency (which is configurable, of course).