Re: [SLE] MySQL Table Locked?

From: Andy Choens (andy.choens_at_gmail.com)
Date: 03/28/05

  • Next message: Theo v. Werkhoven: "Re: [SLE] Streaming Radio" 
    To: suse-linux-e@suse.com
Date: Mon, 28 Mar 2005 07:54:46 -0500

    I gave it a try and I got this as a return.

    mysql.columns_priv OK
    mysql.db OK
    mysql.func OK
    mysql.host OK
    mysql.tables_priv OK
    mysql.user OK
    mysql.user_info OK
    tlp.adults OK
    tlp.campers OK

    I tried to edit the table again, and same result.

    --andy

    On Monday 28 March 2005 3:53 am, Brad Dameron wrote:
    > Sounds like a corrupt table. Run this command from the commandline as root:
    >
    > mysqlcheck -r -A
    >
    > Brad Dameron
    > SeaTab Software
    > www.seatab.com
    >
    >
    > ----- Original Message -----
    > From: "Andy Choens" <andy.choens@gmail.com>
    > To: <suse-linux-e@suse.com>
    > Sent: Sunday, March 27, 2005 10:32 PM
    > Subject: [SLE] MySQL Table Locked?
    >
    > > Just joined the list because of this really bizarre problem. I'm using
    > > 9.2 on
    > > a laptop. I'll describe the basic structure of my database, and what's
    > > going
    > > on. If I leave out any important details, tell me, and I'll do my best
    > > to fill them in.
    > >
    > > I am using the default mysql rpm that came with 9.2 + any updates that
    > > YAST
    > > told me to do. The only thing not stock on this machine is the upgraded
    > > KDE
    > > (3.4) that I'm using, but I don't think that has anything to do with
    > > this. I
    > > don have a couple of other programs installed, like tora, but I don't
    > > think
    > > they are the problem either.
    > >
    > > I have a database called tlp. Within TLP I have a number of actual
    > > tables. I
    > > can edit, update, delete, etc. all of the tables but one. For instance,
    > > if I
    > > go into the table "participants" via konqueror, and edit a row,
    > > everything works just fine. In fact, I do this several times a week as I
    > > update the information on my participants. But, enrollement is pretty
    > > stable. Now I need to update the information in one row in this table,
    > > and I can't. Tora
    > > gets errors, mysqlcc gets errors, konqueror, and OpenOffice.org all get
    > > errors. But, they don't get ANY errors on any other table in the
    > > database.
    > > The others work just like they should. This table used to work like it
    > > should. I can't figure out what I've done, or how to undo it.
    > >
    > > I have the mysql-administrator installed, and don't see anything to
    > > change with it, and I looked through the documentation with mysql, and
    > > tried to unlock my tables, thinking some program had thrown a lock on it,
    > > but no dice.
    > > I still can't update my table.
    > >
    > > If you have any ideas, suggestions, of kludges to get me up and running,
    > > I'd
    > > appreciate it!
    > > --
    > > Alex Lowe's 3 Rules for Climbing:
    > > 1 - Come Back Alive!
    > > 2 - Come Back Still Friends With Your Partners!
    > > 3 - Get To The Top!
    > >
    > > --
    > > 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 

    -- 
Alex Lowe's 3 Rules for Climbing:
	1 - Come Back Alive!
	2 - Come Back Still Friends With Your Partners!
	3 - Get To The Top!
-- 
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
  • Next message: Theo v. Werkhoven: "Re: [SLE] Streaming Radio"

    Relevant Pages

    • Re: Duplicating Multiple records in a form
      ... And in reality, despite it being not good normalized database process, ... It sounds like you are trying to do something (select multiple records, ... At present I can select multiple records and using the Edit Menu, ... command, I can copy these records and then use the Edit Menu, Paste ...
      (microsoft.public.access.formscoding)
    • RE: dont want users to be able to change data unless they have pushed
      ... Use an Unbound form and code the database reads/writes in VB. ... I have also provided for several command buttons on the forms. ... and that they can only edit data when they push an edit button. ...
      (microsoft.public.access.formscoding)
    • dont want users to be able to change data unless they have pushed a button
      ... I have created the database for different users and some of them might change ... I have also provided for several command buttons on the forms. ... and that they can only edit data when they push an edit button. ... error message "the command or action 'SaveRecord' isn't available now. ...
      (microsoft.public.access.formscoding)
    • Re: Bam sender email change
      ... It is possible there is some caching going on there. ... I made the changes in database even though I am still getting emails frmo ... you an XML file that you can edit. ... then use the following command at the command line to update ...
      (microsoft.public.biztalk.server)
    • Re: [SLE] MySQL Table Locked?
      ... Run this command from the commandline as root: ... Subject: MySQL Table Locked? ... I'll describe the basic structure of my database, ... 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 ...
      (SuSE)