see it's copying the table file, what then though?
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the "create index" again using --verbose but this is all
I got:
ERROR 3 at line 1: Error writing file '/proxydb/mys
all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage (uid,time)
--
Bye
Can anyone tell me the specifics of what happens during the create index?
I can see that the table bein
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the "create index" again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
I tried running the "create index" again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage (uid,time)
--
Bye
Can anyone tell me t
Thanks but that's not v helpful. Actually that was my thread! The problem
there was that I didn't have a large-file enabled filesystem. The problem I
have now is being able to create another index on a table but getting an
errcode 27 despite no ulimits and a large enabled filesys
max-4.0.20-ibm-aix4.3.3.0-powerpc):
>
> CREATE INDEX timeindex ON internet_usage (time);
> CREATE INDEX urlindex ON internet_usage (urlid);
>
> but keep running into the following error:
>
> Error writing file '/proxydb/mysql/tmp/STeR39Er' (Errcode: 27)
>
> $ perr
Hi,
I'm trying to run the following SQL (on
mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc):
CREATE INDEX timeindex ON internet_usage (time);
CREATE INDEX urlindex ON internet_usage (urlid);
but keep running into the following error:
Error writing file '/proxydb/mysql/tmp/STeR39Er
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:
mysq
essage-
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_us
Yes. Can you
CREATE TEMP TABLE ?
-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
'/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'
A
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 thi
27;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
27;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
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 c
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 ai
16 matches
Mail list logo
