From: Michael Dykman
Date: March 22 2012 5:23am
Subject: Re: One inst has 39 columns- the other 40
List-Archive: http://lists.mysql.com/mysql/227020
Message-Id: <CANLyif9ETQU9bVmdckAwMF7=B78tHkEHE6mt_OWxKNguaVq+vg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Bear in mind, MySQL Cluster/NDB runs independently of the mysql nodes
used to ast as clients to that cluster.  This is really not an issue.

 - michael dykman

On Thu, Mar 22, 2012 at 1:03 AM, Nuno Tavares <nuno.tavares@stripped> wrote:
> Charles,
>
> You should run "SELECT @@version" on both nodes. It looks like you have
> different version' schemas.
>
> -NT
>
>
> Em 22-03-2012 04:41, Brown, Charles escreveu:
>
>> Look man, there has to be someone out there that can tell me why one use=
r
>> table has 5 extra columns. Is it version related or my sysprog person mi=
ssed
>> out on a step. Its hard to believe that this problem is unique to my sit=
e.
>>
>> Host =A0 =A0char(60) =A0 =A0 =A0 =A0NO =A0 =A0 =A0PRI
>> User =A0 =A0char(16) =A0 =A0 =A0 =A0NO =A0 =A0 =A0PRI
>> Password =A0 =A0 =A0 =A0char(41) =A0 =A0 =A0 =A0NO
>> Select_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Insert_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Update_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Delete_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Create_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Drop_priv =A0 =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Reload_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Shutdown_priv =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Process_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> File_priv =A0 =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Grant_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> References_priv enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Index_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Alter_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Show_db_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Super_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Create_tmp_table_priv =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =
=A0N
>> Lock_tables_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0=
 =A0 =A0N
>> Execute_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Repl_slave_priv enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Repl_client_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0=
 =A0 =A0N
>> Create_view_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0=
 =A0 =A0N
>> Show_view_priv =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Create_routine_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0=
 =A0N
>> Alter_routine_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =
=A0 =A0N
>> Create_user_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0=
 =A0 =A0N
>> Event_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Trigger_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =A0N
>> Create_tablespace_priv =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =A0 =
=A0N
>> ssl_type =A0 =A0 =A0 =A0enum('','ANY','X509','SPECIFIED') =A0 =A0 =A0 NO
>> ssl_cipher =A0 =A0 =A0blob =A0 =A0NO
>> x509_issuer =A0 =A0 blob =A0 =A0NO
>> x509_subject =A0 =A0blob =A0 =A0NO
>> max_questions =A0 int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =A0 =A0 =A0 =A0=
 =A0 =A00
>> max_updates =A0 =A0 int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A00
>> max_connections int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =A0 =A0 =A0 =A0 =
=A0 =A00
>> max_user_connections =A0 =A0int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =A0 =
=A0 =A0 =A0 =A0 =A00
>> plugin =A0char(64) =A0 =A0 =A0 =A0YES
>> authentication_string =A0 text =A0 =A0YES
>>
>> ----
>> =A0 =A0 =A0 =A0Host =A0 =A0char(60) =A0 =A0 =A0 =A0NO
>> =A0 =A0 =A0 =A0User =A0 =A0char(16) =A0 =A0 =A0 =A0NO
>> =A0 =A0 =A0 =A0Password =A0 =A0 =A0 =A0char(41) =A0 =A0 =A0 =A0NO
>> =A0 =A0 =A0 =A0Select_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Insert_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Update_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Delete_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Create_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Drop_priv =A0 =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Reload_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Shutdown_priv =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Process_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0File_priv =A0 =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Grant_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0References_priv enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =
=A0 =A0N
>> =A0 =A0 =A0 =A0Index_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Alter_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Show_db_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Super_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =
=A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Create_tmp_table_priv =A0 enum('N','Y') =A0 NO =A0 =A0 =
=A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Lock_tables_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Execute_priv =A0 =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Repl_slave_priv enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =A0 =
=A0 =A0N
>> =A0 =A0 =A0 =A0Repl_client_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Create_view_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Show_view_priv =A0enum('N','Y') =A0 NO =A0 =A0 =A0 =A0 =
=A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Create_routine_priv =A0 =A0 enum('N','Y') =A0 NO =A0 =A0 =
=A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Alter_routine_priv =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0Create_user_priv =A0 =A0 =A0 =A0enum('N','Y') =A0 NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A0N
>> =A0 =A0 =A0 =A0ssl_type =A0 =A0 =A0 =A0enum('','ANY','X509','SPECIFIED')=
 =A0 =A0 =A0 NO
>>
>> =A0 =A0 =A0 =A0ssl_cipher =A0 =A0 =A0blob =A0 =A0NO
>> =A0 =A0 =A0 =A0x509_issuer =A0 =A0 blob =A0 =A0NO
>> =A0 =A0 =A0 =A0x509_subject =A0 =A0blob =A0 =A0NO
>> =A0 =A0 =A0 =A0max_questions =A0 int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A00
>> =A0 =A0 =A0 =A0max_updates =A0 =A0 int(11) unsigned =A0 =A0 =A0 =A0NO =
=A0 =A0 =A0 =A0 =A0 =A0 =A00
>> =A0 =A0 =A0 =A0max_connections int(11) unsigned =A0 =A0 =A0 =A0NO =A0 =
=A0 =A0 =A0 =A0 =A0 =A00
>> =A0 =A0 =A0 =A0max_user_connections =A0 =A0int(11) unsigned =A0 =A0 =A0 =
=A0NO =A0 =A0 =A0 =A0 =A0 =A0 =A00
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: Rik Wasmus [mailto:rik@stripped]
>> Sent: Wednesday, March 21, 2012 5:08 AM
>> To: mysql@stripped
>> Subject: Re: One inst has 39 columns- the other 40
>>
>>> You keep repeating that, and I already replied to it the first time.
>>> If my answer isn't acceptable, spamming the question isn't going to
>>> make it better - or make people more inclined to help you, for that
>>> matter.
>>
>>
>> I concur
>> --
>> Rik Wasmus
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql
>>
>> ********************************************
>> This message is intended only for the use of the Addressee and
>> may contain information that is PRIVILEGED and CONFIDENTIAL.
>>
>> If you are not the intended recipient, you are hereby notified
>> that any dissemination of this communication is strictly prohibited.
>>
>> If you have received this communication in error, please erase
>> all copies of the message and its attachments and notify us
>> immediately.
>>
>> Thank you.
>> ********************************************
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql
>



--=20
=A0- michael dykman
=A0- mdykman@stripped

=A0May the Source be with you.