Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-3682

[EAP - postgresql115] syntax error at or near "AUTO_INCREMENT"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • None
    • AMQ 7.7.0.GA
    • jdbc
    • None

    Description

      EAP tests using PostgreSQL 11.5 are failing due to following error:

      SQL STATEMENTS:
      CREATE TABLE LARGE_MESSAGES (ID BIGINT AUTO_INCREMENT, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))
      SQL EXCEPTIONS:
      SQLState: 42601 ErrorCode: 0 Message: ERROR: syntax error at or near "AUTO_INCREMENT"
         Position: 40
      16:08:43,148 WARN  [org.apache.activemq.artemis.core.server] (ServerService Thread Pool -- 90)
          AMQ222010: Critical IO Error, shutting down the server. file=NULL, message=Unable to start database driver:
          org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_INCREMENT"
      

      Attachments

        Activity

          People

            fnigro Francesco Nigro
            rvais Roman Vais
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: