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

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

      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

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

                Created:
                Updated:
                Resolved: