Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Dev

MythTV database update error - tonight's CVS

 

 

MythTV dev RSS feed   Index | Next | Previous | View Threaded


mford2 at comcast

May 25, 2004, 8:40 PM

Post #1 of 3 (902 views)
Permalink
MythTV database update error - tonight's CVS

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)

--
Mike


mford2 at comcast

May 25, 2004, 9:00 PM

Post #2 of 3 (873 views)
Permalink
Re: MythTV database update error - tonight's CVS [In reply to]

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)

--
Mike


_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


sbeck at gossamer-threads

May 25, 2004, 10:12 PM

Post #3 of 3 (877 views)
Permalink
Re: MythTV database update error - tonight's CVS [In reply to]

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] magu sbeck $ perror 28
Error code 28: No space left on device
sbeck [at] magu sbeck $

Cheers,

Scott

MythTV dev RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.