[SLE] Re: MySQL Table Locked?
From: Andrew Choens (andy.choens_at_gmail.com)
Date: 03/29/05
- Previous message: Bahram Alinezhad: "[SLE] SDL_mixer-devel"
- In reply to: Onemarty: "Re: [SLE] MySQL Table Locked?"
- Next in thread: Carlos E. R.: "Re: [SLE] MySQL Table Locked?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Mar 2005 12:29:38 -0500 To: Onemarty <marty.one@pp.inet.fi>
I think upgrading may be the route I go as well. Yeah, I tried
unlocking. No dice.
Here's what I tried. I backed up ALL of the tables in the schema
called TLP. I dropped the tables and then I dropped the schema.
After that, I reset mysqld, just to make sure it had cleared it's
memory. I then used the sql file to restore my schema, with all of
the tables included.
This worked just fine. However, I seem to only have read access on
the table adults. I've checked the table for errors, and mysql says
it is fine. I can edit all of the other tables via the KIO slave as
well as via ODBC, so I know those are set up and functioning
correctly. OOo can't edit the table, Tora gets error messages, etc.
I can rename it though, which I found odd, even though that doesn't
seem to change it's behavior (It's still locked).
Oddly enough, on the suggestion of someone else on the list, I tried
webmin, and this tool seems to be able to edit my database just fine,
as user achoens OR root. I don't know why, but right now, webmin is
the only way I can change the data in this table.
This is a BIG thanks to the folks over at webmin.
--andy
On Tue, 29 Mar 2005 20:11:37 +0300, Onemarty <marty.one@pp.inet.fi> wrote:
> Andy,
>
> Presuming that you've already tried the UNLOCK TABLES-command and it didn't
>
> help...
>
> I've seen similar problems (w/ 4.0.18). Found out this:
>
> - If you make a complete copy of the database, eg. database 'data1' to
> 'data2'
> the new database ('data2') is not locked. (which proves that the data itself
>
> is okay, I think)
> - If you then remove the old database ('data1') and rename 'data2' to
> 'data1'
> it stops working, => locked.
> - If you simply rename 'data1' to 'data2' it works.
>
> So there must be a 'flag' or 'tag' or something in the mysql (system)
> database
> that tells MySQL that the database is locked.
>
> Now, what I didn't try was the following sequence:
> - Copy 'data1' to 'data2'
> - DROP DATABASE data1;
> - rename 'data2' to 'data1'
>
> I intended to do a little more research in MySQL's own database mysql,
> but I stupidly first upgraded to 4.1 - only to find out that the old
> database
> was 'unlocked' again. (Guess that something in mysql got overwritten)
>
> I do not think that 4.1 fixed it, only that it cleared the 'tag', so I'm
> waiting for the problem appear again, and then I'll try to catch it.
>
> Marty
>
>
> On Tuesday 29 March 2005 08:09, Andy Choens wrote:
> > > I am not a DBA but using webmin to connect to mysql there is an icon
> for
> > > table permissions that looks like you can change permissions for
> > > individual tables. Maybe something has go wrong there. Just a
> suggestion
> > > for something else to try before you pull all of your hair out.
> >
> > Well, I downloaded webmin and set it up. So far so good. It's not the
> > interface I would like, but I don't seem to get any errors this way. Of
> > course, I'm editing the table as root, so it had better let me do what
> ever
> > the heck I want! :-)
> >
> > I'm going to install usermin and see if that helps any. If it does, at
> > least I'll be able to use webmin while I figure out the root of my
> > difficulty. It certainly gives my back access to my database, which is
> > incredibly nice.
> >
> > Thanks for the idea. I'm going play around with these permissions more.
> >
> > --andy
>
> --
> Check the headers for your unsubscription address
> For additional commands send e-mail to suse-linux-e-help@suse.com
> Also check the archives at http://lists.suse.com
> Please read the FAQs: suse-linux-e-faq@suse.com
>
>
>
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
- Previous message: Bahram Alinezhad: "[SLE] SDL_mixer-devel"
- In reply to: Onemarty: "Re: [SLE] MySQL Table Locked?"
- Next in thread: Carlos E. R.: "Re: [SLE] MySQL Table Locked?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
