search

ODM2 / ODM2DataSharingPortal

A Python-Django web application enabling users to upload, share, and display data from their environmental monitoring sites via the app's ODM2 database. Data can either be automatically streamed from Internet of Things (IoT) devices, manually uploaded via CSV files, or manually entered into forms.
BSD 3-Clause "New" or "Revised" License
31 stars 8 forks source link

staging.monitormywatershed.org OperationalError #733

Open neilh10 opened 1 month ago

neilh10 commented 1 month ago

Yesterday on accessing https://staging.monitormywatershed.org/sites/tu_rcru_test06/ it worked.

On accessing today it threw a problem.
image

https://staging.monitormywatershed.org/sites/tu_rcru_test06/

OperationalError at /sites/tu_rcru_test06/

(psycopg2.OperationalError) terminating connection due to administrator command
SSL connection has been closed unexpectedly

[SQL: SELECT * FROM dataloaderinterface_siteregistration WHERE "SamplingFeatureID" = '%s';]
[parameters: (1267,)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Request Method: | GET -- | -- https://staging.monitormywatershed.org/sites/tu_rcru_test06/ 3.2.16 OperationalError (psycopg2.OperationalError) terminating connection due to administrator command SSL connection has been closed unexpectedly [SQL: SELECT * FROM dataloaderinterface_siteregistration WHERE "SamplingFeatureID" = '%s';] [parameters: (1267,)] (Background on this error at: https://sqlalche.me/e/14/e3q8) /home/ubuntu/.conda/envs/ODM2DataSharingPortal/lib/python3.10/site-packages/sqlalchemy/engine/default.py, line 732, in do_execute /home/ubuntu/.conda/envs/ODM2DataSharingPortal/bin/python 3.10.4 ['/opt/ODM2DataSharingPortal/src', '/usr/bin', '/home/ubuntu/.conda/envs/ODM2DataSharingPortal/lib/python310.zip', '/home/ubuntu/.conda/envs/ODM2DataSharingPortal/lib/python3.10', '/home/ubuntu/.conda/envs/ODM2DataSharingPortal/lib/python3.10/lib-dynload', '/home/ubuntu/.conda/envs/ODM2DataSharingPortal/lib/python3.10/site-packages'] Thu, 03 Oct 2024 18:15:05 -0500
neilh10 commented 1 month ago

When I tried again https://staging.monitormywatershed.org/sites/tu_rcru_test06/ it worked.

I have been POSTing, and description at https://github.com/ODM2/ODM2DataSharingPortal/pull/732#issuecomment-2389168790