RE: Errcode: 27

Sorry me again! I haven't had any success with this thread :( But could someone at least tell me the best way to debug this please? Are there any options I can provide to increase the logging detail? Thanks, JS. Does anyone know what goes on (system wise) during the CREATE INDEX ? I can see it'

RE: Errcode: 27

Does anyone know what goes on (system wise) during the CREATE INDEX ? I can 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 a

RE: Errcode: 27

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) -- CREATE INDEX timeindex ON internet_usage

RE: 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 the specifics of what happen

Re: Errcode: 27

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 filesystem. This shoul

Re: Errcode: 27

This should be a useful thread for you http://lists.mysql.com/mysql/167953 Suggests using ALTER TABLE MAX_ROWS= On Fri, 23 Jul 2004 20:20:24 +, "J S" <[EMAIL PROTECTED]> wrote : > Hi, > > I'm trying to run the following SQL (on > mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc): > > CREA