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 <[email protected]> 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: www.quadris.co.uk > 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 <[email protected]. > 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&sessionV > > 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 > > uadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7Cc508487920 > > c948fa441908dae2949e38%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C63 > > 8071425209591727%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV > > 2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SAj0nkOY53 > > 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. >
