[Bucardo-general] Trouble shooting db connections

[Paul Tader]

On Oct 1, 2018, 9:34 PM -0500, David Christensen <david at endpoint.com>, wrote:
> > > Sorry, that would be Postgres’ “log_min_messages” parameter, and it will show up in the PostgreSQL log file. You could probably just change on the validate_goat function via running the following in your “bucardo” database:
> > >
> > > ALTER FUNCTION bucardo.validate_goat() SET log_min_messages = ‘DEBUG’;
> > >
> > > (Hand-waving syntax here; if you want to just change globally you can as well, it’ll just introduce a lot more noise.)
> > >
> > > --
> > > David Christensen
> > > End Point Corporation
> > > david at endpoint.com
> > > 785-727-1171
> > >
> > >
> > Unfortunately, because the disk containing the WAL files filled up, the database shutdown and I had to restart the bucardo process and the original problem is back, adding a sync fails but psql connections from the command line succeed.
> >
> > $ bucardo add sync mysync tables=all dbs=qasync --verbose
> > DBD::Pg::st execute failed: ERROR: DBI connect(‘dbname=mydb;host=123.123.123.123;port=5432','migration',...) failed: could not connect to server: Connection timed out
> > Is the server running on host “123.123.123.123" and accepting
> > TCP/IP connections on port 5432? at line 63.
> > CONTEXT: PL/Perl function "validate_goat" at /usr/local/bin/bucardo line 5209.
> >
> >
> > I did set:
> >
> > ALTER FUNCTION bucardo.validate_goat() SET log_min_messages = ‘DEBUG’;
> >
> > …but the postgres logs echo the same error.
>
>
> So you are seeing nothing from this line in the postgres logs?:
>
> elog(DEBUG, "Connecting in validate_goat as $db{dsn} user=$db{user} pid=$$ for table $schema.$table");
> --
> David Christensen
> End Point Corporation
> david at endpoint.com
> 785-727-1171
>
>
>
>
Yes, sorry - should have included that in my previous messages. Four or five validate_goat calls are logged before it times out.

2018-10-01 20:30:13.700 UTC [20769] bucardo at bucardo CONTEXT: PL/Perl function "validate_goat"
2018-10-01 20:30:13.701 UTC [20769] bucardo at bucardo DEBUG: Connecting in validate_goat as dbi:Pg:dbname=mydb;host=123.123.123.123;port=5432 user=migration pid=20769 for table atable.token
2018-10-01 20:30:13.701 UTC [20769] bucardo at bucardo CONTEXT: PL/Perl function "validate_goat"
2018-10-01 20:30:13.736 UTC [20769] bucardo at bucardo DEBUG: Valid unique constraints found: 1

2018-10-01 20:30:13.736 UTC [20769] bucardo at bucardo CONTEXT: PL/Perl function "validate_goat"
2018-10-01 20:30:13.737 UTC [20769] bucardo at bucardo DEBUG: Running validate_goat
2018-10-01 20:30:13.737 UTC [20769] bucardo at bucardo CONTEXT: PL/Perl function "validate_goat"
2018-10-01 20:30:13.738 UTC [20769] bucardo at bucardo DEBUG: Connecting in validate_goat as dbi:Pg:dbname=mydb;host=123.123.123.123;port=5432 user=migration pid=20769 for table anothertable.facts



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20181002/28212e45/attachment.html>