Log in

View Full Version : World server crashes on character creation (Rev 1865)

xaque
02-18-2011, 11:01 AM
Whenever I create a character, it causes my world server to crash. I ran GDB on the server to try and track it down, and here is the output:


[Debug] [WORLD__CLIENT] Validating char creation info...
[Debug] [WORLD__CLIENT] Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE player_choice=8 AND player_class=2 AND player_deity=202 AND player_race=8

[Status] Found starting location in start_zones
[Debug] [WORLD__CLIENT] chuzzum: Current location: kaladimb 132.00, 771.00, 2.50
[Debug] [WORLD__CLIENT] chuzzum: Bind location: kaladimb 132.00, 771.00, 2.50

Program received signal SIGSEGV, Segmentation fault.
0x0000000000000000 in ?? ()
(gdb) bt
#0 0x0000000000000000 in ?? ()
#1 0x000000000049ec6a in SharedDatabase::GetItem (this=<value optimized out>, id=<value optimized out>) at ../common/shareddb.cpp:992
#2 0x00000000004a1048 in SharedDatabase::SetStartingItems (this=0x794600, pp=<value optimized out>, inv=0x7fffffff8680, si_race=<value optimized out>, si_class=<value optimized out>,
si_deity=<value optimized out>, si_current_zone=67, si_name=0x7fffffff8794 "Asikoyy", admin_level=250) at ../common/shareddb.cpp:394
#3 0x00000000004569f2 in Client::OPCharCreate (this=0x7c5da0, name=0x7c5dac "Asikoyy", cc=0x7bd9f0) at client.cpp:1286
#4 0x0000000000458383 in Client::HandlePacket (this=0x7c5da0, app=0x7bd8d0) at client.cpp:501
#5 0x000000000045920f in Client::Process (this=0x7c5da0) at client.cpp:812
#6 0x00000000004ba934 in ClientList::Process (this=0x7934a0) at clientlist.cpp:59
#7 0x000000000045cbb3 in main (argc=<value optimized out>, argv=<value optimized out>) at net.cpp:421


I suspect the issue is something to do with the inventory data being corrupted but I'm not sure. I'm using the PEQ rev 1751 database. I looked at the inventory table and it seems to be fine, at least, it has data in it.
Congdar
02-18-2011, 01:05 PM
from: http://www.eqemulator.org/forums/showthread.php?t=32980

In the window that pops up, click on the little square with 3 dots [...] to navigate to
the following folder(on your C-Drive: /source/trunk/EQEmuServer/utils/sql/svn/
*Note*
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)
xaque
02-18-2011, 01:51 PM
I have done that, and I am still getting the same error.
Congdar
02-18-2011, 01:52 PM
your dump file looks like maybe starting_items table is missing or broken
xaque
02-18-2011, 02:11 PM
Here is the first 20 elements of the starting_items table:


INSERT INTO `starting_items` (`id`, `race`, `class`, `deityid`, `zoneid`, `itemid`, `item_charges`, `gm`, `slot`) VALUES
(1, 0, 0, 0, 0, 9979, 1, 0, 14),
(2, 0, 0, 0, 0, 9990, 20, 0, -1),
(3, 0, 0, 0, 0, 9991, 20, 0, -1),
(5, 0, 1, 0, 0, 9998, 1, 0, 13),
(6, 0, 3, 0, 0, 9998, 1, 0, 13),
(7, 0, 4, 0, 0, 9998, 1, 0, 13),
(8, 0, 5, 0, 0, 9998, 1, 0, 13),
(9, 0, 8, 0, 0, 9998, 1, 0, 13),
(10, 0, 2, 0, 0, 9999, 1, 0, 13),
(11, 0, 6, 0, 0, 9999, 1, 0, 13),
(12, 0, 7, 0, 0, 9999, 1, 0, 13),
(13, 0, 10, 0, 0, 9999, 1, 0, 13),
(14, 0, 9, 0, 0, 9997, 1, 0, 13),
(15, 0, 11, 0, 0, 9997, 1, 0, 13),
(16, 0, 12, 0, 0, 9997, 1, 0, 13),
(17, 0, 13, 0, 0, 9997, 1, 0, 13),
(18, 0, 14, 0, 0, 9997, 1, 0, 13),
(19, 0, 15, 0, 0, 9997, 1, 0, 13),
(20, 0, 16, 0, 0, 55623, 1, 0, 13),


I put a debug line in the server to show the exact item ID it was crashing on. (9979.) It corresponds to the Gloomingdeep Lantern in the items table. Looking at the items table, I don't see anything wrong with the entry, but I'm not sure what to look for.
Congdar
02-18-2011, 02:21 PM
yep, it looks good to me too. how many times have you done this? just sayin' cuz if you miss one step things don't work. it's less stressful to start over than trying to figure out what you missed, and you obviously missed something. there are soooooo many steps to getting the emu running that it's easy to miss something that will cause a crash. Are you using the latest source from svn(1865)? sometimes it takes a couple of tries to get it right.
xaque
02-18-2011, 02:25 PM
I dropped the entire SQL database and reloaded it from scratch following that link you posted. Still no luck. I am using the latest revision of the server code. I'll try redoing the SQL db again and see if I can notice any warnings or errors.
Congdar
02-18-2011, 02:34 PM
tell me the exact class race etc. i'll see if i can create a char using your choices. did you choose the tutorial? what other choices did you make? it really could be an issue with the combination of choices you made when creating your character and if i try and get the same error then we'll know it's not your setup.
xaque
02-18-2011, 02:55 PM
I seem to get the same issue with every race/class/other choices combo I pick. One that I know for sure does it is Human Paladin, no tutorial, Erollsi Marr as deity (if that matters), starting in Freeport. This is in EQ Titanium, btw, not sure if that makes a difference.

Also, here are the SQL errors I get when I try and import the files in the EQEmuServer/utils/sql/svn/ folder. I only imported ones with numbers >= 1711.


mysql> source 1719_optional_triggerOnCastAAs.sql
ERROR 1062 (23000): Duplicate entry '1435' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1435-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1435-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1435-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1435-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1436-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1436-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1436-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1436-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1437-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1437-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1437-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1437-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1486-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1486-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1487-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1488-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1489-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1490-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1478' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1478-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1478-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1478-2' for key 'PRIMARY'

mysql> source 1720_required_sql_AA_effects_update.sql;
Query OK, 592 rows affected (0.04 sec)
Records: 592 Duplicates: 0 Warnings: 0

ERROR 1062 (23000): Duplicate entry '625-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '626-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '627-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '92-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '93-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '94-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '267-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '268-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '269-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '637-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '638-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '639-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '640-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '641-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '642-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '770-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '771-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '772-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1107-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1108-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1109-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '924-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '925-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1210-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1211-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1212-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '77-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '77-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '78-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '78-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '79-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '79-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '434-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '435-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '436-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '434-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '435-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '436-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '80-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '80-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '81-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '81-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '82-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '82-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '437-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '437-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '438-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '438-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '439-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '439-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '113-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '114-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '115-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '443-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '444-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '445-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '767-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '768-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '769-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1099-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1100-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1101-1' for key 'NewIndex'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0


mysql> source 1720_optional_sql_AAs.sql
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

ERROR 1062 (23000): Duplicate entry '1378' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1379' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1380' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1381' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1382' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1011' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1011-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1011-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1011-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1011-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1011-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1012-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1012-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1012-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1012-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1012-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1013-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1013-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1013-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1013-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1013-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1014-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1014-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1014-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1014-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1014-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1015-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1015-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1015-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1015-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1015-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1016-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1016-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1016-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1016-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1016-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1361-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1361-7' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1362' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1362-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1362-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1362-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1363' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1363-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1364' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1364-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1364-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1364-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1364-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1364-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1365' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1365-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1366-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-6' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1366-7' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1367' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1367-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1367-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1367-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1368' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1368-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1369' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1369-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1369-2' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1369-3' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1369-4' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1369-5' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '1370' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1370-1' for key 'NewIndex'
ERROR 1062 (23000): Duplicate entry '5150' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5150-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5165-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5180-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5195-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5210-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-1' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-2' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-3' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-4' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-5' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-6' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-7' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-8' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-9' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-10' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-11' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-12' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-13' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '5225-14' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1647' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1647-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4702' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4702-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4703' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4703-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4704' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4704-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4705' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4705-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4706' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4706-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4707' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4707-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4708' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4708-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4709' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4709-0' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4710' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '4710-0' for key 'PRIMARY'

mysql> source 1723_required_sql_corruption.sql
ERROR 1146 (42S02): Table 'peq.botbuffs' doesn't exist
ERROR 1146 (42S02): Table 'peq.bots' doesn't exist
ERROR 1060 (42S21): Duplicate column name 'Corrup'

mysql> source 1736_optional_sql_feral_swipe.sql
ERROR 1062 (23000): Duplicate entry '723-0' for key 'PRIMARY'

mysql> source 1747_optional_HoT_zone_and_zonepoints.sql;
ERROR 1062 (23000): Duplicate entry '5556' for key 'PRIMARY'
ERROR 1062 (23000): Duplicate entry '1912' for key 'PRIMARY'

mysql> source 1802_required_doppelganger.sql
ERROR 1062 (23000): Duplicate entry '678' for key 'PRIMARY'
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.07 sec)

Query OK, 1 row affected (0.03 sec)

Query OK, 1 row affected (0.03 sec)
Congdar
02-18-2011, 03:05 PM
what other errors are you seeing? got some logs from world startup?
xaque
02-18-2011, 09:30 PM
I just found the problem. It's kind of obvious in retrospect. I guess I just skimmed over it when looking at the logs before:


[Error] Load Shared Library 'libEMuShareMem.so' failed. Error=libEMuShareMem.so: cannot open shared object file: No such file or directory
[Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring


I had added the location of the library to my path at one point... but forgot to add it to a startup script so it got cleared when I logged out of that terminal shell. Now it's linked correctly and everything seems to be working. Thank you for your help, Congdar.
Congdar
02-18-2011, 11:58 PM
It always seems to be one small detail. Glad you're up and running!
nerocon2
12-22-2011, 07:57 PM
Thanks for coming back and posting what you found, really is an obvious error once you see it but for some reason my eyes missed it too so I had to search the forums. I got the same error when I forgot to copy libEMuShareMem.so into /usr/lib after compile. Hopefully this will help anyone else who makes the same mistake as it did me.

Sorry to dredge up an old post, but it was very much relevant.