Query execution was interrupted, ERROR 1317 (70100)

Asked Apr 09 '18 at 14:04

Active Apr 09 '18 at 14:21

Viewed 4,258 times

I use mysql command

mysql -uuser -ppassword -B -e "SELECT SUM(duration) FROM table GROUP BY userId" database > result.tsv &

This is a very slow SQL, I need to use & let SQL execute in the background. which takes about a few hours. But always in the middle of the execution to report a error:

ERROR 1317 (70100) at line 1: Query execution was interrupted
Terminal close -- sending "KILL QUERY 236" to server ...
Terminal close -- query aborted.

I am searching for a long time on net. But no use. Please help or try to give some ideas how to achieve this.

edited Apr 09 '18 at 14:21

asked Apr 09 '18 at 14:04

doushichao

Are you executing this on a MySQL server which is not your own computer? Also, what other things are running in the background which might degrade performance? – Tim Biegeleisen Apr 09 '18 at 14:06
What is the max_allowed_packet size ? You may consider splitting the query as well. – farbiondriven Apr 09 '18 at 14:08
I am running SQL on MySQL server, and this server only MySQL server installed – doushichao Apr 09 '18 at 14:09
The `max_allowed_packet` value is 16777216, The SQL I want to execute is a SUM operation and returns only one record. – doushichao Apr 09 '18 at 14:20

Query execution was interrupted, ERROR 1317 (70100)

0 Answers0