>>>>> "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)
mysql>
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.
Hi!
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 !
Regards,
Monty
