<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
<base href="https://hibernate.atlassian.net">
<title>Message Title</title>
</head>
<body class="jira" style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0" bgcolor="#f5f5f5">
<!-- header here -->
<tbody>
<tr>
<td id="header-pattern-container" style="padding: 0; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px" width="32"> <img id="header-avatar-image" class="image_fix" src="https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/557058:f228d658-f396-4caf-b2d8-01abec781928/98c25a95-366c-430a-9a88-193947e5d4fe/128?size=48&s=48" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top"> </td>
<td id="header-text-container" valign="middle" style="padding: 0; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="gerdaschemann" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_gerdaschemann" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Af228d658-f396-4caf-b2d8-01abec781928"> Gerd Aschemann </a> <strong>updated</strong> an issue </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-spacing: 0; border-collapse: separate">
<tbody>
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 15px; background-color: #ffffff; border-left: 1px solid #cccccc; border-top: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly" height="10" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="page-title-pattern-first-line " style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-13783?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-544120b9-0bf9-40a2-9b63-4699b2c0488c" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-13783?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">HHH-13783</a> </td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13783?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">org.hibernate.MappingException: The increment size of the sequence is set to [10] in the entity mapping while … size is [1]</a> </span> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 10px; padding-bottom: 5px" bgcolor="#ffffff">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Change By:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="gerdaschemann" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_gerdaschemann" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Af228d658-f396-4caf-b2d8-01abec781928"> Gerd Aschemann </a> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 5px; padding-bottom: 10px" bgcolor="#ffffff">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tbody>
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0; border-collapse: collapse; padding: 0 0 10px"> <span class="diffcontext">Not sure if this is exactly the same problem as</span> <span class="diffaddedchars" style="background-color:#ddfade;"> [</span> <span class="diffcontext"> HHH-13676</span> <span class="diffaddedchars" style="background-color:#ddfade;">]</span> <span class="diffcontext"> and</span> <span class="diffaddedchars" style="background-color:#ddfade;"> [</span> <span class="diffcontext"> HHH-13674</span> <span class="diffaddedchars" style="background-color:#ddfade;">]</span> <span class="diffcontext"> since my set up is slightly different?</span> <span class="diffaddedchars" style="background-color:#ddfade;"> As far as I can see the problem does not depend on the underlying DB engine since we do have it with H2 as well as PostgreSQL. I think it is a problem of the used sequence generator algorithm. In particular, HiLo increment size has nothing to do with the DB increment size since it is completely independent and sequence ids are never exactly reflected by DB sequence numbers with this algorithm, cf. [https://vladmihalcea.com/the-hilo-algorithm/|https://vladmihalcea.com/the-hilo-algorithm/] of @vladmihalcea.</span> <span class="diffcontext"><br><br>I already brought up the issue on Stack Overflow, cf.</span> <span class="diffaddedchars" style="background-color:#ddfade;"> [</span> <span class="diffcontext"> https://stackoverflow.com/questions/59305427/org-hibernate-mappingexception-the-increment-size-of-the-sequence-is-set-to-10</span> <span class="diffaddedchars" style="background-color:#ddfade;">|https://stackoverflow.com/questions/59305427/org</span> <span class="diffcontext"> -</span> <span class="diffaddedchars" style="background-color:#ddfade;">hibernate-mappingexception-the-increment-size-of-the-sequence-is-set-to-10] -</span> <span class="diffcontext"> it was considered an error by @jensschauder of the Spring Data team.<br><br>We do have the following sequence generator<br><br>{code</span> <span class="diffaddedchars" style="background-color:#ddfade;">:java</span> <span class="diffcontext">}</span> <span class="diffremovedchars" style="background-color: #ffe7e7; text-decoration:line-through;"><br></span> <span class="diffcontext">@Id<br>@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "hilo_sequence_generator")<br>@GenericGenerator(<br> name = "hilo_sequence_generator",<br> strategy = "...",<br> parameters = {<br> @Parameter(name = "sequence_name", value = "XXX_SEQUENCE"),<br> @Parameter(name = "initial_value", value = "1"),<br> @Parameter(name = "increment_size", value = "10"),<br> @Parameter(name = "optimizer", value = "hilo")<br> })<br>private Long id;</span> <span class="diffremovedchars" style="background-color: #ffe7e7; text-decoration:line-through;"><br></span> <span class="diffcontext">{code}<br><br>With the update to SB 2.2 / HB 5.4 we get the following initialization error<br><br>{code</span> <span class="diffaddedchars" style="background-color:#ddfade;">:java</span> <span class="diffcontext">}</span> <span class="diffremovedchars" style="background-color: #ffe7e7; text-decoration:line-through;"><br></span> <span class="diffcontext">org.hibernate.MappingException: The increment size of the sequence is set to [10] in the mapping while the associated database sequence increment size is [1]</span> <span class="diffremovedchars" style="background-color: #ffe7e7; text-decoration:line-through;"><br></span> <span class="diffcontext">{code}<br><br>SO already contains some more information (stack traces etc.).<br>But I also compiled a small (Spring Boot) project to show the issue:</span> <span class="diffaddedchars" style="background-color:#ddfade;"> [</span> <span class="diffcontext"> https://github.com/ascheman/hibernate-so-59305427</span> <span class="diffaddedchars" style="background-color:#ddfade;">|https://github.com/ascheman/hibernate-so-59305427]</span> <span class="diffcontext"><br><br>I consider the priority major since it prohibits us from upgrading to a clean SB 2.2 / Hibernate 5.4., but we can still use HB 5.3.x to prevent the problem.</span> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff"> <script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"description": "View Issue",
"potentialAction": {
"@type": "ViewAction",
"target": "https://hibernate.atlassian.net/browse/HHH-13783?inbox=true&",
"name": "View Issue"
},
"publisher": {
"@type": "Organization",
"name": "Atlassian",
"url": "https://www.atlassian.com"
}
}
</script>
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tbody>
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13783#add-comment?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-89e3964b-41a0-4a1e-8cea-5f939aff79de" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle"> </a> </td>
<td class="actions-pattern-action-text-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-13783#add-comment?atlOrigin=eyJpIjoiODU4ZTY2MmQ0ZWNiNGQyMjhmM2FkM2ZiNGJhZGU3Y2MiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #ffffff; border-top: 0; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly" height="5" bgcolor="#ffffff"> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-mobile-separated-links" class="mobile-resize-text" width="100%" colspan="2" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> Get Jira notifications on your phone! Download the Jira Cloud app for <a href="https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail" style="color: #3b73af; text-decoration: none">Android</a> or <a href="https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8" style="color: #3b73af; text-decoration: none">iOS</a>
<hr> </td>
</tr>
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> This message was sent by Atlassian Jira <span id="footer-build-information">(v1001.0.0-SNAPSHOT#100116-<span title="c5e7184fb355de128d7fd58ea1ea8e193e1ece38" data-commit-id="c5e7184fb355de128d7fd58ea1ea8e193e1ece38}">sha1:c5e7184</span>)</span> </td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0; border-collapse: collapse; padding-top: 3px; opacity: 0.150"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-fc8a9cf6-5dd9-49ca-84e4-e708a71d97a1" alt="Atlassian logo" title="Atlassian logo" width="192" height="24" class="image_fix"> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table>
<img border="0" width="1" height="1" alt="" src="http://atlassian.et.e.sparkpost.com/q/fCcV5ToBa2r4Fytl98LlBA~~/AAAAAQA~/RgRf1hTqPlcLYXRsYXNzaWFudXNCCgAAauH0XTm5_xNSIGhpYmVybmF0ZS1pc3N1ZXNAbGlzdHMuamJvc3Mub3JnWAQAAAAE">
</body>
</html>