Jump to content


Photo

[Solved] Mysql: Query Execution Was Interrupted

MySQL database query interrupted

  • This topic is locked This topic is locked
3 replies to this topic

#1 koripl

koripl

    Newbie

  • Members
  • 2 posts

Posted 07 May 2017 - 12:04 PM

Hi guys,

 

I'm new user of Heliohost who yesteday made MySQL database on Johnny server, which is needed for small university's project, this means I'm using remote connection [from SQLDeveloper actually]. Connection, making tables went well, but problems has begun when I tried to fill some small data into it. Almost every single time, when I try to look into table f.e. to see what columns I've got in there or just to check if insert query was made in the way I would like it to I receive an error message:

 

"An error was encountered performing the requested operation:
Query execution was interrupted
Vendor code 1317"

 

After that I get connection reset.

 

What I should to manage with thie case?

Looking forward for your help!



#2 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 1,816 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 07 May 2017 - 02:13 PM

This support request is being escalated to our root admin.
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#3 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,595 posts
  • Gender:Male

Posted 07 May 2017 - 05:51 PM

It looks like mysql on Johnny restarted itself last around 8 hours ago. Looking at the server monitor that seems to coincide with a spike of load. If you were trying to connect to mysql around that same time it would make sense that you encountered disconnections. Johnny is our experimental server which means he's a lot more likely to have high load spikes and downtime. If you need a stable production server with high uptime we recommend Tommy or Ricky.

#4 koripl

koripl

    Newbie

  • Members
  • 2 posts

Posted 09 May 2017 - 02:13 PM

Ok, thank you! I'm starting with changing server. :)







Also tagged with one or more of these keywords: MySQL, database, query, interrupted

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users