[TAJO-1815] Catalog store initialization with PostgreSQL failed

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

Environment

PostgreSQL 9.4

• Assignee: Jongyoung Park
• Reporter: Jongyoung Park
• Created: 04/Sep/15 13:25
• Updated: 05/Sep/15 07:20
• Resolved: 05/Sep/15 02:07

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