[Met_help] [rt.rap.ucar.edu #95751] History for MySQL syntax error
Tatiana Burek via RT
met_help at ucar.edu
Mon Jun 29 12:17:41 MDT 2020
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
I'm running an updated version of my time series script with results from
four separate models, all of which are being compared to observations. I'm
able to produce results on metviewer but cannot successfully produce these
results in plot batch mode. I've looked carefully at my xml file compared
to what's in metviewer. There are few differences, and the differences
that do exist are irrelevant. I'm attaching my xml file below. The error
I'm receiving is as follows:
0', '2020-06-22 05:00:00', '2020-06-22 06:00:00', '2020-06-22 07:00:00',
'2020-06-22 08:00:00', '2020-06-22 09:00:00', '2020-06-22 10:00:00',
'2020-06-22 11:00:00', '2020-06-22 12:00:00', '2020-06-22 13:00:00',
'2020-06-22 14:00:00', '2020-06-22 15:00:00', '2020-06-22 16:00:00',
'2020-06-22 17:00:00', '2020-06-22 18:00:00', '2020-06-22 19:00:00',
'2020-06-22 20:00:00', '2020-06-22 21:00:00', '2020-06-22 22:00:00',
'2020-06-22 23:00:00', '2020-06-23 00:00:00', '2020-06-23 01:00:00',
'2020-06-23 02:00:00', '2020-06-23 03:00:00', '2020-06-23 04:00:00',
'2020-06-23 05:00:00', '2020-06-23 06:00:00', '2020-06-23 07:00:00',
'2020-06-23 08:00:00', '2020-06-23 09:00:00', '2020-06-23 10:00:00',
'2020-06-23 11:00:00', '2020-06-23 12:00:00', '2020-06-23 13:00:00',
'2020-06-23 14:00:00', '2020-06-23 15:00:00', '2020-06-23 16:00:00',
'2020-06-23 17:00:00', '2020-06-23 18:00:00', '2020-06-23 19:00:00',
'2020-06-23 20:00:00', '2020-06-23 21:00:00', '2020-06-23 22:00:00',
'2020-06-23 23:00:00')
AND BINARY h.fcst_var = 'OZCON'
AND ld.stat_header_id = h.stat_header_id;
2020-06-28
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.executeQueriesAndSaveToFile(Unknown
Source) -1 executeQueriesAndSaveToFile - (conn=2995016) You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ')
Database query time for mv_cmaq_metplus 0:00:00.000
Running Rscript /opt/metviewer/R_work/include/sum_stat.R
==== Start Rscript output ====
file: /data/mv_data/edward.strobach/data/
plot_CMAQ_Time_Series_Ed.sum_stat.info
==== End Rscript output ====
==== Start Rscript error ====
Error in read.table(file = file, header = header, sep = sep, quote = quote,
:
no lines available in input
Calls: read.delim -> read.table
Execution halted
==== End Rscript error ====
Rscript time 0:00:00.247
Running Rscript
/data/mv_data/edward.strobach/scripts/plot_CMAQ_Time_Series_Demo.R
==== Start Rscript error ====
Error in file(file, "rt") : cannot open the connection
Calls: read.delim -> read.table -> file
In addition: Warning message:
In file(file, "rt") :
cannot open file
'/data/mv_data/edward.strobach/data/plot_CMAQ_Time_Series_Ed.data': No such
file or directory
Execution halted
==== End Rscript error ====
Failed to create plot
/data/mv_data/edward.strobach/plots/OZCON_2020_06_22_THROUGH_2020_06_23.png
Rscript time 0:00:00.160
Job 1 execution time 0:00:00.450
There's references to Rscript error, and it's not clear at this point what
I would need to do to resolve this.
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: MySQL syntax error
From: John Halley Gotway
Time: Sat Jun 27 22:20:56 2020
Hi Ed,
I'm going to assign this issue to Tatiana Burek. She should be able to
help
debug this issue this week.
Thanks,
John
On Sat, Jun 27, 2020 at 8:03 PM Edward Strobach - NOAA Affiliate via
RT <
met_help at ucar.edu> wrote:
>
> Sat Jun 27 20:03:10 2020: Request 95751 was acted upon.
> Transaction: Ticket created by edward.strobach at noaa.gov
> Queue: met_help
> Subject: MySQL syntax error
> Owner: Nobody
> Requestors: edward.strobach at noaa.gov
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=95751 >
>
>
> I'm running an updated version of my time series script with results
from
> four separate models, all of which are being compared to
observations. I'm
> able to produce results on metviewer but cannot successfully produce
these
> results in plot batch mode. I've looked carefully at my xml file
compared
> to what's in metviewer. There are few differences, and the
differences
> that do exist are irrelevant. I'm attaching my xml file below. The
error
> I'm receiving is as follows:
>
> 0', '2020-06-22 05:00:00', '2020-06-22 06:00:00', '2020-06-22
07:00:00',
> '2020-06-22 08:00:00', '2020-06-22 09:00:00', '2020-06-22 10:00:00',
> '2020-06-22 11:00:00', '2020-06-22 12:00:00', '2020-06-22 13:00:00',
> '2020-06-22 14:00:00', '2020-06-22 15:00:00', '2020-06-22 16:00:00',
> '2020-06-22 17:00:00', '2020-06-22 18:00:00', '2020-06-22 19:00:00',
> '2020-06-22 20:00:00', '2020-06-22 21:00:00', '2020-06-22 22:00:00',
> '2020-06-22 23:00:00', '2020-06-23 00:00:00', '2020-06-23 01:00:00',
> '2020-06-23 02:00:00', '2020-06-23 03:00:00', '2020-06-23 04:00:00',
> '2020-06-23 05:00:00', '2020-06-23 06:00:00', '2020-06-23 07:00:00',
> '2020-06-23 08:00:00', '2020-06-23 09:00:00', '2020-06-23 10:00:00',
> '2020-06-23 11:00:00', '2020-06-23 12:00:00', '2020-06-23 13:00:00',
> '2020-06-23 14:00:00', '2020-06-23 15:00:00', '2020-06-23 16:00:00',
> '2020-06-23 17:00:00', '2020-06-23 18:00:00', '2020-06-23 19:00:00',
> '2020-06-23 20:00:00', '2020-06-23 21:00:00', '2020-06-23 22:00:00',
> '2020-06-23 23:00:00')
> AND BINARY h.fcst_var = 'OZCON'
> AND ld.stat_header_id = h.stat_header_id;
>
> 2020-06-28
>
>
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.executeQueriesAndSaveToFile(Unknown
> Source) -1 executeQueriesAndSaveToFile - (conn=2995016) You have an
error
> in your SQL syntax; check the manual that corresponds to your MySQL
server
> version for the right syntax to use near ')
> Database query time for mv_cmaq_metplus 0:00:00.000
>
> Running Rscript /opt/metviewer/R_work/include/sum_stat.R
> ==== Start Rscript output ====
> file: /data/mv_data/edward.strobach/data/
> plot_CMAQ_Time_Series_Ed.sum_stat.info
> ==== End Rscript output ====
> ==== Start Rscript error ====
> Error in read.table(file = file, header = header, sep = sep, quote =
quote,
> :
> no lines available in input
> Calls: read.delim -> read.table
> Execution halted
> ==== End Rscript error ====
> Rscript time 0:00:00.247
>
> Running Rscript
> /data/mv_data/edward.strobach/scripts/plot_CMAQ_Time_Series_Demo.R
> ==== Start Rscript error ====
> Error in file(file, "rt") : cannot open the connection
> Calls: read.delim -> read.table -> file
> In addition: Warning message:
> In file(file, "rt") :
> cannot open file
> '/data/mv_data/edward.strobach/data/plot_CMAQ_Time_Series_Ed.data':
No such
> file or directory
> Execution halted
> ==== End Rscript error ====
> Failed to create plot
>
/data/mv_data/edward.strobach/plots/OZCON_2020_06_22_THROUGH_2020_06_23.png
> Rscript time 0:00:00.160
>
> Job 1 execution time 0:00:00.450
>
> There's references to Rscript error, and it's not clear at this
point what
> I would need to do to resolve this.
>
> --
> Edward Strobach
> EMC/NCEP/NWS/
> IMSG Contractor
> Cubicle#: 2029
> 301-683-3717
>
>
------------------------------------------------
Subject: MySQL syntax error
From: Tatiana Burek
Time: Mon Jun 29 08:55:17 2020
Hi Ed,
<set> element doesn't work with <date_list>.
You need to remove it from your xml. Try this:
<field equalize="false" name="fcst_init_beg">
<date_list name="idates"/>
</field>
Tatiana
On Sat Jun 27 22:20:56 2020, johnhg wrote:
> Hi Ed,
>
> I'm going to assign this issue to Tatiana Burek. She should be able
to
> help
> debug this issue this week.
>
> Thanks,
> John
>
> On Sat, Jun 27, 2020 at 8:03 PM Edward Strobach - NOAA Affiliate via
> RT <
> met_help at ucar.edu> wrote:
>
> >
> > Sat Jun 27 20:03:10 2020: Request 95751 was acted upon.
> > Transaction: Ticket created by edward.strobach at noaa.gov
> > Queue: met_help
> > Subject: MySQL syntax error
> > Owner: Nobody
> > Requestors: edward.strobach at noaa.gov
> > Status: new
> > Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=95751
> > >
> >
> >
> > I'm running an updated version of my time series script with
results
> > from
> > four separate models, all of which are being compared to
> > observations. I'm
> > able to produce results on metviewer but cannot successfully
produce
> > these
> > results in plot batch mode. I've looked carefully at my xml file
> > compared
> > to what's in metviewer. There are few differences, and the
> > differences
> > that do exist are irrelevant. I'm attaching my xml file below.
The
> > error
> > I'm receiving is as follows:
> >
> > 0', '2020-06-22 05:00:00', '2020-06-22 06:00:00', '2020-06-22
> > 07:00:00',
> > '2020-06-22 08:00:00', '2020-06-22 09:00:00', '2020-06-22
10:00:00',
> > '2020-06-22 11:00:00', '2020-06-22 12:00:00', '2020-06-22
13:00:00',
> > '2020-06-22 14:00:00', '2020-06-22 15:00:00', '2020-06-22
16:00:00',
> > '2020-06-22 17:00:00', '2020-06-22 18:00:00', '2020-06-22
19:00:00',
> > '2020-06-22 20:00:00', '2020-06-22 21:00:00', '2020-06-22
22:00:00',
> > '2020-06-22 23:00:00', '2020-06-23 00:00:00', '2020-06-23
01:00:00',
> > '2020-06-23 02:00:00', '2020-06-23 03:00:00', '2020-06-23
04:00:00',
> > '2020-06-23 05:00:00', '2020-06-23 06:00:00', '2020-06-23
07:00:00',
> > '2020-06-23 08:00:00', '2020-06-23 09:00:00', '2020-06-23
10:00:00',
> > '2020-06-23 11:00:00', '2020-06-23 12:00:00', '2020-06-23
13:00:00',
> > '2020-06-23 14:00:00', '2020-06-23 15:00:00', '2020-06-23
16:00:00',
> > '2020-06-23 17:00:00', '2020-06-23 18:00:00', '2020-06-23
19:00:00',
> > '2020-06-23 20:00:00', '2020-06-23 21:00:00', '2020-06-23
22:00:00',
> > '2020-06-23 23:00:00')
> > AND BINARY h.fcst_var = 'OZCON'
> > AND ld.stat_header_id = h.stat_header_id;
> >
> > 2020-06-28
> >
> >
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.executeQueriesAndSaveToFile(Unknown
> > Source) -1 executeQueriesAndSaveToFile - (conn=2995016) You have
an
> > error
> > in your SQL syntax; check the manual that corresponds to your
MySQL
> > server
> > version for the right syntax to use near ')
> > Database query time for mv_cmaq_metplus 0:00:00.000
> >
> > Running Rscript /opt/metviewer/R_work/include/sum_stat.R
> > ==== Start Rscript output ====
> > file: /data/mv_data/edward.strobach/data/
> > plot_CMAQ_Time_Series_Ed.sum_stat.info
> > ==== End Rscript output ====
> > ==== Start Rscript error ====
> > Error in read.table(file = file, header = header, sep = sep, quote
=
> > quote,
> > :
> > no lines available in input
> > Calls: read.delim -> read.table
> > Execution halted
> > ==== End Rscript error ====
> > Rscript time 0:00:00.247
> >
> > Running Rscript
> > /data/mv_data/edward.strobach/scripts/plot_CMAQ_Time_Series_Demo.R
> > ==== Start Rscript error ====
> > Error in file(file, "rt") : cannot open the connection
> > Calls: read.delim -> read.table -> file
> > In addition: Warning message:
> > In file(file, "rt") :
> > cannot open file
> >
'/data/mv_data/edward.strobach/data/plot_CMAQ_Time_Series_Ed.data':
> > No such
> > file or directory
> > Execution halted
> > ==== End Rscript error ====
> > Failed to create plot
> >
/data/mv_data/edward.strobach/plots/OZCON_2020_06_22_THROUGH_2020_06_23.png
> > Rscript time 0:00:00.160
> >
> > Job 1 execution time 0:00:00.450
> >
> > There's references to Rscript error, and it's not clear at this
point
> > what
> > I would need to do to resolve this.
> >
> > --
> > Edward Strobach
> > EMC/NCEP/NWS/
> > IMSG Contractor
> > Cubicle#: 2029
> > 301-683-3717
> >
> >
------------------------------------------------
Subject: MySQL syntax error
From: Edward Strobach - NOAA Affiliate
Time: Mon Jun 29 12:09:38 2020
Thank you for catching that. I was able to resolve my issue
On Mon, Jun 29, 2020 at 10:55 AM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Hi Ed,
> <set> element doesn't work with <date_list>.
> You need to remove it from your xml. Try this:
> <field equalize="false" name="fcst_init_beg">
> <date_list name="idates"/>
> </field>
>
> Tatiana
>
> On Sat Jun 27 22:20:56 2020, johnhg wrote:
> > Hi Ed,
> >
> > I'm going to assign this issue to Tatiana Burek. She should be
able to
> > help
> > debug this issue this week.
> >
> > Thanks,
> > John
> >
> > On Sat, Jun 27, 2020 at 8:03 PM Edward Strobach - NOAA Affiliate
via
> > RT <
> > met_help at ucar.edu> wrote:
> >
> > >
> > > Sat Jun 27 20:03:10 2020: Request 95751 was acted upon.
> > > Transaction: Ticket created by edward.strobach at noaa.gov
> > > Queue: met_help
> > > Subject: MySQL syntax error
> > > Owner: Nobody
> > > Requestors: edward.strobach at noaa.gov
> > > Status: new
> > > Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=95751
> > > >
> > >
> > >
> > > I'm running an updated version of my time series script with
results
> > > from
> > > four separate models, all of which are being compared to
> > > observations. I'm
> > > able to produce results on metviewer but cannot successfully
produce
> > > these
> > > results in plot batch mode. I've looked carefully at my xml
file
> > > compared
> > > to what's in metviewer. There are few differences, and the
> > > differences
> > > that do exist are irrelevant. I'm attaching my xml file below.
The
> > > error
> > > I'm receiving is as follows:
> > >
> > > 0', '2020-06-22 05:00:00', '2020-06-22 06:00:00', '2020-06-22
> > > 07:00:00',
> > > '2020-06-22 08:00:00', '2020-06-22 09:00:00', '2020-06-22
10:00:00',
> > > '2020-06-22 11:00:00', '2020-06-22 12:00:00', '2020-06-22
13:00:00',
> > > '2020-06-22 14:00:00', '2020-06-22 15:00:00', '2020-06-22
16:00:00',
> > > '2020-06-22 17:00:00', '2020-06-22 18:00:00', '2020-06-22
19:00:00',
> > > '2020-06-22 20:00:00', '2020-06-22 21:00:00', '2020-06-22
22:00:00',
> > > '2020-06-22 23:00:00', '2020-06-23 00:00:00', '2020-06-23
01:00:00',
> > > '2020-06-23 02:00:00', '2020-06-23 03:00:00', '2020-06-23
04:00:00',
> > > '2020-06-23 05:00:00', '2020-06-23 06:00:00', '2020-06-23
07:00:00',
> > > '2020-06-23 08:00:00', '2020-06-23 09:00:00', '2020-06-23
10:00:00',
> > > '2020-06-23 11:00:00', '2020-06-23 12:00:00', '2020-06-23
13:00:00',
> > > '2020-06-23 14:00:00', '2020-06-23 15:00:00', '2020-06-23
16:00:00',
> > > '2020-06-23 17:00:00', '2020-06-23 18:00:00', '2020-06-23
19:00:00',
> > > '2020-06-23 20:00:00', '2020-06-23 21:00:00', '2020-06-23
22:00:00',
> > > '2020-06-23 23:00:00')
> > > AND BINARY h.fcst_var = 'OZCON'
> > > AND ld.stat_header_id = h.stat_header_id;
> > >
> > > 2020-06-28
> > >
> > >
>
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.executeQueriesAndSaveToFile(Unknown
> > > Source) -1 executeQueriesAndSaveToFile - (conn=2995016) You have
an
> > > error
> > > in your SQL syntax; check the manual that corresponds to your
MySQL
> > > server
> > > version for the right syntax to use near ')
> > > Database query time for mv_cmaq_metplus 0:00:00.000
> > >
> > > Running Rscript /opt/metviewer/R_work/include/sum_stat.R
> > > ==== Start Rscript output ====
> > > file: /data/mv_data/edward.strobach/data/
> > > plot_CMAQ_Time_Series_Ed.sum_stat.info
> > > ==== End Rscript output ====
> > > ==== Start Rscript error ====
> > > Error in read.table(file = file, header = header, sep = sep,
quote =
> > > quote,
> > > :
> > > no lines available in input
> > > Calls: read.delim -> read.table
> > > Execution halted
> > > ==== End Rscript error ====
> > > Rscript time 0:00:00.247
> > >
> > > Running Rscript
> > >
/data/mv_data/edward.strobach/scripts/plot_CMAQ_Time_Series_Demo.R
> > > ==== Start Rscript error ====
> > > Error in file(file, "rt") : cannot open the connection
> > > Calls: read.delim -> read.table -> file
> > > In addition: Warning message:
> > > In file(file, "rt") :
> > > cannot open file
> > >
'/data/mv_data/edward.strobach/data/plot_CMAQ_Time_Series_Ed.data':
> > > No such
> > > file or directory
> > > Execution halted
> > > ==== End Rscript error ====
> > > Failed to create plot
> > >
>
/data/mv_data/edward.strobach/plots/OZCON_2020_06_22_THROUGH_2020_06_23.png
> > > Rscript time 0:00:00.160
> > >
> > > Job 1 execution time 0:00:00.450
> > >
> > > There's references to Rscript error, and it's not clear at this
point
> > > what
> > > I would need to do to resolve this.
> > >
> > > --
> > > Edward Strobach
> > > EMC/NCEP/NWS/
> > > IMSG Contractor
> > > Cubicle#: 2029
> > > 301-683-3717
> > >
> > >
>
>
>
>
--
Edward Strobach
EMC/NCEP/NWS/
IMSG Contractor
Cubicle#: 2029
301-683-3717
------------------------------------------------
More information about the Met_help
mailing list