Revision 258 crash

[aergad]

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

[Scatman]

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?

[John Adams]

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.

[Scatman]

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

[aergad]

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.

[Image]

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

[Image]

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

[Image]

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

[Image]

// 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

[Image]

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

[Image]

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

[John Adams]

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

[Image]

It was on purpose because I know you read every post

Just happened to come across another reason for the autotesting

[John Adams]

Code: Select all

John Adams
    Database Lead
     
    Posts: 4052

Code: Select all

Image
    Developer
     
    Posts: 133

You will never catch me! muhahah!!