Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 20087 invoked from network); 20 Apr 2007 15:13:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Apr 2007 15:13:30 -0000 Received: (qmail 44410 invoked by uid 500); 20 Apr 2007 15:13:35 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 44375 invoked by uid 500); 20 Apr 2007 15:13:35 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 44364 invoked by uid 99); 20 Apr 2007 15:13:35 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Apr 2007 08:13:35 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Apr 2007 08:13:26 -0700 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.11.112]) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id l3KFD5Kd020885 for ; Fri, 20 Apr 2007 08:13:05 -0700 (PDT) Message-ID: <4628D880.2000503@amberpoint.com> Date: Fri, 20 Apr 2007 08:13:04 -0700 From: Bryan Pendleton User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Read timed out References: <20070420135146.E5E0C10FB007@herse.apache.org> In-Reply-To: <20070420135146.E5E0C10FB007@herse.apache.org> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org > I try to modify a Table (6.000.000 Rows) with the DDL: > > �ALTER TABLE D_GEO ADD COLUMN IDX NUMERIC(11) NOT NULL DEFAULT 1; � > > an I recive this error: > > Error: java.sql.SQLException: A communications error has been detected: > Read timed out., SQL State: 58009, Error Code: -4499 How long had the statement been running before the error occurred? Was this system busy during this time? Or idle? Are there any error messages in the derby.log file? Can you get a complete stack trace for the exception? thanks, bryan