On topic: deathhare's posts
03-12-08, 05:14 PM
#77
Sir Fallalot
Join Date: Jul 2006
Posts: 5,286
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 13 Times
in
11 Posts
mmmmm kay. Now magically it works perfectly. No, I didnt clear cookies manually. It works under this username like normal for the fist time since last night. I mean it - I had the exact problem that several of us had. No way to use the forums all day.
Whatever happened has now been undone.
Whatever happened has now been undone.
I can't believe I can actually post without having to retry 5-6 times.
03-12-08, 05:18 PM
#79
thomas masini lives
Thread Starter
Join Date: Sep 2006
Location: i aint dh no mo'
Posts: 3,495
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
He apparently removed his imposed hold on your accounts because deathhare still doesnt work.
Seems clear to me that Brian is responsible for this.
Seems clear to me that Brian is responsible for this.
03-12-08, 05:21 PM
#80
Sir Fallalot
Join Date: Jul 2006
Posts: 5,286
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 13 Times
in
11 Posts
Hey DH, thank you for this! I would have never though this was -personally- directed at me, I thought everybody had the same problem due to some server upgrade or something, but today I started to be impatient and was about to ask some folks I know here, whether they were experiencing the same performance problems. I just couldn't believe BF would allow such catastrophically low performance for more than a few hours.
03-12-08, 05:25 PM
#81
thomas masini lives
Thread Starter
Join Date: Sep 2006
Location: i aint dh no mo'
Posts: 3,495
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
Its pretty fishy that us three..that were in with most of the heat in SSFG on the Tommasini issue immediately had this problem. And now Brian is starting to un-do it?
Im sure there will be some great excuse for all of this.
Im sure there will be some great excuse for all of this.
03-12-08, 05:34 PM
#82
Sir Fallalot
Join Date: Jul 2006
Posts: 5,286
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 13 Times
in
11 Posts
Fact is, Siu Blue Wind went down pretty hard on both deathhare and me, not sure if luv_hooters got the special treatment, too - but I guess is he might have. Whoever is doing this, has a vindictive personality and I fear him/her great deal and am happy I (probably) don't live in the same city as him/her!
03-12-08, 05:36 PM
#83
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
I had closed the SS/Fixie forums briefly a couple of times over the last few days. I'm guessing anyone who was logged in during one of those periods got pooched. Even though I fix SQL databases all day long, I can't seem to find the specific cause, but simply querying the user tables seems to fix things.
03-12-08, 05:38 PM
#84
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
Would you like a foil hat? If anyone else is having issues, it will need to wait until I finish my dinner.
03-12-08, 05:45 PM
#85
Sir Fallalot
Join Date: Jul 2006
Posts: 5,286
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 13 Times
in
11 Posts
I had closed the SS/Fixie forums briefly a couple of times over the last few days. I'm guessing anyone who was logged in during one of those periods got pooched. Even though I fix SQL databases all day long, I can't seem to find the specific cause, but simply querying the user tables seems to fix things.
03-12-08, 06:15 PM
#86
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
Doofo (or deathhare), give it up. Not only can we not log you out, but there would be no reason to. If we didn't want you logged in, we'd just ban you.
03-12-08, 06:22 PM
#87
Senior Member
Join Date: Dec 2007
Location: San Jose, California
Posts: 3,504
Bikes: 2001 Tommasini Sintesi w/ Campagnolo Daytona 10 Speed
Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 145 Post(s)
Likes: 0
Liked 35 Times
in
30 Posts
Hey Brian...
IT guy here...not a dB expert...but I do know a few things can go on with forum apps...
Oftentimes when you apply auditing features, user and log monitoring features, it is going to cause some module(s) built into the forum software to work overtime eating up CPU cycles and RAM and disk swap when an audited/monitored user or IP address generates activity. And of course since the session cookies, logs and such are in this case being fed into MySQL/Oracle/PSQL it effectively loads the hard drive again...
Your queries at the shell SQL level in text mode simply flushed some cached tables and buffers freeing up some memory and thereby speeding things up a tad...
So chances are, you just need to stop or lower some threshhold of any admin utility interface used to apply infraction points, language filtering, ip and user log and activity monitoring.
And for those who don't like reading the above...
...take a deep breath, exhale slowly...relax the fists and fingers...it is not much different from school teachers and vp's monitoring the playground for a day or so after a little fight between us kids...um...excuse me...us adults...
So relax guys....
...and Brian...just take care of it please....
Thanks!
=8-)
IT guy here...not a dB expert...but I do know a few things can go on with forum apps...
Oftentimes when you apply auditing features, user and log monitoring features, it is going to cause some module(s) built into the forum software to work overtime eating up CPU cycles and RAM and disk swap when an audited/monitored user or IP address generates activity. And of course since the session cookies, logs and such are in this case being fed into MySQL/Oracle/PSQL it effectively loads the hard drive again...
Your queries at the shell SQL level in text mode simply flushed some cached tables and buffers freeing up some memory and thereby speeding things up a tad...
So chances are, you just need to stop or lower some threshhold of any admin utility interface used to apply infraction points, language filtering, ip and user log and activity monitoring.
And for those who don't like reading the above...
...take a deep breath, exhale slowly...relax the fists and fingers...it is not much different from school teachers and vp's monitoring the playground for a day or so after a little fight between us kids...um...excuse me...us adults...
So relax guys....
...and Brian...just take care of it please....
Thanks!
=8-)
03-12-08, 06:26 PM
#88
thomas masini lives
Thread Starter
Join Date: Sep 2006
Location: i aint dh no mo'
Posts: 3,495
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
That issue is pretty irrelevent anyway at this point and I dont care what you can or cant do at all.
I doubt any of us do.
I just want my name back.
Last edited by doofo; 03-12-08 at 06:36 PM.
03-12-08, 06:27 PM
#89
Senior Member
Join Date: Dec 2007
Location: San Jose, California
Posts: 3,504
Bikes: 2001 Tommasini Sintesi w/ Campagnolo Daytona 10 Speed
Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 145 Post(s)
Likes: 0
Liked 35 Times
in
30 Posts
Might also want to consider increasing the amount of SQL tables cached in memory by 8M, 16M or 32M via the SQL daemon command line or config file if you admins/mods think it can be done without affecting overall server performance.
=8-)
=8-)
03-12-08, 07:00 PM
#90
Tell them I hate them
Join Date: Oct 2006
Location: Boise, ID
Posts: 939
Bikes: Specialized Allez Epic '91, IRO Mark V Pro, Schwinn Traveler
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Seriously though, I never sign out either at home or work. All morning everything is fine, but then midday it took me at least 15 minutes to post this which happened to conclude a pretty heated exchange (all gone via Cuda2k(?)) I even mention it in the post. Then just before going home, everything is fine. I get home to my still signed in PC, everything's fine.
Good luck DH.
Good luck DH.
03-12-08, 07:22 PM
#91
Your imaginary friend.
Join Date: Jul 2007
Location: Wandering aimlessly.
Posts: 2,211
Bikes: A sweet Quamen ATL custom, GT Mach 2
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Noone answered my question, I am confused.
__________________
Every passing minute is another chance to turn it all around.
Every passing minute is another chance to turn it all around.
03-12-08, 07:34 PM
#92
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
Seriously though, I never sign out either at home or work. All morning everything is fine, but then midday it took me at least 15 minutes to post this which happened to conclude a pretty heated exchange (all gone via Cuda2k(?)) I even mention it in the post. Then just before going home, everything is fine. I get home to my still signed in PC, everything's fine.
Good luck DH.
Good luck DH.
03-12-08, 07:49 PM
#93
Banned.
Join Date: Apr 2006
Posts: 852
Bikes: IRO Rob Roy
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
So computers, software, and all teh internets work perfect all the time for all of you except for the last day on BF? Homeland Security must love you guys.
03-12-08, 07:53 PM
#94
Tell them I hate them
Join Date: Oct 2006
Location: Boise, ID
Posts: 939
Bikes: Specialized Allez Epic '91, IRO Mark V Pro, Schwinn Traveler
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
03-12-08, 09:23 PM
#95
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
Looks like Lotek was able to run a script that fixed deathhare's account. He reindexed something. Seems like a shortcut to what I did. Or perhaps he remembered to drop a table and commit. Whatever. It's fixed.
03-12-08, 09:31 PM
#96
Senior Member
Join Date: Dec 2001
Location: n.w. superdrome
Posts: 17,687
Bikes: 1 trek, serotta, rih, de Reus, Pogliaghi and finally a Zieleman! and got a DeRosa
Mentioned: 6 Post(s)
Tagged: 0 Thread(s)
Quoted: 15 Post(s)
Likes: 0
Liked 9 Times
in
9 Posts
I think it might have fixed it. One of the tables looked suspiciously fragmented, and yes
time stamps were right around the tommasini (crown) affair. We also were moving posts rather quickly,
3 or 4 people modding it at the same time. I suspect we somehow broke pointers (not really sure here)
but I've seen similar problems with tables in mainframe env. I suggested reorg of the tables (especially user tables) and reindexing of them.
Not sure that it works but the table structures look better to me.
Let me know if it still farked.
Marty
time stamps were right around the tommasini (crown) affair. We also were moving posts rather quickly,
3 or 4 people modding it at the same time. I suspect we somehow broke pointers (not really sure here)
but I've seen similar problems with tables in mainframe env. I suggested reorg of the tables (especially user tables) and reindexing of them.
Not sure that it works but the table structures look better to me.
Let me know if it still farked.
Marty
__________________
Sono pił lento di quel che sembra.
Odio la gente, tutti.
Want to upgrade your membership? Click Here.
Sono pił lento di quel che sembra.
Odio la gente, tutti.
Want to upgrade your membership? Click Here.
03-12-08, 09:52 PM
#97
Senior Member
Join Date: Nov 2004
Location: Between the mountains and the lake.
Posts: 16,681
Bikes: 8 bikes - one for each day of the week!
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
select* from ddb_usergroup_whiners...
[edit] just kidding!
[edit] just kidding!
03-12-08, 10:03 PM
#98
.
Join Date: Sep 2006
Posts: 3,860
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Thomas Eni sent me a PM saying he's having trouble too staying logged in. Can anyone help?
03-12-08, 10:07 PM
#99
tired
Join Date: Apr 2006
Location: Portland, OR
Posts: 5,651
Bikes: Breezer Uptown 8, U frame
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 2 Times
in
2 Posts
Maybe send lotek a PM, blickblocks? Looks like he's off for the night.
__________________
"Real wars of words are harder to win. They require thought, insight, precision, articulation, knowledge, and experience. They require the humility to admit when you are wrong. They recognize that the dialectic is not about making us look at you, but about us all looking together for the truth."
"Real wars of words are harder to win. They require thought, insight, precision, articulation, knowledge, and experience. They require the humility to admit when you are wrong. They recognize that the dialectic is not about making us look at you, but about us all looking together for the truth."
03-12-08, 10:45 PM
#100
thomas masini lives
Thread Starter
Join Date: Sep 2006
Location: i aint dh no mo'
Posts: 3,495
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
thanks to everyone that helped to fix this issue
i'd like to reiterate that i believe this was an unfortunate coincidence and nothing more
i wish that deathhare hadn't made accusations using my account
but keep in mind that a day without bikeforums is more than some of us can bear
lol
i'd like to reiterate that i believe this was an unfortunate coincidence and nothing more
i wish that deathhare hadn't made accusations using my account
but keep in mind that a day without bikeforums is more than some of us can bear
lol