Error 2013 Hy000 Lost Connection
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more mysql error 2013 hy000 lost connection to mysql server during query about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Error 2013 Hy000 At Line Lost Connection To Mysql Server During Query
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping error 2013 (hy000) lost connection to mysql server at 'reading initial communication packet' each other. Join them; it only takes a minute: Sign up Error Code: 2013. Lost connection to MySQL server during query up vote 67 down vote favorite 22 I got the Error Code: 2013. Lost connection to MySQL error 2013 (hy000) mysql server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away to increase the timeout value? mysql mysql-workbench share|improve this question edited Oct 6 at 8:06 agold 2,66571532 asked May 12 '12 at 12:14 user836026 2,50054582 add a comment| 16 Answers 16 active oldest votes up vote 118 down vote accepted New versions of MySQL WorkBench have
Lost Connection To Mysql Server At 'reading Initial Communication Packet', System Error: 104
an option to change specific timeouts. For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600 Changed the value to 6000. Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome. share|improve this answer edited Oct 8 '12 at 22:53 Marko 8,109102653 answered Oct 8 '12 at 22:49 eric william nord 1,204273 1 Is it possible to increase this limit over 99,999 seconds? The DBMS connection read time out field only accept up to 5 figures, and setting the field to 0 is equivalent to the default parameter (600 seconds). (Windows 7 64-bit Ultimate, MySQL Workbench 5.2.47 CE) –Franck Dernoncourt Jun 1 '13 at 21:30 1 Following stackoverflow.com/q/16877574/395857, this issue is now solved (bugs.mysql.com/bug.php?id=69395) –Franck Dernoncourt Jun 18 '13 at 3:46 2 uncheck limit rows in in Edit → Preferences →SQL Queries –Jon Mar 2 '14 at 16:32 1 I tried this and it now shows Error 0 with no message when I right-click a table and click Select Rows. I guess I don't understand why 600 seconds isn't long enough for read time out when I do the search seconds after logging into the database. –dhinged May 23 '14 at 1:18 3 After restarting, it is showing Error 2013 again ev
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using error 2013 lost connection to mysql server during query when dumping table MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration lost connection to mysql during query Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax
Mysql Lost Connection
The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys http://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Re
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://dba.stackexchange.com/questions/124964/error-2013-hy000-lost-connection-to-mysql-server-during-query-while-load-of-my and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users http://serverfault.com/questions/739137/lost-connection-to-mysql-server-during-query Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in lost connection the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top error 2013 (hy000) lost connection to mysql server during query while load of mysqldump up vote 0 down vote favorite I'm trying to load mysqldump and I lost connection to keep getting following error: ERROR 2013 (HY000) at line X: Lost connection to MySQL server during query /etc/my.cnf: [mysqld] max_allowed_packet = 16M net_read_timeout = 30 net_write_timeout = 60 ... [mysqldump] max_allowed_packet = 16M I tried to increase these values, but I keep getting that error no matter what( What else can I do to overcome this error? mysql mysqldump errors mysqladmin share|improve this question edited Jan 1 at 21:30 asked Jan 1 at 0:12 alexus 16511 Set the value in the [mysql] section of the config, as well? (Not [mysqladmin] though). SELECT @@MAX_ALLOWED_PACKET; to confirm that the server is using these values? –Michael - sqlbot Jan 1 at 4:15 @Michael-sqlbot I did typo, I meant to write mysqldump (not mysqldadmin), should I just keep max_allowed_packet or add net_read_timeout & net_write_timeout as well? –alexus Jan 1 at 21:27 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote The error code ERROR 2013 (HY000) related with aborted connection. You can run the following command to verify this. mysql> SHOW GLOBAL STATUS LIKE 'Aborted_connects
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Lost connection to MySQL server during query up vote 0 down vote favorite I am trying to import our old database into a new databsae on our test server however I keep coming accross this error: "Lost connection to MySQL server during query". As you can see below I have tried starting the server with increased values for read timeout and wait timeout. Plus I have increased max_allowed_packet = 1024M [root@DB-01 alexl]# /etc/init.d/mysql start Starting MySQL (Percona Server). SUCCESS! [root@DB-01 alexl]# mysql -hlocalhost magento < magento.sql ERROR 2013 (HY000) at line 15235: Lost connection to MySQL server during query The sql file is ~7gig but need it all. Any help is appreciated. +-----------------------------+----------+ | Variable_name | Value | +-----------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | have_statement_timeout | YES | | innodb_flush_log_at_timeout | 1 | | innodb_lock_wait_timeout | 50 | | innodb_rollback_on_timeout | OFF | | interactive_timeout | 28800 | | lock_wait_timeout | 31536000 | | net_read_timeout | 6000 | | net_write_timeout | 6000 | | rpl_stop_slave_timeout | 31536000 | | slave_net_timeout | 3600 | | thread_pool_idle_timeout | 60 | | wait_timeout | 28800 | +-----------------------------+----------+ | max_allowed_packet | 1024M | mysql share|improve this question edited Nov 26 '15 at 16:17 asked Nov 26