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

Server Error: INTERNAL SERVER ERROR for url: https://squash-restful-api-demo.lsst.codes/job

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: squash
    • Labels:
      None

      Description

      If we try to access a resource from the SQuaSH RESTful API while a verification job is being POST we get a 500 error:

       
      [pid: 17|app: 0|req: 5/18] 10.56.0.1 () {42 vars in 557 bytes} [Mon May  7 23:01:32 2018] POST /auth => generated 188 bytes in 71 msecs (HTTP/1.1 200) 2 headers in 72 bytes (1 switches on core 0)
      [pid: 17|app: 0|req: 7/19] 10.56.0.1 () {38 vars in 443 bytes} [Mon May  7 23:03:05 2018] GET / => generated 895 bytes in 1 msecs (HTTP/1.1 200) 2 headers in 72 bytes (1 switches on core 0)
      [pid: 17|app: 0|req: 8/20] 10.56.0.1 () {38 vars in 610 bytes} [Mon May  7 23:03:05 2018] GET /monitor?ci_dataset=validation_data_cfht&metric=validate_drp.AM1&period=Last+6+Months => generated 14276 bytes in 79 msecs (HTTP/1.1 200) 2 headers in 74 bytes (1 switches on core 0)
      [pid: 13|app: 0|req: 6/21] 10.56.0.1 () {38 vars in 443 bytes} [Mon May  7 23:03:05 2018] GET / => generated 895 bytes in 1 msecs (HTTP/1.1 200) 2 headers in 72 bytes (1 switches on core 1)
      [2018-05-07 23:03:05,188] ERROR in app: Exception on /code_changes [GET]
      Traceback (most recent call last):
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
          context)
        File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
          cursor.execute(statement, parameters)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 165, in execute
          result = self._query(query)
        File "/usr/local/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query
          conn.query(q)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 860, in query
          self._affected_rows = self._read_query_result(unbuffered=unbuffered)
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1061, in _read_query_result
          result.read()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1349, in read
          first_packet = self.connection._read_packet()
        File "/usr/local/lib/python3.6/site-packages/pymysql/connections.py", line 1005, in _read_packet
          % (packet_number, self._next_seq_id))
      pymysql.err.InternalError: Packet sequence number wrong - got 114 expected 1
      

        Attachments

          Activity

          Show
          afausti Angelo Fausti added a comment - - edited Read this http://docs.sqlalchemy.org/en/latest/orm/contextual.html and this http://flask-sqlalchemy.pocoo.org/2.3/api/#sessions

            People

            • Assignee:
              afausti Angelo Fausti
              Reporter:
              afausti Angelo Fausti
              Watchers:
              Angelo Fausti
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Summary Panel