Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

Explorer

hey @aashish soni did you fix this ?

Contributor

I think only postgresql 9.5 above is supported !!!

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.