Has performance improved in the Forums?

[paul courry]

I got an SSI on 1/9/01 at 9:19 am et at the following address:

http://forums.itrc.hp.com:80/cm/QuestionAnswer/1,1150,0xe2bb854994d9d4118fef0090279cd0f9,00.html

[Suhas_2]

I tried posting new message as well as an answer to it...I did not get any error..
...
Suhas.

[Dan Hetzel]

Hi Shayne,

Sometimes it's nice to be the first! :-)
Here is the error I just got trying to open THIS thread.

Best regards,

Dan




Page Error:
This page has failed, and the failure has been noted. We are sorry for the inconvenience...

SEARCH: Error while evaluating SQL:

SELECT COUNT(*) AS rated_answers
FROM vgnCommunity.ct_post
WHERE parent_id = 0xd89bc3d7fb78d4118fef0090279cd0f9 AND points <> -1

Database error:
[SERVERERROR] Your transaction (process ID #40) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
while executing
"system_error "$msg""
(procedure "error" line 8)
invoked from within
"error "SEARCH: Error while evaluating SQL:\n $sql\n\n Database error:\n $vdbmsg(Message)""
(procedure "SEARCH" line 116)
invoked from within
"SEARCH TABLE rsUserRatedAnswers INTO rsUserRatedAnswers SQL "
SELECT COUNT(*) AS rated_answers
FROM vgnCommunity.ct_post
WHERE parent_id = [F..."
invoked from within
"FOREACH ROW IN [SHOW rsUserQuestions] {
[SEARCH TABLE rsUserRatedAnswers INTO rsUserRatedAnswers SQL "
SELECT COUNT(*) AS rated_answers
FROM v..."

[Ted Flanders]

Shayne,
I have seen a big improvement in performance over the last week or so! Keep up the good work.

[Patrick Wallek]

Shayne,

I got the '404 Not Found' error again when I submitted a reply to a message earlier today. This is the first one I have gotten in a few weeks. The reply did get posted anyway, even though I got the error.

[James R. Ferguson]

Hi Shayne:

The "timewarp" behavior continues. I have only seen this with the HP-UX family page, and it always presents the page stating with 01/05 and "The SAM Team..." with 64-entries. Off hand, I'd say this occurs at least 50% of the time regardless of whether or not one clears the browser cache.

The accumulated points on the HOME page also continue to be be "stuck". It seems that they too reflect values at or around 01/05, although the tally on the HP-UX page is correct regardless of the "timewarp".

Regards!

...JRF...

[Richard Darling]

Performance in terms of speed...dramatic improvement since last week.

Only other problem is not going to the most current date whn accessing the messages...intermittent problem

You are making progress...thanks
RD

[wagley 2 10-18]

Hi all,

I would like to thank everyone for their contributions to this thread and to the improvement of forums in general. As you know we released a patch on 1/4 addressing performance and the SSI errors which at least some are related to performance. Specifically we enabled a caching strategy and addressed a situation where our search engine was indexing the content of forums too frequently.

On the morning of 1/4 when we started the thread we believed the patch to be complete. However the patch kicked off a full reindex of the forums content which put a load on the servers. Therefore performance was still slugish and SSI errors were still occuring. Since the afternoon of the 4th we have noticed SSI errors to still be occuring but much less frequently and only on a small number of messages. There are some encouraging posts supporting some improvement as well.

As we work to rid ourselves of the remaining SSI errors I would like to ask for you help again. We would like to maintain a unique lists of posts that people receive SSI error against. I will start a new thread listing the specific posts that we know of. In order to maintain this list you can either send me additional encounters with SSI errors in which I will verify uniqueness and maintain the unique list in the new thread or if they are new you can post them to this new thread yourself.

We are also aware that the patch created a new problem with regard to old pages being presented and total points not being updated properly. We believe this issue is related to the caching patch. We are looking into that issue as well and will work to remedy the problem as prompt as possible. Be assured though that the points are proper in the database.

On behalf of the ITRC Forums Team, thank you for your patience and effort in improving forums.

[Dan Hetzel]

Hi Shayne,

I'm still having the 'time warp' feature...
Here is the page displayed.

Best regards,

Dan

[Rita C Workman]

Read down the msgs and noticed Dan Hetzel the first to mention what I'm seeing today (Jan 6 from Dan).

At first I thought it was me....
But when I click to go back into forums/hp-ux it is time warping...I only see from 1/5. And today is the 10th.
If I click into a subdir like databases..voila I see the 10th.

Maybe it's not the Forum Page...maybe it's the twilight zone....or maybe Jan 5 is like that Groundhog Day movie, and we're all stuck in Jan 5
Yeah, that's the ticket.....

ha ha .. anyway, that's what I'm noticing !!

Regards,
Rita

[wagley 2 10-18]

INFORMATION ABOUT THE TIME WARP BUG
....................................

Some pages are showing old content. Until we fix this bug, use the following workaraound to see the current content:

Go to the page, for instance HPUX. At the bottom of the page, click page 2. On the page 2, go to the bottom of the page and click page 1. Trust this view of the page more than going to the page directly.

[Greg Vaidman]

i used to get the SSI messages once in a while, and I haven't gotten one in the past week or so.

Also, I've noticed the time wapr problem as well. Thanks for the fix!

Haven't noticed any real performance changes - certainly pages with lots of replies can take some time to load, but it's not unbearable or anything!

Keep up the good work.

Regards,
Greg

[Steven Sim Kok Leong]

Hi,

The HP-UX main category seems to stuck at 9 Jan while the sub-categories have progressed with new posts till 13 Jan. I guess this is the "time-warp" issue that previous follow-ups have mentioned.

Apart from that, the response time appears to be faster when loading each posting. I have not encountered further SSI errors for my readings.

However, I do wonder when a version of the HP forum will be able to support brackets [] in the listing of postings.

Hope this helps. Regards.

Steven Sim
Brainbench MVP for Unix Admin
http://www.brainbench.com

[Maarten van Maanen]

To be honest,
Not for me. The forum-pages and messages load slow even though we use a 2Mb connection. Second, I still cannot access my own questions (and their answers) and get the same SSL-errors on many other questions as well. Printing still doesn't work right (have to print landscape now). For comparison, with the old HP-forum layout I never had any problems.

[Deshpande Prashant]

I received the SSI message accessing forum questions today multiple times.
Here is the error seen.

Error processing SSI file '/cm/QuestionAnswerContent/0,1154,LoggedIn!0x3dc3854994d9d4118fef0090279cd0f9!0!1!0!0!0,00.html'

Thanks.
Prashant

[James R. Ferguson · Accepted solution]

Hello Shayne et. al

WOW! Performance has really improved during the last few hours. AND, it appears that the SSI errors that were read-blocking posts by Rick Garland, Bassey Essien, Maarten van Maanen, and Berlene Herren, and others have been resolved!

Regards, Jim.

...JRF...

[Darrel Louis]

Shayne,

Thanx for the effort.
It has really improved and haven't seen SSI errors.

Keep up the Good work

Darrel

[Victor BERRIDGE]

Who pressed on the TURBO button?


Yes great improvement...

All the best
Victor

[Rita C Workman]

Oh my YES !!!!!!!

I hope your all finally sitting back with legs kicked up on your desks !!...cause you folks deserve it !

It is 'pumping' !!

Thanks a million,
Rita

[Rick Garland]

I am able to post again, no time warps are appearing, much faster, etc... I tip my hat to you!
Much better!

[Christopher Smith_2]

WOW, what happened. Things are moving GREAT!!! I also haven't received any errors this afternoon.

Keep it up!

Chris

[Patrick Wallek]

Shayne,

I have to agree with everyone else. The forums have been exceptional today. No SSI errors. We're able to read Rick's and Bassey's posts. No time warp behaviour.

Absolutely fabulous.

Now can you just leave the forums be for a while and not monkey with the design or anything so we don't have more problems? ;)

[Mike McKinlay]

No errors since yesterday ... response is about the same, though, maybe a little better overall.

Congrats!

[Dan Hetzel]

Hi Shayne,

I KNEW you would make it !!
Thanks for all your efforts.

Warmest regards,

Dan

[Carlos Fernandez Riera]

It seems run ok today.

I have put some replys and surf for many posts.

Just a question:

Why i must refresh the response window and paste again my response to get ACK from forums?

I think i must response in 30 seconds to get ACK on first try.