| Bug #62359 | ERROR 2005 (HY000): Unknown MySQL server host | ||
|---|---|---|---|
| Submitted: | 6 Sep 2011 7:35 | Modified: | 16 Feb 2012 20:41 |
| Reporter: | chandrashekar chari | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S1 (Critical) |
| Version: | 5.1.36 | OS: | Solaris |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mysql-5.1.36-solaris10-sparc | ||
[6 Sep 2011 7:39]
chandrashekar chari
Mysql version 5.1.36 mysql-5.1.36-solaris10-sparc
[6 Sep 2011 8:22]
Valeriy Kravchuk
Can you upload that .sql file that you are trying to load, server's error log and my.cnf file content? Also, as we do not fix bugs in older versions, please, check that this problem is still repeatable with recent MySQL 5.1 version, 5.1.58.
[7 Sep 2011 8:46]
chandrashekar chari
Thanks for your quick reply. Upload a.sql? oh my god its 7.4Gb. Can I have an option of splitting data in 2 or more and then try? What is the command with mysqldump for splitting a single longblob table? I am able to export a single table but i need to split insert statements. (total longblob rows "19703" ) Thanks in advance -Chari
[7 Sep 2011 9:10]
Valeriy Kravchuk
Why not to start with server's error log if .sql you load is so big? Or, alternatively, why not to try to reproduce on newer version and with smaller amount of data? We need complete test case here, repeatable on recent version with well-defined server configuration.
[7 Sep 2011 9:15]
chandrashekar chari
Hello Valeriy, I am restoring on same version in QA. I agree with new release this will be fixed. However can you provide me workaround to restore only one table i.e longblob bugzilla (attach_data table). I need to export using mysqldump and split the data in two export and then restore same using mysql -Chari
[7 Sep 2011 9:23]
chandrashekar chari
error log i can see Thread database.table_name Locked/Waiting Lock_type 10 bugs.attach_data Locked - write High priority write lock Begin safemalloc memory dump: End safemalloc memory dump. Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : <unknown>:132 LUA : <unknown>:142 WOC : NO Next activation : never
[16 Jan 2012 20:41]
Sveta Smirnova
Thank you for the feedback. But we need full error log file. Have you tried with newer version? Does bug still exist? Also check if you have big enough max_allowed_packet.
[17 Feb 2012 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: While importing using mysql> source < a.sql I get error No connection. Trying to reconnect... ERROR 2005 (HY000): Unknown MySQL server host 'MÔZQ8MìPáÊ5bPaΣH ßHëD¥qnФhlRwÄ¢½ªnW8<§éÉFr¯Xý¨¬4=:A8¤?µ¦'wÌ"õ!MO(<§éi0,¬é %ÀkzÚFèá4=yÐ' (3) ERROR: Can't connect to the server mysql> SHOW TABLE STATUS FROM bugs LIKE 'attach_data'\G; *************************** 1. row *************************** Name: attach_data Engine: InnoDB Version: 10 Row_format: Compact Rows: 2561 Avg_row_length: 21502 Data_length: 55066624 Max_data_length: 0 Index_length: 0 Data_free: 2347761664 Auto_increment: NULL Create_time: 2011-09-06 07:03:36 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: max_rows=100000 avg_row_length=1000000 Comment: 1 row in set (0.00 sec) ERROR: No query specified Its longblob with 7.4Gb data in it mysql> desc attach_data; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | id | mediumint(9) | NO | PRI | NULL | | | thedata | longblob | NO | | NULL | | +---------+--------------+------+-----+---------+-------+ 2 rows in set (0.01 sec) How to repeat: While importing using mysql> source < a.sql I get error No connection. Trying to reconnect... ERROR 2005 (HY000): Unknown MySQL server host 'MÔZQ8MìPáÊ5bPaΣH ßHëD¥qnФhlRwÄ¢½ªnW8<§éÉFr¯Xý¨¬4=:A8¤?µ¦'wÌ"õ!MO(<§éi0,¬é %ÀkzÚFèá4=yÐ' (3) ERROR: Can't connect to the server mysql> SHOW TABLE STATUS FROM bugs LIKE 'attach_data'\G; *************************** 1. row *************************** Name: attach_data Engine: InnoDB Version: 10 Row_format: Compact Rows: 2561 Avg_row_length: 21502 Data_length: 55066624 Max_data_length: 0 Index_length: 0 Data_free: 2347761664 Auto_increment: NULL Create_time: 2011-09-06 07:03:36 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: max_rows=100000 avg_row_length=1000000 Comment: 1 row in set (0.00 sec) ERROR: No query specified Its longblob with 7.4Gb data in it mysql> desc attach_data; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | id | mediumint(9) | NO | PRI | NULL | | | thedata | longblob | NO | | NULL | | +---------+--------------+------+-----+---------+-------+ 2 rows in set (0.01 sec)