[MDEV-2554] LP:987165 - Problem LOCK/FLUSH : Table was locked with a READ lock and can't be updated Created: 2012-04-23 Updated: 2012-10-04 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | ||
| Reporter: | del (Inactive) | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
I have a problem with LOCK/FLUSH. I have a script in python to make backup for some tables. This script works follow : 1.- USE name_of_db; Whith MariaDB 5.2 works fine but in MariaDB 5.5 don't works. After FLUSH TABLES table_name I have this error : ERROR 1099 (HY000): Table 'table_name' was locked with a READ lock and can't be updated Check this example : ~$ mysql -u root This software comes with ABSOLUTELY NO WARRANTY. This is free software, Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> USE test ; Database changed MariaDB [test]> FLUSH TABLES testblob ; MariaDB [test]> Bye ~$ dpkg -l | grep mariadb-server ~$ uname -a ~$lsb_release -a No LSB modules are available. How can I do to make my backup? Thank you |
| Comments |
| Comment by Elena Stepanova [ 2012-04-23 ] |
|
Re: Problem LOCK/FLUSH : Table was locked with a READ lock and can't be updated It is not MariaDB-specific. This is a change in behavior introduced in MySQL 5.5.3, see the manual http://dev.mysql.com/doc/refman/5.5/en/flush.html: "As of MySQL 5.5.3, FLUSH TABLES is not permitted when there is an active LOCK TABLES ... READ. To flush and lock tables, use FLUSH TABLES tbl_list WITH READ LOCK instead." |
| Comment by Rasmus Johansson (Inactive) [ 2012-04-23 ] |
|
Launchpad bug id: 987165 |
| Comment by del (Inactive) [ 2012-04-23 ] |
|
Re: Problem LOCK/FLUSH : Table was locked with a READ lock and can't be updated |