Jan Legenhausen writes:
>
> No other messages at all - simply repeating the query _does_ show the
> expected.
> - no message in the error log (...would have mentioned this... ;-)
> - no special thing in the normal log:
> 010318 20:41:44 7 Query alter table t_webmaster change lfdnr
> lfdnr int(10) unsigned default 0 not null auto_increment
> 010318 20:41:48 7 Query update t_webmaster set status=1 where
> type='Open'
> 010318 20:41:49 7 Query update t_webmaster set status=1 where
> type='Open'
>
> (only 2nd "update" did something)
>
> ...just did some more tests - perhaps this is relevant for this case:
>
> If i re-create this test table with "mysql mydb <testcase.sql"
> ("testcase.sql" includes a "drop table t_webmaster"), and do a
> myisamchk -vv /usr/local/var/ticketeer/t_webmaster.MYI
> immediately afterwards, i get:
>
> Checking MyISAM file: /usr/local/var/ticketeer/t_webmaster.MYI
> Data records: 1 Deleted blocks: 0
> myisamchk: warning: 1 clients is using or hasn't closed the table properly
> - check file-size
> - check key delete-chain
> block_size 1024:
> - check record delete-chain
> No recordlinks
> - check index reference
> - check data record references index: 1
> - check data record references index: 2
> - check data record references index: 3
> - check data record references index: 4
> - check data record references index: 5
> - check data record references index: 6
> - check record links
> MyISAM-table '/usr/local/var/ticketeer/t_webmaster.MYI' is usable but should
> be fixed
>
> If fix it with "myisamchk", this error disappears - but the original strange
> effect remains the same...
>
> regards, Jan
Hi!
I will re-test your case.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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