>>>>> "David" == David Weis <djweis@stripped> writes:
David> On Mon, 8 May 2000 sinisa@stripped wrote:
>> David Weis writes: > I'm running MySQL 3.22.32 on a machine
>> with AIX 4.3.2. I was replicating a > large database over to
>> MySQL (approx 10,000,000 records). It got to > 6,200,000
>> records and stopped with this message > DBD::mysql::st execute
>> failed: Got error 27 from table handler at > ./replicate.pl
>> line 51. > Got error 27 from table handler at ./replicate.pl
>> line 51. > > I checked the file size, it was 1073741312 bytes,
>> which is 1023 megs > (1073741312/1048576). We're fine for free
>> space on the partition, > > [root@abbott access]# df -k /opt >
>> Filesystem 1024-blocks Free %Used Iused %Iused Mounted on >
>> /dev/lv00 12058624 10890504 10% 900 1% /opt > > Large file
>> enabled is set to false in smit and won't let me change it. Any
>> > ideas? Please cc me, I'm not on the list.
>>
>> You should switch to 3.23, best use 3.23.15 as soon as it is
>> out, build it with large file support and transfer your tables
>> to MyISAM format with a script provided with 3.23 distribution.
David> Okay, any ETA for 3.23.15? I see .14 out there now.
>> Before you do that, check if your file system will support
>> large files, by manually creating a huge file, e.g. by use of
>> cat program.
David> My dd if=/dev/zero of=largefile bs=1048576 count=1050 ended
David> at 1023 megs again. It's odd that I can't get larger than a
David> 1 gig file.
Hmm, ulimit ?
>> If you have problems with that install some other file system,
>> like Verilog or JFS.
David> It's a JFS partition right now.
(4.3 does support large files but I'm not sure if its enabled by
default)
Sincerely,
Adrian Phillips
