Hello All,
Getting *ERROR: XX001: could not read block 17 of relation
base/16386/2619: read only 0 of 8192 bytes*, While vacuuming database
Manual vacuuming and Auto vacuuming process *constantly* taking high
CPU, not able to skip corrupted table for vacuuming and dump this
message
Siddharth Shah siddharth.s...@elitecore.com wrote:
* fsync is off*
If you are running the database with fsync off and there is any sort
of unusual termination, your database will probably be corrupted. I
recommend restoring from your last good backup. If you don't have
one, recovery is
Thanks Kevin.
Yes, I installed 8.4.3 then I have found that DDL and DML statements
were getting failed to execute in some distributions
So that's why taken call for reindexing
What can be the method to verify that it's a database corruption ?
xdb=# \dt;
ERROR: index
[rearranged to put the most critical point first]
Siddharth Shah siddharth.s...@elitecore.com wrote:
I don't have any backup available, Is there any way to fix this ?
I *strongly* recommend that you shut down the database and take a
file copy of the whole data tree (everything under what -D
hi,
i am a student , and for my final project i have to work with postgresql ;
my project subject is data warehousing data mining, so i need to define
cube; create dimention table fact table ...
i had active cube in template1; i mean i run cube.sql and there are cube
functions in my databases
Kevin Grittner wrote:
[rearranged to put the most critical point first]
Siddharth Shah siddharth.s...@elitecore.com wrote:
I don't have any backup available, Is there any way to fix this ?
I *strongly* recommend that you shut down the database and take a
file copy of the whole
One more point, This is observed two times while product firmware
updates which updates Postgres 8.4.3 from 8.4.1
Abruptly shutdown never leads to this type of corruption while fsync is
always off
Thanks,
Siddharth
Siddharth Shah wrote:
Kevin Grittner wrote:
[rearranged to put the most
Silvio Brandani wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer:
gfp_mask=0x201d2, order=0, oomkilladj=0
May 6 22:31:01 pgblade02 kernel:
May 6 22:31:01 pgblade02 kernel: Call Trace:
May
Siddharth Shah siddharth.s...@elitecore.com wrote:
xdb=# reindex index pg_class_relname_nsp_index;
Now INDEXing taking High CPU and postgres baffled.
consider doing your recovery in single-user mode
postgres --single -P -D $DATADIR -p 5433 xdb
Same behavior in single mode.
On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani silvio.brand...@tech.sdb.it
wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer:
gfp_mask=0x201d2, order=0, oomkilladj=0
*** snip ***
May
Lacey Powers ha scritto:
Silvio Brandani wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer:
gfp_mask=0x201d2, order=0, oomkilladj=0
May 6 22:31:01 pgblade02 kernel:
May 6 22:31:01
Kevin Grittner wrote:
Siddharth Shah siddharth.s...@elitecore.com wrote:
xdb=# reindex index pg_class_relname_nsp_index;
Now INDEXing taking High CPU and postgres baffled.
consider doing your recovery in single-user mode
postgres --single -P -D $DATADIR -p
Greg Spiegelberg ha scritto:
On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani
silvio.brand...@tech.sdb.it mailto:silvio.brand...@tech.sdb.it wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked
Silvio Brandani ha scritto:
Lacey Powers ha scritto:
Silvio Brandani wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer:
gfp_mask=0x201d2, order=0, oomkilladj=0
May 6 22:31:01 pgblade02
Silvio Brandani ha scritto:
Greg Spiegelberg ha scritto:
On Fri, May 7, 2010 at 8:26 AM, Silvio Brandani
silvio.brand...@tech.sdb.it mailto:silvio.brand...@tech.sdb.it
wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01
Siddharth Shah siddharth.s...@elitecore.com writes:
PID PPID USER STAT VSZ %MEM %CPU COMMAND
13419 13418 nobody R39172 8% 99% postgres --single -P -D
/var/db -p 5433 xdb
It's been running from 10 minutes still there is no output or logs.
What does strace show that process
Silvio Brandani wrote:
Lacey Powers ha scritto:
Silvio Brandani wrote:
We have a postgres 8.3.8 on linux
We get following messages int /var/log/messages:
May 6 22:31:01 pgblade02 kernel: postgres invoked oom-killer:
gfp_mask=0x201d2, order=0, oomkilladj=0
May 6 22:31:01 pgblade02 kernel:
raha sadeghi raha.sade...@gmail.com wrote:
i had active cube in template1; i mean i run cube.sql and there
are cube functions in my databases but i don't know how to create
cube!!!
please help me and explain me how to do these kind of things step
by step!!
Before anyone can make useful
18 matches
Mail list logo