[Met_help] [rt.rap.ucar.edu #99848] History for can not create database
John Halley Gotway via RT
met_help at ucar.edu
Mon Jul 12 11:31:21 MDT 2021
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hello,
I am wondering what's wrong with my script/database:
I think I did create a database named "mv_g2g_met_verf_Bezy". Because if I
tried to create it again, I will get error as:
ERROR 1007 (HY000) at line 1: Can't create database 'mv_g2g_met_verf_Bezy';
database exists
ERROR 1217 (23000) at line 6: Cannot delete or update a parent row: a
foreign key constraint fails.
However I can not find it from METviewer. There is no database called "
mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem here?
Thank you for your help.
Binyu
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: can not create database
From: John Halley Gotway
Time: Tue May 11 07:40:06 2021
Binyu,
It looks like you're having trouble accessing a newly created
METviewer
database. I just logged on to take a look:
https://metviewer.nws.noaa.gov/metviewer1.jsp
I agree that I do not see a database named mv_g2g_met_verf_Bezy in the
NCEP_Bwang group. I tried clicking the "Reload Databases" button as
well as
clearing my browser cache, but with no luck.
I'm going to assign this ticket to Tatiana. She may have a better idea
what's going on with those database error messages you're seeing:
ERROR 1007 (HY000) at line 1: Can't create database
'mv_g2g_met_verf_Bezy';
database exists
ERROR 1217 (23000) at line 6: Cannot delete or update a parent row: a
foreign key constraint fails.
Thanks,
John HG
On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
met_help at ucar.edu> wrote:
>
> Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> Transaction: Ticket created by binyu.wang at noaa.gov
> Queue: met_help
> Subject: can not create database
> Owner: Nobody
> Requestors: binyu.wang at noaa.gov
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
>
>
> Hello,
>
>
> I am wondering what's wrong with my script/database:
>
>
> I think I did create a database named "mv_g2g_met_verf_Bezy".
Because if I
> tried to create it again, I will get error as:
>
>
>
> ERROR 1007 (HY000) at line 1: Can't create database
'mv_g2g_met_verf_Bezy';
> database exists
>
> ERROR 1217 (23000) at line 6: Cannot delete or update a parent row:
a
> foreign key constraint fails.
>
>
> However I can not find it from METviewer. There is no database
called "
> mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem here?
>
> Thank you for your help.
>
> Binyu
>
>
------------------------------------------------
Subject: can not create database
From: Tatiana Burek
Time: Tue May 11 07:52:22 2021
Binyu
I lost the internet in my house and don't know when it will be back. I
will
take a look at your problem as soon as I can.
Tatiana
On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
<met_help at ucar.edu>
wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
>
> Binyu,
>
> It looks like you're having trouble accessing a newly created
METviewer
> database. I just logged on to take a look:
> https://metviewer.nws.noaa.gov/metviewer1.jsp
>
> I agree that I do not see a database named mv_g2g_met_verf_Bezy in
the
> NCEP_Bwang group. I tried clicking the "Reload Databases" button as
well as
> clearing my browser cache, but with no luck.
>
> I'm going to assign this ticket to Tatiana. She may have a better
idea
> what's going on with those database error messages you're seeing:
>
> ERROR 1007 (HY000) at line 1: Can't create database
'mv_g2g_met_verf_Bezy';
> database exists
>
> ERROR 1217 (23000) at line 6: Cannot delete or update a parent row:
a
> foreign key constraint fails.
>
> Thanks,
> John HG
>
> On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> met_help at ucar.edu> wrote:
>
> >
> > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > Transaction: Ticket created by binyu.wang at noaa.gov
> > Queue: met_help
> > Subject: can not create database
> > Owner: Nobody
> > Requestors: binyu.wang at noaa.gov
> > Status: new
> > Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
> >
> >
> > Hello,
> >
> >
> > I am wondering what's wrong with my script/database:
> >
> >
> > I think I did create a database named "mv_g2g_met_verf_Bezy".
Because if
> I
> > tried to create it again, I will get error as:
> >
> >
> >
> > ERROR 1007 (HY000) at line 1: Can't create database
> 'mv_g2g_met_verf_Bezy';
> > database exists
> >
> > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row: a
> > foreign key constraint fails.
> >
> >
> > However I can not find it from METviewer. There is no database
called "
> > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem
here?
> >
> > Thank you for your help.
> >
> > Binyu
> >
> >
>
>
------------------------------------------------
Subject: can not create database
From: binyu.wang at noaa.gov
Time: Wed May 12 09:18:50 2021
Hello Tatiana,
Sorry to hear that. I wish you could get your wifi back very soon.
Binyu
On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Binyu
> I lost the internet in my house and don't know when it will be back.
I will
> take a look at your problem as soon as I can.
>
> Tatiana
>
> On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
<met_help at ucar.edu>
> wrote:
>
> >
> > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
> >
> > Binyu,
> >
> > It looks like you're having trouble accessing a newly created
METviewer
> > database. I just logged on to take a look:
> > https://metviewer.nws.noaa.gov/metviewer1.jsp
> >
> > I agree that I do not see a database named mv_g2g_met_verf_Bezy in
the
> > NCEP_Bwang group. I tried clicking the "Reload Databases" button
as well
> as
> > clearing my browser cache, but with no luck.
> >
> > I'm going to assign this ticket to Tatiana. She may have a better
idea
> > what's going on with those database error messages you're seeing:
> >
> > ERROR 1007 (HY000) at line 1: Can't create database
> 'mv_g2g_met_verf_Bezy';
> > database exists
> >
> > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row: a
> > foreign key constraint fails.
> >
> > Thanks,
> > John HG
> >
> > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> > met_help at ucar.edu> wrote:
> >
> > >
> > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > Queue: met_help
> > > Subject: can not create database
> > > Owner: Nobody
> > > Requestors: binyu.wang at noaa.gov
> > > Status: new
> > > Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> >
> > >
> > >
> > > Hello,
> > >
> > >
> > > I am wondering what's wrong with my script/database:
> > >
> > >
> > > I think I did create a database named "mv_g2g_met_verf_Bezy".
Because
> if
> > I
> > > tried to create it again, I will get error as:
> > >
> > >
> > >
> > > ERROR 1007 (HY000) at line 1: Can't create database
> > 'mv_g2g_met_verf_Bezy';
> > > database exists
> > >
> > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row: a
> > > foreign key constraint fails.
> > >
> > >
> > > However I can not find it from METviewer. There is no database
called "
> > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem
here?
> > >
> > > Thank you for your help.
> > >
> > > Binyu
> > >
> > >
> >
> >
>
>
------------------------------------------------
Subject: can not create database
From: Tatiana Burek
Time: Wed May 12 11:48:41 2021
Binyu,
I checked and can verify that the database with the name
'mv_g2g_met_verf_Bezy' exists on the AWS server. This database doesn't
have any data and that is why METviewer doesn't display it.
Have you tried to load the data?
Tatiana
On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> Hello Tatiana,
> Sorry to hear that. I wish you could get your wifi back very soon.
>
> Binyu
>
> On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Binyu
> > I lost the internet in my house and don't know when it will be
back.
> > I will
> > take a look at your problem as soon as I can.
> >
> > Tatiana
> >
> > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > >
> > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
> > >
> > > Binyu,
> > >
> > > It looks like you're having trouble accessing a newly created
> > > METviewer
> > > database. I just logged on to take a look:
> > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> > >
> > > I agree that I do not see a database named mv_g2g_met_verf_Bezy
in
> > > the
> > > NCEP_Bwang group. I tried clicking the "Reload Databases" button
as
> > > well
> > as
> > > clearing my browser cache, but with no luck.
> > >
> > > I'm going to assign this ticket to Tatiana. She may have a
better
> > > idea
> > > what's going on with those database error messages you're
seeing:
> > >
> > > ERROR 1007 (HY000) at line 1: Can't create database
> > 'mv_g2g_met_verf_Bezy';
> > > database exists
> > >
> > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row:
> > > a
> > > foreign key constraint fails.
> > >
> > > Thanks,
> > > John HG
> > >
> > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> > > met_help at ucar.edu> wrote:
> > >
> > > >
> > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > > Queue: met_help
> > > > Subject: can not create database
> > > > Owner: Nobody
> > > > Requestors: binyu.wang at noaa.gov
> > > > Status: new
> > > > Ticket <URL:
> > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > >
> > > > I am wondering what's wrong with my script/database:
> > > >
> > > >
> > > > I think I did create a database named "mv_g2g_met_verf_Bezy".
> > > > Because
> > if
> > > I
> > > > tried to create it again, I will get error as:
> > > >
> > > >
> > > >
> > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > 'mv_g2g_met_verf_Bezy';
> > > > database exists
> > > >
> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
> > > > row: a
> > > > foreign key constraint fails.
> > > >
> > > >
> > > > However I can not find it from METviewer. There is no database
> > > > called "
> > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem
> > > > here?
> > > >
> > > > Thank you for your help.
> > > >
> > > > Binyu
> > > >
> > > >
> > >
> > >
> >
> >
------------------------------------------------
Subject: can not create database
From: George McCabe
Time: Wed May 12 12:16:40 2021
Tatiana,
It looks like you added this as a comment so it wasn't sent to Binyu.
On Wed May 12 11:48:41 2021, tatiana wrote:
> Binyu,
> I checked and can verify that the database with the name
> 'mv_g2g_met_verf_Bezy' exists on the AWS server. This database
doesn't
> have any data and that is why METviewer doesn't display it.
> Have you tried to load the data?
>
> Tatiana
>
>
> On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> > Hello Tatiana,
> > Sorry to hear that. I wish you could get your wifi back very soon.
> >
> > Binyu
> >
> > On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > > Binyu
> > > I lost the internet in my house and don't know when it will be
> > > back.
> > > I will
> > > take a look at your problem as soon as I can.
> > >
> > > Tatiana
> > >
> > > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > > >
> > > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
>
> > > >
> > > > Binyu,
> > > >
> > > > It looks like you're having trouble accessing a newly created
> > > > METviewer
> > > > database. I just logged on to take a look:
> > > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> > > >
> > > > I agree that I do not see a database named
mv_g2g_met_verf_Bezy
> > > > in
> > > > the
> > > > NCEP_Bwang group. I tried clicking the "Reload Databases"
button
> > > > as
> > > > well
> > > as
> > > > clearing my browser cache, but with no luck.
> > > >
> > > > I'm going to assign this ticket to Tatiana. She may have a
better
> > > > idea
> > > > what's going on with those database error messages you're
seeing:
> > > >
> > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > 'mv_g2g_met_verf_Bezy';
> > > > database exists
> > > >
> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
> > > > row:
> > > > a
> > > > foreign key constraint fails.
> > > >
> > > > Thanks,
> > > > John HG
> > > >
> > > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> > > > met_help at ucar.edu> wrote:
> > > >
> > > > >
> > > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > > > Queue: met_help
> > > > > Subject: can not create database
> > > > > Owner: Nobody
> > > > > Requestors: binyu.wang at noaa.gov
> > > > > Status: new
> > > > > Ticket <URL:
> > > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > > >
> > > > >
> > > > >
> > > > > Hello,
> > > > >
> > > > >
> > > > > I am wondering what's wrong with my script/database:
> > > > >
> > > > >
> > > > > I think I did create a database named
"mv_g2g_met_verf_Bezy".
> > > > > Because
> > > if
> > > > I
> > > > > tried to create it again, I will get error as:
> > > > >
> > > > >
> > > > >
> > > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > > 'mv_g2g_met_verf_Bezy';
> > > > > database exists
> > > > >
> > > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent
> > > > > row: a
> > > > > foreign key constraint fails.
> > > > >
> > > > >
> > > > > However I can not find it from METviewer. There is no
database
> > > > > called "
> > > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the
problem
> > > > > here?
> > > > >
> > > > > Thank you for your help.
> > > > >
> > > > > Binyu
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
------------------------------------------------
Subject: can not create database
From: Tatiana Burek
Time: Wed May 12 12:31:46 2021
Binyu,
I checked and can verify that the database with the name
'mv_g2g_met_verf_Bezy' exists on the AWS server. This database doesn't
have any data and that is why METviewer doesn't display it.
Have you tried to load the data?
Tatiana
On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> Hello Tatiana,
> Sorry to hear that. I wish you could get your wifi back very soon.
>
> Binyu
>
> On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Binyu
> > I lost the internet in my house and don't know when it will be
back.
> > I will
> > take a look at your problem as soon as I can.
> >
> > Tatiana
> >
> > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > >
> > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848 >
> > >
> > > Binyu,
> > >
> > > It looks like you're having trouble accessing a newly created
> > > METviewer
> > > database. I just logged on to take a look:
> > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> > >
> > > I agree that I do not see a database named mv_g2g_met_verf_Bezy
in
> > > the
> > > NCEP_Bwang group. I tried clicking the "Reload Databases" button
as
> > > well
> > as
> > > clearing my browser cache, but with no luck.
> > >
> > > I'm going to assign this ticket to Tatiana. She may have a
better
> > > idea
> > > what's going on with those database error messages you're
seeing:
> > >
> > > ERROR 1007 (HY000) at line 1: Can't create database
> > 'mv_g2g_met_verf_Bezy';
> > > database exists
> > >
> > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row:
> > > a
> > > foreign key constraint fails.
> > >
> > > Thanks,
> > > John HG
> > >
> > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> > > met_help at ucar.edu> wrote:
> > >
> > > >
> > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > > Queue: met_help
> > > > Subject: can not create database
> > > > Owner: Nobody
> > > > Requestors: binyu.wang at noaa.gov
> > > > Status: new
> > > > Ticket <URL:
> > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > >
> > > > I am wondering what's wrong with my script/database:
> > > >
> > > >
> > > > I think I did create a database named "mv_g2g_met_verf_Bezy".
> > > > Because
> > if
> > > I
> > > > tried to create it again, I will get error as:
> > > >
> > > >
> > > >
> > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > 'mv_g2g_met_verf_Bezy';
> > > > database exists
> > > >
> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
> > > > row: a
> > > > foreign key constraint fails.
> > > >
> > > >
> > > > However I can not find it from METviewer. There is no database
> > > > called "
> > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the problem
> > > > here?
> > > >
> > > > Thank you for your help.
> > > >
> > > > Binyu
> > > >
> > > >
> > >
> > >
> >
> >
------------------------------------------------
Subject: can not create database
From: binyu.wang at noaa.gov
Time: Wed May 12 18:54:17 2021
Tatiana,
Thank you for your help. I did try to load the data into the database,
here
is the script I used. I also attached the log file and XML file to
this
email. What is the problem here?
$ vi run_g2g_met_Bezy
SCRIPT=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
XML=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML
BASE_DIR
=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/stat/Bezy_31.thresh.0p1
$SCRIPT/mv_create_db_on_aws.sh binyu.wang mv_g2g_met_verf_Bezy
echo "Create database done!"
$SCRIPT/mv_load_to_aws.sh binyu.wang $BASE_DIR
$XML/load_g2g_met_verf_Bezy.xml
On Wed, May 12, 2021 at 2:31 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Binyu,
> I checked and can verify that the database with the name
> 'mv_g2g_met_verf_Bezy' exists on the AWS server. This database
doesn't have
> any data and that is why METviewer doesn't display it.
> Have you tried to load the data?
>
> Tatiana
>
> On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> > Hello Tatiana,
> > Sorry to hear that. I wish you could get your wifi back very soon.
> >
> > Binyu
> >
> > On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > > Binyu
> > > I lost the internet in my house and don't know when it will be
back.
> > > I will
> > > take a look at your problem as soon as I can.
> > >
> > > Tatiana
> > >
> > > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > > >
> > > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
>
> > > >
> > > > Binyu,
> > > >
> > > > It looks like you're having trouble accessing a newly created
> > > > METviewer
> > > > database. I just logged on to take a look:
> > > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> > > >
> > > > I agree that I do not see a database named
mv_g2g_met_verf_Bezy in
> > > > the
> > > > NCEP_Bwang group. I tried clicking the "Reload Databases"
button as
> > > > well
> > > as
> > > > clearing my browser cache, but with no luck.
> > > >
> > > > I'm going to assign this ticket to Tatiana. She may have a
better
> > > > idea
> > > > what's going on with those database error messages you're
seeing:
> > > >
> > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > 'mv_g2g_met_verf_Bezy';
> > > > database exists
> > > >
> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a parent
row:
> > > > a
> > > > foreign key constraint fails.
> > > >
> > > > Thanks,
> > > > John HG
> > > >
> > > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
> > > > met_help at ucar.edu> wrote:
> > > >
> > > > >
> > > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > > > > Queue: met_help
> > > > > Subject: can not create database
> > > > > Owner: Nobody
> > > > > Requestors: binyu.wang at noaa.gov
> > > > > Status: new
> > > > > Ticket <URL:
> > > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > > >
> > > > >
> > > > >
> > > > > Hello,
> > > > >
> > > > >
> > > > > I am wondering what's wrong with my script/database:
> > > > >
> > > > >
> > > > > I think I did create a database named
"mv_g2g_met_verf_Bezy".
> > > > > Because
> > > if
> > > > I
> > > > > tried to create it again, I will get error as:
> > > > >
> > > > >
> > > > >
> > > > > ERROR 1007 (HY000) at line 1: Can't create database
> > > > 'mv_g2g_met_verf_Bezy';
> > > > > database exists
> > > > >
> > > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent
> > > > > row: a
> > > > > foreign key constraint fails.
> > > > >
> > > > >
> > > > > However I can not find it from METviewer. There is no
database
> > > > > called "
> > > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the
problem
> > > > > here?
> > > > >
> > > > > Thank you for your help.
> > > > >
> > > > > Binyu
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
>
>
>
>
------------------------------------------------
Subject: can not create database
From: binyu.wang at noaa.gov
Time: Wed May 12 20:10:01 2021
Hello Tatiana:
I think I figured out the database problem and now I can see the
database
under METviewer. But I do recall that last year even though the
database
was empty, I still can see it under METviewer, but not anymore.
However I do have another problem: I am doing ensemble verification
like "ensemble_stat
${FILE_list} ${CONFIG_FILE_ens_stat} -grid_obs $f, however only *nc
files
are generated, not *STAT files. I did set "BOTH" for output_flag in
the
control file (please see the attachment). What is the problem here?
Thank
you.
On Wed, May 12, 2021 at 8:53 PM Binyu Wang - NOAA Affiliate <
binyu.wang at noaa.gov> wrote:
> Tatiana,
>
> Thank you for your help. I did try to load the data into the
database,
> here is the script I used. I also attached the log file and XML file
to
> this email. What is the problem here?
>
>
> $ vi run_g2g_met_Bezy
>
>
SCRIPT=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
>
>
XML=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML
>
> BASE_DIR
>
=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/stat/Bezy_31.thresh.0p1
>
>
> $SCRIPT/mv_create_db_on_aws.sh binyu.wang mv_g2g_met_verf_Bezy
>
> echo "Create database done!"
>
>
> $SCRIPT/mv_load_to_aws.sh binyu.wang $BASE_DIR
> $XML/load_g2g_met_verf_Bezy.xml
>
> On Wed, May 12, 2021 at 2:31 PM Tatiana Burek via RT
<met_help at ucar.edu>
> wrote:
>
>> Binyu,
>> I checked and can verify that the database with the name
>> 'mv_g2g_met_verf_Bezy' exists on the AWS server. This database
doesn't have
>> any data and that is why METviewer doesn't display it.
>> Have you tried to load the data?
>>
>> Tatiana
>>
>> On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
>> > Hello Tatiana,
>> > Sorry to hear that. I wish you could get your wifi back very
soon.
>> >
>> > Binyu
>> >
>> > On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
>> > <met_help at ucar.edu>
>> > wrote:
>> >
>> > > Binyu
>> > > I lost the internet in my house and don't know when it will be
back.
>> > > I will
>> > > take a look at your problem as soon as I can.
>> > >
>> > > Tatiana
>> > >
>> > > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
>> > > <met_help at ucar.edu>
>> > > wrote:
>> > >
>> > > >
>> > > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
>
>> > > >
>> > > > Binyu,
>> > > >
>> > > > It looks like you're having trouble accessing a newly created
>> > > > METviewer
>> > > > database. I just logged on to take a look:
>> > > > https://metviewer.nws.noaa.gov/metviewer1.jsp
>> > > >
>> > > > I agree that I do not see a database named
mv_g2g_met_verf_Bezy in
>> > > > the
>> > > > NCEP_Bwang group. I tried clicking the "Reload Databases"
button as
>> > > > well
>> > > as
>> > > > clearing my browser cache, but with no luck.
>> > > >
>> > > > I'm going to assign this ticket to Tatiana. She may have a
better
>> > > > idea
>> > > > what's going on with those database error messages you're
seeing:
>> > > >
>> > > > ERROR 1007 (HY000) at line 1: Can't create database
>> > > 'mv_g2g_met_verf_Bezy';
>> > > > database exists
>> > > >
>> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent row:
>> > > > a
>> > > > foreign key constraint fails.
>> > > >
>> > > > Thanks,
>> > > > John HG
>> > > >
>> > > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT <
>> > > > met_help at ucar.edu> wrote:
>> > > >
>> > > > >
>> > > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
>> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
>> > > > > Queue: met_help
>> > > > > Subject: can not create database
>> > > > > Owner: Nobody
>> > > > > Requestors: binyu.wang at noaa.gov
>> > > > > Status: new
>> > > > > Ticket <URL:
>> > > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
>> > > >
>> > > > >
>> > > > >
>> > > > > Hello,
>> > > > >
>> > > > >
>> > > > > I am wondering what's wrong with my script/database:
>> > > > >
>> > > > >
>> > > > > I think I did create a database named
"mv_g2g_met_verf_Bezy".
>> > > > > Because
>> > > if
>> > > > I
>> > > > > tried to create it again, I will get error as:
>> > > > >
>> > > > >
>> > > > >
>> > > > > ERROR 1007 (HY000) at line 1: Can't create database
>> > > > 'mv_g2g_met_verf_Bezy';
>> > > > > database exists
>> > > > >
>> > > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent
>> > > > > row: a
>> > > > > foreign key constraint fails.
>> > > > >
>> > > > >
>> > > > > However I can not find it from METviewer. There is no
database
>> > > > > called "
>> > > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the
problem
>> > > > > here?
>> > > > >
>> > > > > Thank you for your help.
>> > > > >
>> > > > > Binyu
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>>
>>
>>
>>
------------------------------------------------
Subject: can not create database
From: Tatiana Burek
Time: Thu May 13 11:58:42 2021
Binyu,
John Halley Gotway is the person how can help you with ensemble_stat.
I will assign this ticket to him.
Tatiana
On Wed May 12 20:10:01 2021, binyu.wang at noaa.gov wrote:
> Hello Tatiana:
>
> I think I figured out the database problem and now I can see the
> database
> under METviewer. But I do recall that last year even though the
> database
> was empty, I still can see it under METviewer, but not anymore.
>
> However I do have another problem: I am doing ensemble verification
> like "ensemble_stat
> ${FILE_list} ${CONFIG_FILE_ens_stat} -grid_obs $f, however only *nc
> files
> are generated, not *STAT files. I did set "BOTH" for output_flag in
> the
> control file (please see the attachment). What is the problem here?
> Thank
> you.
>
> On Wed, May 12, 2021 at 8:53 PM Binyu Wang - NOAA Affiliate <
> binyu.wang at noaa.gov> wrote:
>
> > Tatiana,
> >
> > Thank you for your help. I did try to load the data into the
> > database,
> > here is the script I used. I also attached the log file and XML
file
> > to
> > this email. What is the problem here?
> >
> >
> > $ vi run_g2g_met_Bezy
> >
> >
SCRIPT=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
> >
> >
XML=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML
> >
> > BASE_DIR
> >
=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/stat/Bezy_31.thresh.0p1
> >
> >
> > $SCRIPT/mv_create_db_on_aws.sh binyu.wang mv_g2g_met_verf_Bezy
> >
> > echo "Create database done!"
> >
> >
> > $SCRIPT/mv_load_to_aws.sh binyu.wang $BASE_DIR
> > $XML/load_g2g_met_verf_Bezy.xml
> >
> > On Wed, May 12, 2021 at 2:31 PM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> >> Binyu,
> >> I checked and can verify that the database with the name
> >> 'mv_g2g_met_verf_Bezy' exists on the AWS server. This database
> >> doesn't have
> >> any data and that is why METviewer doesn't display it.
> >> Have you tried to load the data?
> >>
> >> Tatiana
> >>
> >> On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> >> > Hello Tatiana,
> >> > Sorry to hear that. I wish you could get your wifi back very
soon.
> >> >
> >> > Binyu
> >> >
> >> > On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> >> > <met_help at ucar.edu>
> >> > wrote:
> >> >
> >> > > Binyu
> >> > > I lost the internet in my house and don't know when it will
be
> >> > > back.
> >> > > I will
> >> > > take a look at your problem as soon as I can.
> >> > >
> >> > > Tatiana
> >> > >
> >> > > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> >> > > <met_help at ucar.edu>
> >> > > wrote:
> >> > >
> >> > > >
> >> > > > <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> >> > > > >
> >> > > >
> >> > > > Binyu,
> >> > > >
> >> > > > It looks like you're having trouble accessing a newly
created
> >> > > > METviewer
> >> > > > database. I just logged on to take a look:
> >> > > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> >> > > >
> >> > > > I agree that I do not see a database named
> >> > > > mv_g2g_met_verf_Bezy in
> >> > > > the
> >> > > > NCEP_Bwang group. I tried clicking the "Reload Databases"
> >> > > > button as
> >> > > > well
> >> > > as
> >> > > > clearing my browser cache, but with no luck.
> >> > > >
> >> > > > I'm going to assign this ticket to Tatiana. She may have a
> >> > > > better
> >> > > > idea
> >> > > > what's going on with those database error messages you're
> >> > > > seeing:
> >> > > >
> >> > > > ERROR 1007 (HY000) at line 1: Can't create database
> >> > > 'mv_g2g_met_verf_Bezy';
> >> > > > database exists
> >> > > >
> >> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent
> >> > > > row:
> >> > > > a
> >> > > > foreign key constraint fails.
> >> > > >
> >> > > > Thanks,
> >> > > > John HG
> >> > > >
> >> > > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via RT
<
> >> > > > met_help at ucar.edu> wrote:
> >> > > >
> >> > > > >
> >> > > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> >> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
> >> > > > > Queue: met_help
> >> > > > > Subject: can not create database
> >> > > > > Owner: Nobody
> >> > > > > Requestors: binyu.wang at noaa.gov
> >> > > > > Status: new
> >> > > > > Ticket <URL:
> >> > > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> >> > > >
> >> > > > >
> >> > > > >
> >> > > > > Hello,
> >> > > > >
> >> > > > >
> >> > > > > I am wondering what's wrong with my script/database:
> >> > > > >
> >> > > > >
> >> > > > > I think I did create a database named
> >> > > > > "mv_g2g_met_verf_Bezy".
> >> > > > > Because
> >> > > if
> >> > > > I
> >> > > > > tried to create it again, I will get error as:
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > > > ERROR 1007 (HY000) at line 1: Can't create database
> >> > > > 'mv_g2g_met_verf_Bezy';
> >> > > > > database exists
> >> > > > >
> >> > > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
> >> > > > > parent
> >> > > > > row: a
> >> > > > > foreign key constraint fails.
> >> > > > >
> >> > > > >
> >> > > > > However I can not find it from METviewer. There is no
> >> > > > > database
> >> > > > > called "
> >> > > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the
> >> > > > > problem
> >> > > > > here?
> >> > > > >
> >> > > > > Thank you for your help.
> >> > > > >
> >> > > > > Binyu
> >> > > > >
> >> > > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >>
> >>
> >>
> >>
------------------------------------------------
Subject: can not create database
From: binyu.wang at noaa.gov
Time: Thu May 13 13:34:07 2021
Hello John,
Since you were able to access WCOSS, I can point you where all the
related
files are:
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/grid2grid/verf_met_ens/ush/
verf_g2g_Bezy_31.0p5.sh
and configure file:
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/grid2grid/verf_met_ens/parm/
verf_g2g_ens_stat_regn_config_Bezy
My question is: why "ensemble_stat" only creates *nc files, not *STAT
files? I did set "BOTH" to output_flag in the control file.
Thank you.
Binyu
On Thu, May 13, 2021 at 1:58 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Binyu,
> John Halley Gotway is the person how can help you with
ensemble_stat.
> I will assign this ticket to him.
>
> Tatiana
>
> On Wed May 12 20:10:01 2021, binyu.wang at noaa.gov wrote:
> > Hello Tatiana:
> >
> > I think I figured out the database problem and now I can see the
> > database
> > under METviewer. But I do recall that last year even though the
> > database
> > was empty, I still can see it under METviewer, but not anymore.
> >
> > However I do have another problem: I am doing ensemble
verification
> > like "ensemble_stat
> > ${FILE_list} ${CONFIG_FILE_ens_stat} -grid_obs $f, however only
*nc
> > files
> > are generated, not *STAT files. I did set "BOTH" for output_flag
in
> > the
> > control file (please see the attachment). What is the problem
here?
> > Thank
> > you.
> >
> > On Wed, May 12, 2021 at 8:53 PM Binyu Wang - NOAA Affiliate <
> > binyu.wang at noaa.gov> wrote:
> >
> > > Tatiana,
> > >
> > > Thank you for your help. I did try to load the data into the
> > > database,
> > > here is the script I used. I also attached the log file and XML
file
> > > to
> > > this email. What is the problem here?
> > >
> > >
> > > $ vi run_g2g_met_Bezy
> > >
> > >
>
SCRIPT=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
> > >
> > >
>
XML=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML
> > >
> > > BASE_DIR
> > >
>
=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/stat/Bezy_31.thresh.0p1
> > >
> > >
> > > $SCRIPT/mv_create_db_on_aws.sh binyu.wang mv_g2g_met_verf_Bezy
> > >
> > > echo "Create database done!"
> > >
> > >
> > > $SCRIPT/mv_load_to_aws.sh binyu.wang $BASE_DIR
> > > $XML/load_g2g_met_verf_Bezy.xml
> > >
> > > On Wed, May 12, 2021 at 2:31 PM Tatiana Burek via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > >> Binyu,
> > >> I checked and can verify that the database with the name
> > >> 'mv_g2g_met_verf_Bezy' exists on the AWS server. This database
> > >> doesn't have
> > >> any data and that is why METviewer doesn't display it.
> > >> Have you tried to load the data?
> > >>
> > >> Tatiana
> > >>
> > >> On Wed May 12 09:18:50 2021, binyu.wang at noaa.gov wrote:
> > >> > Hello Tatiana,
> > >> > Sorry to hear that. I wish you could get your wifi back very
soon.
> > >> >
> > >> > Binyu
> > >> >
> > >> > On Tue, May 11, 2021 at 9:52 AM Tatiana Burek via RT
> > >> > <met_help at ucar.edu>
> > >> > wrote:
> > >> >
> > >> > > Binyu
> > >> > > I lost the internet in my house and don't know when it will
be
> > >> > > back.
> > >> > > I will
> > >> > > take a look at your problem as soon as I can.
> > >> > >
> > >> > > Tatiana
> > >> > >
> > >> > > On Tue, May 11, 2021, 07:40 John Halley Gotway via RT
> > >> > > <met_help at ucar.edu>
> > >> > > wrote:
> > >> > >
> > >> > > >
> > >> > > > <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > >> > > > >
> > >> > > >
> > >> > > > Binyu,
> > >> > > >
> > >> > > > It looks like you're having trouble accessing a newly
created
> > >> > > > METviewer
> > >> > > > database. I just logged on to take a look:
> > >> > > > https://metviewer.nws.noaa.gov/metviewer1.jsp
> > >> > > >
> > >> > > > I agree that I do not see a database named
> > >> > > > mv_g2g_met_verf_Bezy in
> > >> > > > the
> > >> > > > NCEP_Bwang group. I tried clicking the "Reload Databases"
> > >> > > > button as
> > >> > > > well
> > >> > > as
> > >> > > > clearing my browser cache, but with no luck.
> > >> > > >
> > >> > > > I'm going to assign this ticket to Tatiana. She may have
a
> > >> > > > better
> > >> > > > idea
> > >> > > > what's going on with those database error messages you're
> > >> > > > seeing:
> > >> > > >
> > >> > > > ERROR 1007 (HY000) at line 1: Can't create database
> > >> > > 'mv_g2g_met_verf_Bezy';
> > >> > > > database exists
> > >> > > >
> > >> > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
parent
> > >> > > > row:
> > >> > > > a
> > >> > > > foreign key constraint fails.
> > >> > > >
> > >> > > > Thanks,
> > >> > > > John HG
> > >> > > >
> > >> > > > On Mon, May 10, 2021 at 9:37 PM binyu.wang at noaa.gov via
RT <
> > >> > > > met_help at ucar.edu> wrote:
> > >> > > >
> > >> > > > >
> > >> > > > > Mon May 10 21:37:22 2021: Request 99848 was acted upon.
> > >> > > > > Transaction: Ticket created by binyu.wang at noaa.gov
> > >> > > > > Queue: met_help
> > >> > > > > Subject: can not create database
> > >> > > > > Owner: Nobody
> > >> > > > > Requestors: binyu.wang at noaa.gov
> > >> > > > > Status: new
> > >> > > > > Ticket <URL:
> > >> > > > > https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=99848
> > >> > > >
> > >> > > > >
> > >> > > > >
> > >> > > > > Hello,
> > >> > > > >
> > >> > > > >
> > >> > > > > I am wondering what's wrong with my script/database:
> > >> > > > >
> > >> > > > >
> > >> > > > > I think I did create a database named
> > >> > > > > "mv_g2g_met_verf_Bezy".
> > >> > > > > Because
> > >> > > if
> > >> > > > I
> > >> > > > > tried to create it again, I will get error as:
> > >> > > > >
> > >> > > > >
> > >> > > > >
> > >> > > > > ERROR 1007 (HY000) at line 1: Can't create database
> > >> > > > 'mv_g2g_met_verf_Bezy';
> > >> > > > > database exists
> > >> > > > >
> > >> > > > > ERROR 1217 (23000) at line 6: Cannot delete or update a
> > >> > > > > parent
> > >> > > > > row: a
> > >> > > > > foreign key constraint fails.
> > >> > > > >
> > >> > > > >
> > >> > > > > However I can not find it from METviewer. There is no
> > >> > > > > database
> > >> > > > > called "
> > >> > > > > mv_g2g_met_verf_Bezy" under "NCEP_Bwang". What is the
> > >> > > > > problem
> > >> > > > > here?
> > >> > > > >
> > >> > > > > Thank you for your help.
> > >> > > > >
> > >> > > > > Binyu
> > >> > > > >
> > >> > > > >
> > >> > > >
> > >> > > >
> > >> > >
> > >> > >
> > >>
> > >>
> > >>
> > >>
>
>
>
>
------------------------------------------------
Subject: can not create database
From: John Halley Gotway
Time: Thu May 13 13:45:14 2021
Binyu,
When I attempt to log on to WCOSS, it keeps telling me that my
"authentication failed". Not sure if WCOSS is locked down right now or
if
something else is going on?
Regardless, I'm not able to log on directly and debug.
The most likely reason for not getting any .stat output is either...
(1) Failing to configured the "fcst" and "obs" dictionaries to specify
which fields/levels should be verified.
(2) Failing to pass gridded or point observations to ensemble stat for
that
verification.
Please carefully inspect the METplus log file and find the actual call
it
is making to ensemble-stat. Do you see the -grid_obs and/or -point_obs
option to pass in verifying obs?
Then at the log output from ensemble-stat... it should tell you at
least
the top-level steps of what it's doing.
If you want more log output to tell you what it's doing,
reconfigure/rerun
METplus after checking the METplus log level from INFO to DEBUG. And
you
could increase the verbosity level of the call to ensemble-stat. The
default value is 2, but you could increase it to 4 or 5.
If you need help interpreting what the log files are telling you,
please
post them to our anonymous ftp site following these instructions:
https://dtcenter.org/community-code/model-evaluation-tools-met/met-
help-desk#ftp
Understanding the log output will be really helpful to you in the long
run.
Thanks,
John
------------------------------------------------
Subject: can not create database
From: binyu.wang at noaa.gov
Time: Thu May 13 15:10:53 2021
Thank you, John.
WCOSS is down today and just came back. Actually following your
instructions, I did find the problem: the reference file is pointed to
the
wrong location in my run script. I didn't realize it was used before.
It
reminds me another question: if I don't use "REFERENCE", I will not be
able
to create a climatology line in the RELY plot, except that, what other
problem will it lead to?
Binyu
On Thu, May 13, 2021 at 3:45 PM John Halley Gotway via RT
<met_help at ucar.edu>
wrote:
> Binyu,
>
> When I attempt to log on to WCOSS, it keeps telling me that my
> "authentication failed". Not sure if WCOSS is locked down right now
or if
> something else is going on?
>
> Regardless, I'm not able to log on directly and debug.
>
> The most likely reason for not getting any .stat output is either...
> (1) Failing to configured the "fcst" and "obs" dictionaries to
specify
> which fields/levels should be verified.
> (2) Failing to pass gridded or point observations to ensemble stat
for that
> verification.
>
> Please carefully inspect the METplus log file and find the actual
call it
> is making to ensemble-stat. Do you see the -grid_obs and/or
-point_obs
> option to pass in verifying obs?
> Then at the log output from ensemble-stat... it should tell you at
least
> the top-level steps of what it's doing.
> If you want more log output to tell you what it's doing,
reconfigure/rerun
> METplus after checking the METplus log level from INFO to DEBUG. And
you
> could increase the verbosity level of the call to ensemble-stat. The
> default value is 2, but you could increase it to 4 or 5.
>
> If you need help interpreting what the log files are telling you,
please
> post them to our anonymous ftp site following these instructions:
>
>
> https://dtcenter.org/community-code/model-evaluation-tools-met/met-
help-desk#ftp
>
> Understanding the log output will be really helpful to you in the
long run.
>
> Thanks,
> John
>
>
------------------------------------------------
More information about the Met_help
mailing list