Support Questions

Find answers, ask questions, and share your expertise

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.