ERROR 1032 (HY000): Can't find record in ''

[Steve Cersosimo]

Current version: mysql-standard-4.1.11-sun-solaris2.8-sparc

I am getting this error when performing the following query. It worked in previous versions (specifically 3.23).

select User_Name,count(*) as count
from 05_08_05
where concat(Record_Date,' ',Record_Time) > date_sub(now(),interval 60 minute)
group by User_Name
order by count desc
limit 10;

This is a relatively large table 8,274,677 rows. I can provide more details if needed (table & index description, etc.).

Any help would be appreciated.

Steve