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.tava...@dri.pt> 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:r...@grib.nl]
>> Sent: Wednesday, March 21, 2012 5:08 AM
>> To: mysql@lists.mysql.com
>> 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
 - mdyk...@gmail.com
 May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
