Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

PostgreSQL connection errors from mapred

Highlighted

PostgreSQL connection errors from mapred

New Contributor

Hello,

I have a lot of PosgreSQL connection errors:

cat postgresql.log | tail -100

…

time=2017-06-15 18:33:15.839 UTC  appl=[unknown]  user=mapred  db=ambarirca  remote=127.0.0.1  proc=6393  cmd=authentication  session=5942d2e9.18f9  session_line=1session_ts=2017-06-15
18:33:13 UTC 
vtrx=37/51960  trx=0sqlstate=00000 msg=LOG: 
pam_authenticate failed: Authentication failure

I use HDP 2.5. The database ambarirca doesn't exist in my environment.

In the following thread, @yusaku mentions that the database should not be used:

https://community.hortonworks.com/questions/81024/failed-to-backup-ambarirca.html

Something still tries to use this database. How can I fix it?

Thank you,

Luc

1 REPLY 1

Re: PostgreSQL connection errors from mapred

New Contributor

Hi Luc,

we have the same issue here, using HDP 2.5.3;

In postgres logs we have;

< 2017-08-11 10:00:13.732 CEST >FATAL: role "mapred" does not exist
< 2017-08-11 10:05:17.225 CEST >FATAL: role "mapred" does not exist

In pgpool logs we get the matching connection;

2017-08-11 09:59:30: pid 59642: DETAIL: connecting host=localhost port=53936

And it turns out that ... proc_rangeradmin is at the source of this .. looks very strange, as we have checked all ranger parameters and did not see any occurence of "mapred" user there ..

# lsof :53936 java 44878 ranger 42u IPv6 215296569 0t0 TCP localhost:53936->localhost:9999 (ESTABLISHED) pgpool 59642 postgres 8u IPv4 215296570 0t0 TCP localhost:9999->localhost:53936 (ESTABLISHED)

|-java,44878 -Dproc_rangeradmin -Djavax.net.ssl.trustStore=/etc/pki/java/cacerts -Dlogdir=/var/log/ranger/admin-Dcatalina.base=/usr/hdp/2.5

Don't have an account?
Coming from Hortonworks? Activate your account here