vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   database error (https://vborg.vbsupport.ru/showthread.php?t=226744)

rd3500 10-25-2009 01:00 PM

database error
 
I just got this, something I should be concerned? I think it happened while somebod was trying to attach a picture to a discussion...

Database error in vBulletin 3.8.1:

Invalid SQL:

UPDATE session
SET lastactivity = 1256478400, location = '/ddc1/attachment.php?attachmentid=86&d=1256476678', incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 6.0; it; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)'
WHERE sessionhash = '33dc9c164a229cc62e7acdb7e6a10e49';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, October 25th 2009 @ 02:46:40 PM
Error Date : Sunday, October 25th 2009 @ 02:47:22 PM

HMBeaty 10-25-2009 01:16 PM

That is an issue with your server. You need to contact your host about this problem

TurkeySub 10-26-2009 01:56 AM

Quote:

Originally Posted by HMBeaty (Post 1905892)
That is an issue with your server. You need to contact your host about this problem

To clarify that point, it is either because you are actively using more connections to the MySQL server than your allowed or you are connected to the MySQL server longer than allowed.

If you are on a shared web hosting server, most likely this will not be something they will change as you are growing outside the shared web hosting, time for a VPS or dedi.

snakes1100 10-26-2009 03:38 AM

Quote:

Originally Posted by TurkeySub (Post 1906225)
To clarify that point, it is either because you are actively using more connections to the MySQL server than your allowed or you are connected to the MySQL server longer than allowed.

If you are on a shared web hosting server, most likely this will not be something they will change as you are growing outside the shared web hosting, time for a VPS or dedi.

To clarify your answer, if he was using to many connections, why is he not experiencing a error such as "max_connections" limit error, unfortanately, you can NOT use more connections that the server allows.

To try and help combat this issue, you should adjust the 1st of the two variables in my.cnf/my.ini & HUP sql.

wait_timeout = 120 (adjust this in multiples of 60 until the error stops.)
connect_timeout = 120

The above is NOT a fix, there are most likely issues with your coding/programs using & not closing connections or bad indexes or slow queries, these need to be looked at & corrected.

muratmunich 10-26-2009 07:21 AM

Do you get this error only when attaching something ?

Is this a 64Bit Server ?

TurkeySub 10-26-2009 09:25 AM

Quote:

Originally Posted by snakes1100 (Post 1906270)
To clarify your answer, if he was using to many connections, why is he not experiencing a error such as "max_connections" limit error, unfortanately, you can NOT use more connections that the server allows.

To try and help combat this issue, you should adjust the 1st of the two variables in my.cnf/my.ini & HUP sql.

wait_timeout = 120 (adjust this in multiples of 60 until the error stops.)
connect_timeout = 120

The above is NOT a fix, there are most likely issues with your coding/programs using & not closing connections or bad indexes or slow queries, these need to be looked at & corrected.

Good point and that brings me to another item. If the file you are trying to attach is larger than the max_packet_size in your my.cnf it will also fail to upload.

The easiest way may be to change your attachments to use the file system as opposed to the sql server, it would lead to a smaller sql DB and less work on the DB server.

snakes1100 10-26-2009 02:56 PM

If it is a max_packet issue, the site should display the DB error page, as well as generate a email as long as he set his email up in config.php.

TurkeySub 10-26-2009 07:58 PM

Quote:

Originally Posted by snakes1100 (Post 1906436)
If it is a max_packet issue, the site should display the DB error page, as well as generate a email as long as he set his email up in config.php.

Yep, just throwing it out there as it is an issue I have seen many people run into.


All times are GMT. The time now is 09:47 PM.

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.01098 seconds
  • Memory Usage 1,729KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete