Fix twophase recovery log matching with verbose logs
Commit c11eb5de01b added checks for prepared transaction recovery
messages in 009_twophase.pl that assumed no SQLSTATE appeared after
the log severity. With log_error_verbosity=verbose, the SQLSTATE is
included, causing the positive checks to fail and preventing the
negative checks from detecting unwanted LOG messages.
Allow an optional SQLSTATE in all five checks.
Per buildfarm member prion, which uses log_error_verbosity = verbose.
Reported-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/2256937.1793317544@sss.pgh.pa.us
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/d242d82fc482706f95c71cd1d159950cd8e785c5
Modified Files
--------------
src/test/recovery/t/009_twophase.pl | 15 ++++++++++-----
1 file changed, 10 insertions(+), 5 deletions(-)