Can you explicitly create temporary tables? -----Original Message----- From: J S To: [EMAIL PROTECTED] Sent: 7/16/04 3:54 AM Subject: RE: ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>>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] > _________________________________________________________________ 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]