Lance Lovette writes:
> I recently upgraded from MySQL 3.23.36 to 3.23.39 and now the following
> query fails.
>
> > SELECT DISTINCT Ring.*, Question.DefaultRingID, COUNT(RingMember.UserID)
> AS MemberCount FROM Ring, Question, QuestionXQuestionCategory,
> BrandXQuestionCategory LEFT JOIN RingMember ON (Ring.RingID =
> RingMember.RingID) WHERE (Ring.QuestionID = Question.QuestionID) AND
> (Question.QuestionID = QuestionXQuestionCategory.QuestionID) AND
> (QuestionXQuestionCategory.CategoryID = BrandXQuestionCategory.CategoryID)
> AND Ring.DirectoryListing = 1 AND BrandXQuestionCategory.BrandID = 1 GROUP
> BY Ring.RingID, QuestionXQuestionCategory.CategoryID HAVING (Ring.RingID !=
> Question.DefaultRingID) ORDER BY MemberCount DESC LIMIT 5
>
> ERROR 1032: Can't find record in '#sql45e7_7123_1'
>
> I ran 'myisamchk --medium-check --silent /var/lib/mysql/*/*.MYI' and nothing
> was reported.
>
> What might be causing the error?
>
> Thanks!
> Lance
Hi!
Do you always get that error when running the above query on the above
tables ??
If yes, please check space available on TMPDIR partition when the
above error occurs and check file permissions in the same dir.
If this is not a problem, we would like to test it ourselves. How big
are those tables when tar-gzipped ?
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
