Skip to content

Apache Ranger: No transaction in progress error #17

@Spydernaz

Description

@Spydernaz

Hi,

Thank you for your repo, I have tried to build and use the docker compose script and I am getting the below error (just keeps on repeating these lines over and over):

postgres-server_1  | 2019-08-28 14:40:20.852 UTC [203] WARNING:  there is no transaction in progress
postgres-server_1  | 2019-08-28 14:40:20.907 UTC [203] WARNING:  there is no transaction in progress
postgres-server_1  | 2019-08-28 14:40:20.912 UTC [203] WARNING:  there is no transaction in progress
postgres-server_1  | 2019-08-28 14:40:20.918 UTC [203] WARNING:  there is no transaction in progress
postgres-server_1  | 2019-08-28 14:40:20.923 UTC [203] WARNING:  there is no transaction in progress
ranger-admin_1     | 2019-08-28 14:40:20,935  [I] xa_core_db_postgres.sql file imported successfully
ranger-admin_1     | 2019-08-28 14:40:20,935  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \;  -query "update x_db_version_h set inst_by='Ranger 2.0.0' where active='Y' and updated_by='localhost';"
ranger-admin_1     | 2019-08-28 14:40:21,489  [I] Patches status entries updated from base ranger version to current installed ranger version:Ranger 2.0.0
ranger-admin_1     | 2019-08-28 14:40:21,489  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \;  -query "select * from (select table_name from information_schema.tables where table_catalog='ranger' and table_name = 'x_portal_user') as temp;"
ranger-admin_1     | 2019-08-28 14:40:22,069  [I] Table x_portal_user already exists in database 'ranger'
ranger-admin_1     | 2019-08-28 14:40:22,069  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \;  -query "select * from (select table_name from information_schema.tables where table_catalog='ranger' and table_name = 'x_policy_ref_group') as temp;"
ranger-admin_1     | 2019-08-28 14:40:22,639  [I] Table x_policy_ref_group does not exist in database ranger
ranger-admin_1     | 2019-08-28 14:40:22,639  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \;  -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';"
ranger-admin_1     | 2019-08-28 14:40:23,240  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \;  -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';"
ranger-admin_1     | 2019-08-28 14:40:23,851  [I] Importing DB schema to database ranger from file: xa_core_db_postgres.sql
ranger-admin_1     | 2019-08-28 14:40:23,852  [JISQL] /usr/lib/jvm/java-8-openjdk-amd64/bin/java  -cp /opt/postgresql-42.2.2.jar:/opt/ranger-2.0.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver postgresql -cstring jdbc:postgresql://postgres-server/ranger -u ranger -p '********' -noheader -trim -c \; -input /opt/ranger-2.0.0-admin/db/postgres/xa_core_db_postgres.sql 

Any help would be really helpful :) thanks heaps in advance!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions