Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2015-09-13 15:06:20

jpdupont
Member
Registered: 2004-10-01
Posts: 752

Error on Webfaction

Hello,

I get this message 6x on Webfaction server (I’m on last 4.6 dev) :

This email is to inform you that we had to kill one
of your MySql queries because it had been running
for over 1 minute and it was impacting other users.

You don't need to do anything and you don't need
to reply to this message (although you can do if
you like).

Note that you won't get any more notifications in case
we have to kill any more of your MySql queries unless you
click the "Mark this issue as resolved" button below.

The query that we killed was the following:

Date/time: 2015-09-13 13:55:59 UTC
Database: ...
Server: ....webfaction.com
Query: select name, data from txp_lang where lang='fr-fr' and name != '' and event in('public','common')

Regards,

WebFaction team - http://www.webfaction.com

Offline

#2 2015-09-13 15:55:18

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Error on Webfaction

How many rows are in your txp_lang table and how many kilobytes is the table in total? It’s a very simple query that should never take more than one minute. Typically such a query takes only around a millisecond.

Offline

#3 2015-09-13 17:29:28

bici
Member
From: vancouver
Registered: 2004-02-24
Posts: 2,072
Website Mastodon

Re: Error on Webfaction

i also once had that error. I asked what it meant. this was their reply:

Hello,

The error means that a MySQL query took longer than 60 seconds to execute.

If this is the first time you are seeing the error it can be ignored.

It likely means another query on the server slowed this one down.

The query itself does not appear to be very complex, so it should typically execute very fast.

Please let us know if you have any questions.

John S.
WebFaction Support


…. texted postive

Offline

#4 2015-09-13 17:37:06

jpdupont
Member
Registered: 2004-10-01
Posts: 752

Re: Error on Webfaction

txp_lang = 2948 rows / 326 Ko

I had the problem a first time the 6 september (3 error messages) and a second time today (3 error messages)

Offline

#5 2015-09-13 17:50:56

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Error on Webfaction

Hmm.. I’d say that if you get that error a lot, you’re on an overloaded server.

Offline

#6 2015-09-14 09:15:18

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Error on Webfaction

ruud wrote #294782:

Hmm.. I’d say that if you get that error a lot, you’re on an overloaded server.

This. That was my first thought before reading Ruud’s reply. You do get a lot of bang for your buck on Webfaction (i.e., it’s not rock-bottom price hosting) and I’ve only heard of a couple of overloaded servers before now.

jpdupont wrote #294781:

txp_lang = 2948 rows / 326 Ko

This is a little odd. Three languages installed in Textpattern? There should be around 1150 rows per language pack, from memory – so it’s a little short of three languages total rows. Check the language pack(s) is/are up-to-date. It if happens again, truncating and reinstalling the language pack(s) would be worth trying.

Offline

#7 2015-09-14 14:41:17

jpdupont
Member
Registered: 2004-10-01
Posts: 752

Re: Error on Webfaction

@gaekwad, installed en-gb (1163 row) and fr-fr (1790 row), with the 2 languages pack up to date.
But, if you install some plugins smd_ adi_, you get many additional rows …

Offline

#8 2015-09-14 14:46:44

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,134
GitHub

Re: Error on Webfaction

jpdupont wrote #294796:

@gaekwad, installed en-gb (1163 row) and fr-fr (1790 row), with the 2 languages pack up to date.
But, if you install some plugins smd_ adi_, you get many additional rows …

Ah! Yes! My mistake – of course, you are correct.

Offline

Board footer

Powered by FluxBB