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-29-2007, 05:53 AM   #291
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
Originally Posted by MusicAddict911 View Post
If we post immediately after the error you can see the time stamp on the post. Plus, how are we going to help you out if nothing is done about the problem?
Quote:
Originally Posted by dude_se View Post
no hes admitted he doesnt know how to fix it.
he is trying but obviously not hard enough, it has to be said. if i had a site like this id be asking everyone for a fix and would try constantly. even at 1am
Quote:
Originally Posted by alvino View Post
Quoted for truth. Agreed.
Quote:
Originally Posted by dude_se View Post
i wouldnt say hes knocking back help, hes just being a bit anal about it all.
idk.
Quote:
Originally Posted by blackjack View Post
David I will in future post the db error times in future and apologies for my thread but it does get very frustrating at times.

Many thanks for that, I appreciate its frustrating and I hope I didn't single anyones posts out in particular.

On a good note, I've written a monitor program that connects to the database every 30 seonds and writes the result here: http://www.computerforums.org/uptime.txt so this should give us some idea of times.
__________________

__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 07-29-2007, 08:05 AM   #292
muz
Golden Master
 
muz's Avatar
 
Join Date: Oct 2006
Posts: 6,928
Default Re: DB errors

Quote:
Originally Posted by David Lindon View Post
No.

No.



I couldn't have left you a warmer welcome back or invitation to help trouble shooting. The second you return, you immediatly start bashing me with untrue comments. I invited you to a PM conversation about troubleshooting but unfortunately I see you must have refused because I have received no PMs. I guess I'm on my own again.



I want an apology for your above statement refering to me as being too proud to accept any help.




For all the members out there who want to see how rot has been troublemaking, this is it. I welcome him back with open arms and he gives me a slap in the face.





Explain to me how the following posts indicate the time of the errors:



'today', so that would be one of the 50,000 log entrys would it? How am I going to track it down?



no indiciation of an error at all





I know most of you out there with 0 faith in me aren't going to belive me but to anyone who actually wants to help, when making a post in this thread, take an extra 2 seconds, just 2 seconds and say 'David, I got an error at 12.13PM, a connection reset error' and I can go away and have a look exactly what happened at that time and track down any errors, any SQL codes that have been accessed by that page at 12.13PM and do my best to solve the problem'. Posting 10, 20minutes, days later isn't really a help.

Thanks to all those who are quick to jump up and save 'David doens't know what hes doing and isn't putting any effort in', makes the times I spent troubleshooting worth all the effort
For a start that was rfactor not rot13 but whatever , and i am sorry but you are knocking back help because the other day DJ-Chris made an offer for you to send him all the data for the forum and he would put it on his server and see if the errors still occured then but you didnt even comment on this suggestion so that seems to me like you think you can do it on your own without anyones help which if i where you i would take every offer of help people are giving
I would like to believe you are putting effort in but i have seen no evidence and i am not going to defend you when people are saying this if there is no evidence to back up that you are putting effort in sorry but i just dont work like that . In fact this log http://www.computerforums.org/uptime.txt is the first piece of evidence i have seen that you are putting effort in . Maybe keeping us updated with what you are doing and trying would be great so we at least can see that you are trying and people cant come along and critisise you and saying you arent trying hard enough
__________________

__________________
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-29-2007, 08:16 AM   #293
Daemon Poster
 
Join Date: Dec 2005
Posts: 1,153
Send a message via MSN to DannyBoy
Default Re: DB errors

It's really obvious he's trying. Even if he doesn't show evidence, give him a break god damn. If i get Future database errors i will be sure to post the time David.
DannyBoy is offline  
Old 07-29-2007, 08:18 AM   #294
muz
Golden Master
 
muz's Avatar
 
Join Date: Oct 2006
Posts: 6,928
Default Re: DB errors

Yeah i will carry on posting them with a date and time .
i would like to believe that too but its hard to defend against people saying he isnt doing anything if there is no evidence
__________________
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-29-2007, 08:57 AM   #295
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
Originally Posted by dude_se View Post
i wouldnt say hes knocking back help, hes just being a bit anal about it all.
idk.
?

Quote:
Originally Posted by muz View Post
For a start that was rfactor not rot13 but whatever , and i am sorry but you are knocking back help because the other day DJ-Chris made an offer for you to send him all the data for the forum and he would put it on his server and see if the errors still occured then but you didnt even comment on this suggestion so that seems to me like you think you can do it on your own without anyones help which if i where you i would take every offer of help people are giving
I would like to believe you are putting effort in but i have seen no evidence and i am not going to defend you when people are saying this if there is no evidence to back up that you are putting effort in sorry but i just dont work like that . In fact this log http://www.computerforums.org/uptime.txt is the first piece of evidence i have seen that you are putting effort in . Maybe keeping us updated with what you are doing and trying would be great so we at least can see that you are trying and people cant come along and critisise you and saying you arent trying hard enough
Ofcourse I appreicated DJ-chris's offer but I don't think it would be a reliable test for a number of reasons.
1) There would not be a way to test the server under load like the current CF server receives.
2) It wouldn't be very easy to trafer 30GB of data
3) there would be various security issues such as all of the cf passwords being held in that data, and many other security issues including everyones personal information. I'm not saying DJ chris would abuse it but moving it into a public area where 1 person would be able to download it makes me uneasy.
4) its not the data intself thats causing the errors, its been through vbulletin upgrades, mysql upgrades etc each time it would have been reformatted.


Quote:
I would like to believe you are putting effort in but i have seen no evidence and i am not going to defend you when people are saying this if there is no evidence to back up that you are putting effort in sorry but i just dont work like that . In fact this log
No evidence?

Lets rewind back a couple of months when everyone was going on about upgrades. I too hoped that a vbulletin upgrade would solve the db issues.

So I paid out of my own money to renew the vbulletin license and went about performing the upgrade. Easy to install vbulletin you will all say but you have to go through all the custom files such as the reply button, form logo etc that need changing from the default vbulletin one to the custom one.

Customised template code also needs to be converted.

The vbulletin upgrade didn't solve the db problem so I looked at the database software itself. I installed a newer version and setup and configured it. Bear in mind I run a number of sites with lots of databases. Each table needed to be repair and optimised as the new mysql version stored things different. SQL statements were also change so I had to go through and update the websites with the new mysql 5.x type of statements.

That still didn't solve the db errors so I turned my attention to the HTTP software. I install Apache 2.2.4 and set it up. This did have a posetive effect. There were days when I had to split the backups into 100MB files and use download managers to continue downloading the backup when the connection reset so I had check back every 30 minutes to continue the download and then move on to the next backup file batch. Now I can happily download several GBs of backups in one go.

The DB errors still continued so I turned to PHP. I installed the latest stable version and set it up. Ofcourse some PHP code was now old so I had to modify files that still used the old type and integrade the new PHP version with apache.

After all these upgrades , the db errors continued so I am now having to look closely at the PHP files and SQL queries which meant changing small things and waiting to see how they affected the stability.

Now all the obvious ideas have been worn out I am looking behind the scense at the server itself and the sites actually code.

The most recent change was to put a stop to a project I was working on which does seemed to have made a improvement.

I even created this thread so people can post error details and times to help me track them down. No evidence??

I continually ask people to help me out by posting the times.

so by your logic, because you can phyiscally see me sat at my desk working on the server I can't possibly be putting any effort in?
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 07-29-2007, 09:15 AM   #296
muz
Golden Master
 
muz's Avatar
 
Join Date: Oct 2006
Posts: 6,928
Default Re: DB errors

Quote:
Originally Posted by David Lindon View Post
?



Ofcourse I appreicated DJ-chris's offer but I don't think it would be a reliable test for a number of reasons.
1) There would not be a way to test the server under load like the current CF server receives.
2) It wouldn't be very easy to trafer 30GB of data
3) there would be various security issues such as all of the cf passwords being held in that data, and many other security issues including everyones personal information. I'm not saying DJ chris would abuse it but moving it into a public area where 1 person would be able to download it makes me uneasy.
4) its not the data intself thats causing the errors, its been through vbulletin upgrades, mysql upgrades etc each time it would have been reformatted.




No evidence?

Lets rewind back a couple of months when everyone was going on about upgrades. I too hoped that a vbulletin upgrade would solve the db issues.

So I paid out of my own money to renew the vbulletin license and went about performing the upgrade. Easy to install vbulletin you will all say but you have to go through all the custom files such as the reply button, form logo etc that need changing from the default vbulletin one to the custom one.

Customised template code also needs to be converted.

The vbulletin upgrade didn't solve the db problem so I looked at the database software itself. I installed a newer version and setup and configured it. Bear in mind I run a number of sites with lots of databases. Each table needed to be repair and optimised as the new mysql version stored things different. SQL statements were also change so I had to go through and update the websites with the new mysql 5.x type of statements.

That still didn't solve the db errors so I turned my attention to the HTTP software. I install Apache 2.2.4 and set it up. This did have a posetive effect. There were days when I had to split the backups into 100MB files and use download managers to continue downloading the backup when the connection reset so I had check back every 30 minutes to continue the download and then move on to the next backup file batch. Now I can happily download several GBs of backups in one go.

The DB errors still continued so I turned to PHP. I installed the latest stable version and set it up. Ofcourse some PHP code was now old so I had to modify files that still used the old type and integrade the new PHP version with apache.

After all these upgrades , the db errors continued so I am now having to look closely at the PHP files and SQL queries which meant changing small things and waiting to see how they affected the stability.

Now all the obvious ideas have been worn out I am looking behind the scense at the server itself and the sites actually code.

The most recent change was to put a stop to a project I was working on which does seemed to have made a improvement.

I even created this thread so people can post error details and times to help me track them down. No evidence??

I continually ask people to help me out by posting the times.

so by your logic, because you can phyiscally see me sat at my desk working on the server I can't possibly be putting any effort in?
OK 1 i juts had a white screen error at five to two or 13:55 ish and according to your log there was something around that time i dunno when it came back on as i went away for a wile to do something
Quote:
7/29 13:54:46 Failed: Lost connection to MySQL server during query
7/29 13:55:19 Failed: MySQL server has gone away
Ok then i didnt understand how much data would need to be transported so thats that idea rubbished

And 2 i dont remember you notifying the member about all this stuff , except the V bulletin upgrade i didn't bear that in mind . You also didnt tell us about abandoning a project you had . If you want us to believe you are working hard to fix it you need to notify us of what you are trying and what progress you are making .That also gives people with knowledge in this area to successfully help you troubleshoot by looking at what you have tried and thinking what else can be tried
My logic is that i am not gonna defend you if i cant see evidence that you are solving the problem . By keepng us notified of what you are doing and have tried that then shows us that david is working very hard on this problem and then when somebody like rot13 comes along we can show him look here is what david has tried if you wanna help troubleshoot do that heres what he has already tried but you cant say David isn't trying
__________________
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-29-2007, 09:30 AM   #297
Golden Master
 
dude_se's Avatar
 
Join Date: Nov 2004
Posts: 8,632
Send a message via AIM to dude_se Send a message via MSN to dude_se
Default Re: DB errors

maybe also consider hiring a co admin to help with maintaining your sites/server,
theres a lot of people on here that are capable and im sure would do it for free.
__________________
Laptop spec: ASUS X53E, i5 2430m 2.4ghz, 3gb ram, 320gb hdd, intel hd graphics, usb 3.0
dude_se is offline  
Old 07-29-2007, 09:53 AM   #298
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
OK 1 i juts had a white screen error at five to two or 13:55 ish
Thank you.

At the moment the uptime display only shows db errors, I'm still working on adding http errors
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 07-29-2007, 10:17 AM   #299
Golden Master
 
Brookfield's Avatar
 
Join Date: Apr 2005
Posts: 10,056
Default Re: DB errors

Quote:
Originally Posted by muz View Post
For a start that was rfactor not rot13 but whatever , and i am sorry but you are knocking back help because the other day DJ-Chris made an offer for you to send him all the data for the forum and he would put it on his server and see if the errors still occured then but you didnt even comment on this suggestion so that seems to me like you think you can do it on your own without anyones help which if i where you i would take every offer of help people are giving
I would like to believe you are putting effort in but i have seen no evidence and i am not going to defend you when people are saying this if there is no evidence to back up that you are putting effort in sorry but i just dont work like that . In fact this log http://www.computerforums.org/uptime.txt is the first piece of evidence i have seen that you are putting effort in . Maybe keeping us updated with what you are doing and trying would be great so we at least can see that you are trying and people cant come along and critisise you and saying you arent trying hard enough
If you post any more like this, you run the risk of sharing David's anger alongside member "rfactor"
Brookfield is offline  
Old 07-29-2007, 10:29 AM   #300
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: DB errors

Quote:
Originally Posted by Brookfield View Post
If you post any more like this, you run the risk of sharing David's anger alongside member "rfactor"
I didn't ban rfactor
__________________

__________________
[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:37 PM.


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