I was contacted by my host this morning with the following. Do you think this is WSN Links related? It's either that or Wordpress and I have no clue what this means...
Thanks.
--------------------------------
During our monitoring, we noticed that your database "linkloun_links" got a lot of error query and here is the same error:
Please request your database administrator or programmer to have a check.
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/memberstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/memberstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/cronstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/cronstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/membergroupstable.frm' (errno: 24) 100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/membergroupstable.frm' (errno: 24) 100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24) 100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
This is probably related to your other thread. Somehow, it seems to have been failing to process $linkstable into yourprefix_links and so forth. I assume it's not happening since the other thread was resolved.
Mmh, I have no idea if the problems are related, but this one apparently is not resolved. They just sent me this (I love how they call me Sir!):
------------------------
Dear Sir,
There is still MySQL error from your database which caused the MySQL services down, can you kindly have a check on it to avoid our WP hosting server performance affected?
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24) 100108 1:48:26 [Note] /usr/sbin/mysqld: Normal shutdown
Does the debug output on your site show similar "can't open file" sorts of messages? Or any sort of table not found message, or other error? Add ?debug=1 to your URL, or send me your URL so I can check.
'Course without knowing what page its on or what parameters are involved it's going to be just about impossible to find anything.
I moved the whole site to the other server I'm using (the fastest server move I ever did). The "customer service" was getting too obnoxious ("can we suspend your site while you're trying to figure out where this error is coming from?" Excuse me???).
So I have no clue if this error or whatever it was is related to the site, the server, the database, who knows. I looked at the debug, but I can't find anything. (http://link-lounge.com/thelinks/index.php?debug=1)
Could it possibly be related to the fact that I'm pulling data into a non-WSN part of the site using things like this: <script language="javascript" src="http://link-lounge.com/thelinks/exporter.php?number[1]=10&field[1]=hits&ascdesc[1]=descending&type[1]=links&template=export_popular"></script> I read that there's a better way to do it that's less server intensive (?), but I couldn't get it to work.
"'Course without knowing what page its on or what parameters are involved it's going to be just about impossible to find anything."
I know, that's what I kept telling them, but they just kept sending me what I posted above. All I could tell is that it's related to WSN Links and not to Wordpress...
We'll see if the problem occurs again, and maybe with the customer support of the new server (which is much more helpful - and able to write proper English, which helps, too) we'll be able to find the source.
It's not about something server intensive happening (in fact those queries would be really quick because they have no results), it's just some errors caused by querying nonexistent table names. WSN normally queries like this: $db->select('all', 'linkstable', 'id=5'); 'linkstable' gets replaced in the database class by the value of $linkstable, which is yourprefix_links. But in the errors posted above, apparently it's not doing that translation and is just looking for a mysql table named linkstable.
Though I'd rather not query nonexistent tables because that means whatever WSN function doing it isn't working right, there is of course no reason why a query on a nonexistent table should cause MySQL to crash -- crashing on bad queries is a nasty bug in their MySQL version.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on Error query - WSN Links error?
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
I was contacted by my host this morning with the following. Do you think this is WSN Links related? It's either that or Wordpress and I have no clue what this means...
Thanks.
--------------------------------
During our monitoring, we noticed that your database "linkloun_links" got a lot of error query and here is the same error:
Please request your database administrator or programmer to have a check.
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/memberstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/memberstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/cronstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/cronstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/membergroupstable.frm' (errno: 24)
100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/membergroupstable.frm' (errno: 24)
100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24)
100105 2:18:43 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/emailtable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100105 2:18:44 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
This is probably related to your other thread. Somehow, it seems to have been failing to process $linkstable into yourprefix_links and so forth. I assume it's not happening since the other thread was resolved.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Mmh, I have no idea if the problems are related, but this one apparently is not resolved. They just sent me this (I love how they call me Sir!):
------------------------
Dear Sir,
There is still MySQL error from your database which caused the MySQL services down, can you kindly have a check on it to avoid our WP hosting server performance affected?
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/linkstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/categoriestable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100108 1:48:13 [ERROR] /usr/sbin/mysqld: Can't open file: './linkloun_links/sessionstable.frm' (errno: 24)
100108 1:48:26 [Note] /usr/sbin/mysqld: Normal shutdown
100108 1:48:42 InnoDB: Starting shutdown...
100108 1:48:44 InnoDB: Shutdown completed; log sequence number 0 375932624
100108 1:48:44 [Note] /usr/sbin/mysqld: Shutdown complete
100108 01:48:45 mysqld ended
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Does the debug output on your site show similar "can't open file" sorts of messages? Or any sort of table not found message, or other error? Add ?debug=1 to your URL, or send me your URL so I can check.
'Course without knowing what page its on or what parameters are involved it's going to be just about impossible to find anything.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
I moved the whole site to the other server I'm using (the fastest server move I ever did). The "customer service" was getting too obnoxious ("can we suspend your site while you're trying to figure out where this error is coming from?" Excuse me???).
So I have no clue if this error or whatever it was is related to the site, the server, the database, who knows. I looked at the debug, but I can't find anything. (http://link-lounge.com/thelinks/index.php?debug=1)
Could it possibly be related to the fact that I'm pulling data into a non-WSN part of the site using things like this:
<script language="javascript" src="http://link-lounge.com/thelinks/exporter.php?number[1]=10&field[1]=hits&ascdesc[1]=descending&type[1]=links&template=export_popular"></script>
I read that there's a better way to do it that's less server intensive (?), but I couldn't get it to work.
"'Course without knowing what page its on or what parameters are involved it's going to be just about impossible to find anything."
I know, that's what I kept telling them, but they just kept sending me what I posted above. All I could tell is that it's related to WSN Links and not to Wordpress...
We'll see if the problem occurs again, and maybe with the customer support of the new server (which is much more helpful - and able to write proper English, which helps, too) we'll be able to find the source.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It's not about something server intensive happening (in fact those queries would be really quick because they have no results), it's just some errors caused by querying nonexistent table names. WSN normally queries like this:
$db->select('all', 'linkstable', 'id=5');
'linkstable' gets replaced in the database class by the value of $linkstable, which is yourprefix_links. But in the errors posted above, apparently it's not doing that translation and is just looking for a mysql table named linkstable.
Though I'd rather not query nonexistent tables because that means whatever WSN function doing it isn't working right, there is of course no reason why a query on a nonexistent table should cause MySQL to crash -- crashing on bad queries is a nasty bug in their MySQL version.