Re: PGAgent 4.0 error feedback - Mailing list pgadmin-hackers

From Ashesh Vashi
Subject Re: PGAgent 4.0 error feedback
Date
Msg-id CAG7mmoyCB2pre7KFRd1=28ydS3cuZqaGbCjFXomjtySVZ28iJQ@mail.gmail.com
Whole thread Raw
In response to Re: PGAgent 4.0 error feedback  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-hackers
Hi Rob,

On Mon, Jun 11, 2018 at 9:13 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Hi Rob,

On Sun, Jun 10, 2018 at 2:26 AM, Rob Emery <re-pgsql@codeweavers.net> wrote:
Hi Guys,

I've been testing out PGAgent 4 (build today from master at commit
86ca5c5ed1ad572075ba27e05e4680ebdf5b9feb) to check the connection
handling on error is still fixed with the boost reimplementation
(which it is!)
and noticed a few issues compared to PGAgent 3 around feedback to the
user if the connection string is incorrect.

I've tested with incorrect username and password, user not in the hba,
db doesn't exist, postgresql not running on the host (or incorrect
hostaddr) and 4 seems to always returns the error :
`
ERROR: Couldn't find the function 'pgagent_schema_version' - please
run pgagent_upgrade.sql.
`

whereas 3.4.1 tends to output from the pgconnection itself like:
`
Sat Jun  9 21:32:13 2018 : WARNING: Couldn't create the primary
connection (attempt 1): FATAL:  no pg_hba.conf entry for host
"172.30.0.16", user "pgagent_login_role", database
"pgagent_login_role", SSL on
FATAL:  no pg_hba.conf entry for host "172.30.0.16", user
"pgagent_login_role", database "pgagent_login_role", SSL off
`

which at least points the user towards the actual error!

Not sure if this is known already, but I thought I'd raise it prior to release.
Thanks for sharing the information.

Is it possible for you to share the logs with log level set to debug?
Also - please share the operating system details?

I've sent a patch to resolve the issue  based on some assumptions, to verify those assumptions I would still like to see the logs (if you can provide), and operating system information.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi  


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


 

Thanks,
Rob
--

--
 <https://codeweavers.net>


Codeweavers May Newsletter
<https://mailchi.mp/codeweavers/march-edition-336883>  l  Codeweavers April
Finance Trends
<https://codeweavers.net/company-blog/codeweavers-april-finance-trends>


April’s Dealer Highlights
<https://codeweavers.net/company-blog/aprils-dealer-highlights>
<https://codeweavers.net/company-blog/codeweavers-march-car-finance-trends>

_
_



*Phone:* 0800 021 0888   Email: contactus@codeweavers.net
<mailto:contactus@codeweavers.net>
Codeweavers Ltd | Barn 4 | Dunston
Business Village | Dunston | ST18 9AB
Registered in England and Wales No.
04092394 | VAT registration no. 974 9705 63 




<https://www.linkedin.com/company/codeweavers-limited>  
<https://vimeo.com/codeweaversltd>  
<https://plus.google.com/b/105942302039373248738/+CodeweaversNet>  
<https://twitter.com/CodeweaversTeam>




pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: [PATCH] pgAgent segfault
Next
From: Aditya Toshniwal
Date:
Subject: Re: [pgadmin4][patch] Initial patch to decouple from ACI Tree