[pgpool-general: 5100] Re: pgpool.log file

[Lachezar Dobrev]

  The ^@ is actually a null character (ASCII Zero) [1].
  As to why this character made appearance in the logs is an issue probably
worth checking. Maybe you can share a line or two that contain the ^@ so
that a better guess of what's happening can be done. It's possible, that
you have problems with the resolver, since using TCP or loop-back (-h
parameter) behaves differently than the UNIX Socket (without -h).

  [1] https://en.wikipedia.org/wiki/%5E@

2016-11-02 20:03 GMT+02:00 Wolf Schwurack <wolf at uen.org>:

> So maybe my pgpool.conf was just corrupted I changed the parameter back
>  ‘enable_pool_hba=on’ I’m no longer seeing any ‘^@’ in pgpool.log file.
>
>
>
> *From: *"pgpool-general-bounces at pgpool.net" <pgpool-general-bounces@
> pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
> *Date: *Wednesday, November 2, 2016 at 10:26 AM
> *To: *"'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
> *Subject: *[pgpool-general: 5098] Re: pgpool.log file
>
>
>
> I found the issue
>
>
>
> If “enable_pool_hba = on” in pgpool.conf then I get “^@” sign in pgool.log
> file when connecting. If “enable_pool_hba=off” I don’t get “^@” signs in
> pgpool.log file.
>
>
>
> Is this how this should work? Having a bunch of “^@” in the pgpool.log
> file makes it hard to troubleshoot issues when trying read pgpool.log.
>
>
>
> *From: *"pgpool-general-bounces at pgpool.net" <pgpool-general-bounces@
> pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
> *Date: *Wednesday, November 2, 2016 at 10:02 AM
> *To: *"'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
> *Subject: *[pgpool-general: 5097] Re: pgpool.log file
>
>
>
> I notice that ‘data’ pgpool.log contants ‘^@^@’ When I remove ‘^@^@’ from
> pgpool.log Then it shows the file as ASCII.
>
>
>
> We use watchdog on our pgpool servers
>
>
>
> To recreate – When using psql with the watchdog connection command it puts
> ‘^@^@’ signs in pgpool.log file but if I psql on the postgresql host it
> doesn’t put the ‘^@’ sign in the log file.
>
>
>
> This only happens on my development and test hosts
>
>
>
> All of our applications connect using watchdog connection command
>
>
>
> From pgpool hosts connecting to postgres - I get ‘^@’ sign into pgpool.log
> file
>
> $ psql –h wd-pgdev –p 9999
>
>
>
> From postgresql host connecting to postgres – no ‘^@” sign into pgpool.log
> file
>
> $ psql
>
>
>
>
>
> Wolfgang Schwurack
>
> Database/System Administrator
>
> Utah Education Network
>
> 801-587-9444
>
> wolf at uen.org
>
>
>
>
>
>
>
>
>
> *From: *"pgpool-general-bounces at pgpool.net" <pgpool-general-bounces@
> pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
> *Date: *Wednesday, November 2, 2016 at 9:11 AM
> *To: *"'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
> *Subject: *[pgpool-general: 5096] pgpool.log file
>
>
>
> My development pgpool server the pgpool.log file show that it’s a binary
> file but on my production pgpool server show the file as ASCII. Both
> servers are setup the same.
>
>
>
> Anyone know why one file is binary and the other is ASCII?
>
>
>
> I use the same command on both to start pgpool
>
> pgpool -n -D -f /usr/local/etc/pgpool.conf > /var/log/pgpool/pgpool.log
>
>
>
> Version
>
> pgpool-II version 3.5.4 (ekieboshi)
>
>
>
> Host
>
> Ubuntu 14.04.5 LTS
>
>
>
> Production server
>
> # file /var/log/pgpool/pgpool.log
>
> /var/log/pgpool/pgpool.log: ASCII text
>
>
>
> Development server
>
> # file /var/log/pgpool/pgpool.log
>
> /var/log/pgpool/pgpool.log: data
>
>
>
>
>
> Wolfgang Schwurack
>
> Database/System Administrator
>
> Utah Education Network
>
> 801-587-9444
>
> wolf at uen.org
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161103/a6f8dfce/attachment.html>