Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error Starting Streaming Analytics Manager

Highlighted

Error Starting Streaming Analytics Manager

New Contributor

Hi , I am getting below error when Amabari is trying to start Streaming Analytics Manager , Please help

HDF MAPCK = hdf-ambari-mpack-3.1.1.0-35.tar.gz

Ambari = 2.6.1.5

[main] INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory - Database: jdbc:postgresql://hdfpostgres.dev:5432/registry (PostgreSQL 9.4)
[main] INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl - Creating Metadata table: "public"."DATABASE_CHANGE_LOG"
"migrate" option failed : 
Script failed
-------------
SQL State  : 42P07
Error Code : 0
Message    : ERROR: relation "DATABASE_CHANGE_LOG" already exists
Line       : 17
Statement  : CREATE TABLE "public"."DATABASE_CHANGE_LOG" (
    "installed_rank" INT NOT NULL,
    "version" VARCHAR(50),
    "description" VARCHAR(200) NOT NULL,
    "type" VARCHAR(20) NOT NULL,
    "script" VARCHAR(1000) NOT NULL,
    "checksum" INTEGER,
    "installed_by" VARCHAR(100) NOT NULL,
    "installed_on" TIMESTAMP NOT NULL DEFAULT now(),
    "execution_time" INTEGER NOT NULL,
    "success" BOOLEAN NOT NULL
)
2 REPLIES 2

Re: Error Starting Streaming Analytics Manager

New Contributor

hey @aashish soni did you fix this ?

Re: Error Starting Streaming Analytics Manager

Contributor

I think only postgresql 9.5 above is supported !!!

Don't have an account?
Coming from Hortonworks? Activate your account here