Member since
08-08-2017
1652
Posts
30
Kudos Received
11
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2058 | 06-15-2020 05:23 AM | |
| 17016 | 01-30-2020 08:04 PM | |
| 2220 | 07-07-2019 09:06 PM | |
| 8553 | 01-27-2018 10:17 PM | |
| 4837 | 12-31-2017 10:12 PM |
01-30-2020
06:37 AM
yes - the same problem ERROR [main] DBAccessorImpl:119 - Error while creating database accessor org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
... View more
01-30-2020
06:32 AM
after I fixed the permissions I restart the PostgreSQL and ambari server but still get Waiting for server start.................................ERROR: Exiting with exit code -1. REASON: Ambari Server java process has stopped. Please check the logs for more information.
... View more
01-30-2020
06:29 AM
yes I add permissions to the file seems the permissions added successfully and the fresh log is like that LOG: shutting down LOG: database system is shut down LOG: database system was shut down at 2020-01-30 14:23:23 UTC LOG: autovacuum launcher started LOG: database system is ready to accept connections
... View more
01-30-2020
06:07 AM
Dear jay we restart the postgreSQL 3 times but ambari still failed on port 8080 ( include the setting ) server.startup.web.timeout=150
... View more
01-30-2020
06:04 AM
more * LOG: database system was interrupted; last known up at 2020-01-22 23:31:37 UTC LOG: redo starts at 39/C7000080 LOG: consistent recovery state reached at 39/C70474A8 FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up FATAL: the database system is starting up LOG: could not open file "pg_xlog/000000010000003A00000023" (log file 58, segment 35): No such file or directory LOG: redo done at 3A/22036568 LOG: last completed transaction was at log time 2020-01-30 10:41:43.937312+00 FATAL: the database system is starting up LOG: autovacuum launcher started LOG: database system is ready to accept connections WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress WARNING: there is already a transaction in progress
... View more
01-30-2020
06:01 AM
now I see the correct syntax ( I use full FQDN ) /usr/jdk64/jdk1.8.0_112/bin/java -cp /var/lib/ambari-server/resources/DBConnectionVerification.jar:/usr/lib/ambari-server/postgresql-9.3-1101-jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://`hostname -f`:5432/ambari ambari bigdata org.postgresql.Driver Connected to DB Successfully!
... View more
01-30-2020
06:00 AM
now I see the correct syntax ( I use full FQDN ) /usr/jdk64/jdk1.8.0_112/bin/java -cp /var/lib/ambari-server/resources/DBConnectionVerification.jar:/usr/lib/ambari-server/postgresql-9.3-1101-jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://`hostname -f`:5432/ambari ambari bigdata org.postgresql.Driver Connected to DB Successfully!
... View more
01-30-2020
05:57 AM
sorry for my mistake the correct is /usr/jdk64/jdk1.8.0_112/bin/java -cp /var/lib/ambari-server/resources/DBConnectionVerification.jar:/usr/lib/ambari-server/postgresql-9.3-1101-jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://localhost:5432/ambari ambari bigdata org.postgresql.Driver but its hang ( not return prompt )
... View more
01-30-2020
05:54 AM
about the second test how to find the HOSTNAME of PostgresDB ?
... View more
01-30-2020
05:53 AM
Dear Jay here the first test /usr/jdk64/jdk1.8.0_112/bin/java -cp /var/lib/ambari-server/resources/DBConnectionVerification.jar:/usr/lib/ambari-server/postgresql-42.2.2.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://localhost:5432/ambari ambari bigdata org.postgresql.Driver ERROR: Unable to connect to the DB. Please check DB connection properties. java.lang.ClassNotFoundException: org.postgresql.Driver
... View more