MySQL Forums
Forum List  »  Federated Storage Engine

Lost Connection
Posted by: Brian Cavanagh
Date: June 27, 2008 12:58PM

I have 2 servers the remote one running 5.0.22 which holds table data, and a local one 5.0.51b. for the past 2 weeks I have used a federated table to access a view on the remote server storing the data. Everything went fine and we had a heating problem on the server earlier this week and the remote server went down. We brought it back up, and now when I run the query on the local machine I get a lost connection error when I use group function with group by. When I check the local's error log I get a pointer error, and directions to trace the stack for debugging purposses. There is no associated error in the remote's error log with the lost conection

Now I have tried the federated table on another version of mysql, 5.1.23, and works fine.

I am baffled, and I don't know what to check. Any help would be greatly appreciated.

Best,
Brian

Locl error log
stat_order.partners is the federated table

thd=0x8c017f8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb4c0d1d8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81c1860
0x8566c57
0x8567380
0x828d093
0x828d9eb
0x828f5ef
0x82251b8
0x82321d7
0x82346bf
0x823503d
0x81dd270
0x81e30c4
0x81e36c3
0x81e4d97
0x81e58e1
0xd4345b
0xc9b24e
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8c393c8 = select
p.partner_name as label,
group_concat(p.ref_id) as value
from stat_order.partners p
where
p.ref_id in (select distinct ref_id from stat_order.billing_ext)
group by p.partner_name
thd->thread_id=1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Options: ReplyQuote


Subject
Views
Written By
Posted
Lost Connection
5497
June 27, 2008 12:58PM


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.