Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-14747

Change Timeouts for webserv to 2 hours

    XMLWordPrintable

Details

    • Story
    • Status: Done
    • Resolution: Done
    • None
    • webserv
    • None

    Description

      Make sure the blocking timeout for webserv is close to 2 hours.

      Attachments

        Issue Links

          Activity

            fritzm Fritz Mueller added a comment - - edited

            Note: as a short term fix, I exec d in to the running container on lsst-qserv-dax01, adjusted uwsgi_read_timeout in the webserv config up to 7200, then reloaded the nginx config. But something more permanent should be done for the container build for this service.

            fritzm Fritz Mueller added a comment - - edited Note: as a short term fix, I exec d in to the running container on lsst-qserv-dax01 , adjusted uwsgi_read_timeout in the webserv config up to 7200, then reloaded the nginx config. But something more permanent should be done for the container build for this service.

            (bvan also made short-term adjustments to the running service in /etc/nginx/nginx.conf)

            fritzm Fritz Mueller added a comment - ( bvan also made short-term adjustments to the running service in /etc/nginx/nginx.conf )
            kennylo Kenny Lo added a comment -

            gpdf been reporting seeing transient connection (MySQL) errors.  Enabling pool_pre_ping param may help, as in engine = create_engine("mysql+pymysql://", pool_pre_ping=True). 

             

             

            kennylo Kenny Lo added a comment - gpdf been reporting seeing transient connection (MySQL) errors.  Enabling pool_pre_ping param may help, as in engine = create_engine("mysql+pymysql://", pool_pre_ping=True).     
            kennylo Kenny Lo added a comment -

            See Comments.

            kennylo Kenny Lo added a comment - See Comments.
            kennylo Kenny Lo added a comment -

            Per /webserv/log.txt for dbserv v0 on PDAC:

            06/11/2018 09:50:06 root DEBUG: Encountered an error processing request: '(_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: 'SELECT cntr, ra, decl, w1mpro, w2mpro, w3mpro, w4mpro FROM wise_00.allwise_p3as_psd WHERE qserv_areaspec_circle(3.9967364,0.002037,8) AND w1mpro < 5'] (Background on this error at: http://sqlalche.me/e/e3q8)'

            kennylo Kenny Lo added a comment - Per /webserv/log.txt for dbserv v0 on PDAC: 06/11/2018 09:50:06 root DEBUG: Encountered an error processing request: '(_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: 'SELECT cntr, ra, decl, w1mpro, w2mpro, w3mpro, w4mpro FROM wise_00.allwise_p3as_psd WHERE qserv_areaspec_circle(3.9967364,0.002037,8) AND w1mpro < 5'] (Background on this error at: http://sqlalche.me/e/e3q8 )'

            People

              kennylo Kenny Lo
              bvan Brian Van Klaveren
              Brian Van Klaveren
              Brian Van Klaveren, Fritz Mueller, Gregory Dubois-Felsmann, Kenny Lo, Vaikunth Thukral
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Jenkins

                  No builds found.