Hi all

There is a table called std_info which get data from a session temporary
table and was created successfully , while it has a error message
"E_QE0083 Error modifying a table." when it was modified. std_info is a
big table whose size is 1.3G. Besides, I also find a error message in
errlog.log

Sun Mar 6 23:39:55 2005 E_DM9006_BAD_
FILE_WRITE Disk file write error on database:cats table:std_info
pathname:/database/padb1/ingres/data/default/cats filename:a0aaaasx.m00
page:1048560
write() failed with operating system error 0 (Error 0)

Any suggestion would be highly appreciated.

Frank


CREATE TABLE std_info AS SELECT * FROM session.std_info_tmp
WITH location = (padb1)
Executing . . .

(4953769 rows)
continue
* * Sun Mar 6 22:32:11 2005
COMMIT
Executing . . .

continue
* * * * Sun Mar 6 22:32:11 2005

MODIFY std_info TO btree UNIQUE ON cso_no, asset_id
WITH location = (padb1)
Executing . . .

E_QE0083 Error modifying a table.
(Sun Mar 6 23:39:55 2005)

"Frank Fan" <jun_fan4 (AT) agilent (DOT) com> wrote

You probably ran out of disk space. Modifying a table in that way requires
space for three copies of the table. Do a df -k to see what space is
available. (Is it an old machine, with small disks?)

In this particular case you could use less space by specifying WITH
STRUCTURE... on the CREATE AS SELECT statement.

Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"

Hi Roy,
Thanks a lot for your help.
It works fine after we spread the large table to two locations.

Roy Hann wrote: