vorpal-buildbot
commented
1 month ago Exceeded slow_query limit (231.5 > 60.0) in mysql: ```INSERT INTO deck (
created_date,
updated_date,
person_id,
source_id,
url,
identifier,
name,
competition_id,
archetype_id,
resource_uri,
featured_card,
score,
thumbnail_url,
small_thumbnail_url,
finish,
decklist_hash,
reviewed
) VALUES (
IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE
)```[1726695504.5658178, 8004, 3, 'https://pennydreadfulmagic.com/competitions/4741/', '["sacritor", 4741, "1726695505"]', 'Scales', 4741, None, None, None, None, None, None, None, 'fe67f19c50a071602938ee9e27f336e51bff1ebc'] (slow_query, 231.5, mysql)
Reported on decksite by mysql-perf
Location Hash: a9f13c2637101634ecf9fe6a7fa40247e87de53e
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('views', '106'), ('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UdFugjAU_Zc-MwOIID66xJiRYKKZ21wW0rUXqJYW2qIw47-vuDgflr313HPvueeenlFWg6qwAGHQzKgWHIRpxQSa5ZhriyhUrJL0jpkmUtGM2RIae2PXD6JwEk9D342j2Ef3Di4J5mC7QDw8byzx_wgTWdEyTm8WuCwKoIM1LcV11dR1AwdVppBZq0EJXA3KGhPFjFRWQuLWlH6mDTYDw1eLutuWq2VyZIvtyzpZko2X0mPeN4TH934jD2CPPSNMCGh9w4iK6BSm_aLBlEwf--YrNwe_WDfrNDjinZ2HrmYKdIZtbl7kR2PXdb3JyPdDL4omd36IMnQD699BCnJbKn-XdMlb7EHC6vnrKfK8XfnZsT3ZP6Whnm6Go2yQtb3mHV3T0aO9tHJDkPa7WN7b5w-BPhx0Fc1MPwygOWAFCl0c9CdDg1UB1rRoOb98A2EMpsQ.ZutHdA.Oopypuf6QQkq7osa-mKwyUu6Yok')]) Endpoint: add_signup View Args: {} Person: 313024765986209792 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'sacritor', 'name': 'Scales', 'decklist': '\r\nLabels: decksite
[1726609837.077211, 10466, 3, 'https://pennydreadfulmagic.com/competitions/4741/', '["cippdogg", 4741, "1726609837"]', 'doran', 4741, None, None, None, None, None, None, None, 'bf5c5d6f256eea3e2e08eaab2a73a70c47b853b9'](slow_query, 104.4, mysql)Reported on decksite by mysql-perf
Location Hash: a9f13c2637101634ecf9fe6a7fa40247e87de53e
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '250180'), ('views', '99'), ('session', '.eJx9UWFPwjAQ_S_9PE1HRzf4iEgUBDNFNDFm6dpjNq7tbDtAjf_djgT3wcSP7-7du3fvvlDRgFVMg_Zo7G0LEWJCSY3GW1a7gAQoqYzosXTcWFHIUEJxjOMRHmKSpmRAB3RIh6in1IazGgIN9NnDfWj8MyN1UbWyFicTtakqEJ05Z_RxWYwTSiOkfGWK1oHVTHXaXDaNCOSgYVjrXweF88x3nUu_--RifXFgZKGWq-SG300H_LrZQMlK2vO9eYNw7xdinINzJ4yGk_J9tnwS9zDfrHfmwGfxJcFJXpVXN1MS5uHQSAuuYCG6OI0pIZim2TkZkXiUkb7fpUlxkmEcIQvbUHr9XbLXay3UTHymm4V8yjKaP07z1W2-X83VhQhLQpRNuOYZHeNxxxTDs-T2A71E6ChT-I-OgibALFj0HaG_sXlmKwg-dVvX3z-VQqDG.Zun5SQ.ZsY413LHUL0Y8YdYWXlnHz0IX0U')]) Endpoint: add_signup View Args: {} Person: 1101905037732626565 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'cippdogg', 'name': 'doran', 'decklist': "1 Nameless Inversion\r\n1 Fanatic of Rhonas\r\n3 Boromir, Warden of the Tower\r\n4 Sylvan Caryatid\r\n2 Doran, the Siege Tower\r\n3 Bedrock Tortoise\r\n4 Murmuring Bosk\r\n5 Forest\r\n3 Assassin's Trophy\r\n4 Duress\r\n4 Caves of Koilos\r\n4 Brushland\r\n4 Llanowar Wastes\r\n4 Treefolk Harbinger\r\n3 Basilisk Collar\r\n1 Wickerbough Elder\r\n3 The Battle of Bywater\r\n3 Call of the Ring\r\n3 Gaddock Teeg\r\n1 Mirror Entity\r\n\r\n4 Leyline of Lifeforce\r\n3 Pithing Needle\r\n2 Fracturing Gust\r\n3 Nevermore\r\n3 Worship\r\n\r\n"} Content-Type: application/x-www-form-urlencoded Content-Length: 636 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 2600:1010:b134:1068:a1d9:49c7:a36a:a35f Cf-Ray: 8c4c50162f3bfb44-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Chromium";v="128", "Not;A=Brand";v="24", "Microsoft Edge";v="128" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; page_size=20; deck_id=250180; views=99; session=.eJx9UWFPwjAQ_S_9PE1HRzf4iEgUBDNFNDFm6dpjNq7tbDtAjf_djgT3wcSP7-7du3fvvlDRgFVMg_Zo7G0LEWJCSY3GW1a7gAQoqYzosXTcWFHIUEJxjOMRHmKSpmRAB3RIh6in1IazGgIN9NnDfWj8MyN1UbWyFicTtakqEJ05Z_RxWYwTSiOkfGWK1oHVTHXaXDaNCOSgYVjrXweF88x3nUu_--RifXFgZKGWq-SG300H_LrZQMlK2vO9eYNw7xdinINzJ4yGk_J9tnwS9zDfrHfmwGfxJcFJXpVXN1MS5uHQSAuuYCG6OI0pIZim2TkZkXiUkb7fpUlxkmEcIQvbUHr9XbLXay3UTHymm4V8yjKaP07z1W2-X83VhQhLQpRNuOYZHeNxxxTDs-T2A71E6ChT-I-OgibALFj0HaG_sXlmKwg-dVvX3z-VQqDG.Zun5SQ.ZsY413LHUL0Y8YdYWXlnHz0IX0U Cf-Connecting-Ip: 2600:1010:b134:1068:a1d9:49c7:a36a:a35f Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: US ```