Aaron Bush writes:
> I have Mysql version 3.22.25 on a HPUX 10.20 machine, I have installed with
> the directions given in the docs for HPUX specific options
> (--with-low-memory and modifed readline Makefile to be -O2 instead of -O6).
>
> I have a batch job executed as mysql -u root -pPASSWORD db <./input.mysql
> This job will fail with the following error SOME of the time:
> >>ERROR 2013 At Line 2: Lost connection to MySQL server during query.
>
> The input.mysql file is this:
>
> DELETE FROM my_table;
> LOAD DATA INFILE '/var/spool/data/my_data.dat' INTO TABLE my_table FIELDS
> TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' (field1,field2,...field[n]);
>
> I have seen where increasing the max_allowed_packet has been suggested
> before, however the file is only 700K and each line is approx 100bytes.
> I have been able to take the file that the batch process has failed to load
> and load it by executing the same command from a shell and have no errors at
> all? I would assume that it would always fail possibly due to a corrupted
> data file but it doesn't?
> I have ran isamchk against all the tables in the database and have no
> errors.
>
> Are there any know performance issues with MySQL and HPUX?
>
> Aaron Bush
> abush@stripped
>
Hello Aaron,
- Please verify that the max_allowed_packet is at least as big
as the biggest field type you have; i.e. the number of bytes
your biggest field type can contain.
If the above doesn't help, then:
- Use: 'mysqladmin -i1 proc status' to see what happens in the
MySQL server during the problematic query.
- Examine the log files on the server side to find the reason
for the crash.
- If nothing helps, you might have to debug the MySQL server.
For that, please see:
http://www.mysql.com/Manual_chapter/manual_Porting.html#Debugging_server
If you are still having problems, then:
- Please read first:
http://www.mysql.com/Manual_chapter/manual_Questions.html#Questions
- Make a zipped file, which contains information for us
how to reproduce the problem + example data.
Send it to http://www.mysql.com/secret
- Inform us about it with mail, using mysqlbug. We can try to
find a solution for the problem when we have time.
Regards,
- Jani
--
+-------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
| /*/ /*/ /*/ \*\_ |*| |*||*| jani@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+-------------------------------------------------------------+
