Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 07:51 am EDT

Geeklog Forums

_sessions crashed - can't repaired it


Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
I have this problem reoccurring all the time, once per month

I switched from php4 to php 5

I have

PHP version 5.2.6
MySQL version 5.0.45-community-
log

And it the past I could repair the table and now I can't anymore and my site is down
in the past i could just select the table sessions and click repair and it would be fixed

Can I just empty sessions table?

Blue host is asking me what are the limitations they are having, they dont know, I told them that you DIrk tell me to switch but they dont know how to help. Can you give me some ideas please so I can tell them?

This is the error

Tue May 20 10:36:21 2008 - 145: Table './bb_altermed/gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '166.77.6.4' AND uid = 1

 Quote

earnest

Anonymous
I have just emptied the sessions table, and had the site come back. Maybe others will counsel against this.

-E
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
When MySQL crashes or restarts, it often affects the sessions table (see earlier discussions in the forum or this bug report).

Fortunately, the gl_sessions table doesn't contain anything too valuable. The worst that can happen is that users will have to log in again since deleting the table or its contents will end their sessions.

bye, Dirk
 Quote

All times are EDT. The time is now 07:51 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content