Awesome - glad it was a nice simple fix!
Cheers,
James Harrison
On 26/02/2012 06:09, Lee Baker wrote:
DOH! Why did I not think to check the logs....
120226 12:34:24 [Note] Event Scheduler: Purging the queue. 0 events
120226 12:35:10 [Note] Plugin 'FEDERATED' is disabled.
120226 12:35:10 InnoDB: Started; log sequence number 0 44233
120226 12:35:11 [Note] Event Scheduler: Loaded 0 events
120226 12:35:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.1' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 (Ubuntu)
120226 12:35:12 [ERROR] /usr/sbin/mysqld: Table './rivendell/CUTS' is
marked as crashed and should be repaired
120226 12:35:12 [Warning] Checking table: './rivendell/CUTS'
120226 12:35:12 [ERROR] /usr/sbin/mysqld: Table './rivendell/DRSA_SRT'
is marked as crashed and should be repaired
120226 12:35:12 [Warning] Checking table: './rivendell/DRSA_SRT'
120226 12:35:12 [ERROR] /usr/sbin/mysqld: Table
'./rivendell/RDAIRPLAY' is marked as crashed and should be repaired
120226 12:35:12 [Warning] Checking table: './rivendell/RDAIRPLAY'
120226 15:09:25 [Note] /usr/sbin/mysqld: Normal shutdown
Just run a MYSQL repair on the database and everything is now back to
normal....
For future reference, anyone else who may experience the same or
similar issue. As James suggested, check the mysql logs. If you see
something like in the above error log, all you need to do is run a few
simple commands which will repair either the database tables.
Run this command: myisamchk --silent --force --fast --update-state
/var/lib/mysql/rivendell/*.MYI
It will do a repair on the crashed tables.
Cheers,
Lee
On Sun, Feb 26, 2012 at 3:36 PM, James Harrison
<[email protected] <mailto:[email protected]>> wrote:
Check /var/log/mysql - if MySQL is crashing it'll be saying
-something- in the logs which will help massively to debug this.
Cheers,
James Harrison
On 26/02/2012 05:17, Lee Baker wrote:
Hi All, I have a rather strange issue with mysql whereby it keeps
crashing.
I have a network environment running and whenever other systems
connect to the database the mysql server crashes. playout still
works fine, but the database just crashes and none of the other
systems con connect.
can anyone offer advice? or has run in to the same problem?
I am running RRAbuntu
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
