t see any solution and if you can't see any solution either, i'm
going to reinit the db
:)
fous
2009/9/17 Tom Lane :
> fous velkej writes:
>> ok, so i did reindexing ending with following error
>> proxylog=# REINDEX TABLE user_record ;
>> ERROR: concurrent insert
HINT: Please REINDEX it.
ok, so i did reindexing ending with following error
proxylog=# REINDEX TABLE user_record ;
ERROR: concurrent insert in progress
what should i do now?
i think it's not the problem of hw
thanks for help
fous
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgre
e header in block 502758 of relation base/16388/16403
am i doing anything wrong?
regards, fous
>
> Right, so it would be in the .3 file at block number 109542.
>
> regression=# select 502758 / 131072;
> ?column?
> --
> 3
> (1 row)
>
>
i forgot the system informations
postgresql-server-8.4.0-1PGDG.rhel5
linux kernel 2.6.18-128.4.1.el5xen x86_64
centos release 5.3 (final)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
with similar name in
the base/16388 directory.
16403 (1Gb)
16403.1 (1Gb)
16403.2 (1Gb)
16403.3 (almost 1 Gb)
so the question is, where can i find the right 502758 position (i
assume that this is the number of 8k block position).
each file with size 1Gb has 131072 of 8k blocks.
thanx for help
well, i knew how to fix it (probably the reindexing, that you mentioned;))
but i think this happens often in our database, so what informations would
you like to know?
i'm awaiting orders :)
fous
> Nope.
>
> If you just want to fix it, reindexing that index should do the trick.
&
The following bug has been logged online:
Bug reference: 4948
Logged by: fous
Email address: honza...@gmail.com
PostgreSQL version: 8.4.0
Operating system: Linux (CentOS release 5.3)
Description:getting error while vacuuming the database
Details:
hi
i'm ge
The following bug has been logged online:
Bug reference: 4943
Logged by: fous
Email address: honza...@gmail.com
PostgreSQL version: 8.4.0
Operating system: Linux (CentOS release 5.3)
Description:getting error while vacuuming the database
Details:
hi
i'm ge
