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

            No builds found.
            bvan Brian Van Klaveren created issue -
            bvan Brian Van Klaveren made changes -
            Field Original Value New Value
            Risk Score 0
            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 Brian Van Klaveren made changes -
            Link This issue relates to DM-14748 [ DM-14748 ]

            (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 )
            fritzm Fritz Mueller made changes -
            Assignee Kenny Lo [ kennylo ]
            fritzm Fritz Mueller made changes -
            Sprint DB_F18_06 [ 744 ]
            kennylo Kenny Lo made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            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 made changes -
            Story Points 2
            kennylo Kenny Lo made changes -
            Watchers Brian Van Klaveren, Fritz Mueller, Gregory Dubois-Felsmann, Kenny Lo [ Brian Van Klaveren, Fritz Mueller, Gregory Dubois-Felsmann, Kenny Lo ] Brian Van Klaveren, Fritz Mueller, Gregory Dubois-Felsmann, Vaikunth Thukral [ Brian Van Klaveren, Fritz Mueller, Gregory Dubois-Felsmann, Vaikunth Thukral ]
            vaikunth Vaikunth Thukral made changes -
            Epic Link DM-14456 [ 80724 ]
            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 )'
            kennylo Kenny Lo made changes -
            Reviewers Brian Van Klaveren [ bvan ]
            Status In Progress [ 3 ] In Review [ 10004 ]
            bvan Brian Van Klaveren made changes -
            Status In Review [ 10004 ] Reviewed [ 10101 ]
            kennylo Kenny Lo made changes -
            Resolution Done [ 10000 ]
            Status Reviewed [ 10101 ] Done [ 10002 ]

            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.