List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:March 22 2012 5:23am
Subject:Re: One inst has 39 columns- the other 40
View as plain text  
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.
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