[racktables-users] Re: Missing record on upgrade from 0.17.11 to 0.18.4

  • From: "Michael Mansour" <mic@xxxxxxxxxxx>
  • To: racktables-users@xxxxxxxxxxxxx
  • Date: Wed, 29 Sep 2010 17:39:54 +1100

Hi,

> Hi Denis,
> 
> > > Hmm.. I don't want to sit on 0.17.11 forever, so how would I proceed
resolving
> > > this and finding the problem record?
> > 
> > SELECT COUNT(*) FROM IPv4Allocation WHERE object_id = 0;
> 
> The above line returns COUNT 1. The below ones return 0.
> 
> So I then entered:
> 
> SELECT *
> FROM IPv4Allocation
> WHERE object_id =0;
> 
> and got:
> 
> Full Texts    object_id       ip      name    type
>       Edit    Delete  0       3400654844      eth1    regular
> 
> So if I:
> 
> 1. backup DB
> 
> 2. delete this record
> 
> 3. update to 0.18.4
> 
> It should work?
> 
> I'm going to try this now.

Done and worked perfectly.

Am now running on 0.18.4 and all seems fine.

Thank you again.

Michael.

> Thank you.
> 
> Michael.
> 
> > SELECT COUNT(*) FROM IPv4LB WHERE object_id = 0;
> > SELECT COUNT(*) FROM IPv4NAT WHERE object_id = 0;
> > 
> > --
> >     Denis Ovsienko
> ------- End of Original Message -------
------- End of Original Message -------


Other related posts: