qntmfred retired 40726 Posts user info edit post |
hello all, as i attempt to address the issues described in message_topic.aspx?topic=538529 you may experience periods of site unavailability or otherwise unusual site behavior. i expect this to continue through the rest of the evening. thanks for both your patience and candor during this difficult time. yours, qntmfred 12/1/2008 9:29:44 PM |
dakota_man All American 26584 Posts user info edit post |
12/1/2008 9:30:02 PM |
simonn best gottfriend 28968 Posts user info edit post |
luv u qntmfred. 12/1/2008 9:30:23 PM |
Skwinkle burritotomyface 19447 Posts user info edit post |
That means I'd have no excuse not to do my work 12/1/2008 9:30:26 PM |
Tiberius Suspended 7607 Posts user info edit post |
dear god, is there not a development instance this can take pla...ha...hahaha
nevermind
I forgot which website I was on for a second 12/1/2008 9:31:53 PM |
gunzz IS NÚMERO UNO 68205 Posts user info edit post |
luv u qntmfred. 12/1/2008 9:32:31 PM |
EMCE balls deep 89771 Posts user info edit post |
thx man 12/1/2008 9:32:32 PM |
qntmfred retired 40726 Posts user info edit post |
^^^actually there is. now.
but there's only one production database, and that's where the trouble is
[Edited on December 1, 2008 at 9:36 PM. Reason : i even got continuous integration set up on this biatch] 12/1/2008 9:32:47 PM |
Tiberius Suspended 7607 Posts user info edit post |
lol, I stand corrected then
out of curiosity how are you collecting data regarding the issue?
I assume it's MSSQL? 12/1/2008 9:38:13 PM |
qntmfred retired 40726 Posts user info edit post |
it is mssql. it's failing on authentication so i checked the user indices and the fragmentation is > 99% so i'm gonna rebuild them and we'll see how that goes 12/1/2008 9:40:09 PM |
evan All American 27701 Posts user info edit post |
Quote : | "and the fragmentation is > 99%" |
well that would certainly explain it
mssql is for dookie shit12/1/2008 9:46:12 PM |
Skack All American 31140 Posts user info edit post |
THANX FOR THE WARNING. I didn't pay $5 six years ago to be treated like this.
lol, jk. Fix this shit and make it stop sucking.
[Edited on December 1, 2008 at 9:48 PM. Reason : l] 12/1/2008 9:48:45 PM |
evan All American 27701 Posts user info edit post |
tww won't stop sucking until we move away from ASP and MSSQL... that is, completely away from crazyweb 12/1/2008 9:50:43 PM |
qntmfred retired 40726 Posts user info edit post |
i dunno. between crazyweb and phpBB
i'd prolly still go with crazyweb 12/1/2008 9:54:24 PM |
joe17669 All American 22728 Posts user info edit post |
evan your TWW killer really worked out well, didn't it? 12/1/2008 9:54:54 PM |
evan All American 27701 Posts user info edit post |
no, it was horrible
Quote : | "i dunno. between crazyweb and phpBB
i'd prolly still go with crazyweb" |
i would too... but phpBB is a complete sack of bloated shit... crazyweb is just a sack of partially digested food.
i love how lightweight it is... i think that if it were written properly, it'd be pretty awesome.]12/1/2008 9:56:08 PM |
zorthage 1+1=5 17148 Posts user info edit post |
how hard can it be to port the TWW codebase to another language 12/1/2008 9:56:35 PM |
Tiberius Suspended 7607 Posts user info edit post |
lol, I must admit I was hoping for a slightly more interesting answer
on another note, if you get a chance can you confirm my suspicion that the transactions for reading and updating the flood control timestamp are occuring seperately?
I've long suspected that's what's causing mega ultra double posts, and if so it should be fairly easy to combine the read and update into one transaction with a return value ;-p 12/1/2008 10:01:38 PM |
moron All American 34142 Posts user info edit post |
crazyweb is pretty quick when it's working (TWW is one of the fastest sites I browse), but it seems to go down a lot, and has lost more data than any other messageboard I know of. 12/1/2008 10:02:59 PM |
BIGcementpon Status Name 11318 Posts user info edit post |
12/1/2008 10:04:24 PM |
qntmfred retired 40726 Posts user info edit post |
^^ those are hosting and management problems
which i guess reduces to a management problem
[Edited on December 1, 2008 at 10:10 PM. Reason : tiberius you're probably right on the transaction thing, i'll take a peek when i get a chance.] 12/1/2008 10:10:14 PM |
Noen All American 31346 Posts user info edit post |
As a longtime php developer, evan it doesn't matter.
A well designer ASP.Net app will be just as performant as a PHP built one. And MSSQL, again if used properly, is ridiculously fast and reliable. MySQL is just now really catching up to it in many areas.
No reason to throw the baby out with the bathwater, things just need an overhaul, mainly the database. I'd bet a schema change and a newly designed DB to take advantage of MSSQL would help quite a bit. The rest is just nit picky feature requests. 12/1/2008 11:06:16 PM |
evan All American 27701 Posts user info edit post |
oh, i know, i've done plenty of work in both environments
i just hate ASP and MSSQL
open source for the motherfucking win.] 12/1/2008 11:07:53 PM |
BigEgo Not suspended 24374 Posts user info edit post |
12/1/2008 11:08:39 PM |
Sputter All American 4550 Posts user info edit post |
i can't read but like one out of every 8 words in this thread
but i am glad you are fixing this log in problem
twas annoying 12/1/2008 11:14:44 PM |
evan All American 27701 Posts user info edit post |
i'm really tempted to use javascript to remove all words on this page except for every 8th word
but i won't
12/1/2008 11:18:10 PM |
qntmfred retired 40726 Posts user info edit post |
fyi this is probably going to continue overnight as well. i can't tell if mssql is choking on the rebuild or if it's just taking damn forever so i'm gonna let it go overnight and see what's up in the morning.
gnight tdub 12/1/2008 11:46:17 PM |
GREEN JAY All American 14180 Posts user info edit post |
i have not experienced any wonky shit yet 12/1/2008 11:47:27 PM |
Tiberius Suspended 7607 Posts user info edit post |
MSSQL is actually pretty sweet except for the fact that it costs bux
it had stored procedures ages before MySQL
I just now noticed how TWW looks like the standard ASP form designer output in State Red instead of Microsft Grey, lol 12/1/2008 11:55:02 PM |
Noen All American 31346 Posts user info edit post |
^^^
If it's any consolation, our division had to do a full DB rebuild a couple of week ago. It took 5 days, and that is on insano hardware. So yeah, it's probably just taking a while (I know 6-18 hours is pretty common 95% case for a populated rebuilt/reindex) 12/2/2008 4:24:57 AM |
qntmfred retired 40726 Posts user info edit post |
bttt for round 2 12/2/2008 10:19:55 AM |
EMCE balls deep 89771 Posts user info edit post |
you stole my word I am upset
[Edited on December 2, 2008 at 10:21 AM. Reason : also, thanks again. you're awesome] 12/2/2008 10:21:20 AM |
Str8BacardiL ************ 41754 Posts user info edit post |
Whenever i am gonna log in i just bring some bread, cheese, ham, turkey, mayonnaise, mustard, and a toaster upstairs and sit it on my desk.
I start the login process and then fix the sandwich, once I am done eating the sandwich it is usually done. 12/2/2008 10:59:07 AM |
qntmfred retired 40726 Posts user info edit post |
^ aha so you're boxwine. i was wondering who that was on facebook 12/2/2008 11:03:00 AM |
Str8BacardiL ************ 41754 Posts user info edit post |
hah actually its not me but I am pretty sure its a TWW'r 12/2/2008 11:09:20 AM |
pilgrimshoes Suspended 63151 Posts user info edit post |
well no shit it's a tww'r
but who
i haven't accepted the friend request yet, but i know like 40 of you fuckers that have
12/2/2008 11:11:45 AM |
DeltaBeta All American 9417 Posts user info edit post |
qntmfred, as an experienced TWW user, I have to come to expect wonky shit to be imminent at any time. However, I do appreciate the early warning. It is like warning me that my peanut butter will be creamy, but a warning is nice none the less.
[Edited on December 2, 2008 at 11:23 AM. Reason : *] 12/2/2008 11:23:40 AM |
Sputter All American 4550 Posts user info edit post |
the log-in function is still wonky....
it may be my fault though cause i have such a non-leet (attempt at communicating with computer saavy folks) computer 12/5/2008 12:33:55 PM |
qntmfred retired 40726 Posts user info edit post |
no, it's still messed up. i've been working on it little by little in between stuff at work
[Edited on December 5, 2008 at 12:37 PM. Reason : it's been a little better, but not there yet] 12/5/2008 12:36:43 PM |
Str8BacardiL ************ 41754 Posts user info edit post |
Quote : | "WONKY
SHIT
IMMINENT" |
12/5/2008 3:15:19 PM |
Str8BacardiL ************ 41754 Posts user info edit post |
WTF
Mah shiyt just loaded in times new roman 12/10/2008 11:39:06 AM |
ReceiveDeath INEED2 GET HIRITENOW 70284 Posts user info edit post |
I never had any trouble with BubbleBobble logging in slow but RD took about 15 seconds earlier
I don't really care though, I can find other things to do in that time 12/10/2008 12:47:03 PM |
baonest All American 47902 Posts user info edit post |
bttt
this crap is wonky ALL THE TIME.
plz fix 12/15/2008 12:02:54 AM |
qntmfred retired 40726 Posts user info edit post |
yeah, sorry. i've had other things to do lately. don't forget to bother nael about it. i do what i can, when i can, but it's still his responsibility 12/15/2008 12:01:28 PM |
Big Business Suspended 9099 Posts user info edit post |
how do you bother that which does not use this site
I'm Big Business and i approved this message. 12/15/2008 12:02:52 PM |
Fermat All American 47007 Posts user info edit post |
and for those of you that feel like exploiting the static cookies hole, today might be a great opportunity 12/15/2008 12:06:42 PM |
qntmfred retired 40726 Posts user info edit post |
uh no 12/15/2008 12:18:44 PM |
Shadowrunner All American 18332 Posts user info edit post |
Quote : | "STATIC
COOKIES
HOLE" |
12/15/2008 12:21:49 PM |
Woodfoot All American 60354 Posts user info edit post |
Quote : | "STATIC
DOOKIE
HOLE" |
12/15/2008 12:23:59 PM |
djeternal Bee Hugger 62661 Posts user info edit post |
set em up 12/15/2008 2:59:58 PM |