BUG #6041: Unlogged table was created bad in slave node

From:"Emanuel" <postgres(dot)arg(at)gmail(dot)com>
To:pgsql-bugs(at)postgresql(dot)org
Subject:BUG #6041: Unlogged table was created bad in slave node
Date:2011-05-26 11:37:29
Message-ID:[email protected]
Views:Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists:pgsql-bugs pgsql-hackers


The following bug has been logged online:

Bug reference: 6041
Logged by: Emanuel
Email address: postgres(dot)arg(at)gmail(dot)com
PostgreSQL version: 9.1 beta
Operating system: Ubuntu
Description: Unlogged table was created bad in slave node
Details:

MASTER=6666
SLAVE SYNC=6667
SLAVE ASYNC=6668

root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6666
psql (9.1beta1)
Type "help" for help.

postgres=# CREATE UNLOGGED TABLE voidy AS SELECT i, random() FROM
generate_series(1,1000) i(i);
SELECT 1000
postgres=# \q
root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6667
psql (9.1beta1)
Type "help" for help.

postgres=# \d voidy
Unlogged table "public.voidy"
Column | Type | Modifiers
--------+------------------+-----------
i | integer |
random | double precision |

postgres=# select * from voidy ;
ERROR: could not open file "base/12071/17034": No existe el archivo o
directorio
postgres=# \q
root(at)dell-desktop:/usr/local/pgsql# bin/psql -Upostgres -p6668
psql (9.1beta1)
Type "help" for help.

postgres=# \d voidy
Unlogged table "public.voidy"
Column | Type | Modifiers
--------+------------------+-----------
i | integer |
random | double precision |

postgres=# select * from voidy ;
ERROR: could not open file "base/12071/17034": No existe el archivo o
directorio

Responses

Browse pgsql-bugs by date

 FromDateSubject
Next MessageEuler Taveira de Oliveira2011-05-26 16:00:05Re: BUG #6041: Unlogged table was created bad in slave node
Previous MessageJordi Areny2011-05-26 07:43:31BUG #6040: ODBC 64 + SSL Hangs

Browse pgsql-hackers by date

 FromDateSubject
Next MessagePeter Geoghegan2011-05-26 11:58:33Re: Latch implementation that wakes on postmaster death on both win32 and Unix
Previous MessagePavan Deolasee2011-05-26 10:40:37Re: Proposal: Another attempt at vacuum improvements