Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> I happened to be updating our machine running our buildfarm animals, and
> I noticed something quite strange - the machine was unexpectedly running
> out of disk space, which is rather suspicious as it's running just the
> regression tests :-/
> After a bit of investigation, I found this:
> Right - the plpgsql_control.out output has about 58GB, which is somewhat
> excessive I guess. The reason is fairly simple:
> NOTICE: 2147483620..2147483647 by 10: i = 2147483620
> NOTICE: 2147483620..2147483647 by 10: i = 2147483630
> NOTICE: 2147483620..2147483647 by 10: i = 2147483640
> NOTICE: 2147483620..2147483647 by 10: i = -2147483646
> NOTICE: 2147483620..2147483647 by 10: i = -2147483636
> NOTICE: 2147483620..2147483647 by 10: i = -2147483626
> ... many more NOTICE messages ...
> Looking at the plpgsql_call.out timestamp, this seems to be running
> since January 1, which also correlates with the last results reported to
> pgbuildfarm.
Ouch. That test is in fact new as of 31 Dec, and what this seems to
prove is that plpgsql's handling of loop-variable overflow doesn't
work on fulmar.
regards, tom lane