search

EvEmu-Project / evemu_Crucible

Emulator for EvE Online's Crucible expansion
https://evemu.dev
167 stars 65 forks source link

The Personal Assets window spins forever #44

Open jdhirst opened 3 years ago

jdhirst commented 3 years ago

From AlasiyaEvE created by ryllae: zhyrohaad/AlasiyaEvE#96

Whenever I open my Personal Assets (on either toon), I see huge exceptions spewed:


13497   2020.02.19 19:32:15:824 Write:  Packet::CallReq (Address::Client(clientID="0",callID="484",service="None"),Address::Node(nodeID="888444",service="charMgr",callID="None"),117 bytes,(1, 'MachoBindObject', ((90000005, 10002), ('ListStations', (0, 0), {})), {'machoVersion': 1}),{-
13498   2020.02.19 19:32:15:824 }, None)
13499   2020.02.19 19:32:15:841 tasklet <TaskletExt object at 40dadfa8, abps=1001, ctxt='Tick::Sleep'> exiting with TaskletExit()
13500   2020.02.19 19:32:15:893 Read:  Packet::CallRsp (Address::Node(nodeID="888444",service="charMgr",callID="None"),Address::Client(clientID="0",callID="484",service="None"),275 bytes,[<MarshalStream '~\x00\x00\x00\x00,\x19+\x1d~\x00\x00\x00\x00,\x13\x0cN=888444:262\x03 \xd4\xc2J[-
13501   2020.02.19 19:32:15:893 \xe7\xd5\x01#,%\x02\x0edbutil.CRowset\x16\x01",\x02\x14blue.DBRowDescriptor%,,\x11\x9b\x06\x13,\x13\titemCount\x06\x15--\x11$*",\x02\x14blue.DBRowDescriptor%,,\x11\x9b\x06\x13,\x13\titemCount\x06\x15--\x07\xe7\x01\x84\x0b\xcc\xc9\x01*",\x02\x14blue-
13502   2020.02.19 19:32:15:893 .DBRowDescriptor%,,\x11\x9b\x06\x13,\x13\titemCount\x06\x15--\x07\xe7\x97\x84b\x98\x93\x03--'>],{}, None)
13503   2020.02.19 19:32:15:893 charMgr::MachoBindObject args=((90000005, 10002), ('ListStations', (0, 0), {})), retval=(<RemoteObject:N=888444:262>, [<DBRow object [30002187, 1L]>, <DBRow object [60004450, 151L]>])
13504   2020.02.19 19:32:15:894 EXCEPTION #20 logged at  02/19/2020 13:32:16 Unhandled exception in <TaskletExt object at 3a3ce0e0, abps=1001, ctxt='<NO CONTEXT>^<bound method AssetsWindow._Load of form.AssetsWindow object at (snip)ccb0, name=assets, destroyed=False>>'>
13505   2020.02.19 19:32:15:894 Caught at:
13506   2020.02.19 19:32:15:894 /common/lib/bluepy.py(98) CallWrapper
13507   2020.02.19 19:32:15:894 Thrown at:
13508   2020.02.19 19:32:15:894 /common/lib/bluepy.py(86) CallWrapper
13509   2020.02.19 19:32:15:894 /client/script/ui/shared/assetswindow.py(159) _Load
13510   2020.02.19 19:32:15:894 /client/script/ui/shared/assetswindow.py(269) ShowAll
13511   2020.02.19 19:32:15:894 /client/script/ui/shared/neocom/assetsinfo.py(91) GetAll
13512   2020.02.19 19:32:15:894 keyID = None
13513   2020.02.19 19:32:15:894 sortlocations = []
13514   2020.02.19 19:32:15:894 stations = [<DBRow object [30002187, 1L]>, <DBRow object [60004450, 151L]>]
13515   2020.02.19 19:32:15:894 uiSvc = <svc.UI instance at 0x16CC67B0>
13516   2020.02.19 19:32:15:894 self = <svc.AssetsSvc instance at 0x3FA90B48>
13517   2020.02.19 19:32:15:894 sortKey = None
13518   2020.02.19 19:32:15:894 station = <DBRow object [30002187, 1L]>
13519   2020.02.19 19:32:15:894 isCorp = 0
13520   2020.02.19 19:32:15:894 key = 'allitems'
13521   2020.02.19 19:32:15:894 blueprintOnly = 0
13522   2020.02.19 19:32:15:894 mapSvc = <svc.MapSvc instance at 0x3F6138A0>
13523   2020.02.19 19:32:15:894 AttributeError: 'NoneType' object has no attribute 'solarSystemID'
13524   2020.02.19 19:32:15:894 Thread Locals:  session was <Session: (sid:8542536521664276740, clientID:0, mutating:0, locationid:60004450, corprole:0xffffe07ffffff81L, userid:576, languageID:EN, role:0x63f8000280c41000L, charid:90000005, address:47.218.232.252:50358, userType:30, s-
13525   2020.02.19 19:32:15:894 essionType:5, regionid:10000016, constellationid:20000204, allianceid:0, warfactionid:0, corpid:98000002, stationid:60004450, stationid2:60004450, worldspaceid:60004450, solarsystemid2:30001392, hqID:60004450, baseID:60004450, rolesAtAll:0xffffe07f-
13526   2020.02.19 19:32:15:894 fffff81L, rolesAtHQ:0xffffe07ffffff81L, rolesAtBase:0xffffe07ffffff81L, rolesAtOther:0xffffe07ffffff81L, genderID:0, bloodlineID:1, raceID:1, corpAccountKey:1000)>
13527   2020.02.19 19:32:15:894 EXCEPTION END
13528   2020.02.19 19:32:15:895 EXCEPTION #21 logged at  02/19/2020 13:32:16 Exception in Error Logging, preventing infinite recursion
13529   2020.02.19 19:32:15:895 Caught at:
13530   2020.02.19 19:32:15:895 /common/lib/bluepy.py(86) CallWrapper
13531   2020.02.19 19:32:15:895 /common/script/sys/alert.py(415) SendStackTraceAlert_thread
13532   2020.02.19 19:32:15:895 Thrown at:
13533   2020.02.19 19:32:15:895 /common/script/sys/alert.py(413) SendStackTraceAlert_thread
13534   2020.02.19 19:32:15:895 /common/script/sys/alert.py(449) __SendStackTraceAlert
13535   2020.02.19 19:32:15:895 locationID1 = None
13536   2020.02.19 19:32:15:895 origin = 3
13537   2020.02.19 19:32:15:895 locationID2 = None
13538   2020.02.19 19:32:15:895 stackTrace = "EXCEPTION #20 logged at  02/19/2020 13:32:16 Unhandled exception in <TaskletExt object at 3a3ce0e0, abps=1001, ctxt='<NO CONTEXT>^<bound method AssetsWindow._Load of form.AssetsWindow object at (snip)ccb0, name=assets, destroyed=F-
13539   2020.02.19 19:32:15:895 alse>>'>\nCaught at:\n/common/lib/bluepy.py(98) CallWrapper\nThrown at:\n/common/lib/bluepy.py(86) CallWrapper\n/client/script/ui/shared/assetswindow.py(159) _Load\n/client/script/ui/shared/assetswindow.py(269) ShowAll\n/client/script/ui/shared/neo-
13540   2020.02.19 19:32:15:895 com/assetsinfo.py(91) GetAll\n        keyID = None\n        sortlocations = []\n        stations = [<DBRow object [30002187, 1L]>, <DBRow object [60004450, 151L]>]\n        uiSvc = <svc.UI instance at 0x16CC67B0>\n        self = <svc.AssetsSvc inst-
13541   2020.02.19 19:32:15:895 ance at 0x3FA90B48>\n        sortKey = None\n        station = <DBRow object [30002187, 1L]>\n        isCorp = 0\n        key = 'allitems'\n        blueprintOnly = 0\n        mapSvc = <svc.MapSvc instance at 0x3F6138A0>\nAttributeError: 'NoneType' -
13542   2020.02.19 19:32:15:895 object has no attribute 'solarSystemID'\nThread L...
13543   2020.02.19 19:32:15:895 i = 0
13544   2020.02.19 19:32:15:895 GetArgumentsFromStackTrace = <function GetArgumentsFromStackTrace at 0x48527BF0>
13545   2020.02.19 19:32:15:895 self = <svc.Alert instance at 0x40B9ACB0>
13546   2020.02.19 19:32:15:895 userID = None
13547   2020.02.19 19:32:15:895 nodeID = None
13548   2020.02.19 19:32:15:895 nextErrorKeyHash = None
13549   2020.02.19 19:32:15:895 mode = 'Error'
13550   2020.02.19 19:32:15:895 charID = None
13551   2020.02.19 19:32:15:895 stackID = (286022717,
13552   2020.02.19 19:32:15:895 'Caught at:\n/common/lib/bluepy.py(98) CallWrapper\nThrown at:\n/common/lib/bluepy.py(86) CallWrapper\n/client/script/ui/shared/assetswindow.py(159) _Load\n/client/script/ui/shared/assetswindow.py(269) ShowAll\n/client/script/ui-
13553   2020.02.19 19:32:15:895 /shared/neocom/assetsinfo.py(91) GetAll\n')
13554   2020.02.19 19:32:15:895 TypeError: 'NoneType' object is not iterable
13555   2020.02.19 19:32:15:895 Thread Locals:  session was <Session: (sid:8542536521664276740, clientID:0, mutating:0, locationid:60004450, corprole:0xffffe07ffffff81L, userid:576, languageID:EN, role:0x63f8000280c41000L, charid:90000005, address:47.218.232.252:50358, userType:30, s-
13556   2020.02.19 19:32:15:895 essionType:5, regionid:10000016, constellationid:20000204, allianceid:0, warfactionid:0, corpid:98000002, stationid:60004450, stationid2:60004450, worldspaceid:60004450, solarsystemid2:30001392, hqID:60004450, baseID:60004450, rolesAtAll:0xffffe07f-
13557   2020.02.19 19:32:15:895 fffff81L, rolesAtHQ:0xffffe07ffffff81L, rolesAtBase:0xffffe07ffffff81L, rolesAtOther:0xffffe07ffffff81L, genderID:0, bloodlineID:1, raceID:1, corpAccountKey:1000)>
13558   2020.02.19 19:32:15:895 EXCEPTION END

The client window spins forever.

jdhirst commented 3 years ago

i'll have to get db data from main for your char and import to dev for this one. i dont have any problems with any of mine on either server. there is one char that takes a lil while to populate, but it eventually does.

jdhirst commented 3 years ago

My personal asset window has been spinning here for several minutes, no dice. I have a 187 items in this station (loads fine in Items window), and probably a ton of crap elsewhere.

jdhirst commented 3 years ago

While spinning, I can't click on any of the other tabs either.

jdhirst commented 3 years ago

i'll have to compare notes between them to find the error. they (should) have the same db structure

jdhirst commented 3 years ago

The "spinning" means that window is waiting on a response from server. This may have been part of the db code error, which is fixed.
Test again, and let me know if this problem persists.

jdhirst commented 3 years ago

the initial response should be failry quick, so there shouldnt be much delay. however, the quantity will affect the listing once tabs are opened (for individual listing) will look into this tonite.

jdhirst commented 3 years ago

Still present. I'm betting you have an N+1 problem, as I have several hundred items in each of several stations.

jdhirst commented 3 years ago

This works much better on dev eb777b. Check that you aren't missing an index, or indices are disabled in prod?

jdhirst commented 3 years ago

touch