Skip site navigation (1) Skip section navigation (2)

Re: CLUSTER bug

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Darren Steven <dsteven(at)nettas(dot)telstra(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: CLUSTER bug
Date: 2000-05-11 01:01:25
Message-ID: 200005110101.VAA25569@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
We have gotten sporatic reports of problems with CLUSTER.  Perhaps this
will prompt someone to find the problem and FIX IT FOR 7.0.1.  :-)


> Sorry for a downer on an excellent piece of software.
> 
> --
> Darren Steven
> Applications Specialist
> Networking Tasmania
> Telstra Australia
> Ph.1800 813 302
> 
> 

> If PostgreSQL failed to compile on your computer or you found a bug that
> is likely to be specific to one platform then please fill out this form
> and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)
> 
> To report any other bug, fill out the form below and e-mail it to
> pgsql-bugs(at)postgresql(dot)org(dot)
> 
> If you not only found the problem but solved it and generated a patch
> then e-mail it to pgsql-patches(at)postgresql(dot)org instead.  Please use the
> command "diff -c" to generate the patch.
> 
> You may also enter a bug report at http://www.postgresql.org/ instead of
> e-mail-ing this form.
> 
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
> 
> 
> Your name		:	Darren Steven
> Your email address	:	dsteven(at)nettas(dot)telstra(dot)com(dot)au
> 
> 
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)  	: Intel PIII
> 
>   Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.2.14
> 
>   PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-7.0
> 
>   Compiler used (example:  gcc 2.8.0)		: egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> 
> 
> Please enter a FULL description of your problem:
> ------------------------------------------------
> 
> CLUSTER fails and appears to corrupt database. I don't know if this happened on other releases, found it by mistake while playing with 7.0
> 
> PS Great DB by the way.
> 
> 
> 
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible: 
> ----------------------------------------------------------------------
> 
> Create a database, create a table. insert some data. create index on one of fields. CLUSTER indexname ON tablename;
> 
> With a large number of rows (so I can see it happeneing), I see the table being copied to a temp, and the renamed back to its original name. the problem is with the index :
> 
> dws=# create index testind on accesslog (alclient);
> CREATE
> dws=# cluster testind on accesslog;
> ERROR:  temp_674e00 is an index relation 
> 
> 
> temp_674e00 appears to be a copy of the index file.
> 
> psql now tells me the relation accesslog no longer exists
> 
> the same error also occurs on small tables.
> 
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
> 
> Sorry. I've looked at cluster.c and if I fix it I'll post it.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-05-11 01:10:40
Subject: Re: CLUSTER bug
Previous:From: Darren StevenDate: 2000-05-11 00:51:47
Subject: CLUSTER bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group