[mythtv] MythTV database update error - tonight's CVS

[Scott Beck]

On Tue, 2004-05-25 at 21:00, Mike Ford wrote:
> Nevermind. The /var partition was full.
> 
> On Tuesday 25 May 2004 11:40 pm, Mike Ford wrote:
> > I just upgraded to CVS this evening and I'm getting this error when the
> > backend runs and attempts to upgrade the database.  Yesterday's upgrade
> > went fine and I haven't changed anything in the system so maybe a recent
> > patch is the trouble?
> >
> > 2004-05-25 22:56:24 Upgrading to schema version 1046
> > 2004-05-25 22:56:24 Upgrading to schema version 1047
> > DB Error (Performing database upgrade):
> > Query was:
> > ALTER TABLE record ADD COLUMN search INT UNSIGNED NOT NULL DEFAULT 0;
> > Driver error was [2/-1]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Error writing file './mythconverg/#sql-785_2.frm' (Errcode: 28)

For future reference you can use perror with the mysql error number:
sbeck at magus sbeck $ perror 28
Error code  28:  No space left on device
sbeck at magus sbeck $ 

Cheers,

Scott