A.147. Release 3.6.8

A.147.1. Bug fixes

• Doc: Fix document typo and mistakes. (Bo Peng)

• Replace /bin/ed with /bin/sed in pgpool_setup, because /bin/sed is included in most distribution's base packages. (Tatsuo Ishii)

• Change the pgpool.service and sysconfig files to output Pgpool-II log. (Bo Peng)

  Removing "Type=forking" and add OPTS=" -n" to run Pgpool-II with non-daemon mode, because we need to redirect logs. Using "journalctl" command to see Pgpool-II systemd log.

• Add documentation "Compiling and installing documents" for SGML document build. (Tatsuo Ishii)

• Fix timestamp data inconsistency by replication mode. (Bo Peng)

  From PostgreSQL10 the column default value such as 'CURRENT_DATE' changes, Pgpool-II didn't rewrite timestamp by the added default values. This caused data inconsistency.

• Doc: Fix watchdog_setup doc. (Tatsuo Ishii)

  It lacked to mention that it supports logical replication mode.

• Downgrade a log message to debug message. (Tatsuo Ishii)

  That was mistaken left while last development cycle.

• Fix for re-sync logic in reading packet from backend. (Tatsuo Ishii)

  read_kind_from_backend(), which reads message kind from backend, re-syncs backend nodes when a ready for query message is received. Unfortunately it forgot to call pool_pending_message_pull_out() to delete sync pending message. This leads to random stuck while reading packets from backend. Fix this to call pool_pending_message_pull_out().

• Fix Pgpool-II hangs. (bug 370) (Tatsuo Ishii)

  If an erroneous query is sent to primary and without a sync message the next query that requires a catalog cache look up is send, Pgpool-II hangs in do_query().

• Add SL_MODE macro for upper compatibility with Pgpool-II 3.7 or later. (Tatsuo Ishii)

• Fix returning transaction state when "ready for query" message received. (Tatsuo Ishii)

  We return primary or master node state of ready for query message to frontend. In most cases this is good. However if other than primary node or master node returns an error state (this could happen if load balance node is other than primary or master node and the query is an erroneous SELECT), this should be returned to frontend, because the frontend already received an error.

• Fix pgpool start message printed multiple times. (Tatsuo Ishii)

• Add an execute permission bit to the start/stop script in watchdog_setup. (Tatsuo Ishii)