MySQL Forums
Forum List  »  Merge Storage Engine

ERROR 2013 (HY000): Lost connection to MySQL server during query
Posted by: Helen Yelluas
Date: June 26, 2009 03:30PM

Hello everyone,

I have a problem running a simple query from merge table
The table has 22 columns , 15 keys, 3 members with exact set of indecies
Merge table has the same set.

select from each member work fine,

select count(1) from ProfilerEventMin_1441909 where DestReportObjectID=5 and SrcUserGroupID=2 and DestPort=80;
0

select count(1) from ProfilerEvent where DestReportObjectID=5 and SrcUserGroupID=2 and DestPort=80;
ERROR 2013 (HY000): Lost connection to MySQL server during query

select count(1) from ProfilerEvent where DestReportObjectID=5 and SrcUserGroupID=2 and DestPort=8;
+----------+
| count(1) |
+----------+
| 0 |
+----------+

any idea why merge table crashes on the indecies?
any setting should I check?

thank you
helen

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 2013 (HY000): Lost connection to MySQL server during query
16731
June 26, 2009 03:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.