[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[McIDAS #YGO-324744]: repair grib database error

This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.


  • Subject: [McIDAS #YGO-324744]: repair grib database error
  • Date: Mon, 21 Sep 2009 16:38:25 -0600

Hi Hsie,

I apologize for not being able to respond to your inquiry before now...

re:
> How can I correct this error?
> 
> stratus:[42]% cd $MCDATA
> stratus:[43]% gribadmin num
> ERROR 1194 at line 1: Table 'file_list' is marked as crashed and should
> be repaired
> 
> ERROR 1194 at line 1: Table 'file_list' is marked as crashed and should
> be repaired
> Model Number   % of
> Name  of Grids Total
> ===== ======== =====
> ----- -------- -----
> Total
> 
> stratus:[44]% whoami
> mcidas
> stratus:[45]%

I just logged onto stratus to take a look at the problem... I see that you
figured out that one way to fix the problem was to delete and remake the
MySQL database:

<as 'mcidas'>
cd $MCDATA
gribadmin removedb
<supply password>
gribadmin makedb
<supply password>

Cheers,

Tom
--
****************************************************************************
Unidata User Support                                    UCAR Unidata Program
(303) 497-8642                                                 P.O. Box 3000
address@hidden                                   Boulder, CO 80307
----------------------------------------------------------------------------
Unidata HomePage                       http://www.unidata.ucar.edu
****************************************************************************


Ticket Details
===================
Ticket ID: YGO-324744
Department: Support McIDAS
Priority: Normal
Status: Closed