search

EvEmu-Project / evemu_Crucible

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

crash on login at ubuntu 18.04 #210

Closed NukedBart closed 2 years ago

NukedBart commented 2 years ago

Describe the bug It crashes

To Reproduce Steps to reproduce the behavior:

  1. Build
  2. DB Install(probably not fully migrated, SQL syntax error for some sqls)
  3. Login
  4. Crash

Expected behavior Gameplay

System Details:

Additional context


22:36:28 [DB Error] GetExpressions(/evemubuild/evemu_Crucible/src/eve-server/cache/BulkDB.cpp:319): Error in GetExpressions: Table 'evemu.dgmExpressions' doesn't exist
22:36:28 [DB Error] DoQuery_locked(/evemubuild/evemu_Crucible/src/eve-core/database/dbcore.cpp:320): DBCore - Status != Connected
22:36:28 [DB Error] DoQuery_locked(/evemubuild/evemu_Crucible/src/eve-core/database/dbcore.cpp:345): DBCore Query - #1146 in ' SELECT expressionID, operandID, arg1, arg2, expressionValue, description, expressionName, expressionTypeID, expressionGroupID, expressionAttributeID FROM dgmExpressions': Table 'evemu.dgmExpressions' doesn't exist
22:36:28 [DB Error] GetExpressions(/evemubuild/evemu_Crucible/src/eve-server/cache/BulkDB.cpp:319): Error in GetExpressions: Table 'evemu.dgmExpressions' doesn't exist
22:36:28 [DB Error] DoQuery_locked(/evemubuild/evemu_Crucible/src/eve-core/database/dbcore.cpp:320): DBCore - Status != Connected
22:36:30 [Service] bulkMgr::GetFullFilesChunk()```
Almamu commented 2 years ago

I'm guessing direct build here? What MariaDB server version are you running?

NukedBart commented 2 years ago

I'm guessing direct build here? What MariaDB server version are you running?

5.7.37 MySQL

NukedBart commented 2 years ago 
Continuing.
[New Thread 0x7fb78bfff700 (LWP 26348)]

Thread 1 "eve-server" received signal SIGSEGV, Segmentation fault.
0x000055559afdccb3 in MarshalStream::VisitDict (this=0x5555a8bcfc80, rep=0x5555a8bcf6f0)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:279
279             if ( !cur->second->visit( *this ) )
#0  0x000055559afdccb3 in MarshalStream::VisitDict (this=0x5555a8bcfc80, rep=0x5555a8bcf6f0)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:279
#1  0x000055559b158182 in PyDict::visit (this=0x5555a8bcf6f0, v=...) at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:677
#2  0x000055559b1602fb in PyVisitor::VisitTuple (this=0x5555a8bcfc80, rep=0x5555a47a24c0)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyVisitor.cpp:41
#3  0x000055559afdcb42 in MarshalStream::VisitTuple (this=0x5555a8bcfc80, rep=0x5555a47a24c0)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:252
#4  0x000055559b157850 in PyTuple::visit (this=0x5555a47a24c0, v=...)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:555
#5  0x000055559afdc1ee in MarshalStream::SaveStream (this=0x5555a8bcfc80, rep=0x5555a47a24c0)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:89
#6  0x000055559afdc16f in MarshalStream::Save (this=0x5555a8bcfc80, rep=0x5555a47a24c0, into=...)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:72
#7  0x000055559afdbfb4 in Marshal (rep=0x5555a47a24c0, into=...)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:39
#8  0x000055559b15a1a6 in PySubStream::EncodeData (this=0x5555a8bcf7e0)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:1115
#9  0x000055559afddbbf in MarshalStream::VisitSubStream (this=0x5555a8bcfc40, rep=0x5555a8bcf7e0)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:494
#10 0x000055559b15a124 in PySubStream::visit (this=0x5555a8bcf7e0, v=...)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:1106
#11 0x000055559b1602fb in PyVisitor::VisitTuple (this=0x5555a8bcfc40, rep=0x5555a8bcec70)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyVisitor.cpp:41
#12 0x000055559afdcb42 in MarshalStream::VisitTuple (this=0x5555a8bcfc40, rep=0x5555a8bcec70)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:252
#13 0x000055559b157850 in PyTuple::visit (this=0x5555a8bcec70, v=...)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:555
#14 0x000055559b1602fb in PyVisitor::VisitTuple (this=0x5555a8bcfc40, rep=0x5555a8bcec30)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyVisitor.cpp:41
#15 0x000055559afdcb42 in MarshalStream::VisitTuple (this=0x5555a8bcfc40, rep=0x5555a8bcec30)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:252
#16 0x000055559b157850 in PyTuple::visit (this=0x5555a8bcec30, v=...)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:555
#17 0x000055559b160530 in PyVisitor::VisitObject (this=0x5555a8bcfc40, rep=0x5555a8bcfb80)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyVisitor.cpp:73
#18 0x000055559afdcd7f in MarshalStream::VisitObject (this=0x5555a8bcfc40, rep=0x5555a8bcfb80)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:291
#19 0x000055559b1588fc in PyObject::visit (this=0x5555a8bcfb80, v=...)
    at /evemubuild/evemu_Crucible/src/eve-common/python/PyRep.cpp:780
#20 0x000055559afdc1ee in MarshalStream::SaveStream (this=0x5555a8bcfc40, rep=0x5555a8bcfb80)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:89
#21 0x000055559afdc16f in MarshalStream::Save (this=0x5555a8bcfc40, rep=0x5555a8bcfb80, into=...)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:72
#22 0x000055559afdbfb4 in Marshal (rep=0x5555a8bcfb80, into=...)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:39
#23 0x000055559afdc047 in MarshalDeflate (rep=0x5555a8bcfb80, into=..., deflationLimit=8192)
    at /evemubuild/evemu_Crucible/src/eve-common/marshal/EVEMarshal.cpp:48
#24 0x000055559afec8e9 in EVETCPConnection::QueueRep (this=0x7fb784000b40, rep=0x5555a8bcfb80, compress=true)
    at /evemubuild/evemu_Crucible/src/eve-common/network/EVETCPConnection.cpp:66
#25 0x000055559afea1d3 in EVEClientSession::QueuePacket (this=0x55559d817740, packet=0x55559de04bd0)
    at /evemubuild/evemu_Crucible/src/eve-common/network/EVESession.cpp:77
#26 0x000055559aa53f23 in Client::_SendCallReturn (this=0x55559d817740, source=..., callID=5, rsp=...)
    at /evemubuild/evemu_Crucible/src/eve-server/Client.cpp:2412
#27 0x000055559aa54e5d in Client::Handle_CallReq (this=0x55559d817740, packet=0x55559dd3bb50, req=...)
    at /evemubuild/evemu_Crucible/src/eve-server/Client.cpp:2579
#28 0x000055559afe808b in EVEPacketDispatcher::DispatchPacket (this=0x55559d817760, packet=0x55559dd3bb50)
    at /evemubuild/evemu_Crucible/src/eve-common/network/EVEPktDispatch.cpp:82
#29 0x000055559aa475b5 in Client::ProcessNet (this=0x55559d817740) at /evemubuild/evemu_Crucible/src/eve-server/Client.cpp:300
#30 0x000055559aa6f882 in EntityList::Process (this=0x55559c97fcc0) at /evemubuild/evemu_Crucible/src/eve-server/EntityList.cpp:192
#31 0x000055559aa3341c in main (argc=1, argv=0x7ffe9c0e7548) at /evemubuild/evemu_Crucible/src/eve-server/eve-server.cpp:900
jdhirst commented 2 years ago

@NukedBart We don't really support MySQL, only MariaDB. Your experience may vary with MySQL. I suggest trying it in Docker or using MariaDB 10.4 or later.

jdhirst commented 2 years ago

Also, if your DB is not fully migrated, I suggest running ./evedbtool up to finish migration. If you are on staging, it may fail as staging has had changes in the db structure which aren't yet finalized.

In that case, you may want to nuke the db and reinstall it.

However, there should be no such changes in the master db. That one should work fine without migration failures.

In general, staging shouldn't be used for non-ephemeral installations as it is constantly in-flux and not stable.

NukedBart commented 2 years ago

using mysql caused the issue, do not use mysql

jdhirst commented 2 years ago

Thanks for the confirmation! I have updated the wiki to reflect this more clearly in the new users guide: https://wiki.evemu.dev/index.php?title=New_Users_Guide&diff=2942&oldid=2132