Are you files being created in /tmp? How big is this partition? -----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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]