Re: POSTGRE CRASH AND CURRVAL PROBLEM HELP!

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "David Azevedo" <davixz(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: POSTGRE CRASH AND CURRVAL PROBLEM HELP!
Date: 2007-08-19 21:45:27
Message-ID: dcc563d10708191445y24fb263ake1495cf44ce6377b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/19/07, David Azevedo <davixz(at)gmail(dot)com> wrote:
> Please, i need help desperately.
>
> Im running postgresql 8.1.9 on windows 2003 server standard edition service
> pack 2. intel pentium 4 3.2 - 1 gb ram
> I have 5 databases in this server and they all have action all day (
> inserts, selects etc )
>
> i have 2 problems.
>
> First, postgre crashes many times in the day and we have to restart the
> service to keep working. i created a log using the database conection class
> with php. when a query makes an error it logs in a txt file. i will show
> here the errors that im getting and i dont know what they mean.

On stable hardware with a stable OS, postgresql crashing once a year
is too often.

>
> 2007-08-16
> 13:49:43||/labrsangioro/forms/recepcao_temp.php||ERROR:
> could not open relation 1663/1491040/1555634: Invalid argument
> ||update tb_atendimento set total_faturamento='33.6', tipo_desconto='%',
> total_desconto='30' where cod_atendimento=2683
> 2007-08-16

This type of error is indicative of two possibilities. Either the
hardware has issues, or the OS is doing something funny.

On a unix machine I would generally suspect the hardware, but on
Windows I tend to suspect some kind of anti-virus software holding a
lock on your files when the database goes to access them.

Turn off / remove / uninstall all anti-virus / firewall / email filter
software on the box.

However, it is quite likely that by now you have a corrupted data
store and will need to restore from a backup for reliability.

Oh, and buy more RAM for that box. 1 gig is REALLY small for a db server. :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-08-19 22:08:56 Re: POSTGRE CRASH AND CURRVAL PROBLEM HELP!
Previous Message David Azevedo 2007-08-19 20:24:45 POSTGRE CRASH AND CURRVAL PROBLEM HELP!