Re: [BUGS] BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL

2013-08-02 Thread Daniel Farina
On Fri, Aug 2, 2013 at 12:51 AM, Klaus Ita wrote: > Isn't it a funny coincidence, that we also had a corruption of that > same/similar type? > > my disk was quite confidently not tampered. I am wondering: Does PG sign, or > checksum wal_files? Is the integrity of wal_files ensured by any mechanism

Re: [BUGS] BUG #8058: CLUSTER and VACUUM FULL fail to free space

2013-04-12 Thread Daniel Farina
On Fri, Apr 12, 2013 at 7:41 AM, Tom Lane wrote: > dan...@heroku.com writes: >> We have a somewhat high-churn table acting as a queue, and over time it's >> grown to be something like a gigabyte. I surmised it might be vanilla >> bloat, but the truth seems somewhat more exotic because both VACUUM

Re: [BUGS] BUG #8058: CLUSTER and VACUUM FULL fail to free space

2013-04-12 Thread Daniel Farina
On Fri, Apr 12, 2013 at 10:46 AM, Daniel Farina wrote: > On Fri, Apr 12, 2013 at 7:07 AM, Andres Freund wrote: >> On 2013-04-12 08:34:24 +, dan...@heroku.com wrote: >>> The following bug has been logged on the website: >>> >>> Bug reference: 8058 &

Re: [BUGS] BUG #8058: CLUSTER and VACUUM FULL fail to free space

2013-04-12 Thread Daniel Farina
On Fri, Apr 12, 2013 at 7:07 AM, Andres Freund wrote: > On 2013-04-12 08:34:24 +, dan...@heroku.com wrote: >> The following bug has been logged on the website: >> >> Bug reference: 8058 >> Logged by: Daniel Farina >> Email address: dan...

Re: [BUGS] BUG #8013: Memory leak

2013-03-31 Thread Daniel Farina
On Sat, Mar 30, 2013 at 8:41 PM, ajmcello wrote: > unsubscribe That's not how you unsubscribe from this list; you'll want to do that here: http://www.postgresql.org/community/lists/subscribe/ -- fdr -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subs

Re: [BUGS] Questions about PostgreSQL Setup License

2013-03-14 Thread Daniel Farina
On Thu, Mar 14, 2013 at 9:42 AM, DUBILLOT Aurelien wrote: > I read on your website that PostgreSQL source code is free for use and > modification, but in my case I am working on a project where we are > generating our own setup and we would like to integrate PostgreSQL setup > within it. This isn

Re: [BUGS] BUG #7883: "PANIC: WAL contains references to invalid pages" on replica recovery

2013-02-15 Thread Daniel Farina
On Fri, Feb 15, 2013 at 3:18 PM, Maciek Sakrejda wrote: > On Fri, Feb 15, 2013 at 3:15 PM, Daniel Farina wrote: > >> Can you try master on xlogdump instead of the release? I have fixed a few >> bugs there a year ago that don't seem to be in the release, and will f

Re: [BUGS] BUG #7883: "PANIC: WAL contains references to invalid pages" on replica recovery

2013-02-15 Thread Daniel Farina
On Fri, Feb 15, 2013 at 10:57 AM, Maciek Sakrejda wrote: > On Fri, Feb 15, 2013 at 7:10 AM, Heikki Linnakangas < > hlinnakan...@vmware.com> wrote: > >> Hmm, that sure looks like the same issue Kyotaro HORIGUCHI reported ( >> http://www.postgresql.org/message-id/20121206.130458.170549097.horiguchi

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Daniel Farina
On Tue, Jan 22, 2013 at 10:26 AM, Tom Lane wrote: > Heikki Linnakangas writes: >> On 22.01.2013 15:31, jan-peter.seif...@gmx.de wrote: >> Try: >> CREATE EXTENSION "uuid-ossp" > > Although this isn't a bug, it does seem like a usability fail. > Did we make a conscious decision not to call the exte

Re: [BUGS] BUG #7648: Momentary index corruption while in hot standby

2012-11-09 Thread Daniel Farina
On Fri, Nov 9, 2012 at 4:16 PM, Andres Freund wrote: > On 2012-11-09 15:57:06 -0800, Daniel Farina wrote: >> This is the only known occurrence to me, ever, but given it's >> incredibly ephemeral nature probably glossed over most of the time, I >> can't say "i

Re: [BUGS] BUG #7648: Momentary index corruption while in hot standby

2012-11-09 Thread Daniel Farina
On Fri, Nov 9, 2012 at 3:35 PM, Jeff Davis wrote: > On Fri, 2012-11-09 at 22:49 +, dan...@heroku.com wrote: >> PGError: ERROR: could not read block 556642 in file "base/16385/2904143.4": >> read only 0 of 8192 > > Does that seem wildly off to you, or a little off? Do you think that > block may

Re: [BUGS] BUG #7498: Questionable interval parsing when in the form 'n m days'

2012-08-15 Thread Daniel Farina
On Wed, Aug 15, 2012 at 5:19 PM, Tom Lane wrote: > dan...@heroku.com writes: >> select '1 5 hours'::interval = '1 day 5 hours'::interval; >> ?column? >> -- >> t >> (1 row) > >> I think that the first spelling, a unit-less '1', should not be accepted. > > Not sure I agree. The syntax '1

Re: [BUGS] BUG #7486: Error Group by

2012-08-11 Thread Daniel Farina
On Fri, Aug 10, 2012 at 10:33 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7486 > Logged by: Anderson Abreu > Email address: andersonab...@gmail.com > PostgreSQL version: 8.4.12 > Operating system: Linux > Description: > > Dear, > > I'm te

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-10 Thread Daniel Farina
On Tue, Jul 10, 2012 at 2:43 PM, Bruce Momjian wrote: > On Tue, Jul 10, 2012 at 01:03:18PM -0700, Maciek Sakrejda wrote: >> So, is there hope of a better fix here for 9.2 (specifically for >> preserving extension ownership on pg_upgrade and dump/restore, though >> I understand it may not make sens

Re: [BUGS] How to run query by command prompt in Postgres

2012-06-28 Thread Daniel Farina
On Jun 28, 2012 7:44 AM, "Kapil Kr. Khandelwal" wrote: > > Dear Team > > > When I restarted the postgres9.0 service by windows then getting following error message. Plz help me. > > Error Message(Error 1053) : The service did not respond start or control requested in timely fashion. > > Please s

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
On Sun, Nov 13, 2011 at 3:27 PM, Tom Lane wrote: > "Daniel Farina" writes: >> We have on hand a database that makes heavy use of the txid_snapshot family >> of functions, and recently it just passed its 4^32 transaction mark. >> Unfortunately, upon wraparound th

[BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
The following bug has been logged online: Bug reference: 6291 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.5 Operating system: Ubuntu 10.04 Description:Xid epoch is not updated properly Details: We have on hand a database that

[BUGS] BUG #6200: standby bad memory allocations on SELECT

2011-09-08 Thread Daniel Farina
The following bug has been logged online: Bug reference: 6200 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.4 Operating system: Ubuntu 10.04 Description:standby bad memory allocations on SELECT Details: A huge thanks to Conrad

Re: [BUGS] BUG #6170: hot standby wedging on full-WAL disk

2011-08-25 Thread Daniel Farina
On Thu, Aug 25, 2011 at 10:16 AM, Heikki Linnakangas wrote: > On 25.08.2011 19:11, Robert Haas wrote: >> >> On Mon, Aug 22, 2011 at 2:57 AM, Heikki Linnakangas >>  wrote: >>> >>> So the problem is that walreceiver merrily writes so much future WAL that >>> it >>> runs out of disk space? A limit o

[BUGS] BUG #6170: hot standby wedging on full-WAL disk

2011-08-19 Thread Daniel Farina
The following bug has been logged online: Bug reference: 6170 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.4 Operating system: GNU/Linux Ubuntu 10.04 x86_64 Description:hot standby wedging on full-WAL disk Details: After seeing

Re: [BUGS] Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid

2011-02-22 Thread Daniel Farina
On Tue, Feb 22, 2011 at 8:54 AM, Tom Lane wrote: > Daniel Farina writes: >> From what I can tell, people only see this problem with pg_dump, which >> is interesting. This symptom has a very long history: > > Yeah.  There seems to be some well-hidden bug whereby dropping

[BUGS] Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid

2011-02-22 Thread Daniel Farina
On Mon, Feb 21, 2011 at 10:46 PM, Daniel Farina wrote: > It may also be useful information to know that no recent shenanigans > have happened on this server: it's been up continuously for about 500 > days. That doesn't mean something interesting did not occur a very >

[BUGS] Re: 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid

2011-02-21 Thread Daniel Farina
On Mon, Feb 21, 2011 at 10:43 PM, Daniel Farina wrote: > A medium-length story short, this query returns non-zero: > > select count(distinct typnamespace) from pg_type where  not exists > (select 1 from pg_namespace where oid = pg_type.typnamespace); > > I did a very brief

[BUGS] 8.3.5: Types with typnamespace pointing at non-existent pg_namespace oid

2011-02-21 Thread Daniel Farina
A medium-length story short, this query returns non-zero: select count(distinct typnamespace) from pg_type where not exists (select 1 from pg_namespace where oid = pg_type.typnamespace); I did a very brief search in all the release notes for 8.3.5 to 8.3.14, but have not found precisely what I w