Are you files being created in /tmp? How big is this partition?
I wondered about that, but I've set the mysql tmpdir to /proxydb/mysql/tmp, and the error does actually say: Error writing file '/proxydb/mysql/tmp/STTbtrac'
Also I couldn't see any mysql files in /tmp. It's tricky isn't it?!
JS.
-----Original Message-----
From: J S
To: [EMAIL PROTECTED]
Sent: 7/15/04 2:29 PM
Subject: ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac'
(Errcode: 27
Hi,
I'm trying to create an index using the command:
CREATE INDEX urlindex ON internet_usage (urlid)
| Field | Type | Null | Key | Default | Extra | | urlid | int(10) unsigned | | | 0 | |
But I keep getting the following error:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac' (Errcode: 27)
perror says:
$ perror 3 Error code 3: The process does not exist. $ perror 27 Error code 27: A file cannot be larger than the value set by ulimit. $
I'm using mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc on aix 4.3.
The status of this table is:
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | | internet_usage | MyISAM | Fixed | 324936160 | 32 | 10397957120 | 137438953471 | 2888631296 | 0 | NULL | 2004-07-09 14:05:56 | 2004-07-13 20:27:06 | 2004-07-09 14:13:20 | max_rows=4294967295 | |
I can't see any reason why there would be an error 27. The filesystem is
largefile enabled and has plenty of space:
$ df -k . Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/sawmill02 65601536 30921916 53% 1064 1% /proxydb
Also the filesize ulimit is unlimited:
# su - mysql $ cd /proxydb/mysql/tmp $ cat load-SG_BSGL01_main_460429210000 >> test $ ls -l test -rw-r--r-- 1 mysql mysql 4239906888 Jul 15 20:20 test
# su - mysql $ ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) unlimited memory(kbytes) 500000 coredump(blocks) unlimited nofiles(descriptors) 2000
I'm not really sure why I get the error 3 though?
Can anyone help me out please?
Thanks,
JS.
_________________________________________________________________ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
