Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1815

Catalog store initialization with PostgreSQL failed

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.10.1
    • Fix Version/s: 0.11.0
    • Component/s: Catalog
    • Labels:
      None
    • Environment:

      PostgreSQL 9.4

      Description

      According to a document on Tajo website, PostgreSQL catalog store is set, but initialization failed like following:

      2015-09-04 22:20:09,977 WARN org.apache.tajo.catalog.store.XMLCatalogSchemaManager: Failed to drop database objects TABLE INDEXES,TABLE STATS,TABLE PARTITION_METHODS,TABLE PARTITIONS,TABLE PARTITION_KEYS
      2015-09-04 22:20:09,978 ERROR org.apache.tajo.catalog.CatalogServer: CatalogServer initialization failed
      java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
      at org.apache.tajo.catalog.CatalogServer.serviceInit(CatalogServer.java:129)
      at org.apache.hadoop.service.AbstractService.init(AbstractService.java:163)
      at org.apache.hadoop.service.CompositeService.serviceInit(CompositeService.java:107)
      at org.apache.tajo.master.TajoMaster.serviceInit(TajoMaster.java:213)
      at org.apache.hadoop.service.AbstractService.init(AbstractService.java:163)
      at org.apache.tajo.master.TajoMaster.main(TajoMaster.java:561)
      Caused by: org.apache.tajo.exception.TajoInternalError: internal error: internal error: ERROR: multiple primary keys for table "indexes" are not allowed
      Position: 586
      at org.apache.tajo.catalog.store.AbstractDBStore.<init>(AbstractDBStore.java:187)
      at org.apache.tajo.catalog.store.PostgreSQLStore.<init>(PostgreSQLStore.java:32)
      ... 10 more

      1. TAJO-1815.patch
        0.8 kB
        Jongyoung Park

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user eminency closed the pull request at:

        https://github.com/apache/tajo/pull/730

        Show
        githubbot ASF GitHub Bot added a comment - Github user eminency closed the pull request at: https://github.com/apache/tajo/pull/730
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user eminency commented on the pull request:

        https://github.com/apache/tajo/pull/730#issuecomment-137924168

        Sure, thank you for the review.

        Show
        githubbot ASF GitHub Bot added a comment - Github user eminency commented on the pull request: https://github.com/apache/tajo/pull/730#issuecomment-137924168 Sure, thank you for the review.
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-0.11.0-build #12 (See https://builds.apache.org/job/Tajo-0.11.0-build/12/)
        TAJO-1815: Catalog store initialization with PostgreSQL failed. (hyunsik: rev 5ab667a027d734dbdb81c88691aac609bdc43b56)

        • CHANGES
        • tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-0.11.0-build #12 (See https://builds.apache.org/job/Tajo-0.11.0-build/12/ ) TAJO-1815 : Catalog store initialization with PostgreSQL failed. (hyunsik: rev 5ab667a027d734dbdb81c88691aac609bdc43b56) CHANGES tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #833 (See https://builds.apache.org/job/Tajo-master-build/833/)
        TAJO-1815: Catalog store initialization with PostgreSQL failed. (hyunsik: rev ea4443d8df6ffb02e328304dc5681dbd54f62501)

        • tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
        • CHANGES
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #833 (See https://builds.apache.org/job/Tajo-master-build/833/ ) TAJO-1815 : Catalog store initialization with PostgreSQL failed. (hyunsik: rev ea4443d8df6ffb02e328304dc5681dbd54f62501) tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml CHANGES
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/730#issuecomment-137893489

        It was committed in ea4443d8df6ffb02e328304dc5681dbd54f62501.

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/730#issuecomment-137893489 It was committed in ea4443d8df6ffb02e328304dc5681dbd54f62501.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/730#issuecomment-137893470

        I missed to close this issue. Could you close this ticket?

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/730#issuecomment-137893470 I missed to close this issue. Could you close this ticket?
        Hide
        hyunsik Hyunsik Choi added a comment -

        I just committed the patch. I fix it as resolved.

        Show
        hyunsik Hyunsik Choi added a comment - I just committed the patch. I fix it as resolved.
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #477 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/477/)
        TAJO-1815: Catalog store initialization with PostgreSQL failed. (hyunsik: rev ea4443d8df6ffb02e328304dc5681dbd54f62501)

        • CHANGES
        • tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #477 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/477/ ) TAJO-1815 : Catalog store initialization with PostgreSQL failed. (hyunsik: rev ea4443d8df6ffb02e328304dc5681dbd54f62501) CHANGES tajo-catalog/tajo-catalog-server/src/main/resources/schemas/postgresql/postgresql.xml
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user hyunsik commented on the pull request:

        https://github.com/apache/tajo/pull/730#issuecomment-137893327

        +1

        Show
        githubbot ASF GitHub Bot added a comment - Github user hyunsik commented on the pull request: https://github.com/apache/tajo/pull/730#issuecomment-137893327 +1
        Hide
        tajoqa Tajo QA added a comment -

        -1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12754205/TAJO-1815.patch
        against master revision release-0.9.0-rc0-443-g7e0a4a1.

        +1 @author. The patch does not contain any @author tags.

        -1 tests included. The patch doesn't appear to include any new or modified tests.
        Please justify why no new tests are needed for this patch.
        Also please list what manual steps were performed to verify this patch.

        +1 javac. The applied patch does not increase the total number of javac compiler warnings.

        +1 javadoc. The applied patch does not increase the total number of javadoc warnings.

        +1 checkstyle. The patch generated 0 code style errors.

        -1 findbugs. The patch appears to introduce 8 new Findbugs (version 2.0.3) warnings.

        +1 release audit. The applied patch does not increase the total number of release audit warnings.

        +1 core tests. The patch passed unit tests in tajo-catalog/tajo-catalog-server.

        Test results: https://builds.apache.org/job/PreCommit-TAJO-Build/853//testReport/
        Findbugs warnings: https://builds.apache.org/job/PreCommit-TAJO-Build/853//artifact/incubator-tajo/patchprocess/newPatchFindbugsWarningstajo-catalog-server.html
        Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/853//console

        This message is automatically generated.

        Show
        tajoqa Tajo QA added a comment - -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12754205/TAJO-1815.patch against master revision release-0.9.0-rc0-443-g7e0a4a1. +1 @author. The patch does not contain any @author tags. -1 tests included. The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. +1 javac. The applied patch does not increase the total number of javac compiler warnings. +1 javadoc. The applied patch does not increase the total number of javadoc warnings. +1 checkstyle. The patch generated 0 code style errors. -1 findbugs. The patch appears to introduce 8 new Findbugs (version 2.0.3) warnings. +1 release audit. The applied patch does not increase the total number of release audit warnings. +1 core tests. The patch passed unit tests in tajo-catalog/tajo-catalog-server. Test results: https://builds.apache.org/job/PreCommit-TAJO-Build/853//testReport/ Findbugs warnings: https://builds.apache.org/job/PreCommit-TAJO-Build/853//artifact/incubator-tajo/patchprocess/newPatchFindbugsWarningstajo-catalog-server.html Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/853//console This message is automatically generated.
        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user eminency opened a pull request:

        https://github.com/apache/tajo/pull/730

        TAJO-1815: Catalog store initialization with PostgreSQL failed

        Duplicated primary key definition removed.

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/eminency/tajo TAJO-1815

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/730.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #730


        commit 7062b0ec2ec74754d9cfd7e1568345e162172f2d
        Author: Jongyoung Park <eminency@gmail.com>
        Date: 2015-09-04T14:02:57Z

        Duplicate primary key clause deleted


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user eminency opened a pull request: https://github.com/apache/tajo/pull/730 TAJO-1815 : Catalog store initialization with PostgreSQL failed Duplicated primary key definition removed. You can merge this pull request into a Git repository by running: $ git pull https://github.com/eminency/tajo TAJO-1815 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/730.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #730 commit 7062b0ec2ec74754d9cfd7e1568345e162172f2d Author: Jongyoung Park <eminency@gmail.com> Date: 2015-09-04T14:02:57Z Duplicate primary key clause deleted

          People

          • Assignee:
            eminency Jongyoung Park
            Reporter:
            eminency Jongyoung Park
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development