Hi,
I had this issue when I had carts in the DB that didn't exist in
/var/snd. They just sat in my playlist never to go away (until
restarting airplay).
Wayne Merricks
The Voice Asia
On 01/12/15 16:53, Tim Camp wrote:
Greetings,
Thanks for all the help yesterday guys, we got things back up with a
slightly older backup
which meant there was a little data entry to be done, but back up on
the air.
One of my stations is having a issue though with played carts staying
in the top deck
of rdairplay after finishing, sometimes this happen two or three times
leaving the tp two or three decks unusable.
this just started when running off the new database server and backup
database.
Ideas?
Thanks again for your help it was invaluable.
Tim Camp
WZEW-FM
Mobile, Al.
On Mon, Nov 30, 2015 at 3:30 PM, Wayne Merricks
<waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com>> wrote:
Hi,
The schema is saved in the VERSION table.
My 242 table looks like this:
mysql> describe VERSION;
+----------------------+----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default
| Extra |
+----------------------+----------+------+-----+---------------------+-------+
| DB | int(11) | NO | PRI | NULL | |
| LAST_MAINT_DATETIME | datetime | YES | | 1970-01-01
00:00:00 | |
| LAST_ISCI_XREFERENCE | datetime | YES | | 1970-01-01
00:00:00 | |
+----------------------+----------+------+-----+---------------------+-------+
3 rows in set (0.00 sec)
mysql> select * FROM VERSION;
+-----+---------------------+----------------------+
| DB | LAST_MAINT_DATETIME | LAST_ISCI_XREFERENCE |
+-----+---------------------+----------------------+
| 242 | 2015-11-30 21:17:07 | 1970-01-01 00:00:00 |
+-----+---------------------+----------------------+
1 row in set (0.00 sec)
Is it possible this table corrupted and didn't get dumped properly?
On 2015-11-30 20:08, Tim Camp wrote:
Greetings
I dont understand why a mysqldump from schema 234 RD system would
create a backup that appears to restore just fine except that the
backup is schema 0
Anyone have a idea of whats going on here.
Basically, I have 6 stations off the air.
Thanks
Tim Camp
WZEW-FM
Mobile, AL.
On Mon, Nov 30, 2015 at 1:29 PM, Tim Camp <t...@dotcom1.net
<mailto:t...@dotcom1.net> [6]> wrote:
Looking into databases I have backed up from yesterday it
looks good
everything looks just fine look at it in my s_q_l browser.
However
when I restore it even on a new server rivendell
complains is too
old to be updated.
Where is the schema number stored, it thinks this backup
is schema
0
Hair pulling all systems down.
Tim Camp
WZEW FM
On Nov 30, 2015 11:54 AM, "Tim Camp" <t...@dotcom1.net
<mailto:t...@dotcom1.net> [5]> wrote:
Trying to repair corrupt tables, meanwhile I have a
back-up from
yesterday but when I try to run it rivendell says its
too old to
be updated, thinks its schema 0 instead of 242
Tim
On Nov 30, 2015 10:37 AM, "Wayne Merricks"
<waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com> [4]> wrote:
Oops sorry, ignore the bit where I mentioned
"there is this
page which explains it really well" I took the
link out because
it talks about doing a whole bunch of stuff you
shouldnt need to
do.
Wayne Merricks
The Voice Asia
On 30/11/15 16:25, Tim Camp wrote:
No Wayne, drive has 10 GBP of free space.
Thanks what I had
found as well, maybe I am having drive
problems which is why I
want to move the mysql server to another
machine but I cant
get it backed up.
Thanks
Tim
On Nov 30, 2015 10:21 AM, "Wayne Merricks"
<waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com> [3]>
wrote:
Googling, error 5 is an out of space
error. Is the drive
full?
Wayne Merricks
The Voice Asia
On 30/11/15 16:01, Tim Camp wrote:
Greetings,
HELP
Came into the station this morning and
rdlibrary only
shows carts when "show first 100" is
selected
show "all" returns a blank library.
Seems I am having a database issue or
a issue with the
database server.
So now I am trying to do a backup of
the database so I
have a fresh one before I do further
trouble shooting with
the server.
Rivendell RdAdmin fails to backup
database.
When using mysqldump to a single file
I get
Error 1030: Got error 5 from storage
engine when dumping
table Bluesweb_SRT
"Bluesweb" being one of my Rivendell
services.
Any Help on this situation would be
greatly appreciated.
Tim Camp
WZEW-FM
Mobile, Al.
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
<mailto:Rivendell-dev@lists.rivendellaudio.org>
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
<mailto:Rivendell-dev@lists.rivendellaudio.org>
[1]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[2]
Links:
------
[1] mailto:Rivendell-dev@lists.rivendellaudio.org
<mailto:Rivendell-dev@lists.rivendellaudio.org>
[2]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[3] mailto:waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com>
[4] mailto:waynemerri...@thevoiceasia.com
<mailto:waynemerri...@thevoiceasia.com>
[5] mailto:t...@dotcom1.net <mailto:t...@dotcom1.net>
[6] mailto:t...@dotcom1.net <mailto:t...@dotcom1.net>
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
