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]>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 > [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
