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
> >> >
> >>
> >
>
