Database error fixed -- I think! -- I hope!!

Post by **Charles L. Cotton** » Fri Dec 14, 2007 12:57 pm

I'm sure a lot of you folks experienced error messages trying to post. I've been working on it most of the morning and it seems to be fixed. If anyone has any trouble, please post the error message in this thread. It turned out to be a corrupted SQL database and I hope it's over.

I'll be upgrading to Olympus sometime later tonight or this weekend, but I'll post a separate notice about down time.

Sorry for the trouble,
Chas.

Post by **Keith B** » Fri Dec 14, 2007 1:08 pm

Seems to be working for me now Charles. Thanks!

KC5AV · Post by **KC5AV** » Fri Dec 14, 2007 1:14 pm

The only thing I've noticed is lots of multiple posts. Is that related?

Kalrog · Post by **Kalrog** » Fri Dec 14, 2007 1:19 pm

I don't see any errors anymore. I do see more duplicate posts than normal though. It could have been temporary and they won't happen any more, but it is something to keep an eye on.

Post by **Keith B** » Fri Dec 14, 2007 1:25 pm

KC5AV wrote:The only thing I've noticed is lots of multiple posts. Is that related?

Looks like even though we were getting error messages, the posts were in que, so once the issue was resolved, the database updated.

Since the database repair, they should stop.

longtooth · Post by **longtooth** » Fri Dec 14, 2007 1:31 pm

I will try mine again.

Post by **Charles L. Cotton** » Fri Dec 14, 2007 1:36 pm

Keith B wrote:
KC5AV wrote:The only thing I've noticed is lots of multiple posts. Is that related?
Looks like even though we were getting error messages, the posts were in que, so once the issue was resolved, the database updated.

Since the database repair, they should stop.

I think you're right.

Chas.

longtooth · Post by **longtooth** » Fri Dec 14, 2007 1:37 pm

Works for me now.

Kalrog · Post by **Kalrog** » Fri Dec 14, 2007 1:39 pm

Keith B wrote:Looks like even though we were getting error messages, the posts were in que, so once the issue was resolved, the database updated.

Since the database repair, they should stop.

Gotta love ACID transaction databases when they eventually roll forward.

Just think of it as a post count bump

ScubaSigGuy · Post by **ScubaSigGuy** » Fri Dec 14, 2007 3:08 pm

No problems posting here.

Thanks Charles!

Mike1951 · Post by **Mike1951** » Fri Dec 14, 2007 3:19 pm

One thing I just noticed may be an unrelated fluke.

I've been reading new posts of the 68 reported since last visit.

There were 35 on the first page and there showed to be a second page.

However, when I went to the second page, it was blank.

Post by **Charles L. Cotton** » Fri Dec 14, 2007 3:26 pm

Mike1951 wrote:One thing I just noticed may be an unrelated fluke.

I've been reading new posts of the 68 reported since last visit.

There were 35 on the first page and there showed to be a second page.

However, when I went to the second page, it was blank.

Oh no!!

Chas.

Kalrog · Post by **Kalrog** » Fri Dec 14, 2007 4:15 pm

Charles L. Cotton wrote:
Mike1951 wrote:One thing I just noticed may be an unrelated fluke.

I've been reading new posts of the 68 reported since last visit.

There were 35 on the first page and there showed to be a second page.

However, when I went to the second page, it was blank.

Oh no!!

Chas.

Let's eliminate the easy stuff first. How long did it take you to read the first page? I ask because if you had to refresh or do something like that then the "last login time" could have been updated to something much more recent (like now) and then there are no posts since last login. If nobody has seen any posts disappear, then this is most likely an issue with a parameter/variable that got reset and not posts that were deleted accidentally.

Has anyone else seen this happen? Disappearing posts?

Mike1951 · Post by **Mike1951** » Fri Dec 14, 2007 4:29 pm

Not long enough for the messages to stop showing up.

I kept refreshing and going back to the imaginary second page again and again as the count climbed to 69, 70, etc.

I never meant to imply that any posts had disappeared.

I was thinking it was just a problem with the search function.

I finally left the site with the count at 72 or 73, not quite sure, but only the first page was displaying.

LarryH · Post by **LarryH** » Fri Dec 14, 2007 4:45 pm

I experienced the same thing Mike is describing.

When I called up "new messages since last visit" and saw (approx) 61 posts found, I scrolled to the bottom to verify two pages and immediately went to the second page. Second page was empty.