-hackers removed.
On Tue, Sep 17, 2002 at 10:11:41AM +0200, Wim wrote:
> ERROR: AllocSetFree: cannot find block containing chunk 4c5ad0
This is definitely some sort of disk problem. Either you've written
bad data to the disk in some way, or else the disk is corrupted or
damaged.
If it is a h
On Mon, Sep 16, 2002 at 05:27:38PM -0400, Tom Lane wrote:
> FYI, sendmail has the same restart failure mode; I imagine a lot of
> other Unix daemons do too.
Yes, as far as I know atd, klogd, and ypbind also fail this way, at
least on some flavours of Linux (where I've had it happen). And ISTR
t
On Tue, Sep 17, 2002 at 04:25:45PM +0200, Wim wrote:
> >
> >>ERROR: AllocSetFree: cannot find block containing chunk 4c5ad0
> >>
> >>
> >
> >This is definitely some sort of disk problem. Either you've written
> >bad data to the disk in some way, or else the disk is corrupted or
> >damaged.
>
Nigel J. Andrews wrote:
>On Tue, 17 Sep 2002, Wim wrote:
>
>
>>>The next simple but dumb test, which I don't know if you have already tried, is
>>>to check that you can SELECT * FROM pg_* without error.
>>>
>>>
>>>
>>"SELECT * FROM pg_*" gives:
>>ERROR: Relation "pg_" does not exist
>>
Andrew Sullivan wrote:
...
>>>How did you check?
>>>
>>>
>>>
>>>
>>with fsck.
>>
>>
>
>That won't help you if the controller is coming and going; you might
>find that it works one time, and not another. Indeed, a disk on its
>way out can even pass fsck sometimes, although it's pret
On Tue, Sep 17, 2002 at 04:46:00PM +0200, Wim wrote:
> >
> >That won't help you if the controller is coming and going; you might
> >find that it works one time, and not another. Indeed, a disk on its
> >way out can even pass fsck sometimes, although it's pretty unusual.
> >
> The DB is located on
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Tue, Sep 17, 2002 at 04:25:45PM +0200, Wim wrote:
>> ERROR: AllocSetFree: cannot find block containing chunk 4c5ad0
>>
>> Postgres is running on solaris 8...
> Someone else suggested that this would not be the error when you have
> written bad da
Andrew Sullivan wrote:
>On Tue, Sep 17, 2002 at 04:46:00PM +0200, Wim wrote:
>
>
>>>That won't help you if the controller is coming and going; you might
>>>find that it works one time, and not another. Indeed, a disk on its
>>>way out can even pass fsck sometimes, although it's pretty unusua
On Tue, Sep 17, 2002 at 10:55:18AM -0400, Tom Lane wrote:
>
> I am wondering if Wim is running into that same Solaris snprintf() bug
> that we discovered awhile back --- it was not clear if the bug still
> exists in Solaris 8, but the symptoms sure match. See
> http://archives.postgresql.org/pgs
Tom Lane wrote:
>Andrew Sullivan <[EMAIL PROTECTED]> writes:
>
>
>>On Tue, Sep 17, 2002 at 04:25:45PM +0200, Wim wrote:
>>
>>
>>>ERROR: AllocSetFree: cannot find block containing chunk 4c5ad0
>>>
>>>Postgres is running on solaris 8...
>>>
>>>
>
>
>
>>Someone else suggested that t
Wim <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> It would be useful to see a stack traceback from the point of the error,
>> if possible.
> I Would like to send a stack traceback, but I need some halp on this
> (never done this before).
> some add. info:
> SELECT relname FROM pg_class WHER
On Tue, Sep 17, 2002 at 05:04:23PM +0200, Wim wrote:
>
> SELECT relname FROM pg_class WHERE relname like 'pg_%' AND relkind = 'r';
> gives:
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
On Tue, Sep 17, 2002 at 11:08:46AM -0400, Tom Lane wrote:
> This should be producing a core file in your database directory
> ($PGDATA/base/yourdboid/). With gdb you'd do
> gdb /path/to/postgres-executable /path/to/corefile
> gdb> bt
> gdb> quit
> I don't remember the equivalen
Thanks a lot! But I do not think this is so meaningful to
show
at my company:
The bosses need sheets.
"osdb""Invoked: bin/osdb-pg --logfile
leo.log"
create_tables() 0.34 seconds return value =
0
load() 11.52 seconds return value = 0
cre
Hi
everyone!
I have searched the net looking for other postgreSQL
benchmark
than the one
offered by OSDB, and couldn'd find anything.
Is there other on the net?
.. A Question... Since before your sun burned hot in space and before your rac
Someone needs to check out
http://www.osdl.org/projects/performance/osdldbt.html the OSDL
benchmarking tool for DBs and get Postgres to work with it and then run
it and publish results or at a mininum use it to help tune performance for
Postgres.
-Derek
Elielson Fontanezi said:
> Hi everyone!
>
On Tue, Sep 17, 2002 at 11:53:05AM -0700, Derek Neighbors wrote:
> Someone needs to check out
> http://www.osdl.org/projects/performance/osdldbt.html the OSDL
> benchmarking tool for DBs and get Postgres to work with it and then run
> it and publish results or at a mininum use it to help tune per
Hi,
I tried to restore a pg database with pg_restore -d but the operation
was running on error:
ERROR: Relation "..." does not exist
The database was dumped with pg_dump -Ft
As I know I can restore the database successful with psql>\i
But I don't know the parameter for dumping to create an asc
Newbie here...
How do I restore data changes made after the backup? I've been combing the
docs and the web site but I don't see anything on this. Given a backup taken
this morning, and a failure requiring a database restore, how do I restroe
the data that was added after the backup was taken this
Orr, Steve wrote:
> Newbie here...
>
> How do I restore data changes made after the backup? I've been combing the
> docs and the web site but I don't see anything on this. Given a backup taken
> this morning, and a failure requiring a database restore, how do I restroe
> the data that was added a
THANKS! for the quick answer.
Yes I want point in time recovery and I can wait 6 months. $64K question...
Will it be delivered on schedule? ;-)
I also want replication. Any other info other than what on the web site?
Anyone used eRServer? Is the Postgres-R project a separate endeavor? Is
there
Orr, Steve wrote:
> THANKS! for the quick answer.
>
> Yes I want point in time recovery and I can wait 6 months. $64K question...
> Will it be delivered on schedule? ;-)
Usually.
> I also want replication. Any other info other than what on the web site?
> Anyone used eRServer? Is the Postgres
On Tue, Sep 17, 2002 at 04:57:45PM -0600, Orr, Steve wrote:
> THANKS! for the quick answer.
>
> Yes I want point in time recovery and I can wait 6 months. $64K question...
> Will it be delivered on schedule? ;-)
Well, 7.3 looks like it will be.
If you have some dollars to spread around, I'll b
23 matches
Mail list logo