[Met_help] [rt.rap.ucar.edu #96775] History for remove files from database

Tue Oct 13 12:21:31 MDT 2020

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

Hello,

Would you please help to delete all the files with "Raikoke_31.0p25"  in
the database "mv_g2g_met_verf_Raikoke"? I don't know how to do that without
deleting the whole database.

Thank you.
Binyu

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

Subject: remove files from database
From: John Halley Gotway
Time: Mon Sep 21 13:00:19 2020

Hi Binyu,

I see you have a question about METviewer database maintenance. I'm
going
to assign this ticket to Tatiana Burek.

Thanks,
John Halley Gotway

On Fri, Sep 18, 2020 at 12:09 PM binyu.wang at noaa.gov via RT <
met_help at ucar.edu> wrote:

>
> Fri Sep 18 12:09:11 2020: Request 96775 was acted upon.
> Transaction: Ticket created by binyu.wang at noaa.gov
>        Queue: met_help
>      Subject: remove files from database
>        Owner: Nobody
>   Requestors: binyu.wang at noaa.gov
>       Status: new
>  Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
>
>
> Hello,
>
> Would you please help to delete all the files with "Raikoke_31.0p25"
in
> the database "mv_g2g_met_verf_Raikoke"? I don't know how to do that
without
> deleting the whole database.
>
> Thank you.
> Binyu
>
>

------------------------------------------------
Subject: remove files from database
From: binyu.wang at noaa.gov
Time: Mon Sep 21 13:20:12 2020

Hello:

John, can you show me how to add the line to remove the "NO Skill"
line
under "Plot Script Commands" as we discussed this morning?

Thank you.

On Mon, Sep 21, 2020 at 3:00 PM John Halley Gotway via RT
<met_help at ucar.edu>
wrote:

> Hi Binyu,
>
> I see you have a question about METviewer database maintenance. I'm
going
> to assign this ticket to Tatiana Burek.
>
> Thanks,
> John Halley Gotway
>
> On Fri, Sep 18, 2020 at 12:09 PM binyu.wang at noaa.gov via RT <
> met_help at ucar.edu> wrote:
>
> >
> > Fri Sep 18 12:09:11 2020: Request 96775 was acted upon.
> > Transaction: Ticket created by binyu.wang at noaa.gov
> >        Queue: met_help
> >      Subject: remove files from database
> >        Owner: Nobody
> >   Requestors: binyu.wang at noaa.gov
> >       Status: new
> >  Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
> >
> >
> > Hello,
> >
> > Would you please help to delete all the files with
"Raikoke_31.0p25"  in
> > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> without
> > deleting the whole database.
> >
> > Thank you.
> > Binyu
> >
> >
>
>

------------------------------------------------
Subject: remove files from database
From: John Halley Gotway
Time: Mon Sep 21 15:55:52 2020

Binyu,

When I de-select the "Add skill line" and "Add reference line"
options, it
looks like the dashed red reference line remains.

Looking in the Rscript template here:
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl

I see 3 calls to "abline()" on lines 399 (max-skill line), 415
(no-resolution line), and 434 (no-skill line). It's the last of these
that
is not inside an "if" block. So I assume that's the one I'm not able
to
turn off.

So...
(1) "Add skill line" checkbox plots the 1-1 45 degree solid gray line.
See line 399:
https://github.com/dtcenter/METviewer/blob/d8d2e517eeb5df182c8ddaa37504a67e2a71f4ea/R_tmpl/rely.R_tmpl#L399

(2) "Add reference line" checkbox plots the red dashed horizontal
line.
See line 415:
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L415

(3) NO CHECKBOX OPTION and no skill line is always plotted as somewhat
diagonal red dashed line.
See line 434:
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L434

So what changes are needed for this plot?

>From https://metviewer.nws.noaa.gov/servlet see "binyu_rely_example".

John

On Mon, Sep 21, 2020 at 1:20 PM binyu.wang at noaa.gov via RT <
met_help at ucar.edu> wrote:

>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
>
> Hello:
>
> John, can you show me how to add the line to remove the "NO Skill"
line
> under "Plot Script Commands" as we discussed this morning?
>
> Thank you.
>
>
> On Mon, Sep 21, 2020 at 3:00 PM John Halley Gotway via RT <
> met_help at ucar.edu>
> wrote:
>
> > Hi Binyu,
> >
> > I see you have a question about METviewer database maintenance.
I'm going
> > to assign this ticket to Tatiana Burek.
> >
> > Thanks,
> > John Halley Gotway
> >
> > On Fri, Sep 18, 2020 at 12:09 PM binyu.wang at noaa.gov via RT <
> > met_help at ucar.edu> wrote:
> >
> > >
> > > Fri Sep 18 12:09:11 2020: Request 96775 was acted upon.
> > > Transaction: Ticket created by binyu.wang at noaa.gov
> > >        Queue: met_help
> > >      Subject: remove files from database
> > >        Owner: Nobody
> > >   Requestors: binyu.wang at noaa.gov
> > >       Status: new
> > >  Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775
> >
> > >
> > >
> > > Hello,
> > >
> > > Would you please help to delete all the files with
"Raikoke_31.0p25"
> in
> > > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> > without
> > > deleting the whole database.
> > >
> > > Thank you.
> > > Binyu
> > >
> > >
> >
> >
>
>

------------------------------------------------
Subject: remove files from database
From: binyu.wang at noaa.gov
Time: Mon Sep 21 19:49:18 2020

Ok, so it looks there is no easy way to turn off the "no-skill" line,
right?

Binyu

On Mon, Sep 21, 2020 at 6:00 PM John Halley Gotway via RT
<met_help at ucar.edu>
wrote:

> Binyu,
>
> When I de-select the "Add skill line" and "Add reference line"
options, it
> looks like the dashed red reference line remains.
>
> Looking in the Rscript template here:
>
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl
>
> I see 3 calls to "abline()" on lines 399 (max-skill line), 415
> (no-resolution line), and 434 (no-skill line). It's the last of
these that
> is not inside an "if" block. So I assume that's the one I'm not able
to
> turn off.
>
> So...
> (1) "Add skill line" checkbox plots the 1-1 45 degree solid gray
line.
> See line 399:
>
>
https://github.com/dtcenter/METviewer/blob/d8d2e517eeb5df182c8ddaa37504a67e2a71f4ea/R_tmpl/rely.R_tmpl#L399
>
> (2) "Add reference line" checkbox plots the red dashed horizontal
line.
> See line 415:
>
>
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L415
>
> (3) NO CHECKBOX OPTION and no skill line is always plotted as
somewhat
> diagonal red dashed line.
> See line 434:
>
>
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L434
>
> So what changes are needed for this plot?
>
> From https://metviewer.nws.noaa.gov/servlet see
"binyu_rely_example".
>
> John
>
> On Mon, Sep 21, 2020 at 1:20 PM binyu.wang at noaa.gov via RT <
> met_help at ucar.edu> wrote:
>
> >
> > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
> >
> > Hello:
> >
> > John, can you show me how to add the line to remove the "NO Skill"
line
> > under "Plot Script Commands" as we discussed this morning?
> >
> > Thank you.
> >
> >
> > On Mon, Sep 21, 2020 at 3:00 PM John Halley Gotway via RT <
> > met_help at ucar.edu>
> > wrote:
> >
> > > Hi Binyu,
> > >
> > > I see you have a question about METviewer database maintenance.
I'm
> going
> > > to assign this ticket to Tatiana Burek.
> > >
> > > Thanks,
> > > John Halley Gotway
> > >
> > > On Fri, Sep 18, 2020 at 12:09 PM binyu.wang at noaa.gov via RT <
> > > met_help at ucar.edu> wrote:
> > >
> > > >
> > > > Fri Sep 18 12:09:11 2020: Request 96775 was acted upon.
> > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > >        Queue: met_help
> > > >      Subject: remove files from database
> > > >        Owner: Nobody
> > > >   Requestors: binyu.wang at noaa.gov
> > > >       Status: new
> > > >  Ticket <URL:
> https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775
> > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > > Would you please help to delete all the files with
"Raikoke_31.0p25"
> > in
> > > > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> > > without
> > > > deleting the whole database.
> > > >
> > > > Thank you.
> > > > Binyu
> > > >
> > > >
> > >
> > >
> >
> >
>
>

------------------------------------------------
Subject: remove files from database
From: John Halley Gotway
Time: Mon Sep 21 20:37:05 2020

Binyu,

No easy way. Assuming you're running on a machine where R is
installed,
here's how you could rerun it locally.

(1) Use METviewer GUI to make the plot and download the R-script and
data
file to your machine. See attached.

(2) Clone the METviewer repo:
https://github.com/dtcenter/METviewer

(3) Link "R_work/include" into your working directory.
ln -sf METviewer/R_work/include .

(4) Edit the Rscript as follows:
#setwd("/var/lib/tomcat/webapps/metviewer//R_work/");
strDataFile = "plot_binyu_rely_example.data";
strPlotFile = "plot_binyu_rely_example.png";

(5) Execute the R script:
Rscript plot_binyu_rely_example.R

(6) Then you can edit the R script however you want, like commenting
out
the no-skill line (see attached).
[image: plot_binyu_rely_example.png]

John

On Mon, Sep 21, 2020 at 7:49 PM binyu.wang at noaa.gov via RT <
met_help at ucar.edu> wrote:

>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
>
> Ok, so it looks there is no easy way to turn off the "no-skill"
line,
> right?
>
> Binyu
>
> On Mon, Sep 21, 2020 at 6:00 PM John Halley Gotway via RT <
> met_help at ucar.edu>
> wrote:
>
> > Binyu,
> >
> > When I de-select the "Add skill line" and "Add reference line"
options,
> it
> > looks like the dashed red reference line remains.
> >
> > Looking in the Rscript template here:
> >
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl
> >
> > I see 3 calls to "abline()" on lines 399 (max-skill line), 415
> > (no-resolution line), and 434 (no-skill line). It's the last of
these
> that
> > is not inside an "if" block. So I assume that's the one I'm not
able to
> > turn off.
> >
> > So...
> > (1) "Add skill line" checkbox plots the 1-1 45 degree solid gray
line.
> > See line 399:
> >
> >
>
https://github.com/dtcenter/METviewer/blob/d8d2e517eeb5df182c8ddaa37504a67e2a71f4ea/R_tmpl/rely.R_tmpl#L399
> >
> > (2) "Add reference line" checkbox plots the red dashed horizontal
line.
> > See line 415:
> >
> >
>
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L415
> >
> > (3) NO CHECKBOX OPTION and no skill line is always plotted as
somewhat
> > diagonal red dashed line.
> > See line 434:
> >
> >
>
https://github.com/dtcenter/METviewer/blob/main_v3.1/R_tmpl/rely.R_tmpl#L434
> >
> > So what changes are needed for this plot?
> >
> > From https://metviewer.nws.noaa.gov/servlet see
"binyu_rely_example".
> >
> > John
> >
> > On Mon, Sep 21, 2020 at 1:20 PM binyu.wang at noaa.gov via RT <
> > met_help at ucar.edu> wrote:
> >
> > >
> > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775 >
> > >
> > > Hello:
> > >
> > > John, can you show me how to add the line to remove the "NO
Skill" line
> > > under "Plot Script Commands" as we discussed this morning?
> > >
> > > Thank you.
> > >
> > >
> > > On Mon, Sep 21, 2020 at 3:00 PM John Halley Gotway via RT <
> > > met_help at ucar.edu>
> > > wrote:
> > >
> > > > Hi Binyu,
> > > >
> > > > I see you have a question about METviewer database
maintenance. I'm
> > going
> > > > to assign this ticket to Tatiana Burek.
> > > >
> > > > Thanks,
> > > > John Halley Gotway
> > > >
> > > > On Fri, Sep 18, 2020 at 12:09 PM binyu.wang at noaa.gov via RT <
> > > > met_help at ucar.edu> wrote:
> > > >
> > > > >
> > > > > Fri Sep 18 12:09:11 2020: Request 96775 was acted upon.
> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > > >        Queue: met_help
> > > > >      Subject: remove files from database
> > > > >        Owner: Nobody
> > > > >   Requestors: binyu.wang at noaa.gov
> > > > >       Status: new
> > > > >  Ticket <URL:
> > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96775
> > > >
> > > > >
> > > > >
> > > > > Hello,
> > > > >
> > > > > Would you please help to delete all the files with
> "Raikoke_31.0p25"
> > > in
> > > > > the database "mv_g2g_met_verf_Raikoke"? I don't know how to
do that
> > > > without
> > > > > deleting the whole database.
> > > > >
> > > > > Thank you.
> > > > > Binyu
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

------------------------------------------------
Subject: remove files from database
From: Tatiana Burek
Time: Tue Sep 22 09:07:18 2020

Binyu
METviewer has a tool that deletes specified records from the database.
In order to use the tool you need to create a XML file where you
describe from where and what you would like to delete.
Attached is the example that would find and count all records with
model "Raikoke_31.0p25". If you want to delete the records instead
just funding - you need to change the value of <info_only> to false.

to run the tool use mv_prune_on_aws.sh script:
mv_prune_on_aws.sh binyu.wang prune2.xml

I would suggest to run XML with info_only=true to get the information
and if it works for you - change info_only=false and execute the
actual deletion.

You also can find more info on the help page:
https://metviewer.nws.noaa.gov/doc/database_scrubbing.html

Tatiana

On Fri Sep 18 12:09:11 2020, binyu.wang at noaa.gov wrote:
> Hello,
>
> Would you please help to delete all the files with "Raikoke_31.0p25"
in
> the database "mv_g2g_met_verf_Raikoke"? I don't know how to do that
without
> deleting the whole database.
>
> Thank you.
> Binyu

------------------------------------------------
Subject: remove files from database
From: binyu.wang at noaa.gov
Time: Mon Sep 28 08:55:53 2020

Hello Tatiana,

Thank you. Did you forget to put the attachment?

Binyu

On Tue, Sep 22, 2020 at 11:08 AM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:

> Binyu
> METviewer has a tool that deletes specified records from the
database. In
> order to use the tool you need to create a XML file where you
describe from
> where and what you would like to delete.
> Attached is the example that would find and count all records with
model
> "Raikoke_31.0p25". If you want to delete the records instead just
funding -
> you need to change the value of <info_only> to false.
>
> to run the tool use mv_prune_on_aws.sh script:
> mv_prune_on_aws.sh binyu.wang prune2.xml
>
> I would suggest to run XML with info_only=true to get the
information and
> if it works for you - change info_only=false and execute the actual
> deletion.
>
> You also can find more info on the help page:
> https://metviewer.nws.noaa.gov/doc/database_scrubbing.html
>
> Tatiana
>
> On Fri Sep 18 12:09:11 2020, binyu.wang at noaa.gov wrote:
> > Hello,
> >
> > Would you please help to delete all the files with
"Raikoke_31.0p25"  in
> > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> without
> > deleting the whole database.
> >
> > Thank you.
> > Binyu
>
>
>
> rds_host:3306 mv_g2g_met_verf_Raikoke rds_user rds_pwd true
> Raikoke_31.0p25

------------------------------------------------
Subject: remove files from database
From: Tatiana Burek
Time: Mon Sep 28 09:01:45 2020

On Mon Sep 28 08:55:53 2020, binyu.wang at noaa.gov wrote:
> Hello Tatiana,
>
> Thank you. Did you forget to put the attachment?
>
> Binyu
>
>
>
> On Tue, Sep 22, 2020 at 11:08 AM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Binyu
> > METviewer has a tool that deletes specified records from the
> > database. In
> > order to use the tool you need to create a XML file where you
> > describe from
> > where and what you would like to delete.
> > Attached is the example that would find and count all records with
> > model
> > "Raikoke_31.0p25". If you want to delete the records instead just
> > funding -
> > you need to change the value of <info_only> to false.
> >
> > to run the tool use mv_prune_on_aws.sh script:
> > mv_prune_on_aws.sh binyu.wang prune2.xml
> >
> > I would suggest to run XML with info_only=true to get the
information
> > and
> > if it works for you - change info_only=false and execute the
actual
> > deletion.
> >
> > You also can find more info on the help page:
> > https://metviewer.nws.noaa.gov/doc/database_scrubbing.html
> >
> > Tatiana
> >
> > On Fri Sep 18 12:09:11 2020, binyu.wang at noaa.gov wrote:
> > > Hello,
> > >
> > > Would you please help to delete all the files with
> > > "Raikoke_31.0p25"  in
> > > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> > without
> > > deleting the whole database.
> > >
> > > Thank you.
> > > Binyu
> >
> >
> >
> > rds_host:3306 mv_g2g_met_verf_Raikoke rds_user rds_pwd true
> > Raikoke_31.0p25

------------------------------------------------
Subject: remove files from database
From: Tatiana Burek
Time: Mon Sep 28 09:02:57 2020

Binyu
The file was attache to the message.
I'm sanding it again

Tatiana
On Mon Sep 28 08:55:53 2020, binyu.wang at noaa.gov wrote:
> Hello Tatiana,
>
> Thank you. Did you forget to put the attachment?
>
> Binyu
>
>
>
> On Tue, Sep 22, 2020 at 11:08 AM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Binyu
> > METviewer has a tool that deletes specified records from the
> > database. In
> > order to use the tool you need to create a XML file where you
> > describe from
> > where and what you would like to delete.
> > Attached is the example that would find and count all records with
> > model
> > "Raikoke_31.0p25". If you want to delete the records instead just
> > funding -
> > you need to change the value of <info_only> to false.
> >
> > to run the tool use mv_prune_on_aws.sh script:
> > mv_prune_on_aws.sh binyu.wang prune2.xml
> >
> > I would suggest to run XML with info_only=true to get the
information
> > and
> > if it works for you - change info_only=false and execute the
actual
> > deletion.
> >
> > You also can find more info on the help page:
> > https://metviewer.nws.noaa.gov/doc/database_scrubbing.html
> >
> > Tatiana
> >
> > On Fri Sep 18 12:09:11 2020, binyu.wang at noaa.gov wrote:
> > > Hello,
> > >
> > > Would you please help to delete all the files with
> > > "Raikoke_31.0p25"  in
> > > the database "mv_g2g_met_verf_Raikoke"? I don't know how to do
that
> > without
> > > deleting the whole database.
> > >
> > > Thank you.
> > > Binyu
> >
> >
> >
> > rds_host:3306 mv_g2g_met_verf_Raikoke rds_user rds_pwd true
> > Raikoke_31.0p25

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