On Thu, May 24, 2012 at 2:19 PM, Magnus Hagander <mag...@hagander.net> wrote:
> On Thu, May 24, 2012 at 2:16 PM, Peter Geoghegan <pe...@2ndquadrant.com>
> wrote:
>> On 24 May 2012 12:42, Magnus Hagander <mag...@hagander.net> wrote:
>>> What actually happens if it tries to repalloc() something huge? palloc
>>> will throw an elog(ERROR), and since this happens during postmaster
>>> startup, are you sure it won't prevent the server from starting?
>>
>> Oh, yes, missed that.
>>
>> /* Previous incarnation might have had a larger query_size */
>> if (temp.query_len >= buffer_size)
>> {
>> buffer = (char *) repalloc(buffer, temp.query_len +
>> 1);
>> buffer_size = temp.query_len + 1;
>> }
>>
>> Here, "temp" receives its value from an fread().
>>
>> This could probably be coded to be defensive against such things, but
>> a better fix would be preferred. I have to wonder how much of a
>> problem corruption is likely to be though, given that we only save to
>> disk in a corresponding pgss_shmem_shutdown() call, which actually has
>> more protections against corruption. The window for the saved file to
>> be corrupt seems rather small, though I accept that a better window
>> would be zero.
>
> Right. But writing to a temp file and rename()ing it into place is trivial.
>
> It's really the other issues raised that are bigger ;)Here's a patch that does the two easy fixes: 1) writes the file to a temp file and rename()s it over the main file as it writes down. This removes the (small) risk of corruption because of a crash during write 2) unlinks the file after reading it. this makes sure it's not included in online backups. I still think we should consider the placement of this file to not be in the global/ directory, but this is a quick (back-patchable) fix... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
pg_stat_statements_file.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
