RE: database connection lost

2022-12-20 Thread Gary Dixon
the last post in the article that Wei posted https://github.com/apache/cloudstack/issues/4657 Subject: Re: database connection lost Hi Gary, We had the same problem and increasing the wait timeout solved it. Gary Dixon Senior Technical Consultant T: +44 161 537 4990 E: v...@quadris

Re: database connection lost

2022-12-20 Thread Ricardo Pertuz
Hi Gary, We had the same problem and increasing the wait timeout solved it. From: Gary Dixon Sent: Tuesday, December 20, 2022, 9:31 AM To: users@cloudstack.apache.org Subject: RE: database connection lost Thanks Wei Yes we are seeing the exact same errors in

RE: database connection lost

2022-12-20 Thread Gary Dixon
Thanks Wei Yes we are seeing the exact same errors in the cs mgmt. logs - we will set the MySQL global wait timeout to a higher value and see if it resolves our issue What's the error message ? There was a github issue may help you: https://eur01.safelinks.protection.outlook.com/?url=https%3A%

Re: database connection lost

2022-12-20 Thread Wei ZHOU
What's the error message ? There was a github issue may help you: https://github.com/apache/cloudstack/issues/4657 -Wei On Tuesday, 20 December 2022, Gary Dixon wrote: > Hi Vivek > > We are using the --single-transaction flag and --skip-lock-tables flag > Could there be something other than my

RE: database connection lost

2022-12-20 Thread Gary Dixon
Hi Vivek We are using the --single-transaction flag and --skip-lock-tables flag Could there be something other than mysqldumps causing the cs mgmt. server to be losing the connection to the database ? BR Gary Hello, You can use --single-transaction Option while taking the dump or you can sc

Re: database connection lost

2022-12-20 Thread Vivek Kumar
Hello, You can use --single-transaction Option while taking the dump or you can schedule to take dump from a slave server if you have. Regards, Vivek Kumar On Tue, Dec 20, 2022, 7:25 PM Gary Dixon wrote: > Hi all > > > > CS v4.15.2 > > Hypervisor = KVM > > > > We have started to experience an

RE: database connection lost

2022-12-20 Thread Gary Dixon
Hi Wei We thought that without locking tables the mysql dumps may be inconsistent ? Hi, You can dump databases without locking tables. -Wei On Tuesday, 20 December 2022, Gary Dixon wrote: > Hi all > > > > CS v4.15.2 > > Hypervisor = KVM > > > > We have started to experience an issue on a fr

Re: database connection lost

2022-12-20 Thread Wei ZHOU
Hi, You can dump databases without locking tables. -Wei On Tuesday, 20 December 2022, Gary Dixon wrote: > Hi all > > > > CS v4.15.2 > > Hypervisor = KVM > > > > We have started to experience an issue on a frequent basis where the CS > mgmt. service is losing the connection to the database and