Hello.
See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Tripp Bishop wrote: > Howdy all, > > First off, We're running 5.0.15. > > Theres a particular update statement that we run that > updates data in several tables. On our mac OSX test > server (also running 5.0.15) the query executes > quickly and without any errors or warnings. > > On our linux box, which is our production box, we get > the following error as soon as the query is executed: > > ERROR 2013 (HY000): Lost connection to MySQL server > during query > > The databases have a similar amount of data in them. > > I've googled on the error but mostly get pages > containing questions about the error when generated by > stored procedures and mostly on 5.0.3. We're not using > stored procedures. This is just a straight-up query. > > Here's the query: > > UPDATE customer_indicator > INNER JOIN customer_search_pref ON > customer_search_pref.customer_id = > customer_indicator.customer_id AND > customer_search_pref.office_id = > customer_indicator.office_id > LEFT JOIN contact_log ON > contact_log.customer_id = > customer_indicator.customer_id > LEFT JOIN sent ON sent.pref_id = > customer_search_pref.pref_id > SET customer_indicator.office_id = 33, > customer_search_pref.office_id =33, > customer_indicator.agent_id = 105, > sent.office_id = 33, > contact_log.office_id = 33, > customer_indicator.next_message_id = 4403 > WHERE customer_indicator.customer_id = 78437 AND > customer_indicator.office_id = 34; > > The approximate sizes of the tables involved are: > > customer_indicator: 40K records > customer_search_pref: 45K > contact_log: 390K > sent: 20M (million) > > So my question is, what are some possible causes of > this error? Why would trying to execute this query > cause the connection to be lost? Why would the query > work fine on our mac system and fail on the prodcution > box? > > Thanks, > > Tripp > > > > __________________________________________ > Yahoo! DSL Something to write home about. > Just $16.99/mo. or less. > dsl.yahoo.com > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
