Commit98c4ebd

committed

Increase the statement_timeout value used in the prepared_xacts regression

test. We have seen some buildfarm failures that seem to be due to thislimit being unexpectedly exceeded when the machine is under load.

1 parentd7379b7 commit98c4ebdCopy full SHA for 98c4ebd

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -157,7 +157,7 @@ SELECT gid FROM pg_prepared_xacts;`
`157`	`157`	`(2 rows)`
`158`	`158`
`159`	`159`	`-- pxtest3 should be locked because of the pending DROP`
`160`		`-set statement_timeout to1000;`
	`160`	`+set statement_timeout to2000;`
`161`	`161`	`SELECT * FROM pxtest3;`
`162`	`162`	`ERROR: canceling statement due to statement timeout`
`163`	`163`	`reset statement_timeout;`
`@@ -172,7 +172,7 @@ SELECT gid FROM pg_prepared_xacts;`
`172`	`172`	`(2 rows)`
`173`	`173`
`174`	`174`	`-- pxtest3 should still be locked because of the pending DROP`
`175`		`-set statement_timeout to1000;`
	`175`	`+set statement_timeout to2000;`
`176`	`176`	`SELECT * FROM pxtest3;`
`177`	`177`	`ERROR: canceling statement due to statement timeout`
`178`	`178`	`reset statement_timeout;`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -102,7 +102,7 @@ SELECT * FROM pxtest2;`
`102`	`102`	`SELECT gidFROM pg_prepared_xacts;`
`103`	`103`
`104`	`104`	`-- pxtest3 should be locked because of the pending DROP`
`105`		`-set statement_timeout to1000;`
	`105`	`+set statement_timeout to2000;`
`106`	`106`	`SELECT*FROM pxtest3;`
`107`	`107`	`reset statement_timeout;`
`108`	`108`
`@@ -113,7 +113,7 @@ reset statement_timeout;`
`113`	`113`	`SELECT gidFROM pg_prepared_xacts;`
`114`	`114`
`115`	`115`	`-- pxtest3 should still be locked because of the pending DROP`
`116`		`-set statement_timeout to1000;`
	`116`	`+set statement_timeout to2000;`
`117`	`117`	`SELECT*FROM pxtest3;`
`118`	`118`	`reset statement_timeout;`
`119`	`119`

Comments

(0)