[RESOLVED]Trades page brings down the site

[Noahs Second Country]

I've reported this on the cards discord in the #bug-reports channel but I'll go ahead and post it here.

This was initially reported a few days ago, but it appears the problem persists.

The gist of the problem is that whenever mass copy transfers are being conducted(where multiple matches are made on a card in order to transfer to bank to the main), attempts to access the trades page of the main nation brings the whole gameside down for 30 seconds - a minute.

Any player currently has the capacity to cause this issue simply by clicking a link such as: https://www.nationstates.net/page=deck/ ... nd_country whenever transfers are being conducted. (DO NOT CLICK THAT LINK)

I did not observe any issues with the market page, going directly to the card in question, or any other page. This does not appear to be a coincidence or a problem with this card in general, as the same thing is happening right now with this card: https://www.nationstates.net/page=deck/ ... 9/season=1 and DGES's trades page.

The player has to have said multicopy transfer in their auctions for the link to break the site.

Sorry for any trouble I have caused

[Ballotonia]

Thank you for alerting me when you started a new mass-transfer, allowing me to do some 'live' analysis.
The root cause is now known, we have an ugly SQL query which isn't easy to optimize.

Admins are discussing what the best way forward is to resolve this issue.

Ballotonia

[Ballotonia]

Greetings,

This has now been fixed.

Well... it won't come up again until the number of cards being mass-transferred increases by a lot. If you throw enough data at a server it will always buckle at some point, but this time it was happening way way way too soon.

Thanks again for assistance from Noahs Second Country in providing a situation to test possible fixes.

Ballotonia

[Refuge Isle]

Greetings,

This has now been fixed.

Well... it won't come up again until the number of cards being mass-transferred increases by a lot. If you throw enough data at a server it will always buckle at some point, but this time it was happening way way way too soon.

Thanks again for assistance from Noahs Second Country in providing a situation to test possible fixes.

Ballotonia

Thanks for your hard work Ballo <3