Can`t exchange sets for points

Started by Megaloxantha [1980069] on 7 Aug 2020 in Bugs & Issues.

22 replies · 336 views · thread synced 23 Sep 2026 · 3 days ago · View on torn.com

About this thread

Posts archived: 23 / 23 posts (100%) · the total is Torn's reply count + the opening post at the last fetch

Counted by TornLife from the archived posts.

Archived posts: 23
Discussion span: 7 Aug 2020 → 19 Aug 2020
Authority score: 61 / 100
Historical score: 47 / 100
Story score: 50 / 100
Engagement score: 65 / 100

People posting, likes and official posts are not counted for this thread yet: on threads longer than one page they come from a periodic pass over the archive, which has not covered it.

Most-liked replies

Aduialelen [2093738] · 4 likes · 8 Aug 2020
Unable to exchange sets of any quantity. I've been trying for the last 30mins and it just resets or times out.
Aduialelen [2093738] · 3 likes · 10 Aug 2020
Still happening. Just tried to exchange 635 sets for a faction member, it timed out and I'm now unable to even exchange 1 set.
Chedburn [1] Admin · 3 likes · 10 Aug 2020
I think we've resolved this weirdness, something regarding the database upgrade must have caused - although we're not sure why exactly. We've rebuilt it and it seems to work well now. Thanks for the help.

Megaloxantha [1980069] 7 Aug 2020, 19:47 TCT · #1 · edited

It`s probably some post-migration issue. Everytime I try to exchange sets for points, I see something like this. Whole Torn stops working for me and after minute or so the progress bar disappears like nothing happened, but I still have plushies. My Internet connection is ok, because other sites are working fine. Playing on Chrome 84.0.4147.105, Windows 10.

Edit: the same happens on Android phone, I just checked.

CloudJumper [1636201]Staff 7 Aug 2020, 20:12 TCT · #2

Can you try exchanging fewer sets at a time? I tried exchanging a single set and it worked fine for me. You can try moving all but 10 sets worth of plushies to your Display Cabinet and then try exchanging just the 10 sets at a time.

I am thinking it is probably related to this issue. The query on the inventory page is getting locked in case of a transaction involving thousand+ items.

Mentions: Items page database error

Megaloxantha [1980069] 7 Aug 2020, 20:19 TCT · #3 · edited

I could trade 1, 10 and 100 sets a moment ago, now again it doesn`t work.

In the meantime two new issues arose - I can`t withdraw money from the vault (even $1) and I can`t travel as well.

Edit. And now it`s working fine.

CloudJumper [1636201]Staff 7 Aug 2020, 20:23 TCT · #4

Your query probably locked the session, try again in couple minutes please?

I will pass this up to Joe for the time to determine if the original issue is related to the confirmed report related to the Inventory page. If not, can be passed up to Ivan for resolution.

Thanks..!!

Megaloxantha [1980069] 7 Aug 2020, 20:24 TCT · #5

Now everything seems to be working, I can even travel again :) If it will happen again, I`ll let You know.

Roweena [2338543] 7 Aug 2020, 22:43 TCT · #6

trying to exchange sets, stuck on loading as OP screenie shows. Tried lower amounts like 100, 50, 10... same issue

Aduialelen [2093738] 8 Aug 2020, 12:42 TCT · #7

Unable to exchange sets of any quantity. I've been trying for the last 30mins and it just resets or times out.

thestud [1654931] 8 Aug 2020, 13:26 TCT · #8

Same here.

Megaloxantha [1980069] 8 Aug 2020, 16:11 TCT · #9

It is happening again to me as well.

oraN [1778676] 9 Aug 2020, 06:47 TCT · #10

attempting to exchange sets lags a ton.

themastermaker [2242874] 9 Aug 2020, 07:16 TCT · #11

Yes I agree with this. It doesn’t work you need to try a ton of times to make it work

IHTl [2403739] 9 Aug 2020, 10:33 TCT · #12

Also same, cant deposit with :Database error - please contact staff or file a bug report

Chedburn [1] Admin Developer 9 Aug 2020, 11:38 TCT · #13

After the upgrade, some queries are choosing wrong indexes - leading them to take much longer / timeout.

I'll need to test on one of your accounts I expect (when you're not travelling!).

oraN [1778676] 9 Aug 2020, 11:46 TCT · #14

Feel free to test on mine, i don't mind if you actually manage to exchange flowers or plushies. Thanks
[image: i.oran.pw]

Chedburn [1] Admin Developer 9 Aug 2020, 12:10 TCT · #15

Thanks I tried, but it worked perfectly fine. I converted 100x sets within a second. Will keep searching.

oraN [1778676] 9 Aug 2020, 12:13 TCT · #16 · edited

ah yes now thats strange because i managed to exchange 100 just now too, 100 seems to work fine, but then i tried 600 and it failed.

although i'm not sure why it didn't work earlier when i tried to exchange 3 maybe 4.

edit: tried 100 again and it failed.

Chedburn [1] Admin Developer 9 Aug 2020, 12:20 TCT · #17

I think if it succeeds once, it's cached so all future runs would be much faster. We just need to add an index hint to it, but I need to catch one running slowly in order to analyse it.

Baldr [1847600] Reporter 9 Aug 2020, 13:42 TCT · #18

I had this problem yesterday, but it cleared up after 20-30 minutes.

Once it stopped, I had no more trouble trading in points. I've traded in more today, again with no problems.

_SCOFIELD_ [1441750] 9 Aug 2020, 17:48 TCT · #19 · edited

[image: i.imgur.com]
tried with 1k -- failed.

tried 1 set, worked. tried 10 sets worked tried 100 sets worked. tried 500 sets failed. So I'm gonna continue to exchange them 100 sets at a time.

Mania [1958969] 10 Aug 2020, 08:40 TCT · #20

I have the same problem.

It is freezing if i try over 200 sets.

Even home page is not accessible when it freezes. After 30 secs I receive 504 error code. In a minute it goes back to normal but happens again with big sets.