Hi Gary, We had the same problem and increasing the wait timeout solved it.
________________________________ From: Gary Dixon <gary.di...@quadris.co.uk.INVALID> Sent: Tuesday, December 20, 2022, 9:31 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: RE: database connection lost 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%2F%2Fgithub.com%2Fapache%2Fcloudstack%2Fissues%2F4657&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc0e6e3c68e4149de9c5308dae295e6b3%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C638071430711725069%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=u%2BEUWskmwM4y%2FA4%2FEwmJOBEOsdr0ZtYKcmz2Z5X9OGg%3D&reserved=0 -Wei On Tuesday, 20 December 2022, Gary Dixon <gary.di...@quadris.co.uk.invalid> wrote: > 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 schedule to take dump from a > slave server if you have. > > Regards, > Vivek Kumar > > Gary Dixon > Senior Technical Consultant > T: +44 161 537 4990 > E: *v* <+44%207989717661>ms@quadris‑support.com > W: > https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.q > uadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc0e6e3c68e > 4149de9c5308dae295e6b3%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C63 > 8071430711725069%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV > 2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ClDbnphfgf > WJtD37XnVSa2U1n6EQOtTVYBYbUBCsAJc%3D&reserved=0 > The information contained in this e-mail from Quadris may be > confidential and privileged for the private use of the named > recipient. The contents of this e-mail may not necessarily represent the > official views of Quadris. > If you have received this information in error you must not copy, > distribute or take any action or reliance on its contents. Please > destroy any hard copies and delete this message. > Gary Dixon Senior Technical Consultant T: +44 161 537 4990 E: v<tel:+44%207989717661>ms@quadris‑support.com W: www.quadris.co.uk [cid:image011498.png@FB84B645.38DDA861] The information contained in this e-mail from Quadris may be confidential and privileged for the private use of the named recipient. The contents of this e-mail may not necessarily represent the official views of Quadris. If you have received this information in error you must not copy, distribute or take any action or reliance on its contents. Please destroy any hard copies and delete this message. On Tue, Dec 20, 2022, 7:25 PM Gary Dixon <gary.di...@quadris.co.uk. > invalid> > 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 > > believe it is being caused by mysqldumps locking the tables. > > > > Looking at the db.properties file there are tuning parameters : > > > > # CloudStack database tuning parameters > > > > db.cloud.maxActive=250 > > > > db.cloud.maxIdle=30 > > > > db.cloud.maxWait=10000 > > > > db.cloud.validationQuery=SELECT 1 > > > > db.cloud.testOnBorrow=true > > > > db.cloud.testWhileIdle=true > > > > db.cloud.timeBetweenEvictionRunsMillis=40000 > > > > db.cloud.minEvictableIdleTimeMillis=240000 > > > > db.cloud.poolPreparedStatements=false > > > > > > db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessio > > nV > > ariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, > > ER > > ROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC > > > > > > > > would changing the ‘maxwait’ value to a higher value stop the mgmt. > > service losing the db connection whilst dumps are taken ? > > > > BR > > > > > > > > Gary > > > > > > > > > > Gary Dixon > > Senior Technical Consultant > > T: +44 161 537 4990 > > E: *v* <+44%207989717661>ms@quadris‑support.com > > W: > > https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww > > .q%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc0e6e3c68e4149de9c > > 5308dae295e6b3%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C63807143 > > 0711725069%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luM > > zIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=mt9MlK3EMSW1 > > shNbTq%2B4Z9JseyTJw1Ynah305yJeq4s%3D&reserved=0 > > uadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc5084879 > > 20 > > c948fa441908dae2949e38%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C > > 63 > > 8071425209591727%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo > > iV > > 2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SAj0nkOY > > 53 > > 6UUokgQPzXfdGH6Jp2pJ1hxlqA5hAJiwY%3D&reserved=0 > > The information contained in this e-mail from Quadris may be > > confidential and privileged for the private use of the named > > recipient. The contents of this e-mail may not necessarily represent > > the > official views of Quadris. > > If you have received this information in error you must not copy, > > distribute or take any action or reliance on its contents. Please > > destroy any hard copies and delete this message. > > > > -- > This message is intended only for the use of the individual or entity > to which it is addressed and may contain confidential and/or > privileged information. If you are not the intended recipient, please > delete the original message and any copy of it from your computer > system. You are hereby notified that any dissemination, distribution > or copying of this communication is strictly prohibited unless proper > authorization has been obtained for such action. If you have received > this communication in error, please notify the sender immediately. > Although IndiQus attempts to sweep e-mail and attachments for viruses, > it does not guarantee that both are virus-free and accepts no > liability for any damage sustained as a result of viruses. >
