Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#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
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
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
Re: Error on Webfaction
Hmm.. I’d say that if you get that error a lot, you’re on an overloaded server.
Offline
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
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
Pages: 1