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

        Attachments

        1. TAJO-1815.patch
          0.8 kB
          Jongyoung Park

          Activity

            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: