You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Sanjay Kumar <ss...@gmail.com> on 2023/03/23 07:18:13 UTC
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
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 <ss...@gmail.com> wrote:
> Hi Wei,
>
> Thanks for your prompt response
>
> Please find the logs herewith.
>
>
>
> On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com> wrote:
>
>> Hi,
>>
>> Can you upload the full log ?
>>
>> -Wei
>>
>> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <ss...@gmail.com> 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
>> >
>>
>
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
Posted by Pierre-Luc Dion <pd...@voilevacance.ca>.
Looks good, Thanks Wei.
On Tue, Aug 29, 2023 at 4:43 AM Wei ZHOU <us...@gmail.com> wrote:
> 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 <pd...@hypertec.com> 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 <ss...@gmail.com>
> > Date: Thursday, March 23, 2023 at 05:22
> > To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
> > 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 <us...@gmail.com> 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 <ss...@gmail.com>
> > 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 <ss...@gmail.com>
> >
> > > > wrote:
> >
> > > >
> >
> > > > > Hi Wei,
> >
> > > > >
> >
> > > > > Thanks for your prompt response
> >
> > > > >
> >
> > > > > Please find the logs herewith.
> >
> > > > >
> >
> > > > >
> >
> > > > >
> >
> > > > > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com>
> >
> > > wrote:
> >
> > > > >
> >
> > > > >> Hi,
> >
> > > > >>
> >
> > > > >> Can you upload the full log ?
> >
> > > > >>
> >
> > > > >> -Wei
> >
> > > > >>
> >
> > > > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <sslinuxpath@gmail.com
> >
> >
> > > > 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
> >
> > > > >> >
> >
> > > > >>
> >
> > > > >
> >
> > > >
> >
> > >
> >
>
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
Posted by Wei ZHOU <us...@gmail.com>.
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 <pd...@hypertec.com> 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 <ss...@gmail.com>
> Date: Thursday, March 23, 2023 at 05:22
> To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
> 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 <us...@gmail.com> 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 <ss...@gmail.com>
> 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 <ss...@gmail.com>
>
> > > wrote:
>
> > >
>
> > > > Hi Wei,
>
> > > >
>
> > > > Thanks for your prompt response
>
> > > >
>
> > > > Please find the logs herewith.
>
> > > >
>
> > > >
>
> > > >
>
> > > > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com>
>
> > wrote:
>
> > > >
>
> > > >> Hi,
>
> > > >>
>
> > > >> Can you upload the full log ?
>
> > > >>
>
> > > >> -Wei
>
> > > >>
>
> > > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <ss...@gmail.com>
>
> > > 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
>
> > > >> >
>
> > > >>
>
> > > >
>
> > >
>
> >
>
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
Posted by Pierre-Luc Dion <pd...@hypertec.com>.
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 <ss...@gmail.com>
Date: Thursday, March 23, 2023 at 05:22
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
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 <us...@gmail.com> 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 <ss...@gmail.com> 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 <ss...@gmail.com>
> > wrote:
> >
> > > Hi Wei,
> > >
> > > Thanks for your prompt response
> > >
> > > Please find the logs herewith.
> > >
> > >
> > >
> > > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com>
> wrote:
> > >
> > >> Hi,
> > >>
> > >> Can you upload the full log ?
> > >>
> > >> -Wei
> > >>
> > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <ss...@gmail.com>
> > 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
> > >> >
> > >>
> > >
> >
>
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
Posted by Sanjay Kumar <ss...@gmail.com>.
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 <us...@gmail.com> 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 <ss...@gmail.com> 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 <ss...@gmail.com>
> > wrote:
> >
> > > Hi Wei,
> > >
> > > Thanks for your prompt response
> > >
> > > Please find the logs herewith.
> > >
> > >
> > >
> > > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com>
> wrote:
> > >
> > >> Hi,
> > >>
> > >> Can you upload the full log ?
> > >>
> > >> -Wei
> > >>
> > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <ss...@gmail.com>
> > 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
> > >> >
> > >>
> > >
> >
>
Re: Getting DB error while installing fresh cloudstack-mangment on Rocky-Linux9
Posted by Wei ZHOU <us...@gmail.com>.
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 <ss...@gmail.com> 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 <ss...@gmail.com>
> wrote:
>
> > Hi Wei,
> >
> > Thanks for your prompt response
> >
> > Please find the logs herewith.
> >
> >
> >
> > On Wed, Mar 22, 2023 at 1:07 PM Wei ZHOU <us...@gmail.com> wrote:
> >
> >> Hi,
> >>
> >> Can you upload the full log ?
> >>
> >> -Wei
> >>
> >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <ss...@gmail.com>
> 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
> >> >
> >>
> >
>