Lost connection to MySQL server during query

MySQL & MariaDB Other MySQL® Questions
1

Hi Guys

If I execute this type of select command I get following error

select Distinct B.cdlabel, cdlabelText from cdlabel A ,entrycheck B, markingqc C where B.ImageId=C.ImageId and A.cdlabel = B.cdlabel and markingqc =2 and (B.BatchidName<>0 or B.BatchidLegal<>0) and ( KeyQc=0 )and ( Key1=6) and ( Key2=6) and counterN =1 and markflag = 0 AND IMAGEORDER =1 and utility <>1 order by cdlabelText

Error Code : 2013
Lost connection to MySQL server during query
(0 ms taken)

Even this error occurs while executing in Qury browser.

I created index also.

If the DB contains minimum records the result is displayed

If DB contains more number of records “Lost connection to MySQL server during query” error displayed.

Why this error occurs and what is the solution for it?

Thanks

1 Like