Hi, The issue should have been fixed in upcoming 4.18.1.0, by https://github.com/apache/cloudstack/pull/7381
You can find 4.18.1.0-RC1 at https://download.cloudstack.org/testing/4.18.1.0-RC20230828T2026/ -Wei On Tue, 29 Aug 2023 at 10:33, Pierre-Luc Dion <[email protected]> wrote: > Hi, > > > We’ve been experimenting with the installation and upgrade of Cloudstack > 4.18 and got into this issue; where the database upgrade fail with “CALL > `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 'user_data', > > > 'id');“ resulting: Can't write; duplicate key in table '#sql-6679_5f' > > Look like this issue is related to MySQL 5.7, we’ve been getting this > error using CentOS7 + Percona-XtraDB-Cluster-57-5.7.42 > But upgrading MySQL to 8.0.33 resolved the issue. > > Would this mean that CloudStack 4.18.x would require MySQL 8 or later and > does not support MySQL 5.7 ? > > Regards, > > > From: Sanjay Kumar <[email protected]> > Date: Thursday, March 23, 2023 at 05:22 > To: [email protected] <[email protected]> > Subject: Re: Getting DB error while installing fresh cloudstack-mangment > on Rocky-Linux9 > Hi Wei, Thank you so much I was using mysql 5. 7. 41 and now we've > upgraded the mysql version and it's working now. On Thu, Mar 23, 2023 at 1: > 46 PM Wei ZHOU <ustcweizhou@ gmail. com> wrote: > Hi, > > What's the > mysql/mariadb version > ZjQcmQRYFpfptBannerStart > ATTENTION / CAUTION > Ce courriel provient de l'extérieur de l'organisation. Ne cliquez pas sur > les liens et n'ouvrez pas les pièces jointes à moins de reconnaître > l'expéditeur et de savoir que le contenu est sûr / This email originated > from outside of your organization. Do not click links or open attachments > unless you recognize the sender and know the content is safe. > ZjQcmQRYFpfptBannerEnd > > Hi Wei, > > > > Thank you so much > > > > I was using mysql 5.7.41 and now we've upgraded the mysql version and it's > > working now. > > > > > > On Thu, Mar 23, 2023 at 1:46 PM Wei ZHOU <[email protected]> wrote: > > > > > Hi, > > > > > > What's the mysql/mariadb version ? > > > > > > Can you execute the mysql statement manually ? > > > > > > CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', > 'user_data', > > > 'id') > > > > > > > > > -Wei > > > > > > On Thu, 23 Mar 2023 at 08:19, Sanjay Kumar <[email protected]> > wrote: > > > > > > > Hi All, > > > > > > > > I was installing fresh management server of new release apache > cloudstack > > > > 4.18 and getting db error. When I was installing apache cloudstack 4.17 > > > > then it is working but apache cloudstack 4.18 is not working. we are > > > > suspecting, there could be db issue or version issue? > > > > > > > > Any help will be greatly appreciated. > > > > > > > > On Thu, Mar 23, 2023 at 9:06 AM Sanjay Kumar <[email protected]> > > > > wrote: > > > > > > > > > Hi Wei, > > > > > > > > > > Thanks for your prompt response > > > > > > > > > > Please find the logs herewith. > > > > > > > > > > > > > > > > > > > > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <[email protected]> > > > wrote: > > > > > > > > > >> Hi, > > > > >> > > > > >> Can you upload the full log ? > > > > >> > > > > >> -Wei > > > > >> > > > > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <[email protected]> > > > > wrote: > > > > >> > > > > >> > Hi All, > > > > >> > > > > > >> > I was trying to fresh installation of cloudstack 4.18 on rocky > > > linux 9 > > > > >> and > > > > >> > getting db error. > > > > >> > > > > > >> > Can't write; duplicate key in table '#sql-3bb_2870 > > > > >> > > > > > >> > 2023-03-22 03:28:24,031 DEBUG [c.c.u.d.T.Transaction] (main:null) > > > > >> (logid:) > > > > >> > Rolling back the transaction: Time = 354 Name = Upgrade; called > by > > > > >> > > > > > >> > > > > > >> > > > > > > > > -TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-TransactionLegacy.close:655-DatabaseUpgradeChecker.upgrade:325-DatabaseUpgradeChecker.check:401-CloudStackExtendedLifeCycle.checkIntegrity:64-CloudStackExtendedLifeCycle.start:54-DefaultLifecycleProcessor.doStart:178-DefaultLifecycleProcessor.access$200:54-DefaultLifecycleProcessor$LifecycleGroup.start:356-Iterable.forEach:75-DefaultLifecycleProcessor.startBeans:155 > > > > >> > > > > > >> > 1. ACS_Version: 4.18 > > > > >> > 2. MysqlDB: 5.7.41 > > > > >> > > > > > >> > Any help would be really appreciated. Thank you! > > > > >> > > > > > >> > > > > > >> > With Regards, > > > > >> > > > > > >> > Sanjay > > > > >> > > > > > >> > > > > > > > > > > > > >
