• Revision 258 crash

Posted: **Sat May 23, 2009 6:32 pm**

Ok so I downloaded the latest svn (rev 258) compiled after removing some stuff from misc.cpp that im guessing svn put thre cause of a botched commit (posted it on another forum)

Loaded eq2world it loads fine (database error reguarding the name field of item_effects table) But other then that it loads fine and connects to the ls

Code: Select all

[wisler@cp eqemu2]$ ./eq2world
[Status] Using database 'wisler_eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status]        Connected to Update Server: eq2emulator.net:9103
[Status]        Checking for updates.
[Status]        Found Updates.
[Status]        Processing Updates.
[Error] Login reports that the latest version of the 'item_effects' is 65000, you are using 0.  The query that will run to update your table is: 
DROP TABLE IF EXISTS `item_effects`

CREATE TABLE `item_effects` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `item_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default 'Unknown',
  `percentage` tinyint(3) unsigned NOT NULL default '100',
  `description` text NOT NULL,
  `bullet` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
alter table `item_effects` change `name` `name` varchar(512) default 'Unknown' NOT NULL



[Status]        Table Update complete.
[Status]        Server is already up-to-date.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Clearing player online flags..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status]        Loaded 0 loot tables.
[Status]        Loaded 0 loot drops.
[Status]        Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status]        Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status]        Loaded 0 Bag(s)
[Status]        Loaded 0 Food(s)
[Status]        Loaded 0 Weapon(s)
[Status]        Loaded 0 Armor/Shield Piece(s)
[Status]        Loaded 0 Skill Item(s)
[Status]        Loaded 0 Regular Items
[Status] Loading spells..
[Status]        Loaded 2 Spell(s)
[Status] Loading LUA spells..
[Status]        Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status]        Loaded 48 Factions
[Status] Loading skills..
[Status]        Loaded 129 Skills
[Status] Loading Quests..
[Status]        Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status]        Loaded 0 Merchant Inventory Item(s)
[Status]        Loaded 0 Merchant List(s)
[Status] Loading Spawn Script Information..
[Status] Loading Zone Script Information..
[Status] Loading EQ time of day..
Please refrain from drinking alcoholic beverages while using this program.
Starting factory Reader
Starting factory Writer
World server listening on: 64.69.34.153:9001
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100

about ohhh a minute or so later my terminal window fills with the following

Code: Select all

Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11
Got signal 11

Posted: **Sun May 24, 2009 1:11 am**

Why are you removing stuff from misc.cpp?

And what do you mean after a "botched commit", you can't commit anything

A botched wha?

Posted: **Sun May 24, 2009 9:46 am**

Nothing is wrong with the commit (see my other response to this user in Development).

As for Got Signal 11, welcome to the club. That's just how it is, and I can only cry and complain about it so much before choosing to ignore and reset.

Posted: **Mon May 25, 2009 12:33 am**

Are you getting a signal 11 every time you start up your server?

Posted: **Wed May 27, 2009 3:03 am**

yes and its a never ending loop its pretty bad when it hangs on crashing and wont fully crash lol, that means no core dumps no info and the process keeps runningbut the server doesnt, its very annoying but hey i just said screw it and stopped messing with it after 2 days of trying to get it to work.

Posted: **Sat May 30, 2009 8:39 am**

You don't have SpawnStructs.xml, ItemStructs.xml, CommonStructs.xml or EQ2_Structs.xml in the directory?

Posted: **Sat May 30, 2009 8:41 am**

It is really easy to debug in linux if its crashing (if you compile yourself):

go into the directory with the eq2world executable.

type 'gdb' and press enter.
type 'file eq2world' and press enter.
type 'run' and press enter.

Do ctrl-c at any time to break out of the program, type 'quit' and enter to exit gdb.

If you did this, would have noticed why all the signal 11's

Posted: **Sat May 30, 2009 8:50 am**

backtrace:

(gdb) backtrace
#0 0xb7ae187b in ?? () from /lib/tls/i686/cmov/libc.so.6
#1 0xb7ae15e0 in strtol () from /lib/tls/i686/cmov/libc.so.6
#2 0xb7ade891 in atoi () from /lib/tls/i686/cmov/libc.so.6
#3 0x0813ac93 in WorldDatabase::WriteServerStatisticsNeededQueries (
this=0x8269140) at WorldDatabase.cpp:3260
#4 0x081ca02c in World::WriteServerStatistics (this=0x8267c20)
at World.cpp:1267
#5 0x081d8d4c in World::Process (this=0x8267c20) at World.cpp:212
#6 0x0810feb4 in main () at net.cpp:274

Posted: **Sat May 30, 2009 8:52 am**

// Number of unique accounts
result = query.RunQuery2(Q_SELECT, "SELECT COUNT(DISTINCT account_id) FROM characters");
if (result && (row = mysql_fetch_row(result)))
WriteServerStatistic(STAT_SERVER_NUM_ACCOUNTS, atoi(row[0]));

// Number of characters
result = query.RunQuery2(Q_SELECT, "SELECT COUNT(id) FROM characters");
if (result && (row = mysql_fetch_row(result)))
WriteServerStatistic(STAT_SERVER_NUM_CHARACTERS, atoi(row[0]));

// Average character level
result = query.RunQuery2(Q_SELECT, "SELECT ROUND(AVG(level)) FROM characters");
if (result && (row = mysql_fetch_row(result)))
WriteServerStatistic(STAT_SERVER_AVG_CHAR_LEVEL, atoi(row[0]));

if characters is empty round(avg(..)) can return null

Posted: **Sat May 30, 2009 8:56 am**

well John Adams as we were talking test cases, I would like to see your QA tools because I actually haven't taken much of an active role in QA but I see the advantages

Posted: **Sat May 30, 2009 9:01 am**

Revision 712 resolves this issue (private svn). Revision 264 should be the public svn when its pushed.

Posted: **Sat May 30, 2009 3:59 pm**

Image, did you mean all your replies to be in this thread? I wasn't sure if you were answering aergad, or found some other problem. Or if the forums are whacked and all your posts are ending up here lol

Posted: **Sat May 30, 2009 4:03 pm**

It was on purpose because I know you read every post

Just happened to come across another reason for the autotesting

Posted: **Sat May 30, 2009 4:47 pm**

Code: Select all

John Adams
    Database Lead
     
    Posts: 4052

Code: Select all

Image
    Developer
     
    Posts: 133

You will never catch me! muhahah!!

Revision 258 crash

Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash

Re: Revision 258 crash