C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe --host=localhost --port=3306 -u root nd7b265_rahetbally
Task 'MySQL script' started at Sun May 31 09:53:09 MST 2020
ERROR 2013 (HY000) at line 118827: Lost connection to MySQL server during query
Task 'MySQL script' finished at Sun May 31 09:53:13 MST 2020
2020-05-31 09:53:13.363 - IO error: Process failed (exit code = 1). See error log.
2020-05-31 09:53:13.363 - java.io.IOException: Process failed (exit code = 1). See error log.
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:182)
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:237)
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:52)
at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Asked
Active
Viewed 1.2k times
2
Amira Elsayed Ismail
- 8,822
- 30
- 81
- 160
-
What does the MySQL error log show (if anything)? – Dave May 31 '20 at 18:09
4 Answers
2
Just change connection setting from --host=localhost to --host=127.0.0.1.
It works for me.
vuklip
- 39
- 7
-
1You helped me. But similar bug. In case exit code=2. I had. Thanks. – Ivan Pirus Jan 20 '21 at 11:16
-
1
Via right click DB > SQL editor > New SQL script
Execute following queries:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
S. vanh.
- 91
- 5
0
At mysql client program, you can config the maxallowedpacket as below.
At the mysql server, max_allowed_package is in mysqld.conf (mysql 5.7 version)
If database size is bigger 7GB, you have to make a trick with 256MB as the post https://stackoverflow.com/a/35599592
Duc Toan Pham
- 238
- 2
- 6
-2
I solved it by adding these lines
wait_timeout = 28800 interactive_timeout = 28800 max_allowed_packet=100M
under [mysql] section
Amira Elsayed Ismail
- 8,822
- 30
- 81
- 160