Go Back   Computer Forums > Welcome To Computer Forums .org > Site Admin, News and Feedback
Click Here to Login
Join Computer forums Today


Closed Thread
 
Thread Tools Search this Thread Display Modes
 
Old 07-31-2007, 09:49 AM   #351
Daemon Poster
 
Join Date: Dec 2005
Posts: 1,153
Send a message via MSN to DannyBoy
Default Re: DB errors

u went bed brookfield because of a minute error :P
7/30 21:27:29 Connected to Database Successfully
7/30 21:27:59 Connected to Database Successfully
7/30 21:28:29 Connected to Database Successfully
7/30 21:28:59 Connected to Database Successfully
7/30 21:29:29 Connected to Database Successfully
7/30 21:29:59 Connected to Database Successfully
7/30 21:30:29 Connected to Database Successfully
7/30 21:31:16 Failed: MySQL server has gone away
7/30 21:31:47 Failed: MySQL server has gone away
7/30 21:32:18 Connected to Database Successfully
7/30 21:33:41 Connected to Database Successfully
7/30 21:34:11 Connected to Database Successfully
7/30 21:34:41 Connected to Database Successfully
7/30 21:35:11 Connected to Database Successfully
7/30 21:35:41 Connected to Database Successfully
__________________

DannyBoy is offline  
Old 07-31-2007, 10:06 AM   #352
Golden Master
 
DJ-CHRIS's Avatar
 
Join Date: Apr 2006
Posts: 5,203
Send a message via AIM to DJ-CHRIS Send a message via MSN to DJ-CHRIS Send a message via Yahoo to DJ-CHRIS
Default Re: DB errors

Quote:
Originally Posted by David Lindon View Post
Yeah thats what I did, otherwise the errors would last alot longer than 1 minute!
I'm just wondering if you have tried moving the database to a new server. I have a win2k3 server that I can make internet visible, and you could throw mySQL + PHP + Apache on their and see if it's the database or software.
__________________

DJ-CHRIS is offline  
Old 07-31-2007, 02:52 PM   #353
Golden Master
 
Brookfield's Avatar
 
Join Date: Apr 2005
Posts: 10,056
Default Re: DB errors

DB's at 3.22pm BST today, logged on about 5 minutes ago, [I had chores to do] so I don't know when it came back.
Brookfield is offline  
Old 07-31-2007, 02:52 PM   #354
BSOD
 
rot13's Avatar
 
Join Date: Jul 2007
Posts: 113
Default Re: DB errors

I agree with DJ-CHRIS as I was reading this thread while I was banned and could see David Lindon talkign about how hed tried reinstalling vbulletin apache mysql etc and didn't manage to get rid of the porblem permanently.

I would also say that its looking mroe and more like a server fau;t. Not just the database errors but the white screen errors which Ive seen and a straight off connection reset in firefox indiciating a fullon server crash. Mysql can crash for numerous reasons like a dodgy sql query but its designed to restart automatically natifvely under Linux although I dont know about other platforms. I very much doubt that theres any problem with your database integrity because you would have been having deep rooted problems for years if that was the case.

Can I ask w hat the server specs are i.e. operating system & ram etc. Is it your own homebuild that youve sent off to a datacentre or are you hosting from home? Or does it belong to your hosting company? (who are the hosting company), and is it shared or dedicated?

If it was my own server I would try looking in more detail at the other processes and services/daemons running and check their ram/cpu usage and stability and if nothing comes up try doing a reinstall of your operating system. You never know it might help and wont take too long in the grand scheme of things.
rot13 is offline  
Old 07-31-2007, 02:56 PM   #355
Fully Optimized
 
hascet's Avatar
 
Join Date: Jul 2006
Posts: 3,218
Default Re: DB errors

You could also see if the forums at the mysql site could find an answer to our problem: http://forums.mysql.com/
The DB errors are getting a lot less frequent though, and a lot shorter.
__________________
www.crazycomputers.org
hascet is offline  
Old 07-31-2007, 02:58 PM   #356
BSOD
 
Join Date: Apr 2005
Posts: 6,556
Send a message via MSN to Rudster816
Default Re: DB errors

Quote:
Originally Posted by hascet View Post
You could also see if the forums at the mysql site could find an answer to our problem: http://forums.mysql.com/
The DB errors are getting a lot less frequent though, and a lot shorter.
yep short and sweet. kind of like the server saying "get a life..." lol
Rudster816 is offline  
Old 07-31-2007, 04:15 PM   #357
Golden Master
 
DJ-CHRIS's Avatar
 
Join Date: Apr 2006
Posts: 5,203
Send a message via AIM to DJ-CHRIS Send a message via MSN to DJ-CHRIS Send a message via Yahoo to DJ-CHRIS
Default Re: DB errors

Quote:
Originally Posted by Rudster816 View Post
yep short and sweet. kind of like the server saying "get a life..." lol
Yeah it's because David changed how the service responds in a crash, meaning it will restart itself. No user intervention needed.
DJ-CHRIS is offline  
Old 07-31-2007, 05:35 PM   #358
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
Originally Posted by rot13 View Post
I agree with DJ-CHRIS as I was reading this thread while I was banned and could see David Lindon talkign about how hed tried reinstalling vbulletin apache mysql etc and didn't manage to get rid of the porblem permanently.

I would also say that its looking mroe and more like a server fau;t. Not just the database errors but the white screen errors which Ive seen and a straight off connection reset in firefox indiciating a fullon server crash. Mysql can crash for numerous reasons like a dodgy sql query but its designed to restart automatically natifvely under Linux although I dont know about other platforms. I very much doubt that theres any problem with your database integrity because you would have been having deep rooted problems for years if that was the case.

Can I ask w hat the server specs are i.e. operating system & ram etc. Is it your own homebuild that youve sent off to a datacentre or are you hosting from home? Or does it belong to your hosting company? (who are the hosting company), and is it shared or dedicated?

If it was my own server I would try looking in more detail at the other processes and services/daemons running and check their ram/cpu usage and stability and if nothing comes up try doing a reinstall of your operating system. You never know it might help and wont take too long in the grand scheme of things.
Its a dedicated P4 2.8GHz, 1.5GB Ram, Sata drives etc and its owned by the datacenter (www.layeredtech.com)
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 07-31-2007, 05:37 PM   #359
muz
Golden Master
 
muz's Avatar
 
Join Date: Oct 2006
Posts: 6,928
Default Re: DB errors

And are the hosting company aware of any of the problems you are having
__________________
Desktop-AMD Athlon 64 X2 6000+-2GB Elixer DDR2 800 250gb+500gb+500gb+120gb
Laptop-Apple Macbook Pro 13" Intel core i5(2.3ghz) 4gb Ram 320gb hard drive
muz is offline  
Old 07-31-2007, 05:40 PM   #360
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
Originally Posted by muz View Post
And are the hosting company aware of any of the problems you are having
Its a unmanged dedicated server which means its up to me to run
__________________

__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 02:41 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0