MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 24 1999 10:39pm
Subject:strage behavior ...
View as plain text  
>>>>> "Roman" == Roman D Sinyuk <roman@stripped>
> writes:

Roman> Hi All!
Roman> I have a strange behavior of mysql server:

mysql> select * from access_all where url_host_id=5455;
Roman> Empty set (0.00 sec)

mysql> select count(*) from access_all where url_host_id=5455;
Roman> +----------+
Roman> | count(*) |
Roman> +----------+
Roman> |      101 |
Roman> +----------+
Roman> 1 row in set (0.01 sec)


Roman> What does it mean ?
Roman> This happens after 3.22.13-beta to 3.22.19b upgrade, files on
Roman> /usr/local/mysql/var was untouched.

Roman> my OS is FreeBSD-stable.  


Please check your table with 'isamchk -e access_all' to verify that
this is ok !

If not, run isamchk -r 'access_all' to repair it !

strage behavior ...Roman D. Sinyuk24 Mar
  • strage behavior ...Michael Widenius25 Mar