|
|
 |
|
|
|
register |
bbs |
search |
rss |
faq |
about
|
|
|
meet up |
add to del.icio.us |
digg it
|
|
|
| News of the Temple News about what's happening on this web site and BBS. Please keep posts on topic. |
# 1
2007-04-05, 01:49
|
|
|
MySQL errors
You may have experienced a MySQL server error by now. I'm investigating the cause of this instability and trying to find a fix, but it may take a couple of days and the BBS may be unavailable from time to time while this gets straightened out.
Please bear with me while this gets worked out.
|
# 2
2007-04-05, 01:57
|
|
Regular
|
|
Washington State
|
|
Re: MySQL errors
Thanks for all the updates Jeff. I certainly appreciate it.
|
# 3
2007-04-05, 02:11
|
|
Regular
|
|
bc
|
|
Re: MySQL errors
Just wondering.. why is PM feature disabled?
Not very many people like avatars/signatures and all that but a lot want PM feature. 
|
# 4
2007-04-05, 03:04
|
|
|
Re: MySQL errors
We're already having problems with the database, adding PM's into it would just make it worse.
|
# 5
2007-04-05, 03:26
|
|
Regular
|
|
K-W Ontario, Canada
|
|
Re: MySQL errors
Thanks for fixing the way it sorts threads. Is there a way to turn off the post minimun? It won't let us just quote someone when we think they have a good point. You have to add something to it.
|
|
#6
2007-04-05, 03:48 |
|
|
Re: MySQL errors
You are a god
|
|
#7
2007-04-05, 03:52 |
|
Regular
|
|
Staten Island New York (Ugh)
|
|
Re: MySQL errors
Maybe the SQL errors are from the UBB mover accessing the database at the same time as vBulletin?
Jeff, you should hang around a bit more, i think you may get to like the frankenstein's, or, hunter's monster youve created.
HB needs our IMG tags back, and PM's would be nice.
Oh, and I've been a faithful HB poster since it began. Ive been there for the retarded moments and the intelligent sparks. I think i would make a great mod for the forum. Just asking for you to consider it.
|
|
#8
2007-04-05, 03:56 |
wmt9 
Regular
|
|
|
|
Re: MySQL errors
Maybe the SQL errors are from the UBB mover accessing the database at the same time as vBulletin?
Jeff, you should hang around a bit more, i think you may get to like the frankenstein's, or, hunter's monster youve created.
HB needs our IMG tags back, and PM's would be nice.
Oh, and I've been a faithful HB poster since it began. Ive caused the retarded moments and had no idea what was going on during the intelligent sparks. I think i would make a great mod for the forum. Just asking for you to consider it.
Lol, Sorry jag I'm just really bored.
|
|
#9
2007-04-05, 04:58 |
White Blue Mushrooms
Regular
|
|
|
|
Re: MySQL errors
props bro'
|
|
#10
2007-04-05, 05:03 |
I_am_god
Regular
|
|
|
|
Re: MySQL errors
Reserved spot for future post.
|
|
#11
2007-04-05, 05:21 |
|
|
Re: MySQL errors
Aside from the post, quote, new topic, etc. icons, everything is looking really good cosmetically speaking. Of course, some fine tuning to get rid of database errors would really help.
I think you integrated Vbulletin seamlessly into the site itself. I noticed that the tabs on the left don't touch the sides of the browser window like they did on UBB and that it is integrated better a little better than UBB was. More functions, and it seems to load quicker (now) than UBB did. I don't exactly like how the threads are displayed, but it is just something I have to get used to I guess.
Good job Jeff, I am proud of you. =P
|
|
#12
2007-04-05, 05:22 |
|
|
Re: MySQL errors
Maybe the SQL errors are from the UBB mover accessing the database at the same time as vBulletin?
Nope. The converter only runs once a day, during the system's least-used hours in the middle of the night. After tonight's run I'm going to disable it.
I did find a couple of problems. PHP was configured to be too generous allocating time to processes, so MySQL would run out of threads.
The network card on the db server is having problems -- errors are showing up in the system message log. (I think I've fixed this with ethtool.)
MySQL was configured with some less-than-optimal settings for the size of database we have. I increased the memory allocation to better fit the size of database, but what I really need is to get more memory for the database server. I'm figuring out how much is needed right now. Looks like it's going to be somewhere in the neighborhood of 4-8GB.
Lastly, MySQL is using MyISAM tables for the database, and there are known problems with large tables stored as MyISAM files if those tables are frequently updated (lock contention problems), so I'm probably going to convert some of the key tables (posts, threads, users) over to InnoDB tables which don't have that limitation.
|
|
#13
2007-04-05, 05:35 |
robinhoody
Regular
|
|
|
|
Re: MySQL errors
Nope. The converter only runs once a day, during the system's least-used hours in the middle of the night. After tonight's run I'm going to disable it.So there are still posts from the old board that haven't come over yet?
That's mind-bottling.
|
|
#14
2007-04-05, 13:32 |
|
|
Re: MySQL errors
UPDATE:
There have been no more ethernet errors since I changed the card settings.
I got a crash course in the care and feeding of MySQL server databases last night. The BBS is now set up to use InnoDB tables, which should solve a number of problems that we were having. I've also optimized the settings the db server uses for managing InnoDB tables.
I still need to add memory to the db server, but that won't happen until later this week. Until that happens, the system won't be as fast as it could be.
Hopefully things will run a bit smoother now.
|
|
#15
2007-04-05, 13:45 |
Kooper0
Regular
|
|
|
|
Re: MySQL errors
Wahey, thanks Jeff. Good to see you fixed the forum thread ordering too and reduced the size of the username in the post.
|
|
#16
2007-04-05, 13:46 |
DivineKaos
Regular
|
|
|
|
Re: MySQL errors
Hey Jeff,
Just out of curiosity, what kind of hardware is Totse running on?
I am pretty sure I read the hardware in teh FAQ, but I am wondering if that is kept up-to date.
Thanks!
|
|
#17
2007-04-05, 13:49 |
|
|
Re: MySQL errors
Sounds great Jeff! Thanks a million and change for actually going through with this shit-storm of a change over.
I owe you one hundred dollars AND a drink now. Feel free to take me up on it whenever, man. ;)
|
|
#18
2007-04-05, 14:01 |
|
|
Re: MySQL errors
Jeff, Why are all the administrative positions fucked up?
How come is acidmelt now a regular, Zok a simple mod and Momentary Lapse Of Reason a super-moderaor?
Also, why did many mods lost their moderator title? They've not returned to regular status, but just don't have any title.
And I've seen some people with "Acolyte" title. What the different titles mean?
|
|
#19
2007-04-05, 14:24 |
maurovz
Regular
|
|
|
|
Re: MySQL errors
Jeff why don't you enable private messaging? It couldn't take that much space...
|
|
#20
2007-04-05, 14:36 |
Source
Regular
|
|
|
|
Re: MySQL errors
Whats with the post length?
|
|
#21
2007-04-05, 15:33 |
needmoney
Regular
|
|
|
|
Re: MySQL errors
y helo thar Mr. Jeffray Huntar. Is this you?
http://www.dba-oracle.com/bp/images/auth_pic_jeff_hunter.gif
;)
|
|
#22
2007-04-05, 15:47 |
missing_cipher
Regular
|
|
|
|
Re: MySQL errors
Thanks for the updates and good work on the board, must have been real hard work.
Keep it up. :)
|
|
#23
2007-04-05, 16:39 |
Leary
Regular
|
|
|
|
Re: MySQL errors
Quote:
|
Originally Posted by needmoney
y helo thar Mr. Jeffray Huntar. Is this you?
http://www.dba-oracle.com/bp/images/auth_pic_jeff_hunter.gif
;)
|
Dude, that isn't jeff.
This is jeff.
http://dannymiller.typepad.com/blog/images/jeff_hunter_1.jpg |
|
#24
2007-04-05, 17:03 |
moss2455
Regular
|
|
|
|
Re: MySQL errors
Please give hb img tags back
|
|
#25
2007-04-05, 17:27 |
|
|
Re: MySQL errors
:) yay Jeff!
|
# 26
2007-04-05, 17:49
|
|
Regular
|
|
Staten Island New York (Ugh)
|
|
Re: MySQL errors
Little known fact: Jeff actually had 8 Ethernet ports implanted in his body. All between his toes. He is currently looking to add a wireless point between his gonads.
|
# 27
2007-04-05, 18:49
|
|
Regular
|
|
Friends are Gay!
|
|
Re: MySQL errors
Good deal, I was having an error page come up every three minutes last night, and I havent had a problem all day.
Now that VB is here do you have any plans for the donation system?
|
|
#28
2007-04-05, 20:07 |
|
|
Re: MySQL errors
Dude, that isn't jeff.
This is jeff.
http://dannymiller.typepad.com/blog/images/jeff_hunter_1.jpg
Wrong. This is Jeff http://tinyurl.com/z4p5d - He's the guy on the right.
Also, what is up with the titles like Acolyte, New Arrival, ect?
EDIT: Jeff I love you.
|
|
#29
2007-04-05, 20:20 |
|
Regular
|
|
If she's easy, take'r twice.
|
|
Re: MySQL errors
in the words of mcdonalds, "i'm lovin it!"
/shoots self for using a mcdonalds referance*
but either way good to see things being straightened out man!
|
|
#30
2007-04-06, 01:18 |
maurovz
Regular
|
|
|
|
Re: MySQL errors
This is Jeff's MySpace:
http://www.myspace.com/realjeffhunter
|
# 31
2007-04-06, 05:46
|
|
Regular
|
|
Sydney
|
|
Re: MySQL errors
~werd
|
# 32
2007-04-06, 07:44
|
|
|
Re: MySQL errors
Quote:
Originally Posted by robyextreme
Just wondering.. why is PM feature disabled?
Not very many people like avatars/signatures and all that but a lot want PM feature. |
^ Yar
<3
|
# 33
2007-04-06, 13:36
|
|
Regular
|
|
take that eyepatch off
|
|
constipated smiley
My posts are still 200 lower than they should be. WTF Jeff?
|
# 34
2007-04-06, 13:59
|
|
|
Re: MySQL errors
Are you going to update the server certificate?
|
# 35
2007-04-06, 16:55
|
|
|
Re: MySQL errors
Quote:
Originally Posted by azalie
^ Yar
<3 |
You have 50 new PMs.
Yar I'm A Pirate! RANDOMhbSpammer69
Yar I'm A Pirate! RANDOMhbSpammer59
Yar I'm A Pirate! RANDOMhbSpammer67
Yar I'm A Pirate! RANDOMhbSpammer89
Yar I'm A Pirate! RANDOMhbSpammer34
Yar I'm A Pirate! RANDOMhbSpammer23
Yar I'm A Pirate! RANDOMhbSpammer51
Yar I'm A Pirate! RANDOMhbSpammer68
Yar I'm A Pirate! RANDOMhbSpammer97
Yar I'm A Pirate! RANDOMhbSpammer05
...
I have a feeling you get the point.
|
# 36
2007-04-06, 17:12
|
|
Regular
|
|
Arbiter Of Perversions
|
|
Re: MySQL errors
Quote:
Originally Posted by GusMk4
You have 50 new PMs.
Yar I'm A Pirate! RANDOMhbSpammer69
Yar I'm A Pirate! RANDOMhbSpammer59
Yar I'm A Pirate! RANDOMhbSpammer67
Yar I'm A Pirate! RANDOMhbSpammer89
Yar I'm A Pirate! RANDOMhbSpammer34
Yar I'm A Pirate! RANDOMhbSpammer23
Yar I'm A Pirate! RANDOMhbSpammer51
Yar I'm A Pirate! RANDOMhbSpammer68
Yar I'm A Pirate! RANDOMhbSpammer97
Yar I'm A Pirate! RANDOMhbSpammer05
...
I have a feeling you get the point.
|
Those who want PM's will have to suck it up and deal with spammers, and those that don't want to can disable PM's.
Problem solved.
As for the messages taxing the server resources, enforce a strict PM limit that will force users to remove old PM's to make room for new ones, and will reduce storage requirements.
|
# 37
2007-04-07, 07:39
|
|
|
Re: MySQL errors
Quote:
Originally Posted by GusMk4
You have 50 new PMs.
Yar I'm A Pirate! RANDOMhbSpammer69
Yar I'm A Pirate! RANDOMhbSpammer59
Yar I'm A Pirate! RANDOMhbSpammer67
Yar I'm A Pirate! RANDOMhbSpammer89
Yar I'm A Pirate! RANDOMhbSpammer34
Yar I'm A Pirate! RANDOMhbSpammer23
Yar I'm A Pirate! RANDOMhbSpammer51
Yar I'm A Pirate! RANDOMhbSpammer68
Yar I'm A Pirate! RANDOMhbSpammer97
Yar I'm A Pirate! RANDOMhbSpammer05
...
I have a feeling you get the point.
|
Nay 
<3
|
# 38
2007-04-07, 11:00
|
|
|
Re: MySQL errors
What. The. Fuck.
I move house and get hit in the face by vB...Hmm...I need a few pints of Guinness and a night of typing if I'm to catch up with Totse.
Good work Jeff
- Rabb
__________________
- Rabb
 - Pvt. ZeroTrace
|
# 39
2007-04-07, 17:51
|
|
|
Re: MySQL errors
Quote:
Originally Posted by Source
Are you going to update the server certificate?
|
Nice, thanks Jeff.
|
|
#40
2007-04-08, 04:40 |
hypno
Regular
|
|
|
|
Re: MySQL errors
agreed post minimum can suck my balls
|
|
#41
2007-04-08, 04:43 |
hypno
Regular
|
|
|
|
Re: MySQL errors
awww im way down to 1,933 what the fuck.
|
|
#42
2007-04-09, 07:49 |
rasta_rider
Regular
|
|
|
|
Re: MySQL errors
Jeff. the search function doesn't seem to be working properly  |
|
#43
2007-04-09, 09:38 |
makersmarkwhiskey
Regular
|
|
|
|
Re: MySQL errors
posts
|
# 44
2007-04-09, 09:39
|
|
|
Re: MySQL errors
posts
|
# 45
2007-04-09, 09:40
|
|
|
Re: MySQL errors
posts
|
# 46
2007-04-09, 09:40
|
|
|
Re: MySQL errors
posts
|
# 47
2007-04-09, 14:51
|
|
|
Re: MySQL errors
Content removed due to some conflicts
Last edited by dfgremnantsunleashed; 2007-05-11 at 07:10.
|
# 48
2007-04-11, 11:10
|
|
Regular
|
|
Paradise
|
|
Re: MySQL errors
lulz
*fucking 5 characters*
|
# 49
2007-04-12, 18:28
|
|
|
Re: MySQL errors
Don't know WHO has been pokin' the database, but they need to stop that as it's finally gotten unhappy again. Oh well, that's life though. Unhappy databases and people with sticks NOT poking dead people.
|
# 50
2007-04-13, 07:12
|
|
|
Re: MySQL errors
Search doesnt work, is there a reason you are requiring image verification for it?
|
|
#51
2007-04-13, 18:07 |
robinhoody
Regular
|
|
|
|
Re: MySQL errors
Search doesnt work, is there a reason you are requiring image verification for it?I believe that image verification is only for people who are not logged in.
That's how it is on most vB boards, and I don't see any captchas on the search page.
|
|
#52
2007-04-17, 02:05 |
helladamnleet
Regular
|
|
|
|
Re: MySQL errors
So, are there any chances of you updating the look a little bit? I think a calming shade of red would be better:o
|
|
#53
2007-04-19, 05:45 |
|
|
Re: MySQL errors
Jeff, i know you don't have time to look at my individual question, but anyone that can awnser it to the best of their ability, that would be wonderful.
Is this why I can't post any new topics? And why was i last logged in in the 1970s?
0_o
|
|
#54
2007-04-19, 16:12 |
robinhoody
Regular
|
|
|
|
Re: MySQL errors
Your last logged in date was January 1, 1970 because you had never logged in to vBulletin before today, which means the database still had a default timestamp, which would be 0.
The timestamp is measured in "UNIX time", which is a count of the seconds since the UNIX epoch began, which was on January 1, 1970 at 00:00:00 GMT.
Since your log in timestamp was 0, it was the equivalent of January 1, 1970.
|
|
#55
2007-04-22, 09:21 |
|
|
Re: MySQL errors
well, your really smart =]
i used to be a big computer geek but now adays it just seems i do too much other shit... hell i havent been on totse for months until these past few weeks, its good to be back, i dk why i got annoyed with totse in the first place
anyways, im not getting MySQL errors but it still says i cant create topics, and i cant post replies in the other forums other than this one, news of the temple
Edit: actually i just posted a reply in a thread, then when i got a reply, i tried replying to that and it says i couldnt!!! =[
something to do with it being 5 in the morning maybe? i dk
|
# 56
2007-04-24, 01:02
|
|
|
Re: MySQL errors
Quote:
Originally Posted by Jeff Hunter
Please bear with me while this gets worked out.
|
That one hurt my eyes. Wouldn't it be "bare", like if someone said to another, "Bare your pain along with me!", or, "Bare your pain to me, my friend, and I will soothe it like a savage beast!"? Talking about an animal, while referring to the toleration or commiseration of someone's pain just seems weird, so weird I can hardly bear it.
|
# 57
2007-04-24, 04:37
|
|
Regular
|
|
Arbiter Of Perversions
|
|
Re: MySQL errors
Quote:
Originally Posted by -SpectraL
That one hurt my eyes. Wouldn't it be "bare"...
|
No, Jeff used the correct "bear", as in "put up with something or somebody unpleasant".
|
# 58
2007-04-24, 13:32
|
|
|
Re: MySQL errors
Quote:
Originally Posted by robinhoody
No, Jeff used the correct "bear", as in "put up with something or somebody unpleasant".
|
I would tend to agree with you, but the dictionary seems to indicate otherwise:
Quote:
|
8. to open to view; reveal or divulge: to bare one's arms; to bare damaging new facts.
|
http://dictionary.reference.com/browse/bare
One could just as easily have said "to bare one's pain", instead of "to bare one's arms (not that I'd ever bare that jack-ass at a party or anything! God forbid! ahem...ahem...)" Now, if I was to bare my pain to you, and wanted you to commiserate with me on that, could I not ask you "Bare my pain with me, friend!"? Or would I, instead, refer to a furry mammal, when I ask you to put up and share in the unpleasant experience?
I'm not sure, but I think I just ownt you robinhoody.
[EDIT] Ok. Not wanting you to look bad or anything, I researched it further. It seems we have a contradiction in our own tools of learning. When we go to the same source, we find this:
Quote:
|
32. bear with, to be patient or forbearing with: Please bear with me until I finish the story.
|
So it appears both responses are correct, bare and bear.
Sorry to trouble you.
Last edited by -SpectraL; 2007-04-24 at 13:37.
|
# 59
2007-04-24, 17:52
|
|
Regular
|
|
Arbiter Of Perversions
|
|
Re: MySQL errors
No, both words are not correct. Only "bear" was the correct spelling.
Jeff was not asking anyone to open, expose, reveal, or uncover anything (bare). He was asking people to deal with something unpleasant (bear).
|
|
#60
2007-12-21, 20:49 |
|
|
Re: MySQL errors
UPDATE:*
|
|
#61
2007-12-21, 21:41 |
|
|
Re: MySQL errors
Wtf? I'm down 500 posts!?
|
|
#62
2007-12-27, 20:45 |
|
|
Re: MySQL errors
Tony is fat shit
|
|
#63
2007-12-28, 06:13 |
FAT_SHIT_TONY
Regular
|
|
|
|
Re: MySQL errors
yeah i agree
|
|
#64
2008-02-05, 19:48 |
|
|
Re: MySQL errors
yeah i agree
haha, pwnt
|
|
#65
2008-03-22, 03:12 |
|
|
Re: MySQL errors
BUMP!  |
|
#66
2008-04-11, 19:56 |
|
|
Re: MySQL errors
lol y u bump this?
You were the last to post in here anyway.
|
|
#67
2008-04-11, 22:01 |
|
|
Re: MySQL errors
Quote:
|
Originally Posted by Agent 008
lol y u bump this?
You were the last to post in here anyway.
|
The irony. |
# 68
2008-11-03, 07:44
|
|
|
Re: MySQL errors
Bump.
|
# 69
2009-01-04, 21:14
|
|
|
Re: MySQL errors
Since everyone else is posting off topic in old threads, so will I!!
If I get banned for this, I ask why these people aren't getting banned for the same thing:
-SpectraL
Toothlessjoe
DaGuru
Dandy Crab
Infacreep
That's just the few I could find, my computer is running too slow to look around too much.
|
# 70
2009-01-05, 19:40
|
|
Regular
|
|
Alexa > IRC Goon Squad
|
|
Re: MySQL errors
Quote:
Originally Posted by helladamnleet
Since everyone else is posting off topic in old threads, so will I!!
If I get banned for this, I ask why these people aren't getting banned for the same thing:
DaGuru
|
Why in the FUCK is my name on your lips in this thread? You could very well be the stupidest son of a bitch I've encountered on here this year. Ok, so its only a couple of days old....but you are still a mindless twit nonetheless.
Exactly why the hell are you whining for me to be banned? Or is this another screen name and one of your others that you've used is someone that I pwned on a profound scale and you have some butthurt grudge?
|
# 71
2009-01-05, 20:47
|
|
|
Re: MySQL errors
Quote:
Originally Posted by DaGuru
Why in the FUCK is my name on your lips in this thread? You could very well be the stupidest son of a bitch I've encountered on here this year. Ok, so its only a couple of days old....but you are still a mindless twit nonetheless.
Exactly why the hell are you whining for me to be banned? Or is this another screen name and one of your others that you've used is someone that I pwned on a profound scale and you have some butthurt grudge?
|
|
|
#72
2009-01-05, 23:16 |
|
Regular
|
|
Alexa > IRC Goon Squad
|
|
Re: MySQL errors
http://www.getreligion.org/wp-content/photos/kleenex.jpg
Wow....you are one helpful bitch, ain't ya? Somebody mentions..."is this another screen name and one of your others that you've used is someone that I pwned on a profound scale and you have some butthurt grudge".....and perfectly on cue you reply.
Good ole Snoopy/Xenobite/Dandy Crab and his ever changing wardrobe changes acts as exhibit "A" so perfectly for my argument. The shining example of my post above, and *WHOOSH* he knows his role like the prompt little whore that he is.
Could I have this bitch trained any better? :)
|
|
#73
2009-01-06, 04:49 |
|
|
Re: MySQL errors
Wow....you are one helpful bitch, ain't ya? Somebody mentions..."is this another screen name and one of your others that you've used is someone that I pwned on a profound scale and you have some butthurt grudge".....and perfectly on cue you reply.
Good ole Snoopy/Xenobite/Dandy Crab and his ever changing wardrobe changes acts as exhibit "A" so perfectly for my argument. The shining example of my post above, and *WHOOSH* he knows his role like the prompt little whore that he is.
Could I have this bitch trained any better? :)
The kleenex just doesn't work for you, eh? :o
http://ecx.images-amazon.com/images/I/510mdVXFnSL._SL500_AA280_PIbundle-24,TopRight,0,0_AA280_SH20_.jpg
It's okay now, dry your tearz.
|
# 74
2009-01-08, 08:09
|
|
|
Re: MySQL errors
Quote:
Originally Posted by DaGuru
Why in the FUCK is my name on your lips in this thread? You could very well be the stupidest son of a bitch I've encountered on here this year. Ok, so its only a couple of days old....but you are still a mindless twit nonetheless.
Exactly why the hell are you whining for me to be banned? Or is this another screen name and one of your others that you've used is someone that I pwned on a profound scale and you have some butthurt grudge?
|
" If I get banned for this" being the key words there, genius .
|
# 75
2009-01-08, 15:08
|
|
Regular
|
|
Alexa > IRC Goon Squad
|
|
Re: MySQL errors
Quote:
Originally Posted by helladamnleet
"If I get banned for this" being the key words there, genius .
|
For once you are going to have to actually put 3 or 4 sentences together and at least TRY to fully elaborate whatever failed point you want to make here. Why are you on this kick expecting/desiring all of these bans, locks, etc. ? Are you like Meta's wet dream....someone that revels in such silly e-moderating pettiness?
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
To the best of our knowledge, the text on this page may be freely reproduced and distributed.
totse.com certificate signatures
|
|
|
About | Community | Bad Ideas | Drugs | Ego | Erotica | Fringe | Society | Technology
|
|
|
|
|
|
![]()
![]()
|
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode