testcases
testcases copied to clipboard
coheigea
Apache Ranger: No transaction in progress error
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!
@Spydernaz I am having having the same issue. Did you figure out what the issue was? Thanks
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