When the temp directory runs out of space, the thread executing will
wait for space to become free.
If you kill the server, this client has not closed the table properly.
How do you determine that the server "crashed" ?
If it stopped responding, maybe it is just waiting for space to become
available. Killing it at this point may crash a table.
Wintercom New Media wrote:
> Hello list.
>
> I am having strange problems with my Tables since the partition had been
> running out of space and mysql crashed. I repaired all the tables and
> thought it was a success (no errors were detected anymore) but some days
> later there was an error in another table and I fixed it .... but then
> there was another error and so on. I cannot reproduce the error.
>
> The error is: 1 clients is using or hasn't closed the table properly
>
> Normally this is not a problem... just someone is using the table. But
> the table sometimes crashes.
>
> What may be my problem?
>
> Mfg
> S. winter
>
> +-----------------------------------+--------------------------------+
> | Wintercom New Media | Telefon: +49 (0)2381/378373 |
> | Eibenweg 12 | Fax: +49 (0)2381/378374 |
> | D-59071 Hamm | E-Mail: [EMAIL PROTECTED] |
> | Germany | http://www.wintercom.de |
> | | |
> | Wir freuen uns auf Ihre Anfrage...| |
> +-----------------------------------+--------------------------------+
> | Web-Design, Webhosting, Server-Housing, Netzwerktechnik und mehr |
> +-----------------------------------+--------------------------------+
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
