Обсуждение: Re: [GENERAL] Zombie index?

>I'm having a problem with an index on a Postgres database.
>
>I created an index as follows:
>
>    create index table1_column1 on table1 using hash (column1);
>
>(column1 is a varchar(70))
>
>I discovered that I couldn't actually use this index for anything; any
>query which uses column1 in the where clause comes up with:
>
>   ERROR:  hash table out of memory. Use -B parameter to increase buffers.
>
>I then dropped it:
>
>    drop index table1_column1;
>
>Now, I can't create an index with that name:
>
>   ERROR:  cannot create table1_column1
>
>In fact, the index doesn't seem to be *really* gone.  Any query which
>uses column1 still gives that error message.  Whuzzup?
>


i've had a similar problem -- apparently postgres thought the index no
longer existed, but the index file still existed on the HD.  i don't know if
this is the correct thing to do or not, but i just went in and deleted the
index file, and things worked fine (for me at least, ymmv)  the index file
should be located in $PGDATA/base/{db_name}/{index_name}

I'm getting the following when I do a: make all > & make.log &

Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine

===========================================================================
gcc -I../../../include -I../../../backend   -O2  -Wall -Wmissing-prototypes
-fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
ld: cannot open ecpglib.sho: No such file or directory
make[3]: *** [libecpg.so.2.6.2] Error 1
make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
make: *** [all] Error 2
============================================================================

Did I miss something?

Andy

A few things...

First, this shouldn't be discussed on this mailing list

Second, see First.

this is not a general question, this is a specific one...since it is an
unreleased version of PostgreSQL, the *only* list that it should be
discussed on is pgsql-hackers@postgresql.org...

I also believe that it has been discussed, and corrected, since, on that
same mailing list...


On Thu, 15 Oct 1998, Andy Lewis wrote:

> I'm getting the following when I do a: make all > & make.log &
>
> Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine
>
> ===========================================================================
> gcc -I../../../include -I../../../backend   -O2  -Wall -Wmissing-prototypes
> -fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
> ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
> ld: cannot open ecpglib.sho: No such file or directory
> make[3]: *** [libecpg.so.2.6.2] Error 1
> make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
> make[2]: *** [all] Error 2
> make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
> make: *** [all] Error 2
> ============================================================================
>
> Did I miss something?
>
> Andy
>
>

Marc G. Fournier                               scrappy@hub.org
Systems Administrator @ hub.org
scrappy@{postgresql|isc}.org                       ICQ#7615664

Hello Andy,

giovedì, 15 ottobre 98, you wrote:

AL> I'm getting the following when I do a: make all > & make.log &

AL> Postgres v6.4-BETA2 on a Linux 2.0.34 Intel machine

AL> ===========================================================================
AL> gcc -I../../../include -I../../../backend   -O2  -Wall -Wmissing-prototypes
AL> -fpic -I../include -I../../../interfaces/libpq -c typename.c -o typename.sho.o
AL> ld -shared -soname libecpg.so.2 -o libecpg.so.2.6.2 ecpglib.sho typename.sho.o
AL> ld: cannot open ecpglib.sho: No such file or directory
AL> make[3]: *** [libecpg.so.2.6.2] Error 1
AL> make[3]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg/lib'
AL> make[2]: *** [all] Error 2
AL> make[2]: Leaving directory `/usr/src/pgsql/src/interfaces/ecpg'
AL> make[1]: *** [all] Error 2
AL> make[1]: Leaving directory `/usr/src/pgsql/src/interfaces'
AL> make: *** [all] Error 2
AL> ============================================================================

AL> Did I miss something?

AL> Andy


 edit file: /home/postgres/pgsql/src/interfaces/ecpg/lib/Makefile
 change ecpglib.sho to ecpglib.sho.o
 and then re-compile.


 Jose'