Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1225

MySQL 5.1 - UTC_TIMESTAMP is reserved and fails when the DNA_CHANGELOG table is trying to be created

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 2.5.1.GA
    • Fix Version/s: 2.6.0.Beta2, 2.5.1.GA
    • Component/s: Storage
    • Labels:
      None
    • Environment:
      RHEL 6.1, MySQL 5.1 - as supplied by RHEL6
      SOA-P 5.2 ER1
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Use ModeShape's DDL generation tool/utility to generate the DDL for Hibernate's MySQL InnoDB dialect, manually change the name of the "UTC_TIMESTAMP" column, and manually apply the DDL schema to the database. Then be sure to set the "autoGenerateSchema" property in the JpaSource (within the ModeShape configuration) to "disable".

      Show
      Use ModeShape's DDL generation tool/utility to generate the DDL for Hibernate's MySQL InnoDB dialect, manually change the name of the "UTC_TIMESTAMP" column, and manually apply the DDL schema to the database. Then be sure to set the "autoGenerateSchema" property in the JpaSource (within the ModeShape configuration) to "disable".

      Description

      This issue was originally logged as a feature request for MySQL 5.5 in: SOA-3170

      But - the same error is being seen with RHEL6 and MySQL 5.1 - as installed by RHEL6

      2011-07-20 12:51:48,892 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) Unsuccessful: create table DNA_CHANGELOG (ID bigint not null auto_increment, CHANGES longblob not null, CHANGE_COUNT integer not null, UTC_TIMESTAMP bigint not null, USERNAME varchar(64) not null, primary key (ID)) ENGINE=InnoDB
      2011-07-20 12:51:48,892 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP bigint not null, USERNAME varchar(64) not null, primary key (ID)) ' at line 1
      2011-07-20 12:51:49,702 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) Unsuccessful: create index NS_CHANGE_TS_INX on DNA_CHANGELOG (UTC_TIMESTAMP)
      2011-07-20 12:51:49,702 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP)' at line 1
      2011-07-20 12:51:52,941 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) Unsuccessful: create table DNA_CHANGELOG (ID bigint not null auto_increment, CHANGES longblob not null, CHANGE_COUNT integer not null, UTC_TIMESTAMP bigint not null, USERNAME varchar(64) not null, primary key (ID)) ENGINE=InnoDB
      2011-07-20 12:51:52,941 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP bigint not null, USERNAME varchar(64) not null, primary key (ID)) ' at line 1
      2011-07-20 12:51:52,941 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) Unsuccessful: create index NS_CHANGE_TS_INX on DNA_CHANGELOG (UTC_TIMESTAMP)
      2011-07-20 12:51:52,941 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (modeshape-start-repo-2-thread-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UTC_TIMESTAMP)' at line 1

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            Van Halbert <vhalbert@redhat.com> changed the Status of bug 724798 from ASSIGNED to MODIFIED

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - Van Halbert <vhalbert@redhat.com> changed the Status of bug 724798 from ASSIGNED to MODIFIED
            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            Van Halbert <vhalbert@redhat.com> made a comment on bug 724798

            Commit ID: 24938f14255fdc2a037a
            for MODE-1245 was committed to the 2.5.x branch to resolve the ItemNotFoundException that is occurring at start up time.

            This should be available for the next BRMS ER3 build.

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - Van Halbert <vhalbert@redhat.com> made a comment on bug 724798 Commit ID: 24938f14255fdc2a037a for MODE-1245 was committed to the 2.5.x branch to resolve the ItemNotFoundException that is occurring at start up time. This should be available for the next BRMS ER3 build.
            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            Van Halbert <vhalbert@redhat.com> changed the Status of bug 724798 from MODIFIED to ON_QA

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - Van Halbert <vhalbert@redhat.com> changed the Status of bug 724798 from MODIFIED to ON_QA
            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            Lukáš Petrovický <lpetrovi@redhat.com> changed the Status of bug 724798 from ON_QA to VERIFIED

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - Lukáš Petrovický <lpetrovi@redhat.com> changed the Status of bug 724798 from ON_QA to VERIFIED
            Hide
            jira-bugzilla-migration RH Bugzilla Integration added a comment -

            Lukáš Petrovický <lpetrovi@redhat.com> made a comment on bug 724798

            This bug is now fixed. Thanks!

            Show
            jira-bugzilla-migration RH Bugzilla Integration added a comment - Lukáš Petrovický <lpetrovi@redhat.com> made a comment on bug 724798 This bug is now fixed. Thanks!

              People

              • Assignee:
                van.halbert Van Halbert
                Reporter:
                ldimaggio Len DiMaggio
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development