And just one more interesting thing:
After I correct the agents authentication, and it can reach the system
tables, and report all the stuff, I still have got lines:
2013-09-23 14:28:56 CEST FATAL: password authentication failed for user
"postgres"
Until I set up the access parameters, I have got only such lines, but after
setting it up, I have got this:
2013-09-23 14:28:17 CEST ERROR: column "current_query" does not exist at
character 70
2013-09-23 14:28:17 CEST STATEMENT: SELECT (SELECT COUNT(*) FROM
pg_stat_activity where usename = $1 AND current_query != '<IDLE>') AS
active,
(SELECT COUNT(*) FROM pg_stat_activity WHERE usename = $2) AS
total
and less frequently this:
2013-09-23 14:28:56 CEST FATAL: password authentication failed for user
"postgres"
Attila
2013/9/23 Attila Heidrich <attila.heidrich(a)gmail.com>
I have "uninventoried" the postgres plugin for most of the
servers. By the
way there's only a single server which suffers from this issue, and this is
the one what is used by RHQ itself! The others - which are only monitored
by the agent, are quite fine. The only problem is with the 9.2 version that
some system tables has been changed with 9.2, so there's not current_query
anymore.
This is strange, that in postgres log there's still lines like this:
2013-09-23 13:43:04 CEST ERROR: column "current_query" does not exist at
character 70
2013-09-23 13:43:04 CEST STATEMENT: SELECT (SELECT COUNT(*) FROM
pg_stat_activity where usename = $1 AND current_query != '<IDLE>') AS
active,
(SELECT COUNT(*) FROM pg_stat_activity WHERE usename = $2) AS
total
2013-09-23 13:43:44 CEST FATAL: password authentication failed for user
"postgres"
2013-09-23 13:43:46 CEST FATAL: password authentication failed for user
"postgres"
I guess uninventory is not the perfect way to disable the plugin...
max_connection is the default 100 for all the servers.
Whenever it happen again, I will collect more Pg statistics!
Regards,
Attila
2013/9/23 Attila Heidrich <attila.heidrich(a)gmail.com>
> Postgres database stopped again... I guess the problem was the enormous
> number of open files...
>
> We use 9.2, and we also use the postgres plugin - which still doesn't
> really support 9.2 as far as I know.
>
> Altogether Postgres (only the one storing the RHQ database) can only run
> for a few days, than the number of open files and the open connections
> raise really high, and finally I should restart it.
>
> Usually I restart RHQ as well, I generally have no time to play with
> "what to restart".
>
> The log is practically endless, I can quote, but I think I should know
> something to look for in it.
>
>
> Regards,
>
> Attila
>