URGENT - "CANNOT EXTEND"

From: "Tim Perdue" <perdue(at)raccoon(dot)com>
To: <pgsql-sql(at)hub(dot)org>, <pgsql-hackers(at)hub(dot)org>
Subject: URGENT - "CANNOT EXTEND"
Date: 1999-03-14 04:46:49
Message-ID: 000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

A couple days ago I asked what happens when I hit 2GB and I was told "no
worries". Well, I hit 2GB and it barfed on me. It looks like postgres is
trying to create a new file, but it isn't able to use it....

/dev/sda is where my database resides and it has 38% free.

Right now, geocrawler is still up and running, but no new mail can be
inserted into it until I can get this figured out....

Please respond directly to tim(at)perdue(dot)net

Thanks,

Tim

java.sql.SQLException: ERROR: tbl_mail_archive: cannot extend <-- BAD NEWS

at postgresql.Connection.ExecSQL(Compiled Code)
at postgresql.Statement.execute(Compiled Code)
at postgresql.Statement.executeUpdate(Compiled Code)
at com.geocrawler.mail.News2SQL.processFile(Compiled Code)
at com.geocrawler.mail.News2SQL.<init>(Compiled Code)
at com.geocrawler.mail.News2SQL.main(Compiled Code)
java.sql.SQLException: IOError while reading from backend:
java.io.IOException:
The backend has broken the connection. Possibly the action you have
attempted ha
s caused it to close.
at postgresql.PG_Stream.ReceiveChar(Compiled Code)
at postgresql.Connection.ExecSQL(Compiled Code)
at postgresql.Statement.execute(Compiled Code)
at postgresql.Statement.executeUpdate(Compiled Code)
at com.geocrawler.mail.News2SQL.processFile(Compiled Code)
at com.geocrawler.mail.News2SQL.<init>(Compiled Code)
at com.geocrawler.mail.News2SQL.main(Compiled Code)

ls -l

-rw------- 1 postgres postgres 2147482624 Mar 13 22:43 tbl_mail_archive
-rw------- 1 postgres postgres 0 Mar 13 22:41 tbl_mail_archive.1

df

Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/sdb3 1931651 725575 1106236 40% /
/dev/sda 8573425 5077127 3051717 62% /fireball

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-03-14 05:07:07 Re: [HACKERS] URGENT - "CANNOT EXTEND"
Previous Message Bruce Momjian 1999-03-14 02:59:12 Re: [HACKERS] tutorial won't compile in current tree.

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-03-14 05:07:07 Re: [HACKERS] URGENT - "CANNOT EXTEND"
Previous Message Brett W. McCoy 1999-03-13 20:30:43 Re: [SQL] So what happens at 2GB?