Back

Bug Report Forums

Report bugs and errors to the Flight Rising development team.
TOPIC | I was trading with crim when..
1 2 3
Same
http://www1.flightrising.com/trading/crim/next
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 3, `item` = 253, `val` = 500, `created_at` = 2016-10-06 15:08:07 where `userid` = 252029) in /Connection.php Line 539
Same
http://www1.flightrising.com/trading/crim/next
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 3, `item` = 253, `val` = 500, `created_at` = 2016-10-06 15:08:07 where `userid` = 252029) in /Connection.php Line 539
Same problem, but only when moving onto the next trade without giving her the requested item. Giving her the item she wants seems to work normally. I use Firefox.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 2, `item` = 150, `val` = 500, `type` = food, `created_at` = 2016-10-06 14:55:22 where `userid` = 15915) in /Connection.php Line 539
Same problem, but only when moving onto the next trade without giving her the requested item. Giving her the item she wants seems to work normally. I use Firefox.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 2, `item` = 150, `val` = 500, `type` = food, `created_at` = 2016-10-06 14:55:22 where `userid` = 15915) in /Connection.php Line 539
cnFe09Q.gif
Same here!

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 4, `item` = 1480, `val` = 5350, `type` = familiar, `created_at` = 2016-10-06 15:15:28 where `userid` = 147294) in /Connection.php Line 539

(( My item was a Moonstone, but I didn't have one. I guess Crim really wanted one, though! :p ))
Same here!

http://www1.flightrising.com/trading/crim/next

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 4, `item` = 1480, `val` = 5350, `type` = familiar, `created_at` = 2016-10-06 15:15:28 where `userid` = 147294) in /Connection.php Line 539

(( My item was a Moonstone, but I didn't have one. I guess Crim really wanted one, though! :p ))
Forum-Signature.png
Welp, might as well add mine in here.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
Welp, might as well add mine in here.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
H01Ejx7.png
Made by Macabre!
I guess I should post too.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_food WHERE rarity <= '5' order by rand() limit 1) in /Connection.php Line 539

EDIT:
And another:


SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 1, `item` = 4523, `val` = 1000, `created_at` = 2016-10-06 15:28:42 where `userid` = 83309) in /Connection.php Line 539
I guess I should post too.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_food WHERE rarity <= '5' order by rand() limit 1) in /Connection.php Line 539

EDIT:
And another:


SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `crimcart` set `turns` = 1, `item` = 4523, `val` = 1000, `created_at` = 2016-10-06 15:28:42 where `userid` = 83309) in /Connection.php Line 539
windmill toy
Have a good day!
... Boreas coat of arms
Yep. She sure is breaking a lot lately.

Latest version of Chrome with Windows 8.1 in use.
Yep. She sure is breaking a lot lately.

Latest version of Chrome with Windows 8.1 in use.
3 hours ahead of FR time

Fair warning: I have the social grace of a potato.
ZoeC058.png
Same thing here.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
Same thing here.

http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_food WHERE rarity <= '5' order by rand() limit 1) in /Connection.php Line 539

the first time i traded in an item to her, i had to refresh numerous times too, then it wouldnt load other items if i didnt give her an item
http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_food WHERE rarity <= '5' order by rand() limit 1) in /Connection.php Line 539

the first time i traded in an item to her, i had to refresh numerous times too, then it wouldnt load other items if i didnt give her an item
yeahbuddy.png
Boo
he/him
um,, hi lol
smol.png
chrysocolla.gif
yeah I've got the same problem being reported


http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
yeah I've got the same problem being reported


http://www1.flightrising.com/trading/crim/next

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: SELECT * FROM cms_trinket WHERE rarity <= '5' AND store = '0' AND gem_val = '0' AND subcat != 'holiday items' AND subcat != 'chests' AND subcat != 'dragon eggs' AND subcat != 'specialty items' AND subcat != 'blueprint' AND subcat != 'transmutation' AND subcat != 'vista' order by rand() limit 1) in /Connection.php Line 539
[quote name="TacticianLyra" date=2016-10-06 15:26:45] Yep. She sure is breaking a lot lately. Latest version of Chrome with Windows 8.1 in use. [/quote] She seems to be okay now. Still wondering why she bugged, though.
TacticianLyra wrote on 2016-10-06:
Yep. She sure is breaking a lot lately.

Latest version of Chrome with Windows 8.1 in use.

She seems to be okay now. Still wondering why she bugged, though.
3 hours ahead of FR time

Fair warning: I have the social grace of a potato.
ZoeC058.png
1 2 3