Re: [GENERAL] READ ONLY & I/O ERROR

2009-12-02 Thread Craig Ringer
On 2/12/2009 11:35 PM, Scott Marlowe wrote: (please use text only email to the list) On Wed, Dec 2, 2009 at 7:51 AM, Sam Jas wrote: We are getting the below errors after 20 or 25 days of database creation. ERROR: could not open relation 1919829/1152694/1921473: Read-only file system ERROR: c

Re: [GENERAL] READ ONLY & I/O ERROR

2009-12-02 Thread Scott Marlowe
(please use text only email to the list) On Wed, Dec 2, 2009 at 7:51 AM, Sam Jas wrote: > > We are getting the below errors after 20 or 25 days of database creation. > > ERROR: could not open relation 1919829/1152694/1921473: Read-only file system > ERROR: could not read block 312320 of relation

Re: [GENERAL] READ ONLY & I/O ERROR

2009-12-02 Thread Sam Jas
From: Greg Smith Subject: Re: [GENERAL] READ ONLY & I/O ERROR To: "Scott Marlowe" Cc: "Sam Jas" , pgsql-general@postgresql.org Date: Monday, 30 November, 2009, 8:29 PM Scott Marlowe wrote: > Areca doesn't make the high point rocket raid cards (which are medium >

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-30 Thread Greg Smith
Scott Marlowe wrote: Areca doesn't make the high point rocket raid cards (which are medium quality RAID cards). On a good day maybe. HighPoint is a pretty miserable RAID vendor--in the same league as Promise from what I've seen as far as their Linux driver support goes. In generally, and f

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-27 Thread Scott Marlowe
On Fri, Nov 27, 2009 at 4:53 AM, Sam Jas wrote: > > I will check that one. Also i have read one forum which tells that whenever > you face disk i/o run "dmesg" command it will give you detail information. > Today again i face disk i/o and i have run "dmesg" it has given me below o/p. > Can some

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Scott Marlowe
On Thu, Nov 26, 2009 at 6:40 AM, Sam Jas wrote: > > Hi Folks, > > I am frequently getting read-only file system error on my server. > > We are using postgreSQL, GridSQL database. The size of database is very huge. > Architecture Details: > CentOS 5.3 64 bit Areca high point rocket raid 3520 8 port

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Alan Hodgson
On Thursday 26 November 2009, Sam Jas wrote: > We are daily processing millions of rows and loadiing into database. We > have marked that when we create a new database it worked fine upto 20 or > 25 days. After that we are getting errors like "read only file system" , > data is corrupted. Therefo

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Grzegorz Jaśkiewicz
oh, and fourth - if you get filesystem errors, I would inspect drives, raid card, etc - because those usually mean that something's fishy.

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Grzegorz Jaśkiewicz
2009/11/26 Sam Jas > How can i enable journaling as i am not so good at OS & H/W level. Can you > give me some detail description. > > a) don't top post, b) don't send emails in html, c) man e2fsck , I am sure it is described all around net million times. it is something I haven't done in a while

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Sam Jas
How can i enable journaling as i am not so good at OS & H/W level. Can you give me some detail description. Thanks Sam Jas --- On Thu, 26/11/09, Grzegorz Jaśkiewicz wrote: From: Grzegorz Jaśkiewicz Subject: Re: [GENERAL] READ ONLY & I/O ERROR To: "Sam Jas"

Re: [GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Grzegorz Jaśkiewicz
On Thu, Nov 26, 2009 at 1:40 PM, Sam Jas wrote: > Hi Folks, > > I am frequently getting read-only file system error on my server. > > We are using postgreSQL, GridSQL database. The size of database is very > huge. > Architecture Details: > CentOS 5.3 64 bit Areca high point rocket raid 3520 8 por

[GENERAL] READ ONLY & I/O ERROR

2009-11-26 Thread Sam Jas
Hi Folks, I am frequently getting read-only file system error on my server. We are using postgreSQL, GridSQL database. The size of database is very huge.   Architecture Details: CentOS 5.3 64 bit Areca high point rocket raid 3520 8 port 32 GB RAM assemble hardware   We are daily processing mill