[Met_help] [rt.rap.ucar.edu #81029] History for Problem loading VSDBs to existing database: ERROR DROP INDEX

[John Halley Gotway via RT]

----------------------------------------------------------------
  Initial Request
----------------------------------------------------------------

Hello.  I'm having trouble loading VSDBs to the existing database 
mv_ylin_pcp on the NCEP MetViewer server, with messages like this:

17:22:25 INFO   line_data_ssvar_fcst_init_beg_idx: 0:00:00.001
17:22:25 ERROR DROP INDEX line_data_enscnt_fcst_lead_idx ON 
line_data_enscnt ;
17:22:25 ERROR   **  ERROR: caught class java.lang.Exception applying 
index line
_data_enscnt_fcst_lead_idx: caught SQLException calling executeUpdate: 
Error wri
ting file './mv_ylin_pcp/#sql-1bf5_551c.frm' (Errcode: 28)
17:22:25 INFO      line_data_enscnt_fcst_lead_idx: 0:00:00.001

My load script: /metviewer/staging/wd22yl/load_test.xml_ying, with 
drop_indexes set to 'true'

Output: /metviewer/staging/wd22yl/out.load/loadlog.20170601-20170617

The job produced the error messages within the first second or so, then 
got stuck at the first model ('cmc') for hours, until I killed the job.

Thanks,

Ying

-- 
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov




----------------------------------------------------------------
  Complete Ticket History
----------------------------------------------------------------

Subject: Problem loading VSDBs to existing database: ERROR DROP INDEX
From: Tatiana Burek
Time: Tue Jun 27 15:10:22 2017

Ying,

Errcode: 28 - means that  no space left on device.
I checked the size of MySQL databases and it is 202.5GB and 170GB of
indexes.

The biggest space consumer is mv_emc_g2o - 156GB.

Tatiana

On Tue Jun 27 09:21:47 2017, ying.lin at noaa.gov wrote:
> Hello.  I'm having trouble loading VSDBs to the existing database
> mv_ylin_pcp on the NCEP MetViewer server, with messages like this:
>
> 17:22:25 INFO   line_data_ssvar_fcst_init_beg_idx: 0:00:00.001
> 17:22:25 ERROR DROP INDEX line_data_enscnt_fcst_lead_idx ON
> line_data_enscnt ;
> 17:22:25 ERROR   **  ERROR: caught class java.lang.Exception
applying
> index line
> _data_enscnt_fcst_lead_idx: caught SQLException calling
executeUpdate:
> Error wri
> ting file './mv_ylin_pcp/#sql-1bf5_551c.frm' (Errcode: 28)
> 17:22:25 INFO      line_data_enscnt_fcst_lead_idx: 0:00:00.001
>
> My load script: /metviewer/staging/wd22yl/load_test.xml_ying, with
> drop_indexes set to 'true'
>
> Output: /metviewer/staging/wd22yl/out.load/loadlog.20170601-20170617
>
> The job produced the error messages within the first second or so,
then
> got stuck at the first model ('cmc') for hours, until I killed the
job.
>
> Thanks,
>
> Ying
>



------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #81029] Problem loading VSDBs to existing database: ERROR DROP INDEX
From: Ying Lin
Time: Tue Jun 27 15:25:17 2017

Hi Tatiana,

     Oh, OK, thank you very much for looking into this.

Ying

On 06/27/2017 05:10 PM, Tatiana Burek via RT wrote:
> Ying,
>
> Errcode: 28 - means that  no space left on device.
> I checked the size of MySQL databases and it is 202.5GB and 170GB of
indexes.
>
> The biggest space consumer is mv_emc_g2o - 156GB.
>
> Tatiana
>
> On Tue Jun 27 09:21:47 2017, ying.lin at noaa.gov wrote:
>> Hello.  I'm having trouble loading VSDBs to the existing database
>> mv_ylin_pcp on the NCEP MetViewer server, with messages like this:
>>
>> 17:22:25 INFO   line_data_ssvar_fcst_init_beg_idx: 0:00:00.001
>> 17:22:25 ERROR DROP INDEX line_data_enscnt_fcst_lead_idx ON
>> line_data_enscnt ;
>> 17:22:25 ERROR   **  ERROR: caught class java.lang.Exception
applying
>> index line
>> _data_enscnt_fcst_lead_idx: caught SQLException calling
executeUpdate:
>> Error wri
>> ting file './mv_ylin_pcp/#sql-1bf5_551c.frm' (Errcode: 28)
>> 17:22:25 INFO      line_data_enscnt_fcst_lead_idx: 0:00:00.001
>>
>> My load script: /metviewer/staging/wd22yl/load_test.xml_ying, with
>> drop_indexes set to 'true'
>>
>> Output: /metviewer/staging/wd22yl/out.load/loadlog.20170601-
20170617
>>
>> The job produced the error messages within the first second or so,
then
>> got stuck at the first model ('cmc') for hours, until I killed the
job.
>>
>> Thanks,
>>
>> Ying
>>
>
>

--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov



------------------------------------------------