Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [epf-dev] Lost Connection to MySQL
Onno,
 
Sorry for not replying earlier (day job got in the way).
 
The issue arises for all users. They are not particularly active. Just normal check-in/save/view activity gives rise to it. I will look at the server side next and get back to you.
 
Thanks again for your help to date.
 
Regards,
John
 

From: epf-dev-bounces@xxxxxxxxxxx [mailto:epf-dev-bounces@xxxxxxxxxxx] On Behalf Of Onno van der Straaten
Sent: 31 March 2011 18:09
To: Eclipse Process Framework Project Developers List
Subject: Re: [epf-dev] Lost Connection to MySQL

Hi john,
Several things could be the cause of this. It could also be that too much stuff is set on the session object, might be less than optimal application design. Does this occur with specific users? Are these users very active compared to users that don't experience these problems?
It could also be causes by timeouts of some sorts. It is possible to set a different timeout value but I have to find out how.

The MySQL log might have some additional clues to what is going wrong. Can you check what errors are reported at that side.
Best Regards,
Onno


On Thu, Mar 31, 2011 at 10:46 AM, John Allen <John.allen@xxxxxxxxxx> wrote:

Dear EPF Dev,

Somewhat speculative but I see quite a few "Mysql::Error: Lost connection to MySQL server during query" from the EPF Wiki

E.g.

  User Load (0.000000)   Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM `users` WHERE (admin='C') LIMIT 1

  Comment Columns (0.000000)   Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM `da_texts`
  User Columns (0.000000)   Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM `users`
ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM `users`):

Any suggestions as to what might be causing this? Hitting F5 always seems to fixes the problem. Is there some connection pooling settings that might be at plat?

The MySQL host is on the subnet so I would hope its not actual network related.

Thanks,
John

______________________________________________
John Allen - Solution Architect, Senior Manager
t +44 (0)207 812 4626 | m +44 (0)778 753 3602
f +44 (0)207 812 4100 | c +44 (0)207 897 9424 # 93410 59633
a Detica | 2 Arundel Street | London | WC2R 3AZ | UK
Please do not send emails to this account protectively marked as restricted or above
______________________________________________
www.detica.com – a BAE Systems company 

Please consider the environment before printing this email.

This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorised signatory.  The contents of this email may relate to dealings with other companies within the Detica Limited group of companies.

Detica Limited is registered in England under No: 1337451.

Registered offices: Surrey Research Park, Guildford, Surrey, GU2 7YP, England.

_______________________________________________
epf-dev mailing list
epf-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/epf-dev


Please consider the environment before printing this email.

This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorised signatory.  The contents of this email may relate to dealings with other companies within the Detica Limited group of companies.

Detica Limited is registered in England under No: 1337451.

Registered offices: Surrey Research Park, Guildford, Surrey, GU2 7YP, England.

Back to the top