Mike Linksvayer at 19:45, 5 January 2006

2006-01-05T19:45:35Z

New page

Sometimes the database server crashes on ccmixter and needs to be restarted. There is a watchdog script to restart it but there is a need possibly to run a repair command on the phpbb_sessions as shown below:

<pre>
$ mysql -u XXXXXX -h XXXXXX -p XXXXXX
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'phpbb_sessions'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is XXX to server version: XXXXXXX

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> repair table phpbb_sessions
-> ;
+-----------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+--------+----------+------------------------------------------+
| mixter.phpbb_sessions | repair | warning | Number of rows changed
from 1759 to 1690 |
| mixter.phpbb_sessions | repair | status | OK |
+-----------------------+--------+----------+------------------------------------------+
2 rows in set (0.25 sec)

...

Is there any reason for a session to be created before login?

On Thu, 2005-11-24 at 11:52 -0800, Victor wrote:
> looks like the db is confused for non-logged in folks:
>
> --------------------------------------------------
> phpBB : Critical Error
>
> Error creating new session
>
> DEBUG MODE
>
> SQL Error : 1062 Duplicate entry '-1' for key 2
>
> INSERT INTO phpbb_sessions (session_id,
> session_user_id, session_start, session_time,
> session_ip, session_page, session_logged_in) VALUES
> ('619979eadf190dbb52abae05f3c94134', -1, 1132843628,
> 1132843628, '457919b3', 0, 0)
>
> Line : 158
> File : sessions.php
>
> --------------------------------------------------
>
> maybe emptying the phpbb_sessions table might just
> clear things out??? -- I don't know. (I can't log in
> or terminal in from where I'm at)
>
>
> VS

</pre>

[[Category:CcMixter]]

Restarting CC Mixter - Revision history

Mike Linksvayer at 19:45, 5 January 2006