[PHPLIB] MySQL isamchk results in active_sessions error From: Eric Ries (eric.ries <email protected>)
Date: 12/17/99

Here's a strange one for you today... I just started using isamchk (a MySQL
tool) to optimize tables in m database. I ran the following commands:

isamchk /var/lib/mysql/*/*.ISM -S -r -w -s

which "repairs" tables, purging deleted data, etc. Also re-sorts the column
by its primary index

as well as

isamchk /var/lib/mysql/*/*.ISM -s -w

which just checks for errors

and

isamchk /var/lib/mysql/*/*.ISM -a -w

which "optimizes joins" by analyzing data layout in the table.

As soon as I did this, my users started getting the following error:

</td></tr></table></table></form><b>Database error:</b> Invalid SQL: insert
into active_sessions ( sid, name, val, changed )
values ( 'be338e364f63d9871e4b9024afb3a7f4', 'Poe_Session', '$this->in =
""; $this->pt = array(); $this->pt["auth"] = "1"; $this->pt["challenge"] =
"1"; $GLOBALS["auth"] = new Poe_Challenge_Auth; $GLOBALS["auth"]->auth =
array(); $GLOBALS["auth"]->auth["uid"] = "form"; $GLOBALS["challenge"] =
"fed0997faebbcfc15f9347ba6b19eb53"; ', '19991217164602')<br>
<b>MySQL Error</b>: 1062 (Duplicate entry
'Poe_Session-be338e364f63d9871e4b9024afb3a7f4' for key 1)<br>

which I am having trouble reproducing. Any ideas? I'm getting about 3
emails/minute from people trying to register for my site!

Thanks,

Eric

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.