Weird Item bug, no items are showing up.

Maze_EQ · #1 07-19-2016, 08:21 AM

Rebooted my host machine to add an extra 16gb of ram for other virtual machines, and when it came back up I started seeing some strange things such as disappearing items, and errors in world.

Code:

[07-19-2016 :: 07:31:51] [World Server] Starting HTTP world service...
[07-19-2016 :: 07:31:51] [World Server] Checking Database Conversions..
[07-19-2016 :: 07:31:51] [World Server] Loading variables..
[07-19-2016 :: 07:31:51] [World Server] Loading zones..
[07-19-2016 :: 07:31:51] [World Server] Clearing groups..
[07-19-2016 :: 07:31:51] [World Server] Clearing raids..
[07-19-2016 :: 07:31:51] [World Server] Clearing inventory snapshots..
[07-19-2016 :: 07:31:51] [World Server] Loading items..
[07-19-2016 :: 07:31:51] [World Server] Loading skill caps..
[07-19-2016 :: 07:31:51] [World Server] Loading guilds..
[07-19-2016 :: 07:31:51] [World Server] Loaded default rule set 'default'
[07-19-2016 :: 07:31:51] [World Server] Loading EQ time of day..
[07-19-2016 :: 07:31:51] [World Server] Loading launcher list..
[07-19-2016 :: 07:31:51] [World Server] Reboot zone modes OFF
[07-19-2016 :: 07:31:51] [World Server] Deleted 14 stale player corpses from database
[07-19-2016 :: 07:31:51] [World Server] Loading adventures...
[07-19-2016 :: 07:31:51] [World Server] Purging expired instances
[07-19-2016 :: 07:31:51] [World Server] Loading char create info...
[07-19-2016 :: 07:31:51] [World Server] Zone (TCP) listener started.
[07-19-2016 :: 07:31:51] [World Server] Client (UDP) listener started.
[07-19-2016 :: 07:31:51] [World Server] New TCP connection from 127.0.0.1:59560
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59561
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59548
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59562
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59563
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59564
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59566
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59565
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59567
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59549
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59550
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59551
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59569
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59570
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59552
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59553
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59554
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59555
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59571
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59556
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59557
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59558
[07-19-2016 :: 07:31:52] [World Server] New TCP connection from 127.0.0.1:59559
[07-19-2016 :: 07:32:00] [World Server] New TCP connection from 127.0.0.1:59577
[07-19-2016 :: 07:32:00] [World Server] New TCP connection from 127.0.0.1:59578
[07-19-2016 :: 07:32:00] [World Server] New TCP connection from 127.0.0.1:59579
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59580
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59581
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59582
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59583
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59584
[07-19-2016 :: 07:32:01] [World Server] New TCP connection from 127.0.0.1:59585
[07-19-2016 :: 07:33:36] [World Server] New connection from 92.108.63.218:56934
[07-19-2016 :: 07:33:37] [World Server] Checking inbound connection 92.108.63.218 against BannedIPs table
[07-19-2016 :: 07:33:37] [World Server] Connection 92.108.63.218 PASSED banned IPs check. Processing connection.
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (251) with parent slot id (22)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=9990, slot_id=251
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (252) with parent slot id (22)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=9991, slot_id=252
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (253) with parent slot id (22)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=21779, slot_id=253
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (254) with parent slot id (22)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=4113, slot_id=254
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (255) with parent slot id (22)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=28018, slot_id=255
[07-19-2016 :: 07:33:37] [Error] Inventory::_PutItem: Invalid slot_id specified (266) with parent slot id (23)
[07-19-2016 :: 07:33:37] [Error] Warning: Invalid slot_id for item in inventory: name=Wulfin, acctid=76822, item_id=9979, slot_id=266
[07-19-2016 :: 07:34:15] [World Server] New connection from 68.83.5.63:49655
[07-19-2016 :: 07:34:15] [World Server] Checking inbound connection 68.83.5.63 against BannedIPs table
[07-19-2016 :: 07:34:15] [World Server] Connection 68.83.5.63 PASSED banned IPs check. Processing connection.
[07-19-2016 :: 07:34:15] [Error] Inventory::_PutItem: Invalid slot_id specified (278) with parent slot id (24)
[07-19-2016 :: 07:34:15] [Error] Warning: Invalid slot_id for item in inventory: name=Maze, acctid=76668, item_id=59943, slot_id=278
[07-19-2016 :: 07:34:15] [Error] Inventory::_PutItem: Invalid slot_id specified (271) with parent slot id (24)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=5360, slot_id=271
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (273) with parent slot id (24)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=11552, slot_id=273
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (274) with parent slot id (24)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=4882, slot_id=274
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (275) with parent slot id (24)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=4886, slot_id=275
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (311) with parent slot id (28)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=30402, slot_id=311
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (313) with parent slot id (28)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=15747, slot_id=313
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (314) with parent slot id (28)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=30449, slot_id=314
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (315) with parent slot id (28)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=20922, slot_id=315
[07-19-2016 :: 07:34:16] [Error] Inventory::_PutItem: Invalid slot_id specified (317) with parent slot id (28)
[07-19-2016 :: 07:34:16] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=7734, slot_id=317
[07-19-2016 :: 08:12:34] [World Server] Starting HTTP world service...
[07-19-2016 :: 08:12:34] [World Server] Checking Database Conversions..
[07-19-2016 :: 08:12:34] [World Server] Loading variables..
[07-19-2016 :: 08:12:34] [World Server] Loading zones..
[07-19-2016 :: 08:12:34] [World Server] Clearing groups..
[07-19-2016 :: 08:12:34] [World Server] Clearing raids..
[07-19-2016 :: 08:12:34] [World Server] Clearing inventory snapshots..
[07-19-2016 :: 08:12:34] [World Server] Loading items..
[07-19-2016 :: 08:12:34] [World Server] Loading skill caps..
[07-19-2016 :: 08:12:34] [World Server] Loading guilds..
[07-19-2016 :: 08:12:34] [World Server] Loaded default rule set 'default'
[07-19-2016 :: 08:12:34] [World Server] Loading EQ time of day..
[07-19-2016 :: 08:12:34] [World Server] Loading launcher list..
[07-19-2016 :: 08:12:34] [World Server] Reboot zone modes OFF
[07-19-2016 :: 08:12:34] [World Server] Deleted 1 stale player corpses from database
[07-19-2016 :: 08:12:34] [World Server] Loading adventures...
[07-19-2016 :: 08:12:34] [World Server] Purging expired instances
[07-19-2016 :: 08:12:34] [World Server] Loading char create info...
[07-19-2016 :: 08:12:35] [World Server] Zone (TCP) listener started.
[07-19-2016 :: 08:12:35] [World Server] Client (UDP) listener started.
[07-19-2016 :: 08:12:35] [World Server] New TCP connection from 127.0.0.1:60918
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60919
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60920
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60921
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60922
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60923
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60924
[07-19-2016 :: 08:12:37] [World Server] New TCP connection from 127.0.0.1:60925
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60926
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60927
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60928
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60929
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60930
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60931
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60932
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60933
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60934
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60935
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60936
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60937
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60938
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60939
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60940
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60941
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60942
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60943
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60944
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60945
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60946
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60947
[07-19-2016 :: 08:12:38] [World Server] New TCP connection from 127.0.0.1:60948
[07-19-2016 :: 08:12:44] [World Server] New connection from 68.83.5.63:58168
[07-19-2016 :: 08:12:44] [World Server] Checking inbound connection 68.83.5.63 against BannedIPs table
[07-19-2016 :: 08:12:44] [World Server] Connection 68.83.5.63 PASSED banned IPs check. Processing connection.
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (278) with parent slot id (24)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Maze, acctid=76668, item_id=59943, slot_id=278
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (271) with parent slot id (24)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=5360, slot_id=271
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (273) with parent slot id (24)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=11552, slot_id=273
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (274) with parent slot id (24)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=4882, slot_id=274
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (275) with parent slot id (24)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=4886, slot_id=275
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (311) with parent slot id (28)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=30402, slot_id=311
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (313) with parent slot id (28)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=15747, slot_id=313
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (314) with parent slot id (28)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=30449, slot_id=314
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (315) with parent slot id (28)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=20922, slot_id=315
[07-19-2016 :: 08:12:44] [Error] Inventory::_PutItem: Invalid slot_id specified (317) with parent slot id (28)
[07-19-2016 :: 08:12:44] [Error] Warning: Invalid slot_id for item in inventory: name=Tunes, acctid=76668, item_id=7734, slot_id=317

no items are seen on any character or in #fi.

Not sure what changes were made today,and not sure why this would happen.

EDIT: I've tried changing item tables to a backup, and inventory to a backup.

Neither of those have fixed this.

EDIT2: Okay, so I sourced in my backup from yesterday (Known working database) same issue. I'm at the point to thinking this is not DB related but binary related as I downloaded new binaries via akka's installer this morning, and this is the first reboot since then.

EDIT3: I'm an idiot. Used old binaries, same issue. Updated binaries again just now and everything is happily working.

My thought is that I downloaded binaries without applying database updates. Just a hunch, in case anyone else sees this issue.

>.<