Uploaded image for project: 'Spring Integration'
  1. Spring Integration
  2. INT-3510

Message store script error using PostgreSQL (relation "int_message_seq" does not exist)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Complete
    • Affects Version/s: 4.0.3
    • Fix Version/s: 4.1 M1, 4.0.4
    • Component/s: JDBC Support
    • Labels:
    • Environment:
      Ubuntu 14.04 64 Bit
      PostgreSQL 9.3
      JDK 1.7.0_67
      TC Server 3.0 (Tomcat 8.0.9)

      Description

      Execution of jdbc script 'org/springframework/integration/jdbc/store/channel/schema-postgresql.sql' for creating the message store for spring integration on postgresql fails with error message 'relation "int_message_seq" does not exist' (SQL state: 42P01).
      This is because the sequence is created after first usage in create table statement. The corresponding drop script fails too because index name to drop does not match the created one.
      Execution of the script fails in ScriptUtils.executeSqlScript() and in pgadmin tool of Postgresql as well.

      I attached a fixed version of same script (verified successfully directly on postgresql 9.3 and with ScriptUtils.executeSqlScript()).

        Attachments

          Activity

            People

            Assignee:
            abilan Artem Bilan
            Reporter:
            andifalk Andreas Falk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: