Обсуждение: What causes 'FATAL: invalid cache id: 30' in my postgresql log?

Hi everyone!

What is the cause of the following error message:

    FATAL:  invalid cache id: 30

and how do I fix it...?   8-)


Regards,
    Evert Meulie

Evert Meulie <evert@witelcom.com> writes:
> What is the cause of the following error message:
>     FATAL:  invalid cache id: 30

This indicates some sort of internal mismatch in the server.  I seem to
recall that one particular combination of server version and (different)
plpgsql.so version would happen to fail in this way.

            regards, tom lane

Strange... I'm using the Gentoo-version of PostgreSQL 7.4.6 and since
it's a fresh install of PostgreSQL, all components are of the same
version...

Regards,
    Evert



Tom Lane wrote:
> Evert Meulie <evert@witelcom.com> writes:
>
>>What is the cause of the following error message:
>>    FATAL:  invalid cache id: 30
>
>
> This indicates some sort of internal mismatch in the server.  I seem to
> recall that one particular combination of server version and (different)
> plpgsql.so version would happen to fail in this way.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>

Evert Meulie <evert@witelcom.com> writes:
> Strange... I'm using the Gentoo-version of PostgreSQL 7.4.6 and since
> it's a fresh install of PostgreSQL, all components are of the same
> version...

But are you sure there wasn't a previous version of PG already on the
machine?  It sure looks to me like you have some code that's out of step
about the syscache numbers, and as I said the most likely theory for
that is an out-of-date plpgsql.so getting picked up from someplace.

            regards, tom lane

I'm quite sure all of PostgreSQL got installed in 1 go when I ran a
'emerge postgresql'    8-)

Regards,
    Evert

Tom Lane wrote:

>Evert Meulie <evert@witelcom.com> writes:
>
>
>>Strange... I'm using the Gentoo-version of PostgreSQL 7.4.6 and since
>>it's a fresh install of PostgreSQL, all components are of the same
>>version...
>>
>>
>
>But are you sure there wasn't a previous version of PG already on the
>machine?  It sure looks to me like you have some code that's out of step
>about the syscache numbers, and as I said the most likely theory for
>that is an out-of-date plpgsql.so getting picked up from someplace.
>
>            regards, tom lane
>
>
>
>

Whether they are or not, could you please give me a syntax I can use to
update FROM multiple tables (>2)? I prefer to use a syntax that includes
'join'.


-RYAN


-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Monday, November 29, 2004 11:48 PM
To: Evert Meulie
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] What causes 'FATAL: invalid cache id: 30' in my
postgresql log?


Evert Meulie <evert@witelcom.com> writes:
> Strange... I'm using the Gentoo-version of PostgreSQL 7.4.6 and since
> it's a fresh install of PostgreSQL, all components are of the same
> version...

But are you sure there wasn't a previous version of PG already on the
machine?  It sure looks to me like you have some code that's out of step
about the syscache numbers, and as I said the most likely theory for that is
an out-of-date plpgsql.so getting picked up from someplace.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend