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

Re: 7.3.2 strange behavior (long)

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: andrea suisani <suisani(at)demetra(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.3.2 strange behavior (long)
Date: 2003-03-24 18:57:06
Message-ID: 1048532226.13798.294.camel@camel (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 2003-03-20 at 08:05, andrea suisani wrote:
> Hello,
> 
> Firstly I apologise for my terrible english.
> we are using postgresql 7.2.x (currently 7.2.4)
> on our production server for last year (and also
>   we are on suse 7.2).
> 
> Last night i was working on the project for
> porting our application on pgsql 7.3.2 when a strange
> thing happen. The machine hangs (not only postgres) after
> I submit via psql this query "update coop_uni set msg_quote=''"
> to the server. The structure of this table is:
> 
<snip>
> 
> When i try to manually reboot the box
> I have another problem. the machine hangs during
> the boot with this message:
> 
> "Unable to handle kernel paging request at virtual address dc7d00
> printing eip:
> c01ad272
> * pde = 17edb...
>   ....
>   Oops:  000
>   CPU: 0
> 
>   ...."
> 
<snip>
> 
> The developing box is a "small" machine
> (celeron 1.2GHZ,ram 384MB, no scsi disks and
> PGDATA is on one ide disk), the kernel version
> is 2.4.20
> 
> I wanted to ask to you if this problem can have had
> to a hardware issue or to something else.
> 

I'm almost certain you have some kind of hardware issue, though
unfortunately I can't deduce just what it is. I'd start with checking
your ram, then maybe hdd. HTH.

Robert Treat


In response to

Responses

pgsql-admin by date

Next:From: Stephan SzaboDate: 2003-03-24 18:59:26
Subject: Re: what its better seqscan or indexscan
Previous:From: Robert TreatDate: 2003-03-24 18:51:08
Subject: Re: ┬┐What's wrong?

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