[AMBARI-25191] Ambari server setup failed with postgres connectivity error when using postgres 9.3

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6.0
• Component/s: ambari-server
• Labels: pull-request-available
• Assignee: Attila Magyar
• Reporter: Attila Magyar
• Created: 12/Mar/19 10:59
• Updated: 13/Mar/19 11:35
• Resolved: 13/Mar/19 11:34

Description

INFO 2019-03-04 17:45:49,694 serverSetup.py:1088 - Setup ambari-server.
ERROR 2019-03-04 17:45:50,498 ambari-server.py:901 - 'Fatal exception: Unable to start PostgreSQL server. Exiting, exit code 4'
Traceback (most recent call last):
File "/usr/sbin/ambari-server.py", line 884, in main
action_obj.execute()
File "/usr/sbin/ambari-server.py", line 79, in execute
self.fn(*self.args, **self.kwargs)
File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 1145, in setup
_setup_database(options)
File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 958, in _setup_database
dbmsAmbari.setup_database()
File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration.py", line 150, in setup_database
self._setup_local_database()
File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration_linux.py", line 474, in _setup_local_database
raise FatalException(retcode, err)
FatalException: 'Fatal exception: Unable to start PostgreSQL server. Exiting, exit code 4'
INFO 2019-03-04 17:45:51,001 ambari-server.py:798 - loglevel=logging.INFO
INFO 2019-03-04 17:45:51,003 serverSetup.py:1208 - Reset ambari-server.
ERROR 2019-03-04 17:45:51,036 ambari-server.py:901 - 'Fatal exception: could not change directory to "/root": Permission denied\npsql: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"?\n, exit code 1'
Traceback (most recent call last):
File "/usr/sbin/ambari-server.py", line 884, in main
action_obj.execute()
File "/usr/sbin/ambari-server.py", line 79, in execute
self.fn(*self.args, **self.kwargs)
File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 1236, in reset
_reset_database(options)
File "/usr/lib/ambari-server/lib/ambari_server/serverSetup.py", line 999, in _reset_database
dbmsAmbari.reset_database()
File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration.py", line 157, in reset_database
self._reset_local_database()
File "/usr/lib/ambari-server/lib/ambari_server/dbConfiguration_linux.py", line 513, in _reset_local_database
raise FatalException(1, drop_errdata)
FatalException: 'Fatal exception: could not change directory to "/root": Permission denied\npsql: could not connect to server: No such file or directory\n\tIs the server running locally and accepting\n\tconnections on Unix domain socket "/tmp/.s.PGSQL.5432"?\n, exit code 1'
INFO 2019-03-04 17:45:53,854 ambari-server.py:798 - loglevel=logging.INFO
INFO 2019-03-04 17:45:53,856 ambari-server.py:161 - Stopping ambari-server.
INFO 2019-03-04 17:45:53,857 ambari-server.py:190 - Ambari Server is not running

Issue Links

• links to: GitHub Pull Request #2859