Re: [GENERAL] postgres crash when select a record

2008-05-15 Thread Scott Marlowe
Definitely run some tests on the hardware, like memtest86, and some drive tests for bad blocks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgres crash when select a record

2008-05-15 Thread mailtolouis2020-postgres
Hello Pavel, Thanks for the info, this is very great help. Regard Louis - Original Message From: Pavel Stehule <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: Postgres Sent: Thursday, May 15, 2008 4:43:36 AM Subject: Re: [GENERAL] postgres crash when select a record Hello 200

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread Pavel Stehule
> Louis > > - Original Message > From: Pavel Stehule <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: Postgres > Sent: Wednesday, May 14, 2008 6:13:05 PM > Subject: Re: [GENERAL] postgres crash when select a record > > Hello > > Delete this broken

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread mailtolouis2020-postgres
ED] Cc: Postgres Sent: Wednesday, May 14, 2008 6:13:05 PM Subject: Re: [GENERAL] postgres crash when select a record Hello Delete this broken row Regards Pavel Stehule 2008/5/14  <[EMAIL PROTECTED]>: > Hello, > > I wish some could help me on this. > > I got a table which has

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread Glyn Astill
6:20:10 PM Subject: Re: [GENERAL] postgres crash when select a record No, I didn't run the query when the DB is in recovering. I did that after database system is ready - Original Message From: Glyn Astill <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; Postgres Sent: Wednesday

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread mailtolouis2020-postgres
es Sent: Wednesday, 14 May, 2008 5:07:03 PM Subject: [GENERAL] postgres crash when select a record Hello,   I wish some could help me on this.   I got a table which has 100500 records, when I try to query this particular record   select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609; Postgres

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread Pavel Stehule
Hello Delete this broken row Regards Pavel Stehule 2008/5/14 <[EMAIL PROTECTED]>: > Hello, > > I wish some could help me on this. > > I got a table which has 100500 records, when I try to query this particular > record > > select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609; > Postgres cra

Re: [GENERAL] postgres crash when select a record

2008-05-14 Thread Glyn Astill
ay, 14 May, 2008 5:07:03 PM Subject: [GENERAL] postgres crash when select a record Hello, I wish some could help me on this. I got a table which has 100500 records, when I try to query this particular record select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609; Postgres crash, and

[GENERAL] postgres crash when select a record

2008-05-14 Thread mailtolouis2020-postgres
Hello, I wish some could help me on this. I got a table which has 100500 records, when I try to query this particular record select * from cs_sr_mthly_rtn where mthly_rtn_id = 61609; Postgres crash, and show this errors: server closed the connection unexpectedly  This probably means the server te