pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Perdue <perdue@raccoon.com>
To: pgsql-sql@hub.org
To: pgsql-hackers@hub.org
Subject: URGENT - "CANNOT EXTEND"
Date: Sat, 13 Mar 1999 22:46:49 -0600
Message-ID: <000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net> (raw)

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@perdue.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






view thread (5+ messages)  latest in thread

Message-ID: <000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net>
Permalink:  ../000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net/
Also on:    postgresql.org/message-id/000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: perdue@raccoon.com, pgsql-sql@hub.org, pgsql-hackers@hub.org
  Subject: Re: URGENT - "CANNOT EXTEND"
  In-Reply-To: <000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net>
  References: <000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox