Failure of subscription tests with topminnow
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-08-16T03:52:55Z
Lists: pgsql-hackers
Hi all, topminnow has just failed in a weird fashion: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=topminnow&dt=2021-08-15%2013%3A24%3A58 # SELECT pid != FROM pg_stat_replication WHERE application_name = 'tap_sub'; # expecting this output: # t # last actual query output: # # with stderr: # ERROR: syntax error at or near "FROM" # LINE 1: SELECT pid != FROM pg_stat_replication WHERE application_na... Looking at the logs, it seems like the problem boils down to an active slot when using ALTER SUBSCRIPTION tap_sub CONNECTION: 2021-08-15 18:44:38.027 CEST [16473:2] ERROR: could not start WAL streaming: ERROR: replication slot "tap_sub" is active for PID 16336 There is only one place in 001_rep_changes.pl where this is used. Thoughts? -- Michael
Commits
-
Fix the random test failure in 001_rep_changes.
- 8d0138ef51b5 15.0 landed
- b7ad093d50e1 14.0 landed
- 387093e43225 10.19 landed
- 56683e1684ef 11.14 landed
- df6ab94aca90 12.9 landed
- b51985d8a0e1 13.5 landed