|
231 | 231 | $sect ="startup deadlock"; |
232 | 232 | $expected_conflicts++; |
233 | 233 |
|
234 | | -# Want to test recovery deadlock conflicts, not buffer pin conflicts. Without |
235 | | -# changing max_standby_streaming_delay it'd be timing dependent what we hit |
236 | | -# first |
237 | | -$node_standby->adjust_conf('postgresql.conf','max_standby_streaming_delay', |
238 | | -"${PostgreSQL::Test::Utils::timeout_default}s"); |
239 | | -$node_standby->restart(); |
240 | | -reconnect_and_clear(); |
241 | | - |
242 | 234 | # Generate a few dead rows, to later be cleaned up by vacuum. Then acquire a |
243 | 235 | # lock on another relation in a prepared xact, so it's held continuously by |
244 | 236 | # the startup process. The standby psql will block acquiring that lock while |
|
294 | 286 |
|
295 | 287 | # clean up for next tests |
296 | 288 | $node_primary->safe_psql($test_db,qq[ROLLBACK PREPARED 'lock';]); |
297 | | -$node_standby->adjust_conf('postgresql.conf','max_standby_streaming_delay','50ms'); |
298 | | -$node_standby->restart(); |
299 | | -reconnect_and_clear(); |
300 | 289 |
|
301 | 290 |
|
302 | 291 | # Check that expected number of conflicts show in pg_stat_database. Needs to |
|