Metviewer 4.1.0 - webapp not communicating with the data base after initial installation

[jwraby]

We are installing a local instance of METviewer and have run into an issue. OS is RHEL 7.9, database is Mariadb 10.3.35, and a Python 3.6.3 environment has been created. The following is observed in the Catalina.out logs, and I CAN get to the database by CLI using mysql -u user -p. I believe I have modified all the files where the hostname, user, and password information are necessary for this connection to be established, yet I get the following:

2023-01-13 09:02 edu.ucar.metviewer.MVServlet.init(Unknown Source) -1 init - METviewer app being placed into service by the servlet container.
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databases (conn=125) Could not select database 'Select databases' : Unknown database 'Select databases'
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databases (conn=125) Could not select database 'Select databases' : Unknown database 'Select databases'
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.

Thank you,

[TatianaBurek]

Message "get connection for database Select databases" is expected because when the user opens a page there is no selected databases yet.
Can you see your database(s) in the drop-down menu?

How/when did you create a database? Did you create it before upgrading/installing METviewer 4.1? Which mv_mysql.sql did you use to add the schema? Do you have data in your database?
METviewer 4.1 works only with databases that:

• were created with mv_mysql.sql from METviewer 4.1 (https://github.com/dtcenter/METviewer/blob/main_v4.1/sql/mv_mysql.sql)
  or
• older databases that were updated to match METviewer 4.1 schema
  and
  contain data

[jwraby]

I am looking at the database menu and I see the db we created using METviewer V4.1. See attached for a screen capture showing the menu and db name. The db was created last week and appears to have data in it.

I attached screen captures of the mariadb output showing the contents of the db named "mv_URMAval6".

Beyond what you see in the mariadb images, I'm not sure how to show that the db has data.
I need to consult with my system admin on which mv_mysql.sql was used to add the schema, but it was from METviewer 4.1.

I have a plot xml I generated using METviewer V2.11 for the data in mv_URMAval6 and when I load it, all the plot settings I expect are loaded into the right side of the gui. Clicking on "Generate Plot" results in "no image available", and the log tab has no output. I tried to attached the plot xml but GitHub is saying that it can't process the file. I also tried saving it as a .txt file, but it is rejecting that too.

See attached for a screen capture of the plot settings in the V4.1 gui and the plot which was generated by METviewer V2.11.

[jwraby]

Correction on my statement above regarding the location of the plot settings in the gui. I mistakenly said that the settings were on the right said of the gui, but they are on the left side of the gui.

[rarmendarez]

Hello,

The mv_mysql.sql is the one that was used to load/create the db schema. I verified this by line count, file size, and contents (from the link you provided).

We don't have a good sample set (data,xml,etc) to test the new version.

That being said, the following is displayed in the catalina.out log when selecting the database in the web gui:

bash-4.2# tail -f catalina.out
2023-01-17 08:00 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databases (conn=49) Could not select database 'Select databases' : Unknown database 'Select databases'
2023-01-17 08:00 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databaseURMA_validation6_testmv_URMAval6 (conn=49) Co uld not select database 'Select databaseURMA_validation6_testmv_URMAval6' : Unknown database 'Select databaseURMA_validation6_testmv_URMAval6'
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databaseURMA_validation6_testmv_URMAval6 (conn=49) Co uld not select database 'Select databaseURMA_validation6_testmv_URMAval6' : Unknown database 'Select databaseURMA_validation6_testmv_URMAval6'
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databaseURMA_validation6_testmv_URMAval6 (conn=49) Co uld not select database 'Select databaseURMA_validation6_testmv_URMAval6' : Unknown database 'Select databaseURMA_validation6_testmv_URMAval6'
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databaseURMA_validation6_testmv_URMAval6 (conn=49) Co uld not select database 'Select databaseURMA_validation6_testmv_URMAval6' : Unknown database 'Select databaseURMA_validation6_testmv_URMAval6'
2023-01-17 08:37 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.

not sure how to get around this.

-Rey
ARL - Sys Admin

[TatianaBurek]

I am surprised that GitHub rejected your .txt file - TXT is a supported format:

It would be helpful to see it. Instead of loading the old XML could you reload the page and configure and run the job using GUI? Any success?

[jwraby]

Thanks for your reply. This info is very helpful. I noticed that I can plot a series plot using Python. Could I just use Python for all features using V4.1.0 or do I need Rscripts for certain legacy features? Thanks.

[TatianaBurek]

You should be able to use Python for all major features.
Here is the list of known limitations that Python has:
https://github.com/dtcenter/METplotpy/wiki

[jwraby]

This is good information. I see from the wiki that some of the limitations of Python are resolved by Rscripts. Does this apply to all of the listed limitations?

[TatianaBurek]

The listed limitations were implemented in the past and still work in Rscript. Unfortunately, Python does not support these features and we excluded them from the current code for now.

[jwraby]

Good information. Thanks for answering my question.