Hi!
On Jul 14, Dan wrote:
> Hi all.
>
> I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
> month, and around 1,000,000 records imported into it. The import process
> consists of a 'load data infile' operation, followed by some updates to
> extract data and dump it somewhere where it is easier to access ( in the
> same table ).
>
> The problem is that each time I do an import, soon after I get 'error
> 127 from table handler'. Sometimes it is while selecting, sometimes
> while updating. Sometimes it is *in* the import process ( after the load
> data infile step ). I haven't been able to pinpoint exactly what
> triggers it.
>
> I know how to 'fix' the error 127: run myisamchk. But instead of dodgy
> it up after the thing has crashed, I'd rather find the cause. Anyone
> interested in helping me help them find the cause? I could try InnoDB (
> and probably will since we need this up and running soon ) but I'd still
> like to get the issue fixed.
>
> Any takers?
> Dan
Yes, sure.
Start from describing your setup - OS, did you build mysqld yourself,
etc.
And provide your table structure (SHOW CREATE TABLE) and LOAD DATA
command in question (FIELDS TERMINATED BY ... and whatever).
And, yes, please, do it at bugs.mysql.com, by creating a bug report
there - otherwise some developer will do it, and you won't be able to
follow the progress log, as you will not be the owner of the ticket.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
