Lists: | pgsql-general |
---|
From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
Date: | 2012-12-09 10:36:11 |
Message-ID: | ka1pi3$o4d$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database.
I am using the statement:
drop owned by wbjunit cascade;
at the end of a test suite to get rid of everything that was created during the tests.
Now since the upgrade to 9.2.2 it fails with the error message:
ERROR: unrecognized object class: 1262
I could easily drop and re-create the database, but I'm a) curious on how this situation could have happened and b) if there is a way to fix a problem like that with re-creating the database (in case this would have not been a unit test DB)
Is this a bug in 9.2.2 or did I do something wrong?
A "vacuumdb -f -v wbjunit" shows the following message:
INFO: vacuuming "pg_catalog.pg_depend"
INFO: "pg_depend": found 2 removable, 6219 nonremovable row versions in 47 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU 0.00s/0.01u sec elapsed 0.10 sec.
The "found 2 removable" part does not change, even if I re-run the statement several times.
My environment:
PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 32-bit
Windows XP SP2
Regards
Thomas
From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
Date: | 2012-12-09 14:14:30 |
Message-ID: | ka26al$m3s$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Thomas Kellerer wrote on 09.12.2012 11:36:
> I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application are failing when cleaning up my test database.
>
> I am using the statement:
>
> drop owned by wbjunit cascade;
>
> at the end of a test suite to get rid of everything that was created during the tests.
>
> Now since the upgrade to 9.2.2 it fails with the error message:
>
> ERROR: unrecognized object class: 1262
As this can be reproduced with a clean new installation I filed a bug report: #7748
Regards
Thomas
From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
Date: | 2012-12-09 22:41:22 |
Message-ID: | CAMkU=1ygGRoqYAsiUF2QhnmxoYsnNqB=GdzYMG5xPQvX+mAbGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Sun, Dec 9, 2012 at 2:36 AM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
> are failing when cleaning up my test database.
>
> I am using the statement:
>
> drop owned by wbjunit cascade;
>
> at the end of a test suite to get rid of everything that was created during
> the tests.
>
> Now since the upgrade to 9.2.2 it fails with the error message:
>
> ERROR: unrecognized object class: 1262
This was introduced into 9.2.2 by da24920ab8ea6b226321038
REASSIGN OWNED: consider grants on tablespaces, too
And presumably introduced into the latest releases of other versions
by the analogous commits into those branches.
Cheers,
Jeff
From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
Date: | 2012-12-10 07:02:45 |
Message-ID: | ka41dl$buk$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Jeff Janes, 09.12.2012 23:41:
> On Sun, Dec 9, 2012 at 2:36 AM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
>> I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
>> are failing when cleaning up my test database.
>>
>> I am using the statement:
>>
>> drop owned by wbjunit cascade;
>>
>> at the end of a test suite to get rid of everything that was created during
>> the tests.
>>
>> Now since the upgrade to 9.2.2 it fails with the error message:
>>
>> ERROR: unrecognized object class: 1262
>
>
> This was introduced into 9.2.2 by da24920ab8ea6b226321038
> REASSIGN OWNED: consider grants on tablespaces, too
>
> And presumably introduced into the latest releases of other versions
> by the analogous commits into those branches.
>
Thanks for the feedback.
Regards
Thomas
From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unrecognized object class: 1262 with 9.2.2 but not with 9.2.1 |
Date: | 2012-12-10 07:17:17 |
Message-ID: | ka428s$ibo$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Jeff Janes, 09.12.2012 23:41:
>> I recently upgraded from 9.2.1 to 9.2.2 and my unit tests for my application
>> are failing when cleaning up my test database.
>>
>> I am using the statement:
>>
>> drop owned by wbjunit cascade;
>>
>> at the end of a test suite to get rid of everything that was created during
>> the tests.
>>
>> Now since the upgrade to 9.2.2 it fails with the error message:
>>
>> ERROR: unrecognized object class: 1262
>
>
> This was introduced into 9.2.2 by da24920ab8ea6b226321038
> REASSIGN OWNED: consider grants on tablespaces, too
>
> And presumably introduced into the latest releases of other versions
> by the analogous commits into those branches.
>
Does anybody know if a 9.2.1 Windows (32bit and 64bit) ZIP distribution can still be downloaded somewhere?
I checked the Enterprise DB download page, but they only offer the current version.
I didn't keep a copy around as usually the minor updates go really smooth ;)
Regards
Thomas