Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-20005

Adding a new user doesnt work with PostgreSQL 9.0 read-writer configuration

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: No Longer Reproducible
    • Affects Version/s: 6.0.6 GA
    • Fix Version/s: 6.1.30 EE GA3, 6.2.0 CE M2
    • Labels:
      None
    • Environment:
      Debian Squeeze, PostgreSQL 9.0 (installed via Debian-Backports), one master-db, one slave-db (hotstandby, synchronized using the streaming replication feature of postgresql9), tomcat 6 shipped with debian squeeze, liferay-portal-6.0.6-20110225.war

      Description

      Startup of liferay works, but adding a new user fails with "com.liferay.portal.kernel.exception.SystemException: java.sql.SQLException: Table not found in statement [select currentId from Counter where name = ?]". Please take a look at the attached part of catalina.out for full error message.

      We are using postgresql-9.0-801.jdbc4.jar.

      Our portal-ext.properties:

      jdbc.read.driverClassName=org.postgresql.Driver
      jdbc.read.url=jdbc:postgresql://<db-ip>:5432/<dbname>?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
      jdbc.read.username=user
      jdbc.read.password=pw

      jdbc.write.driverClassName=org.postgresql.Driver
      jdbc.write.url=jdbc:postgresql://<db-ip>:5432/<dbname>?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
      jdbc.write.username=user
      jdbc.write.password=pw

      spring.configs=\
      #META-INF/audit-spring.xml,\
      #META-INF/monitoring-spring.xml,\
      META-INF/base-spring.xml,\
      META-INF/hibernate-spring.xml,\
      META-INF/infrastructure-spring.xml,\
      META-INF/management-spring.xml,\
      META-INF/util-spring.xml,\
      META-INF/editor-spring.xml,\
      META-INF/jcr-spring.xml,\
      META-INF/messaging-spring.xml,\
      META-INF/scheduler-spring.xml,\
      META-INF/search-spring.xml,\
      META-INF/counter-spring.xml,\
      META-INF/document-library-spring.xml,\
      META-INF/lock-spring.xml,\
      META-INF/mail-spring.xml,\
      META-INF/portal-spring.xml,\
      META-INF/portlet-container-spring.xml,\
      META-INF/wsrp-spring.xml,\
      META-INF/mirage-spring.xml,\
      META-INF/dynamic-data-source-spring.xml,\
      META-INF/ext-spring.xml,\
      META-INF/workflow-spring.xml,\
      META-INF/messaging-core-spring.xml,\
      META-INF/messaging-misc-spring.xml,\
      META-INF/ldap-spring.xml
      #META-INF/service-builder-spring.xml,\
      #META-INF/cluster-spring.xml,\
      #META-INF/jpa-spring.xml,\
      #META-INF/poller-spring.xml,\
      #META-INF/counter-spring.xml,\
      #META-INF/rules-spring.xml,\
      #META-INF/memcached-spring.xml

      liferay.home=/path/to/liferay

      #Performance-Tuning:
      last.modified.check=false
      theme.css.fast.load=true
      javascript.fast.load=true

      The error doesnt occur with default databaseconfiguration.
      Any help greatly appreciated!

      With kind regards
      Sebastian

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                6 years, 5 days ago