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 user
>> table has 5 extra columns. Is it version related or my sysprog person missed
>> out on a step. Its hard to believe that this problem is unique to my site.
>>
>> Host char(60) NO PRI
>> User char(16) NO PRI
>> Password char(41) NO
>> Select_priv enum('N','Y') NO
> N
>> Insert_priv enum('N','Y') NO
> N
>> Update_priv enum('N','Y') NO
> N
>> Delete_priv enum('N','Y') NO
> N
>> Create_priv enum('N','Y') NO
> N
>> Drop_priv enum('N','Y') NO
> N
>> Reload_priv enum('N','Y') NO
> N
>> Shutdown_priv enum('N','Y') NO
> N
>> Process_priv enum('N','Y') NO
> N
>> File_priv enum('N','Y') NO
> N
>> Grant_priv enum('N','Y') NO
> N
>> References_priv enum('N','Y') NO
> N
>> Index_priv enum('N','Y') NO
> N
>> Alter_priv enum('N','Y') NO
> N
>> Show_db_priv enum('N','Y') NO
> N
>> Super_priv enum('N','Y') NO
> N
>> Create_tmp_table_priv enum('N','Y') NO
> N
>> Lock_tables_priv enum('N','Y') NO
> N
>> Execute_priv enum('N','Y') NO
> N
>> Repl_slave_priv enum('N','Y') NO
> N
>> Repl_client_priv enum('N','Y') NO
> N
>> Create_view_priv enum('N','Y') NO
> N
>> Show_view_priv enum('N','Y') NO
> N
>> Create_routine_priv enum('N','Y') NO
> N
>> Alter_routine_priv enum('N','Y') NO
> N
>> Create_user_priv enum('N','Y') NO
> N
>> Event_priv enum('N','Y') NO
> N
>> Trigger_priv enum('N','Y') NO
> N
>> Create_tablespace_priv enum('N','Y') NO
> N
>> ssl_type enum('','ANY','X509','SPECIFIED')
> NO
>> ssl_cipher blob NO
>> x509_issuer blob NO
>> x509_subject blob NO
>> max_questions int(11) unsigned NO
> 0
>> max_updates int(11) unsigned NO
> 0
>> max_connections int(11) unsigned NO
> 0
>> max_user_connections int(11) unsigned NO
> 0
>> plugin char(64) YES
>> authentication_string text YES
>>
>> ----
>> Host char(60)
> NO
>> User char(16)
> NO
>> Password char(41)
> NO
>> Select_priv enum('N','Y') NO
> N
>> Insert_priv enum('N','Y') NO
> N
>> Update_priv enum('N','Y') NO
> N
>> Delete_priv enum('N','Y') NO
> N
>> Create_priv enum('N','Y') NO
> N
>> Drop_priv enum('N','Y') NO
> N
>> Reload_priv enum('N','Y') NO
> N
>> Shutdown_priv enum('N','Y') NO
> N
>> Process_priv enum('N','Y') NO
> N
>> File_priv enum('N','Y') NO
> N
>> Grant_priv enum('N','Y') NO
> N
>> References_priv enum('N','Y') NO
> N
>> Index_priv enum('N','Y') NO
> N
>> Alter_priv enum('N','Y') NO
> N
>> Show_db_priv enum('N','Y') NO
> N
>> Super_priv enum('N','Y') NO
> N
>> Create_tmp_table_priv enum('N','Y') NO
> N
>> Lock_tables_priv
> enum('N','Y') NO N
>> Execute_priv enum('N','Y') NO
> N
>> Repl_slave_priv enum('N','Y') NO
> N
>> Repl_client_priv
> enum('N','Y') NO N
>> Create_view_priv
> enum('N','Y') NO N
>> Show_view_priv enum('N','Y') NO
> N
>> Create_routine_priv enum('N','Y')
> NO N
>> Alter_routine_priv enum('N','Y')
> NO N
>> Create_user_priv
> enum('N','Y') NO N
>> ssl_type
> enum('','ANY','X509','SPECIFIED') NO
>>
>> ssl_cipher blob NO
>> x509_issuer blob NO
>> x509_subject blob NO
>> max_questions int(11) unsigned
> NO 0
>> max_updates int(11) unsigned
> NO 0
>> max_connections int(11) unsigned
> NO 0
>> max_user_connections int(11) unsigned
> NO 0
>>
>>
>>
>>
>>
>> -----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: http://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: http://lists.mysql.com/mysql
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
