[Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Geunsik Lim
Recently, I have often been getting the "Error:MySQL server has gone away" message after I enabled the multiple-user access in front web service. Here is logs. . . . Upper Omission . . . 2017-04-10 21:15:22.881 [INFO][socketio.js] socket disconnect 2017-04-10 21:15:23.858 [INFO][socketio.js

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Geunsik Lim
For reference, We are running web-based front service with nodejs package + pm2 (http://pm2.keymetrics.io/) on Ubuntu 16.04.1 server. It seems that this issue results from the too big packet size and too long waiting time between mariadb server and our nodejs-based web-service. Any hints (or Any

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Daniel Black
On 11/04/17 15:15, Geunsik Lim wrote: > For reference, We are running web-based front service > with nodejs package + pm2 (http://pm2.keymetrics.io/) on Ubuntu 16.04.1 > server. > > It seems that this issue results from the too big packet size and too > long waiting time > between mariadb serve

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Geunsik Lim
Thank you for telling me the webpage. I have got the more appropriate method thanks to you. :) On Tue, Apr 11, 2017 at 2:48 PM, Daniel Black wrote: > > > On 11/04/17 15:15, Geunsik Lim wrote: > > For reference, We are running web-based front service > > with nodejs package + pm2 (http://pm2.keym

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Geunsik Lim
I have summarized a solution after finding out some hints by running "mytop" command and digging a related source code of mariadb server. I have started running an existing our web service with the below two solutions for aging test. * EVALUATION ENVIRONMENT: --

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Geunsik Lim
4 hours is passed. The web-based service is okay with "wait_timeout=8hours" and "max_allowed_packet=100MB". I am planning to execute aging test for 3 days at least. BTW, Can we check inactivity time (e.g., wait_timeout) that MariaDB waits before it will be close a connection with "mytop" command l

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-12 Thread Geunsik Lim
Finally, I am using the below setting file to avoid "Error: MySQL server has gone away" message. I have not been getting the message for 3 days (as an aging test). Here is the related configuration files that have to be modified for Ubuntu 16.04.1 & Mariadb Server 10.0. mytizen$sudo vi /etc/mysql/