lzwzxx commented on issue #112: URL: https://github.com/apache/gravitino-playground/issues/112#issuecomment-2677307576
> > I also encountered the same problem > > > [@tim108108](https://github.com/tim108108) It still doesn't work according to your operation > > Context: Due to another [issue discuss](https://github.com/apache/gravitino-playground/issues/128), I followed the guidelines and commented out the # checkPortsInUse operation. > > Execution log: > > ``` > # sh -x playground.sh start > + set -e > ++ dirname playground.sh > + playground_dir=. > ++ cd . > ++ pwd > + playground_dir=/ssd1/hudi_env/gravitino-playground > + playgroundRuntimeName=gravitino-playground > + requiredDiskSpaceGB=25 > + requiredRamGB=8 > + requiredCpuCores=2 > + requiredPorts=(6080 8090 9001 3307 19000 19083 60070 13306 15342 18080 18888 19090 13000) > + dockerComposeCommand= > + case "$1" in > + [[ '' == \-\-\e\n\a\b\l\e\-\r\a\n\g\e\r ]] > + enableRanger=false > + start > + '[' false == true ']' > + echo '[INFO] Starting the playground...' > [INFO] Starting the playground... > + echo '[INFO] The playground requires 2 CPU cores, 8 GB of RAM, and 25 GB of disk storage to operate efficiently.' > [INFO] The playground requires 2 CPU cores, 8 GB of RAM, and 25 GB of disk storage to operate efficiently. > + testDocker > + echo '[INFO] Testing Docker environment by running hello-world...' > [INFO] Testing Docker environment by running hello-world... > + docker run --rm --pull always hello-world:linux > + '[' 0 -eq 0 ']' > + echo '[INFO] Docker check passed: Docker is working correctly!' > [INFO] Docker check passed: Docker is working correctly! > ++ docker ps -a > ++ grep hello-world > ++ awk '{print $1}' > ++ awk '{print $2}' > ++ grep hello-world > ++ docker images > + for imageTag in '$(docker images | grep hello-world | awk '\''{print $2}'\'')' > + docker rmi hello-world:linux > Untagged: hello-world:linux > Untagged: hello-world@sha256:a77ecd852b17bfaee6708208960645d20fc9e6d0eec12353f8eb0e7b94bb647a > Deleted: sha256:74cc54e27dc41bb10dc4b2226072d469509f2f22f1a3ce74f4a59661a1d44602 > Deleted: sha256:63a41026379f4391a306242eb0b9f26dc3550d863b7fdbb97d899f6eb89efe72 > + checkDockerCompose > + dockerComposeCommand= > + command -v docker > + command -v docker compose > + dockerComposeCommand='docker compose' > + echo '[INFO] Docker compose check passed: Docker compose is working correctly using docker compose command!' > [INFO] Docker compose check passed: Docker compose is working correctly using docker compose command! > + checkPlaygroundNotRunning > + docker compose ls > + grep -q gravitino-playground > + checkDockerDisk > ++ awk '{print $NF}' > ++ grep 'Docker Root Dir' > ++ docker info > + local dockerRootDir=/ssd1/docker/data > + '[' -z /ssd1/docker/data ']' > + local availableSpaceKB > + '[' -d /ssd1/docker/data ']' > ++ awk 'NR==2 {print $4}' > ++ df -k /ssd1/docker/data > + availableSpaceKB=3228843860 > + local availableSpaceGB=3079 > + '[' 3079 -ge 25 ']' > + echo '[INFO] Docker disk check passed: 3079 GB available.' > [INFO] Docker disk check passed: 3079 GB available. > + checkDockerRam > ++ docker info --format '{{.MemTotal}}' > + local totalRamBytes=539946176512 > + local totalRamGB=502 > + '[' 502 -ge 8 ']' > + echo '[INFO] Docker RAM check passed: 502 GB available.' > [INFO] Docker RAM check passed: 502 GB available. > + checkDockerCpu > ++ docker info --format '{{.NCPU}}' > + local cpuCores=128 > + '[' 128 -ge 2 ']' > + echo '[INFO] Docker CPU check passed: 128 cores available.' > [INFO] Docker CPU check passed: 128 cores available. > + cd /ssd1/hudi_env/gravitino-playground > + echo '[INFO] Preparing packages...' > [INFO] Preparing packages... > + ./init/spark/spark-dependency.sh > Downloading iceberg-spark-runtime-3.4_2.12-1.5.2.jar to /ssd1/hudi_env/gravitino-playground/init/spark/packages > Downloading gravitino-spark-connector-runtime-3.4_2.12-0.8.0-incubating.jar to /ssd1/hudi_env/gravitino-playground/init/spark/packages > Downloading mysql-connector-java-8.0.27.jar to /ssd1/hudi_env/gravitino-playground/init/spark/packages > Downloading kyuubi-spark-authz-shaded_2.12-1.9.2.jar to /ssd1/hudi_env/gravitino-playground/init/spark/packages > + ./init/gravitino/gravitino-dependency.sh > Downloading mysql-connector-java-8.0.27.jar to /ssd1/hudi_env/gravitino-playground/init/gravitino/packages > Downloading postgresql-42.2.7.jar to /ssd1/hudi_env/gravitino-playground/init/gravitino/packages > + ./init/jupyter/jupyter-dependency.sh > ++ date +%Y%m%d%H%M%s > + logSuffix=2025021911171739935058 > + '[' false == true ']' > + docker compose -p gravitino-playground up --detach > [+] Running 11/11 > ✔ Network gravitino-playground_default Created 0.0s > ✔ Container playground-grafana Started 1.5s > ✘ Container playground-ranger Error 146.5s > ✔ Container playground-prometheus Started 1.5s > ✔ Container playground-postgresql Started 1.5s > ✔ Container playground-hive Healthy 20.5s > ✔ Container playground-spark Started 1.4s > ✔ Container playground-mysql Healthy 12.0s > ✔ Container playground-gravitino Created 0.0s > ✔ Container playground-jupyter Created 0.0s > ✔ Container playground-trino Created 0.0s > dependency failed to start: container playground-ranger is unhealthy > ``` > > docker logs: > > ``` > # docker logs playground-ranger > Starting MariaDB database server: mysqld. > 2025-02-19 03:40:11,540 --------- Running Ranger PolicyManager Web Application Install Script --------- > 2025-02-19 03:40:11,542 [I] uname=Linux > 2025-02-19 03:40:11,543 [I] hostname=1682068cf30b > 2025-02-19 03:40:11,546 [I] DB_FLAVOR=MYSQL > 2025-02-19 03:40:11,548 [I] Audit source=db > 2025-02-19 03:40:11,550 [I] Checking distribution name.. > 2025-02-19 03:40:11,555 [I] Found distribution : PRETTY_NAME="Debian > 2025-02-19 03:40:11,555 [I] check if command /usr/local/jdk/bin/java exists > 2025-02-19 03:40:11,556 [I] '/usr/local/jdk/bin/java' command found > /opt/ranger-admin/setup.sh: line 380: bc: command not found > /opt/ranger-admin/setup.sh: line 380: [: -eq: unary operator expected > 2025-02-19 03:40:11,729 [I] Checking MYSQL CONNECTOR FILE : /usr/share/java/mysql-connector-java.jar > 2025-02-19 03:40:11,730 [I] MYSQL CONNECTOR FILE : /usr/share/java/mysql-connector-java.jar file found > 2025-02-19 03:40:11,731 [I] Setting up UNIX user : ranger and group: ranger > 2025-02-19 03:40:11,736 [I] Creating new user and adding to group > 2025-02-19 03:40:11,747 [I] Setting up UNIX user : ranger and group: ranger DONE > 2025-02-19 03:40:11,748 [I] Setting up installation files and directory > 2025-02-19 03:40:11,751 [WARN] core-site.xml file not found in provided hadoop_conf path. Creating blank core-site.xml > 2025-02-19 03:40:11,751 [I] Creating /opt/ranger-admin/ews/webapp/WEB-INF/classes/lib > 2025-02-19 03:40:11,753 [I] Setting up init.d > 2025-02-19 03:40:11,755 [I] Creating script S88ranger-admin/K90ranger-admin in /etc/rc2.d directory .... > 2025-02-19 03:40:11,757 [I] Creating script S88ranger-admin/K90ranger-admin in /etc/rc3.d directory .... > 2025-02-19 03:40:11,761 [I] RANGER ADMIN LOGBACK CONF FILE : /opt/ranger-admin/ews/webapp/WEB-INF/classes/conf/logback.xml > 2025-02-19 03:40:11,763 [I]Creating Ranger PID folder: /var/run/ranger > 2025-02-19 03:40:11,765 [I] Setting up installation files and directory DONE > 2025-02-19 03:40:12,934 [I] /opt/ranger-admin/ews/webapp folder found > 2025-02-19 03:40:12,935 [I] db/mysql/optimized/current/ranger_core_db_mysql.sql file found > 2025-02-19 03:40:12,936 [I] Copying MYSQL Connector to /opt/ranger-admin/ews/webapp/WEB-INF/lib > 2025-02-19 03:40:12,939 [I] Copying MYSQL Connector to /opt/ranger-admin/ews/webapp/WEB-INF/lib DONE > 2025-02-19 03:40:12,940 [I] check if command python3 exists > 2025-02-19 03:40:12,941 [I] 'python3' command found > 2025-02-19 03:40:13,773 [I] DB FLAVOR :MYSQL > 2025-02-19 03:40:13,773 [I] --------- Verifying Ranger DB connection --------- > 2025-02-19 03:40:13,773 [I] Checking connection.. > 2025-02-19 03:40:13,774 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:14,938 [I] Checking connection passed. > 2025-02-19 03:40:14,946 [E] 'setup_mode' not found in /opt/ranger-admin/install.properties file while getting....!! > 2025-02-19 03:40:14,947 [I] Setup mode is not set. Running DBA steps.. > 2025-02-19 03:40:15,045 [I] Running DBA setup script. QuiteMode:True > 2025-02-19 03:40:15,045 [I] Using Java:/usr/local/jdk/bin/java > 2025-02-19 03:40:15,045 [I] DB FLAVOR:MYSQL > 2025-02-19 03:40:15,045 [I] DB Host:localhost > 2025-02-19 03:40:15,045 [I] ---------- Verifying DB root password ---------- > 2025-02-19 03:40:15,045 [I] DBA root user password validated > 2025-02-19 03:40:15,045 [I] ---------- Verifying Ranger Admin db user password ---------- > 2025-02-19 03:40:15,045 [I] admin user password validated > 2025-02-19 03:40:15,045 [I] ---------- Creating Ranger Admin db user ---------- > 2025-02-19 03:40:15,045 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "SELECT version();" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:16,149 [I] Verifying user rangeradmin for Host % > 2025-02-19 03:40:16,149 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "select user from mysql.user where user='rangeradmin' and host='%';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:17,242 [I] MySQL user rangeradmin does not exists for host % > 2025-02-19 03:40:17,243 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "create user 'rangeradmin'@'%' identified by '********';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:18,255 [I] Verifying user rangeradmin for Host % > 2025-02-19 03:40:18,256 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "select user from mysql.user where user='rangeradmin' and host='%';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:19,444 [I] MySQL user rangeradmin created for host % > 2025-02-19 03:40:19,444 [I] Verifying user rangeradmin for Host localhost > 2025-02-19 03:40:19,444 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "select user from mysql.user where user='rangeradmin' and host='localhost';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:20,546 [I] MySQL user rangeradmin already exists for host localhost > 2025-02-19 03:40:20,546 [I] ---------- Creating Ranger Admin database ---------- > 2025-02-19 03:40:20,546 [I] Verifying database ranger > 2025-02-19 03:40:20,547 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "show databases like 'ranger';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:21,648 [I] Database ranger already exists. > 2025-02-19 03:40:21,649 [I] ---------- Granting permission to Ranger Admin db user ---------- > 2025-02-19 03:40:21,649 [I] ---------- Granting privileges TO user 'rangeradmin'@'%' on db 'ranger'---------- > 2025-02-19 03:40:21,649 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "grant all privileges on ranger.* to 'rangeradmin'@'%' with grant option;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:22,729 [I] ---------- FLUSH PRIVILEGES ---------- > 2025-02-19 03:40:22,729 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "FLUSH PRIVILEGES;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:23,832 [I] Privileges granted to 'rangeradmin' on 'ranger' > 2025-02-19 03:40:23,832 [I] ---------- Granting privileges TO user 'rangeradmin'@'localhost' on db 'ranger'---------- > 2025-02-19 03:40:23,832 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "grant all privileges on ranger.* to 'rangeradmin'@'localhost' with grant option;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:24,949 [I] ---------- FLUSH PRIVILEGES ---------- > 2025-02-19 03:40:24,950 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/mysql -u root -p '********' -noheader -trim -c \; -query "FLUSH PRIVILEGES;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:26,050 [I] Privileges granted to 'rangeradmin' on 'ranger' > 2025-02-19 03:40:26,051 [I] ---------- Ranger Policy Manager DB and User Creation Process Completed.. ---------- > 2025-02-19 03:40:26,058 [I] /opt/ranger-admin/ews/webapp/WEB-INF/classes/conf/ranger-admin-site.xml file found > 2025-02-19 03:40:26,059 [I] /opt/ranger-admin/ews/webapp/WEB-INF/classes/conf/ranger-admin-default-site.xml file found > Starting configuration for Ranger DB credentials: > Using Java:/usr/local/jdk/bin/java > Alias ranger.db.password created successfully! > Using Java:/usr/local/jdk/bin/java > Alias unixAuthKeyStoreAlias created successfully! > Using Java:/usr/local/jdk/bin/java > Alias unixAuthTrustStoreAlias created successfully! > 2025-02-19 03:40:33,760 [I] Starting setup based on user authentication method=NONE > /opt/ranger-admin/ews/webapp > 2025-02-19 03:40:33,832 [I] Finished setup based on user authentication method=NONE > ln -sf /opt/ranger-admin/ews/webapp/WEB-INF/classes/conf /opt/ranger-admin/conf > 2025-02-19 03:40:34,640 [I] DB FLAVOR :MYSQL > 2025-02-19 03:40:34,640 [I] --------- Verifying Ranger DB connection --------- > 2025-02-19 03:40:34,640 [I] Checking connection.. > 2025-02-19 03:40:34,640 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:35,753 [I] Checking connection passed. > 2025-02-19 03:40:35,753 [I] --------- Verifying version history table --------- > 2025-02-19 03:40:35,753 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:36,948 [I] Table x_db_version_h does not exist in database ranger > 2025-02-19 03:40:36,948 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:38,050 [I] Table x_db_version_h does not exist in database ranger > 2025-02-19 03:40:38,050 [I] Importing x_db_version_h table schema to database ranger from file: create_dbversion_catalog.sql > 2025-02-19 03:40:38,050 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /opt/ranger-2.4.0-admin/db/mysql/create_dbversion_catalog.sql > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:39,129 [I] create_dbversion_catalog.sql file imported successfully > 2025-02-19 03:40:39,130 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_db_version_h';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:40,331 [I] Table x_db_version_h already exists in database 'ranger' > 2025-02-19 03:40:40,331 [I] --------- Importing Ranger Core DB Schema --------- > 2025-02-19 03:40:40,331 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:41,443 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'CORE_DB_SCHEMA' and active = 'N';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:42,549 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by,active) values ('CORE_DB_SCHEMA', current_timestamp, 'Ranger 2.4.0', current_timestamp, '1682068cf30b','N') ;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:43,653 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_portal_user';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:44,842 [I] Table x_portal_user does not exist in database ranger > 2025-02-19 03:40:44,842 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_policy_ref_group';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:46,043 [I] Table x_policy_ref_group does not exist in database ranger > 2025-02-19 03:40:46,043 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:47,248 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:48,343 [I] Importing DB schema to database ranger from file: ranger_core_db_mysql.sql > 2025-02-19 03:40:48,343 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /opt/ranger-2.4.0-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:50,254 [I] ranger_core_db_mysql.sql file imported successfully > 2025-02-19 03:40:50,254 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set inst_by='Ranger 2.4.0' where active='Y' and updated_by='localhost';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:51,258 [I] Patches status entries updated from base ranger version to current installed ranger version:Ranger 2.4.0 > 2025-02-19 03:40:51,258 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_portal_user';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:52,353 [I] Table x_portal_user already exists in database 'ranger' > 2025-02-19 03:40:52,354 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "show tables like 'x_policy_ref_group';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:53,543 [I] Table x_policy_ref_group already exists in database 'ranger' > 2025-02-19 03:40:53,543 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:54,946 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:56,144 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set active='Y' where version='CORE_DB_SCHEMA' and active='N' and updated_by='1682068cf30b';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:57,157 [I] CORE_DB_SCHEMA import status has been updated > 2025-02-19 03:40:57,157 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DB_PATCHES' and inst_by = 'Ranger 2.4.0' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:40:58,251 [I] DB_PATCHES have already been applied > 2025-02-19 03:40:59,149 [I] DB FLAVOR :MYSQL > 2025-02-19 03:40:59,150 [I] --------- Verifying Ranger DB connection --------- > 2025-02-19 03:40:59,150 [I] Checking connection.. > 2025-02-19 03:40:59,150 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:00,249 [I] Checking connection passed. > 2025-02-19 03:41:00,249 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'JAVA_PATCHES' and inst_by = 'Ranger 2.4.0' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:01,449 [I] JAVA_PATCHES have already been applied > 2025-02-19 03:41:02,343 [I] DB FLAVOR :MYSQL > 2025-02-19 03:41:02,344 [I] --------- Verifying Ranger DB connection --------- > 2025-02-19 03:41:02,344 [I] Checking connection.. > 2025-02-19 03:41:02,344 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select 1;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:03,551 [I] Checking connection passed. > 2025-02-19 03:41:03,551 [I] RANGER_ADMIN_ENV_PATH : /opt/ranger-2.4.0-admin > 2025-02-19 03:41:03,551 [I] env_file_path : /opt/ranger-2.4.0-admin/ranger-admin-env*.sh > 2025-02-19 03:41:03,552 [I] RANGER ADMIN LOG DIR : /opt/ranger-2.4.0-admin/ews/logs > 2025-02-19 03:41:03,552 [I] LOGBACK CONF FILE : file:/opt/ranger-2.4.0-admin/ews/webapp/WEB-INF/classes/conf/logback.xml > 2025-02-19 03:41:03,552 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DEFAULT_ALL_ADMIN_UPDATE' and active = 'Y';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:04,654 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = 'DEFAULT_ALL_ADMIN_UPDATE' and active = 'N';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:05,845 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by,active) values ('DEFAULT_ALL_ADMIN_UPDATE', current_timestamp, 'Ranger 2.4.0', current_timestamp, '1682068cf30b','N') ;" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:06,862 [I] Ranger all admins default password change request is in process.. > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:55,345 [JISQL] /usr/local/jdk/bin/java -cp /usr/share/java/mysql-connector-java.jar:/opt/ranger-2.4.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://localhost/ranger?useSSL=false -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "update x_db_version_h set active='Y' where version='DEFAULT_ALL_ADMIN_UPDATE' and active='N' and updated_by='1682068cf30b';" > Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. > 2025-02-19 03:41:56,360 [I] Ranger all admins default password change request processed successfully.. > Installation of Ranger PolicyManager Web Application is completed. > Starting Apache Ranger Admin Service > Apache Ranger Admin Service with pid 2418 has started. > [r...@bjdd-lingyunshengtai001.bjdd.baidu.com gravitino-playground]# > ``` > > docker inspect info > > ``` > # docker inspect playground-ranger > [ > { > "Id": "1682068cf30bdb82db061ab4ce7e9587151481563711cac8861ce34d6692c3f9", > "Created": "2025-02-19T03:40:07.473809278Z", > "Path": "/bin/bash", > "Args": [ > "/tmp/ranger/init.sh" > ], > "State": { > "Status": "running", > "Running": true, > "Paused": false, > "Restarting": false, > "OOMKilled": true, > "Dead": false, > "Pid": 4241, > "ExitCode": 0, > "Error": "", > "StartedAt": "2025-02-19T03:40:08.867587822Z", > "FinishedAt": "0001-01-01T00:00:00Z", > "Health": { > "Status": "unhealthy", > "FailingStreak": 107, > "Log": [ > { > "Start": "2025-02-19T11:50:45.643831253+08:00", > "End": "2025-02-19T11:50:45.687501134+08:00", > "ExitCode": 7, > "Output": "+ max_attempts=3\n+ attempt=0\n+ '[' 0 -lt 3 ']'\n++ curl -s -o /dev/null -w '%{http_code}' -u 'admin:rangerR0cks!' -H 'Content-Type: application/json' -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info\n+ response=000\n" > }, > { > "Start": "2025-02-19T11:50:50.688431328+08:00", > "End": "2025-02-19T11:50:50.732436872+08:00", > "ExitCode": 7, > "Output": "+ max_attempts=3\n+ attempt=0\n+ '[' 0 -lt 3 ']'\n++ curl -s -o /dev/null -w '%{http_code}' -u 'admin:rangerR0cks!' -H 'Content-Type: application/json' -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info\n+ response=000\n" > }, > { > "Start": "2025-02-19T11:50:55.733574821+08:00", > "End": "2025-02-19T11:50:55.789662682+08:00", > "ExitCode": 7, > "Output": "+ max_attempts=3\n+ attempt=0\n+ '[' 0 -lt 3 ']'\n++ curl -s -o /dev/null -w '%{http_code}' -u 'admin:rangerR0cks!' -H 'Content-Type: application/json' -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info\n+ response=000\n" > }, > { > "Start": "2025-02-19T11:51:00.790643367+08:00", > "End": "2025-02-19T11:51:00.835966188+08:00", > "ExitCode": 7, > "Output": "+ max_attempts=3\n+ attempt=0\n+ '[' 0 -lt 3 ']'\n++ curl -s -o /dev/null -w '%{http_code}' -u 'admin:rangerR0cks!' -H 'Content-Type: application/json' -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info\n+ response=000\n" > }, > { > "Start": "2025-02-19T11:51:05.836699388+08:00", > "End": "2025-02-19T11:51:05.880775506+08:00", > "ExitCode": 7, > "Output": "+ max_attempts=3\n+ attempt=0\n+ '[' 0 -lt 3 ']'\n++ curl -s -o /dev/null -w '%{http_code}' -u 'admin:rangerR0cks!' -H 'Content-Type: application/json' -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info\n+ response=000\n" > } > ] > } > } > ... > ``` > > container check info > > ``` > # docker exec -it playground-ranger /bin/bash > root@1682068cf30b:~# sh -x /tmp/healthcheck/ranger-healthcheck.sh > + set -ex > + max_attempts=3 > + attempt=0 > + [ 0 -lt 3 ] > + curl -s -o /dev/null -w %{http_code} -u admin:rangerR0cks! -H Content-Type: application/json -X GET http://127.0.0.1:6080/service/public/v2/api/plugins/info > + response=000 > root@1682068cf30b:~# ps -aux > USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND > root 1 0.0 0.0 3732 1540 ? Ss 03:40 0:00 /bin/bash /tmp/ranger/init.sh > root 36 0.0 0.0 2384 752 ? S 03:40 0:00 /bin/sh /usr/bin/mysqld_safe > mysql 152 0.2 0.0 2358468 96528 ? Sl 03:40 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/x86_64-linux-gnu/mariadb19/plugin --u > root 153 0.0 0.0 4704 920 ? S 03:40 0:00 logger -t mysqld -p daemon error > root 3068 0.0 0.0 3864 2024 pts/0 Ss 03:46 0:00 /bin/bash > root 3199 0.0 0.0 2292 376 ? S 03:47 0:00 sleep 5 > root 3207 0.0 0.0 7920 1676 pts/0 R+ 03:47 0:00 ps -aux > root@1682068cf30b:~# > ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@gravitino.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
