I had the same problem, it has nothing to do with the 2.4.0 update.
Google mysql errno 24 and find out how to do a backup without lock
tables from the command line. IF you give me some time I'll tell you the
command that worked for me but I'll have to go find it in the history.
Wish it would work right from RDadmin though.
Nathaniel C. Steele
Assistant Chief Engineer/Technical Director
WTRM-FM / TheCrossFM
On 1/29/2013 5:17 PM, ICR Programs wrote:
Thanks Wayne,
The issue that worries me is this: I am not able to back up the
database. I should be able to, shouldn't I?
(this was using the Backup Database button on RDAdmin) and trying it
from command line (though I am not sure how to do that).
And, the system wasn't 'live' in the sense that I didn't have
RDAirplay or any other Rivendell components running. I rebooted the
system and then tried all this.
Any suggestions, please?
thanks!
Rene
On Tue, Jan 29, 2013 at 4:36 PM, waynemerricks
<waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com>> wrote:
To update the schema you just need to run RDAdmin. From memory not
much happens as far as the user is concerned (unless it dies in which
case you get an error message). As for the mysqldump error it failed
because it couldn't lock the tables on a live system. You can dump
without lock tables but data integrity is not guaranteed as changes
could have been made while the dump was running.
Basically, business as usual but an off putting error message that
makes you wonder.
Regards,
Wayne
On 2013-01-29 21:27, ICR Programs wrote:
> Dear list members,
>
> Im sorry to basically post this same question again, but the thread
> it
> was in went in another direction and I didnt want to get my query
> "lost in the shuffle."
>
> What I did glean from the thread and a few other messages was that
> Apache may be at play here ... however, I dont know anything about
> Apache or how/why it was affect our system such that we were able to
> back up the Database before upgrading from 2.3.x to 2.4.0
>
> Also, Im NOT sure about whether this is relevant, and indeed it
was a
> problem that cropped up BEFORE this v2.4.0 update, but whenever one
> moves a file to the trash (logged in as user rd) it doesnt appear in
> the GUI in the Trash. If one logs in via terminal, however, the
> deleted files are there and one can expunge them from the system. I
> am guessing this is a permissions problem, but am mystified why it
> would have happened.
>
> Thanks to all!
> Rene
>
> Hello Fred and all,
>
> Thanks for your work on the updates and indeed, the Rivendell
System.
>
> I upgraded, but have what I hope is a slight problem.
>
> I used the Package Updater -- it had a notification up about the
> updates -- and it installed fine.
>
> I then opened RDAdmin, typed the user name "admin" and wasnt sure
> what
> to do next in order to update the database schema (which is now,
> according to System Info, Rivendell Version 2.4.0; Database schema
> 216).
>
> I did try to do a backup of the database, and that gave the error
> "Unable to create backup"
>
> I then went to Terminal, typed "rddamin" and got this:
>
> Terminal Output:
>
> [rd@icr-dj-desktop ~]$ rdadmin
> mysqldump: Got error: 1016: Cant open file:
> ./Rivendell/Weekday_6_AM_CLK.frm (errno: 24) when using LOCK TABLES
>
> What should I do now, please?
>
> Thanks,
> Rene
>
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "Democracy is not a spectator
> sport"
>
> Ithaca Community Radio -- 88.1 FM in
> Ithaca
> WRFI 91.9 FM in
> Watkins Glen
> WINO 89.9 FM
> in Odessa
>
> News, Culture & Information from our Neighborhoods and the World
>
> _Phone_: 607.319.5445 <tel:607.319.5445> [1]
> _Email_: progr...@ithacaradio.org
<mailto:progr...@ithacaradio.org> [2]
> _Web_: http://ithacaradio.org/ [3]
>
>
> Mailing address:
> The Clinton House
> 103 West Seneca St.
> Suite 305
> Ithaca, N.Y, 14850
>
>
>
> Links:
> ------
> [1] http://mail2.thevoiceasia.com/tel:607.319.5445
> [2] mailto:progr...@ithacaradio.org
<mailto:progr...@ithacaradio.org>
> [3] http://ithacaradio.org/
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
<mailto:Rivendell-dev@lists.rivendellaudio.org>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Democracy is not a spectator sport"
Ithaca Community Radio -- 88.1 FM in Ithaca
WRFI 91.9 FM in Watkins Glen
WINO 89.9 FM in Odessa
News, Culture & Information from our Neighborhoods and the World
/Phone/: 607.319.5445
/Email/: progr...@ithacaradio.org <mailto:progr...@ithacaradio.org>
/Web/: http://ithacaradio.org/
Mailing address:
The Clinton House
103 West Seneca St.
Suite 305
Ithaca, N.Y, 14850
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
