vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Lots of database errors (https://vborg.vbsupport.ru/showthread.php?t=296274)

borbole 03-19-2013 12:56 PM
Quote:
Originally Posted by Floyd R Turbo (Post 2410865)
Snakes, I ran a repair on all tables actually before you said to optimize. Is there any harm done in repairing vs optimizing?

borbole, I believe it is a shared server. I'm not big enough for a dedicated server or vps (I'm guessing that means virtual private server). I have read that running vb on a shared server can cause issues with temporary tables created during queries, could that be what is going on? I need to have them bump up my allowable table size or shared space?

I also heard godaddy is a PITA for this stuff.
Indeed, hence why I asked about your hosting plan. If the table keep crashing repeatedly then it would be best to contact your host. If they will not be able to fix it then maybe it is time to start looking for a new host.

Floyd R Turbo 03-19-2013 04:48 PM
My site is not that active. I have less than 100 users, and I do have people register successfully, just not that often, only a couple a month.

So it seems to me that someone is trying to 'ping' the database or something. Maybe someone can explain to me what actually causes the error. Because to me it does not make sense that I get this error message

Code:
Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error  : Incorrect key file for table '/tmp/mysqltmp/#sql_1851_0.MYI'; try to repair it
for Usernames that are not registered!! Like these, all received in the last 24 hours

Code:
IP Address    : 118.101.4.158
Username      : HumbertoC

IP Address    : 91.207.8.157
Username      : tzhang216

IP Address    : 188.123.248.25
Username      : Flapidolilt

IP Address    : 108.61.95.217
Username      : ShanaZSS

IP Address    : 222.76.80.244
Username      : turejrn

IP Address    : 109.169.82.12
Username      : DanuncoqH

IP Address    : 75.136.23.77
Username      : DonaldRHW

IP Address    : 113.212.68.20
Username      : MartaMont

IP Address    : 5.9.251.139
Username      : Antoinett
So it's not like someone is trying to register and failing. They are trying to do SOMETHING that seems to set off this error. It seems like bot or spammer activity or something.

snakes1100 03-19-2013 05:00 PM
This error doesnt mean the table crashed.

MySQL Error : Incorrect key file for table '/tmp/mysqltmp/#sql_XXXX_0.MYI'; try to repair it

Floyd R Turbo 03-19-2013 05:13 PM
Ok...so what is going on here? I get this error message randomly throughout the day. It always has a Username listed that is not registered.

snakes1100 03-19-2013 05:19 PM
As i posted before, it can be triggered a few different ways, this is a issue with the low resource over sold server your on.

If the query is triggered & sql reaches a timeout or if it by chance crashes, that tmp file will be created, then marked invalid, as the key is no longer valid.

That could come from a simple large join query/order by, tat your site is running, i doubt your going to get away from it.

Do you get any other error fro msql, like the server has gone away?

Floyd R Turbo 03-19-2013 05:44 PM
Yes, I do occasionally get the 'server has gone away' error, and yesterday the site was down for a period of time.

Help me out here. What is a 'large join query' or 'order by'?

Also I still don't understand why this error keeps happening and flags a username that does not exist.

--------------- Added [DATE]1363715363[/DATE] at [TIME]1363715363[/TIME] ---------------

From yesterday, while the forum was down (like a server was unplugged!!)
Code:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'turboforum.db.XXXXXXXXX.hostedresource.com' (0)
/home/content/XX/XXXXXXXXX/html/vb4/includes/class_core.php on line 317
another one from a few days ago

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error  : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Friday, March 15th 2013 @ 10:54:49 PM
Error Date    : Friday, March 15th 2013 @ 10:54:49 PM
Script        : http://www.turbosaquatics.com/vb4//register.php?do=addmember
Referrer      : http://www.turbosaquatics.com/vb4//register.php?
IP Address    : 27.153.231.63
Username      : frierobia
Classname    : vB_Database
MySQL Version :
Again, a user that does not exist

Another that I have seen once or twice

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                        SELECT title, template
                        FROM template
                        WHERE templateid IN (14,78,79,67,51,60,0,20,80,81,109,4,3,576,605,566,567,569,575,574,402,403,404,405,158,159,406,411,407,408,409,412,413,414,415,416,467,469,471,473,475,522,521,524,525,528,529,771,941,947,580,578,581,583,582,584,585,586,587,588,589,590,595,592,594,591,593,604,606,607,616,598,609,610,611,612,614,577,603,608,617,613,619,618,615,695,1030,1040,981,1051,0,0,429,423,422,427,428,426,425,430,431,432,737,1033,683,687,684,685,686,1049,0,0,1012,1014,707,708,710,711,934,976,975,1025,977,534,533,537,85,361);

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Wednesday, March 13th 2013 @ 09:26:00 AM
Error Date    : Wednesday, March 13th 2013 @ 09:27:30 AM
Script        : http://www.turbosaquatics.com/vb4/member.php?7-halfmoon&tab=activitystream&type=friends&page=105
Referrer      :
IP Address    : 66.249.74.210
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

snakes1100 03-19-2013 05:50 PM
I think you have 420 on the brain, i said JOIN :D

It doesnt matter what the username is, its the query thats being called that is most likely the culprit.

As ive already explained what im thinking it is, this is a server issue & i dont believe your gonna be able to get them to correct it, as its a over sold poopie vhost server.

Floyd R Turbo 03-19-2013 05:57 PM
Ok I understand your position on GoDaddy.

I am still trying to understand something here. When a query is called, does it have to have a username attached to it? So obviously SOMEthing is calling the query. Whatever is calling the query is choosing a username. What kind of program does this sort of thing?

Is it POSSIBLE that people are trying to register, and are not being successful? Or is this likely Bot and/or spammer activity?

I have an announcement on my site stating to contact me via the contact us link if anyone is having a problem registering. So far, no one has. That only happened once, a while back, and the error message I received included their e-mail address.

snakes1100 03-19-2013 06:03 PM
Its hard to say what is causing it as i dont have access to the server logs.

I didnt specify godaddy, i was talking about the server itself, which many hosts like them do just that, over sell a server & severly limit resource usage, especially for a db driven site.

If your getting both those errors error 28 & 2006, id get off that server.

--------------- Added [DATE]1363716457[/DATE] at [TIME]1363716457[/TIME] ---------------

Im guessing there is going to be a gone away error here with a time stamp earlier than the following tmp error.

Time stamp from the original post for the tmp error:
Request Date : Wednesday, March 13th 2013 @ 09:19:55 AM
Error Date : Wednesday, March 13th 2013 @ 09:20:05 AM

Gone away error:
Request Date : Wednesday, March 13th 2013 @ 09:26:00 AM
Error Date : Wednesday, March 13th 2013 @ 09:27:30 AM

Floyd R Turbo 03-25-2013 01:22 AM
I haven't received the ^ error recently... but here is a new one,

Code:
atabase error in vBulletin 4.2.0:

Invalid SQL:

                        SELECT  pm.*, pmtext.*
                                , icon.title AS icontitle, icon.iconpath
                       
                        FROM pm AS pm
                        LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
                        LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
                       
                        WHERE pm.userid=77 AND pm.folderid=-1
                       
                       
                        ORDER BY pmtext.dateline DESC
                        LIMIT 0, 50;

MySQL Error  : Got error -1 from storage engine
Error Number  : 1030
Request Date  : Sunday, March 24th 2013 @ 02:44:00 PM
Error Date    : Sunday, March 24th 2013 @ 02:44:00 PM
Script        : http://www.turbosaquatics.com/vb4/private.php?folderid=-1
Referrer      : https://www.turbosaquatics.com/vb4/private.php?folderid=0
IP Address    : 65.128.243.236
Username      : **********
Classname    : vB_Database
MySQL Version :
Tagged to a recently registered user whom I have communicated with, so I don't think he's a bot. What's this one?

Also I did call GoDaddy and I'm on a shared server with a database size limit of 2GB. Even though my current database is not even 200MB I have a feeling that will not be enough space, and soon.


All times are GMT. The time now is 01:04 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01290 seconds
  • Memory Usage 1,761KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete