Ticket #10885 (closed: fixed)

Opened 6 years ago

Last modified 5 years ago

Resolve MySQL server failing overnight

Reported by: MarcusNoble Owned by: Lottie Greenwood
Priority: major Milestone: Release 3.4
Component: Tools Keywords: AUTOREDUCTION
Cc: Blocked By:
Blocking: Tester: Anders Markvardsen

Description

Something is causing the autoreduction service to throw "MySQL has gone away" each morning.

Need to investigate problem and come up with a solution.

Change History

comment:1 Changed 6 years ago by MarcusNoble

  • Status changed from new to assigned

comment:2 Changed 6 years ago by Lottie Greenwood

  • Owner changed from MarcusNoble to Lottie Greenwood

comment:3 Changed 6 years ago by Lottie Greenwood

  • Status changed from assigned to verify
  • Resolution set to fixed

Fixed in ​https://github.com/mantidproject/autoreduce/blob/master/WebApp/ISIS/autoreduce_webapp/autoreduce_webapp/queue_processor.py

by

def on_message(self, headers, message):

connection.close()

Which avoids MySQL wait timeout limit

comment:4 Changed 5 years ago by Anders Markvardsen

  • Status changed from verify to verifying
  • Tester set to Anders Markvardsen

comment:5 Changed 5 years ago by Anders Markvardsen

  • Status changed from verifying to closed
  • Milestone changed from Backlog to Release 3.4
Note: See TracTickets for help on using tickets.