Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-3969

Can not switch to slave when master down using postgresql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • jboss-fuse-6.1-patches
    • jboss-fuse-6.1
    • Karaf
    • None
    • % %

    Description

      I tried to setup the failover using postgresql according to the document:
      https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Fuse/6.1/html/Configuring_and_Running_Red_Hat_JBoss_Fuse/ESBRuntimeFailoverJdbc.html
      The master can be startedup successfully, but when the master shutdown, the slave is still on the starting state, the log in the slave shows: 

      karaf.lock=true
karaf.lock.class=org.apache.karaf.main.PostgreSQLJDBCLock
karaf.lock.jdbc.url=jdbc:postgresql://127.0.0.1:5432/dbname
karaf.lock.jdbc.driver=org.postgresql.Driver
karaf.lock.jdbc.user=user
karaf.lock.jdbc.password=password
karaf.lock.jdbc.table=KARAF_LOCK
karaf.lock.jdbc.clustername=karaf
karaf.lock.jdbc.timeout=0

      log shows:

      Sep 09, 2015 3:26:06 PM org.apache.karaf.main.DefaultJDBCLock aquireLock
WARNING: Failed to acquire database lock: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

      Attachments

        Activity

          People

            Unassigned Unassigned
            rhn-support-xiwu Xiaohui Wu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: