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

Change Timeouts for webserv to 2 hours

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: webserv
    • Labels:
      None

      Description

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

        Attachments

          Issue Links

            Activity

            Hide
            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.

            Show
            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.
            Hide
            fritzm Fritz Mueller added a comment -

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

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

            Gregory Dubois-Felsmann 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). 

             

             

            Show
            kennylo Kenny Lo added a comment - Gregory Dubois-Felsmann 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).     
            Hide
            kennylo Kenny Lo added a comment -

            See Comments.

            Show
            kennylo Kenny Lo added a comment - See Comments.
            Hide
            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)'

            Show
            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

              Assignee:
              kennylo Kenny Lo
              Reporter:
              bvan Brian Van Klaveren
              Reviewers:
              Brian Van Klaveren
              Watchers:
              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.