List:General Discussion« Previous MessageNext Message »
From:Mark Goodge Date:March 22 2012 10:06am
Subject:Re: One inst has 39 columns- the other 40
View as plain text  
On 22/03/2012 04:41, Brown, Charles wrote:
> Look man, there has to be someone out there that can tell me why one
> user table has 5 extra columns.

As far as I can see, plenty of people already have told you.

> Is it version related or my sysprog person missed out on a step.

Yes, it's related to your version.

You probably have different versions of MySQL on different nodes of the
cluster.

Your sysprog person has missed out the step of ensuring that all nodes
are upgraded at the same time in order to maintain consistency.

> Its hard to believe that this problem is unique to my site.

No, the problem is not unique to your site. It's an easy mistake to make.

Please could you now give some indication of having read and understood
this reply.

Mark
-- 
  Sent from my Babbage Difference Engine 2
  http://mark.goodge.co.uk
Thread
date comparison querySimon Wilkinson16 Mar
  • Re: date comparison queryBaron Schwartz16 Mar
  • Re: date comparison queryhsv17 Mar
    • One inst has 39 columns- the other 40Charles Brown18 Mar
      • Re: One inst has 39 columns- the other 40Johan De Meersman19 Mar
  • One inst has 39 columns- the other 40Charles Brown19 Mar
  • RE: One inst has 39 columns- the other 40Charles Brown21 Mar
    • Re: One inst has 39 columns- the other 40Johan De Meersman21 Mar
      • Re: One inst has 39 columns- the other 40Rik Wasmus21 Mar
        • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Nuno Tavares22 Mar
            • Re: One inst has 39 columns- the other 40Michael Dykman22 Mar
          • Re: One inst has 39 columns- the other 40Reindl Harald22 Mar
            • RE: One inst has 39 columns- the other 40Charles Brown22 Mar
          • Re: One inst has 39 columns- the other 40Mark Goodge22 Mar
    • Re: One inst has 39 columns- the other 40Reindl Harald21 Mar
      • tables do not have the same number of columns. Charles Brown22 Mar
        • Re: tables do not have the same number of columns.Johan De Meersman22 Mar