Received: from slip1.raccoon.com (slip1.raccoon.com [165.90.135.16]) by hub.org (8.9.2/8.9.1) with ESMTP id XAA29173; Sat, 13 Mar 1999 23:48:10 -0500 (EST) (envelope-from perdue@raccoon.com) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip1.raccoon.com (8.8.7/8.8.7) with SMTP id WAA00484; Sat, 13 Mar 1999 22:47:05 -0600 Message-ID: <000701be6dd5$ac72f830$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue" From: "Tim Perdue" To: , Subject: URGENT - "CANNOT EXTEND" Date: Sat, 13 Mar 1999 22:46:49 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 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.(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.(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