List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:October 11 2004 8:42am
Subject:Re: mysql-4.1.6-gamma: LOCK TABLE problem
View as plain text  
Please report as bug in category MySQL Cluster at bugs.mysql.com

Thanks,

T


Joseph E. Sacco, Ph.D. wrote:

>Encountered a problem with 'LOCK TABLE'.
>
>Given an NDB table named 'user':
>
>mysql> describe user;
>+--------------+------------------+------+-----+--------+--------------+
>| Field        | Type             | Null | Key | Default|Extra         |
>+--------------+------------------+------+-----+--------+--------------+
>| user_id      | int(10) unsigned |      | PRI | NULL   |auto_increment|
>| email        | varchar(255)     | YES  |     | NULL   |              |
>| first_name   | varchar(64)      | YES  |     | NULL   |              |
>| last_name    | varchar(64)      | YES  |     | NULL   |              |
>| login        | varchar(255)     |      | MUL |        |              |
>| mobile_phone | varchar(32)      | YES  |     | NULL   |              |
>| password     | varchar(255)     |      |     |        |              |
>| phone        | varchar(32)      | YES  |     | NULL   |              |
>| hidden       | tinyint(1)       |      | MUL | 0      |              |
>+--------------+------------------+------+-----+---------+-------------+
>
>Consider the following:
>
>        mysql> LOCK TABLES user WRITE;
>        Query OK, 0 rows affected (0.00 sec)
>         
>        mysql> delete from user where login='jsacco';
>        ERROR 1296 (HY000): Got error 208 '208' from ndbcluster
>
>
>
>Now unlock the table and try once more:
>
>        mysql> UNLOCK TABLES;
>        Query OK, 0 rows affected (0.00 sec)
>         
>        mysql> delete from user where login='jsacco';
>        Query OK, 1 row affected (0.02 sec)
>
>Hmmm....
>
>Do we have permission to lock the table???
>
>        mysql> use mysql;
>        mysql> select User, Host, Lock_tables_priv from user where
>        User='root' \G
>        *************************** 1. row ***************************
>                    User: root
>                    Host: localhost
>        Lock_tables_priv: Y
>        *************************** 2. row ***************************
>                    User: root
>                    Host: musa.jesacco.com
>        Lock_tables_priv: Y
>        2 rows in set (0.01 sec)
>        
>Yes...
>
>
>
>If the exercise with a myISAM table all is well.  
>
>Thoughts???
>
>
>-Joseph
>
>  
>

Thread
mysql-4.1.6-gamma: LOCK TABLE problemPh.D. Joseph E. Sacco11 Oct
  • Re: mysql-4.1.6-gamma: LOCK TABLE problemTomas Ulin11 Oct
    • Re: mysql-4.1.6-gamma: LOCK TABLE problemMagnus Svensson11 Oct