Apache Ranger: No transaction in progress error

[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!

[KentonParton]

@Spydernaz I am having having the same issue. Did you figure out what the issue was? Thanks

[Spydernaz]

I have a docker image in my repo on docker hub that I got working if you are after the image, otherwise I have the dockerfile etc in one of my repos

https://hub.docker.com/r/spydernaz/apache-ranger-admin-db
https://hub.docker.com/r/spydernaz/apache-ranger-admin

[KentonParton]

Awesome, thanks.