Yes you can.
-----Original Message-----
From: J S
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 7/16/04 8:35 AM
Subject: RE: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>
>Yes. Can you
>CREATE TEMP TABLE ....?
I managed this:
mysql> CREATE TEMPORARY TABLE test
-> select * from internet_usage;
Query OK, 324936160 rows affected (54 min 31.64 sec)
Records: 0 Duplicates: 324936160 Warnings: 0
Can you create a temp table with keys then?
>
>-----Original Message-----
>From: J S
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Sent: 7/16/04 7:34 AM
>Subject: RE: ERROR 3 at line 1: Error writing file
>'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>
> >Can you explicitly create temporary tables?
>
>Yes, I have full priviledges. Do you mean I could copy the
>internet_usage
>table to a temp table with new keys?
>
>JS.
> >
> >-----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]
>
>_________________________________________________________________
>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]
>
_________________________________________________________________
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]
