[BUGS] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
Dear Folks; A very serious bug was reported on pg_lesslog. So far, I found it's a bug in pg_compresslog. Please do not use pg_compresslog and pg_decompresslog until improved version is uploaded. I strongly advise to take base backup of your database. I apologize for inconvenience. I'll upl

Re: [BUGS] BUG #5322: Time to perform vacuums

2010-02-11 Thread Robert Haas
On Thu, Feb 11, 2010 at 11:25 AM, Robert Haas wrote: > I can see VACUUM making VACUUM FULL faster.  I don't think VACUUM FULL > should make VACUUM FULL ANALYZE faster. Err, let me correct myself. A second VACUUM FULL should be faster than the first one. But the two together I wouldn't expect to

Re: [BUGS] BUG #5322: Time to perform vacuums

2010-02-11 Thread Robert Haas
On Wed, Feb 10, 2010 at 8:56 AM, Eric Pailleau wrote: > > The following bug has been logged online: > > Bug reference:      5322 > Logged by:          Eric Pailleau > Email address:      e...@numlog.fr > PostgreSQL version: 8.2.3 > Operating system:   linux debian > Description:        Time to per

Re: [BUGS] [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Joshua D. Drake
On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: > Dear Folks; > > A very serious bug was reported on pg_lesslog. So far, I found it's > a bug in pg_compresslog. Please do not use pg_compresslog and > pg_decompresslog until improved version is uploaded. > > I strongly advise to take ba

Re: [BUGS] [GENERAL] [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Karl Denninger
Joshua D. Drake wrote: > On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: > >> Dear Folks; >> >> A very serious bug was reported on pg_lesslog. So far, I found it's >> a bug in pg_compresslog. Please do not use pg_compresslog and >> pg_decompresslog until improved version is uploaded.

[BUGS] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
Dear Folks; A very serious bug was reported on pg_lesslog. So far, I found it's a bug in pg_compresslog. Please do not use pg_compresslog and pg_decompresslog until improved version is uploaded. I strongly advise to take base backup of your database. I apologize for inconvenience. I'll upl

Re: [BUGS] BUG #5314: Error in nested composite types in plpgsql.

2010-02-11 Thread Robert Haas
2010/2/10 Oleg Serov : > Somebody will fix this bug or not? I'm not sure whether this is a bug. This is an explicit cast: SELECT '(1,)'::bug_level_one; But I think this is an implicit cast: SELECT bug_procedure('(1,)'); I'm not totally sure of the details, but implicit, assignment, and explic

[BUGS] BUG #5323: plperl and plperlu interaction segfaults

2010-02-11 Thread Dave Olszewski
The following bug has been logged online: Bug reference: 5323 Logged by: Dave Olszewski Email address: cx...@pobox.com PostgreSQL version: 8.3.9 Operating system: Linux Description:plperl and plperlu interaction segfaults Details: Creating the following functions re

Re: [BUGS] BUG #5314: Error in nested composite types in plpgsql.

2010-02-11 Thread Tom Lane
Robert Haas writes: > 2010/2/10 Oleg Serov : >> Somebody will fix this bug or not? > I'm not sure whether this is a bug. Yeah, I think it is. The problem is that exec_move_row is taking too many shortcuts with nulls. If the input record is short of fields it is willing to pass this data to exe

Re: [BUGS] BUG #5323: plperl and plperlu interaction segfaults

2010-02-11 Thread Robert Haas
On Thu, Feb 11, 2010 at 1:44 PM, Dave Olszewski wrote: > > The following bug has been logged online: > > Bug reference:      5323 > Logged by:          Dave Olszewski > Email address:      cx...@pobox.com > PostgreSQL version: 8.3.9 > Operating system:   Linux > Description:        plperl and plpe

Re: [BUGS] BUG #5323: plperl and plperlu interaction segfaults

2010-02-11 Thread Alexey Klyukin
On Feb 11, 2010, at 10:02 PM, Robert Haas wrote: > On Thu, Feb 11, 2010 at 1:44 PM, Dave Olszewski wrote: >> >> The following bug has been logged online: >> >> Bug reference: 5323 >> Logged by: Dave Olszewski >> Email address: cx...@pobox.com >> PostgreSQL version: 8.3.9 >>

Re: [BUGS] BUG #5322: Time to perform vacuums

2010-02-11 Thread Eric Pailleau
Robert Haas a écrit : On Thu, Feb 11, 2010 at 11:25 AM, Robert Haas wrote: I can see VACUUM making VACUUM FULL faster. I don't think VACUUM FULL should make VACUUM FULL ANALYZE faster. Err, let me correct myself. A second VACUUM FULL should be faster than the first one. But the two togethe

Re: [BUGS] [GENERAL] [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
Thank you very much for the advice. Yes I think it should go to announce. I will post a message. -- Koichi Suzuki 2010/2/12 Karl Denninger : > Joshua D. Drake wrote: > > On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: > > > Dear Folks; > > A very serious bug was reported on p

Re: [BUGS] [GENERAL] [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Koichi Suzuki
In addition, in the fix, I'm thinking I should add at least the following check mechanism; 1. Check XNOOP record size to match the original WAL record. 2. Restore WAL segment at the time of pg_compress, compare restored WAL with the original and check it is safe to use in the restoration, both eac

Re: [BUGS] BUG #5323: plperl and plperlu interaction segfaults

2010-02-11 Thread Robert Haas
On Thu, Feb 11, 2010 at 3:12 PM, Alexey Klyukin wrote: >> I think this might be the same problem previously discussed here: >> http://archives.postgresql.org/pgsql-bugs/2010-01/msg00224.php > > Seems to be the same problem. Backtrace I'm getting on 8.4 is almost > identical to the one at the end

Re: [BUGS] BUG #5323: plperl and plperlu interaction segfaults

2010-02-11 Thread Robert Haas
On Thu, Feb 11, 2010 at 10:47 PM, Robert Haas wrote: > On Thu, Feb 11, 2010 at 3:12 PM, Alexey Klyukin > wrote: >>> I think this might be the same problem previously discussed here: >>> http://archives.postgresql.org/pgsql-bugs/2010-01/msg00224.php >> >> Seems to be the same problem. Backtrace I

[BUGS] BUG #5324: Server not starting

2010-02-11 Thread sourabh bansal
The following bug has been logged online: Bug reference: 5324 Logged by: sourabh bansal Email address: sourabh.k.ban...@gmail.com PostgreSQL version: 8.4 Operating system: windows XP SP2 Description:Server not starting Details: While Starting Server the Error messag