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 Bug
    • Status: Closed Closed (View Workflow)
    • Priority: Critical 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".
    • Similar Issues:
      Show 10 results 

      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

        Issue Links

          Activity

          Hide
          RH Bugzilla Integration
          added a comment -

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

          Show
          RH Bugzilla Integration
          added a comment - Van Halbert <vhalbert@redhat.com> changed the Status of bug 724798 from ASSIGNED to MODIFIED
          Hide
          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
          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
          RH Bugzilla Integration
          added a comment -

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

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

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

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

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

          This bug is now fixed. Thanks!

          Show
          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
              Reporter:
              Len DiMaggio
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: