increase the timeout value in the my.ini to at least 5 minutes.
#The number of seconds the server waits for activity on an interactive
connection before closing it.
interactive_timeout=28800
#The number of seconds the server waits for activity on a connection
before closing it
wait_timeout=28800
Thomas
Von: Renaud <ma...@nopourriel.fr>
An: assp-test@lists.sourceforge.net
Datum: 15.12.2011 22:12
Betreff: [Assp-test] MySQL 105 Server Greeting Error 1156
Dear users,
I installed a new ASSP server using a MySQL database. However I see in
my logs lots of mysql error:
__________________
déc-15-11 21:58:10 [Worker_10000] Warning: got database error Database
select statement failed: MySQL server has gone away at sub
main::checkDBCon line 27 thread 1
on table whitelist - try to reconnect
déc-15-11 21:58:10 [Worker_10000] Info: reusing table <whitelist>
in mysql Database <assp>
__________________
I tried to allow more connexions on the MySQL side, but the trouble
persist. Moreover it's always this error message appearing in my logs ...
I've done a network dump and I see:
MySQL 105 Server Greeting Error 1156
According to MySQL documentation the error 1156 is due to out of order
packet (maybe in the login handshake).
Anyone got this kind of trouble and fixed it ?
Thanks for your help,
Renaud
-- Jabber: ren...@visp.im
------------------------------------------------------------------------------
10 Tips for Better Server Consolidation
Server virtualization is being driven by many needs.
But none more important than the need to reduce IT complexity
while improving strategic productivity. Learn More!
http://www.accelacomm.com/jaw/sdnl/114/51507609/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
