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 <ustcweiz...@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 <sslinuxp...@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 <sslinuxp...@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 <ustcweiz...@gmail.com>
> wrote:
> > >
> > >> Hi,
> > >>
> > >> Can you upload the full log ?
> > >>
> > >> -Wei
> > >>
> > >> On Wed, 22 Mar 2023 at 03:47, Sanjay Kumar <sslinuxp...@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
> > >> >
> > >>
> > >
> >
>
