EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Bots (https://www.eqemulator.org/forums/forumdisplay.php?f=676)
-   -   Bot Zoning / Grouping issue (https://www.eqemulator.org/forums/showthread.php?t=40413)

ionhsmith 02-19-2016 10:48 AM
Bot Zoning / Grouping issue
 
Found two issues with the bots when grouping.

1. When there are bots in a group and anyone zones or dies the group is disbanded.

2. When in group the group leader cannot invite other bots only his own. The group leader has to pass the lead to get other players bots in.

N0ctrnl 02-19-2016 06:39 PM
#2 isn't a an issue. That's how it works.

#1 is likely due to you missing a table update. Check your table names and structure against the bot SQL file https://github.com/EQEmu/Server/blob...09_30_bots.sql

Uleat 02-19-2016 07:22 PM
(#1)
I had him manually install the updates since he was having issues with eqemu_update.pl.

He probably needs a few more schema changes applied..though, it could be a missed table addition or change.


(#2)
This could be looked at in the future..just make the check include a case for the owner being in the group, or such.

Wouldn't know its feasibility until it was actually looked at, though.

ionhsmith 02-19-2016 11:18 PM
yea looks like I have that because I manually loaded in that bot sql ... I'm not sure which one is out of date but if there is a fix I would love it lol because that zoning things is annoying

Uleat 02-19-2016 11:49 PM
Check your server log files to see if there are any database query errors.

Cursian 02-20-2016 04:52 PM
Hi Uleat,

I am having the same issue with bots disappearing and disbanding on zone.

I have dropped bots and reloaded several times. I also manually confirmed each table and field / value with the above SQL.

There are no query errors in the logs. I have another server / DB version from 2013 that has the same issue. I actually thought this was normal until I saw posts regarding this problem.

Do you have any ideas? This issue persists on all client versions. I sourced, compiled and created a new DB just a few days ago.

Uleat 02-20-2016 04:59 PM
Are you manually dropping/loading bots? Or are you using the eqemu_update.pl script to do it?

ionhsmith 02-20-2016 05:39 PM
ok I manually looked at my tables and they are all there and look the same as the update. the only thing I see different is where this says integer unsigned... mine has INT(10) unigned

Code:
CREATE TABLE `bot_groups` (
186        `groups_index` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
187        `group_leader_id` INTEGER UNSIGNED NOT NULL DEFAULT '0',
188        `group_name` VARCHAR(64) NOT NULL,
189        PRIMARY KEY  (`groups_index`),
190        KEY `FK_bot_groups_1` (`group_leader_id`),
191        CONSTRAINT `FK_bot_groups_1` FOREIGN KEY (`group_leader_id`) REFERENCES `bot_data` (`bot_id`)

Uleat 02-20-2016 06:24 PM
That should be fine..INT(10) is large enough to an unsigned 32-bit integer.


Make sure that you have these four tables (views):
Quote:
vw_bot_character_mobs
vw_bot_groups
vw_groups
vw_guild_members
and these two functions:
Quote:
GetMobType
GetMobTypeById

ionhsmith 02-20-2016 06:51 PM
Yes I have all of those

Uleat 02-20-2016 07:50 PM
What do these queries return:
Code:
SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';

Quote:
Originally Posted by `spawn2`
id,enabled
59297,1
59298,1
Quote:
Originally Posted by `guild_members` - should be no results
Quote:
Originally Posted by `group_id`
Table,Non_unique,Key_name,Seq_in_index,Column_name ,Collation,Cardinality,Sub_part,Packed,Null,Index_ type,Comment,Index_comment
group_id,0,PRIMARY,1,groupid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,2,charid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,3,name,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,4,ismerc,A,1,\N,\N,,BTREE,,

ionhsmith 02-20-2016 07:55 PM
Code:
/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 622 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `peq`;
/* Entering session "EQ" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='peq';
SHOW TABLE STATUS FROM `peq`;
SHOW FUNCTION STATUS WHERE `Db`='peq';
SHOW PROCEDURE STATUS WHERE `Db`='peq';
SHOW TRIGGERS FROM `peq`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';

ionhsmith 02-20-2016 08:00 PM
ID Enabled

59,297 1
59,298 1

and the group id is 0

ionhsmith 02-21-2016 09:15 PM
Is this what its suppose to show ?

Uleat 02-21-2016 09:34 PM
The `spawn2` query is fine.

Just need clarification on the `guild_members` and `group_id` queries.

ionhsmith 02-22-2016 11:04 PM
Code:
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.000 sec. */
Code:
/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 979 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `peq`;
/* Entering session "EQ" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='peq';
SHOW TABLE STATUS FROM `peq`;
SHOW FUNCTION STATUS WHERE `Db`='peq';
SHOW PROCEDURE STATUS WHERE `Db`='peq';
SHOW TRIGGERS FROM `peq`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.000 sec. */
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0  Found rows: 4  Warnings: 0  Duration for 1 query: 0.000 sec. */

This everything you needed?

Uleat 02-22-2016 11:13 PM
`guild_members` has 1 key for standard, 0 keys for bots..

`group_id` has 3 keys for standard, 4 keys for bots..


Based on that, and the previous checks, it 'looks' like you have the correct db schema for bots.


At this point, we really need log errors to see what may be going on - in particular, database query failures.

ionhsmith 02-23-2016 06:58 PM
where do I find these because in my logs folder I don't see any thing except world.exe logs and in the zone folder ... everything else is blank

Uleat 02-23-2016 07:25 PM
Check your zone folder logs.

Look for entries in the zone log for the zone where the failed action occurred.

ionhsmith 02-23-2016 09:38 PM
Code:
[07-07-2015 :: 22:47:03] [Crash] EXCEPTION_ACCESS_VIOLATION
[07-07-2015 :: 22:47:03] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEMUServer;C:\EQ\EQEMUServer;C:\Windows;C:\Windows\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Gamble'
[07-07-2015 :: 22:47:03] [Crash] OS-Version: 6.1.7601 (Service Pack 1) 0x300-0x1
[07-07-2015 :: 22:47:04] [Crash] C:\EQ\EQEMUServer\world.exe:world.exe (00D60000), size: 7806976 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\world.exe'
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77B00000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\kernel32.dll:kernel32.dll (759B0000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (76050000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\USER32.dll:USER32.dll (77130000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\GDI32.dll:GDI32.dll (76110000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.18778
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\LPK.dll:LPK.dll (760E0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7601.18768
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\USP10.dll:USP10.dll (77030000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18454
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (75F90000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (77650000), size: 659456 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\SysWOW64\sechost.dll:sechost.dll (75570000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (75EA0000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.18532
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (75470000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (75460000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_ec86b8d6858ec0bc\COMCTL32.dll:COMCTL32.dll (6EBD0000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_ec86b8d6858ec0bc\COMCTL32.dll', fileVersion: 5.82.7601.18837
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (760A0000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\NSI.dll:NSI.dll (76ED0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\VERSION.dll:VERSION.dll (736A0000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\IMM32.DLL:IMM32.DLL (775F0000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (76E00000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7601.18731
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\NLAapi.dll:NLAapi.dll (68CA0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.18685
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\napinsp.dll:napinsp.dll (68C90000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (67F40000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL:WLIDNSP.DLL (6E950000), size: 159744 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL', fileVersion: 7.250.4225.0
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\PSAPI.DLL:PSAPI.DLL (761A0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\PSAPI.DLL', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (75950000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\mswsock.dll:mswsock.dll (71D60000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.18254
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (71BF0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\winrnr.dll:winrnr.dll (68C80000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (6E940000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (71D50000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\wship6.dll:wship6.dll (6E9B0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wship6.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\IPHLPAPI.DLL:IPHLPAPI.DLL (71C50000), size: 114688 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IPHLPAPI.DLL', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\WINNSI.DLL:WINNSI.DLL (71C40000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINNSI.DLL', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\fwpuclnt.dll:fwpuclnt.dll (6E900000), size: 229376 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\fwpuclnt.dll', fileVersion: 6.1.7601.18283
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\apphelp.dll:apphelp.dll (6CB20000), size: 311296 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\apphelp.dll', fileVersion: 6.1.7601.18777
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\dbghelp.dll:dbghelp.dll (75100000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\queue.h (116): MyQueue<ServerPacket>::count
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\emu_tcp_connection.cpp (803): EmuTCPConnection::RecvData
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\tcp_connection.cpp (541): TCPConnection::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\tcp_server.h (99): TCPServer<EmuTCPConnection>::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\emu_tcp_server.cpp (23): EmuTCPServer::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\tcp_server.cpp (77): BaseTCPServer::TCPServerLoop
[07-07-2015 :: 22:47:07] [Crash] f:\dd\vctools\crt\crtw32\startup\thread.c (255): _callthreadstart
[07-07-2015 :: 22:47:07] [Crash] f:\dd\vctools\crt\crtw32\startup\thread.c (239): _threadstart
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 759C337A)
[07-07-2015 :: 22:47:07] [Crash] 759C337A (kernel32): (filename not available): BaseThreadInitThunk
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B392E2)
[07-07-2015 :: 22:47:07] [Crash] 77B392E2 (ntdll): (filename not available): RtlInitializeExceptionChain
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B392B5)
[07-07-2015 :: 22:47:07] [Crash] 77B392B5 (ntdll): (filename not available): RtlInitializeExceptionChain
just got this one

ionhsmith 02-23-2016 09:40 PM
Code:
[02-23-2016 :: 20:36:13] [Crash] EXCEPTION_ACCESS_VIOLATION
[02-23-2016 :: 20:36:13] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEMUServer;C:\EQ\EQEMUServer;C:\WINDOWS;C:\WINDOWS\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Gamble'
[02-23-2016 :: 20:36:13] [Crash] OS-Version: 6.2.9200 () 0x300-0x1
[02-23-2016 :: 20:36:14] [Crash] C:\EQ\EQEMUServer\zone.exe:zone.exe (00020000), size: 17686528 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\zone.exe'
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (76FE0000), size: 1544192 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\KERNEL32.DLL:KERNEL32.DLL (74680000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNEL32.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\KERNELBASE.dll:KERNELBASE.dll (742B0000), size: 1531904 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNELBASE.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\system32\apphelp.dll:apphelp.dll (73FC0000), size: 593920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\apphelp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\AppPatch\AcLayers.DLL:AcLayers.DLL (67C60000), size: 2588672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\AppPatch\AcLayers.DLL', fileVersion: 6.2.10240.16425
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\msvcrt.dll:msvcrt.dll (75320000), size: 778240 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\msvcrt.dll', fileVersion: 7.0.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\USER32.dll:USER32.dll (74530000), size: 1310720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USER32.dll', fileVersion: 6.2.10240.16603
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\GDI32.dll:GDI32.dll (751B0000), size: 1363968 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\GDI32.dll', fileVersion: 6.2.10240.16644
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\SHELL32.dll:SHELL32.dll (75620000), size: 20701184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHELL32.dll', fileVersion: 6.2.10240.16542
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\windows.storage.dll:windows.storage.dll (74BE0000), size: 5095424 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\windows.storage.dll', fileVersion: 6.2.10240.16515
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\combase.dll:combase.dll (74940000), size: 1810432 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\combase.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\RPCRT4.dll:RPCRT4.dll (74430000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\RPCRT4.dll', fileVersion: 6.2.10240.16412
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\SspiCli.dll:SspiCli.dll (740D0000), size: 122880 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SspiCli.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\CRYPTBASE.dll:CRYPTBASE.dll (740C0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPTBASE.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll:bcryptPrimitives.dll (74060000), size: 364544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sechost.dll:sechost.dll (740F0000), size: 274432 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sechost.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\advapi32.dll:advapi32.dll (74B20000), size: 503808 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\advapi32.dll', fileVersion: 6.2.10240.16644
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\shlwapi.dll:shlwapi.dll (76DF0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\shlwapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\kernel.appcore.dll:kernel.appcore.dll (74B10000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\kernel.appcore.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\shcore.dll:shcore.dll (750C0000), size: 577536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\shcore.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\powrprof.dll:powrprof.dll (76F90000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\powrprof.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\profapi.dll:profapi.dll (74670000), size: 61440 (result: 0), SymType: '-nosymbols-', PDB: 'C:\WINDOWS\SYSTEM32\profapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\OLEAUT32.dll:OLEAUT32.dll (74830000), size: 598016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\OLEAUT32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\SETUPAPI.dll:SETUPAPI.dll (76C40000), size: 1724416 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SETUPAPI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\CFGMGR32.dll:CFGMGR32.dll (74BA0000), size: 221184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CFGMGR32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MPR.dll:MPR.dll (737A0000), size: 94208 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MPR.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sfc.dll:sfc.dll (012C0000), size: 12288 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\WINSPOOL.DRV:WINSPOOL.DRV (6FD50000), size: 421888 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINSPOOL.DRV', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\bcrypt.dll:bcrypt.dll (72F30000), size: 110592 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcrypt.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sfc_os.DLL:sfc_os.DLL (67C50000), size: 61440 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc_os.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\IMM32.DLL:IMM32.DLL (74280000), size: 176128 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\IMM32.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MSCTF.dll:MSCTF.dll (74160000), size: 1179648 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSCTF.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\WS2_32.dll:WS2_32.dll (76F30000), size: 376832 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WS2_32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\NSI.dll:NSI.dll (75480000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\NSI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\LIBMYSQL.dll:LIBMYSQL.dll (64A30000), size: 3960832 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\LIBMYSQL.dll'
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\zlib1.dll:zlib1.dll (67FC0000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEMUServer\zlib1.dll', fileVersion: 1.2.8.0
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\lua51.dll:lua51.dll (67520000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEMUServer\lua51.dll'
[02-23-2016 :: 20:36:15] [Crash] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (73660000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MSVCR110.dll:MSVCR110.dll (67EE0000), size: 876544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSVCR110.dll', fileVersion: 11.0.51106.1
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.10240.16384_none_49c02355cf03478c\COMCTL32.dll:COMCTL32.dll (753E0000), size: 598016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.10240.16384_none_49c02355cf03478c\COMCTL32.dll', fileVersion: 5.82.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (73100000), size: 77824 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (730B0000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (73090000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (72890000), size: 319488 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (73DC0000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (737F0000), size: 45056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (6FCD0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\System32\fwpuclnt.dll:fwpuclnt.dll (6FCE0000), size: 286720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\fwpuclnt.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\Perl\lib\auto\Cwd\Cwd.dll:Cwd.dll (10000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Cwd\Cwd.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\site\lib\auto\DBI\DBI.dll:DBI.dll (0D770000), size: 98304 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\site\lib\auto\DBI\DBI.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\List\Util\Util.dll:Util.dll (01450000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\List\Util\Util.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\Filter\Util\Call\Call.dll:Call.dll (030F0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Filter\Util\Call\Call.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\IO\IO.dll:IO.dll (03250000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\IO\IO.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\site\lib\auto\DBD\mysql\mysql.dll:mysql.dll (0D790000), size: 86016 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\site\lib\auto\DBD\mysql\mysql.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (68820000), size: 1306624 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\bot.cpp (3880): Bot::LoadAndSpawnAllZonedBots
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_packet.cpp (1556): Client::Handle_Connect_OP_ZoneEntry
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_packet.cpp (452): Client::HandlePacket
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_process.cpp (609): Client::Process
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\entity.cpp (487): EntityList::MobProcess
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\net.cpp (472): main
[02-23-2016 :: 20:36:24] [Crash] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup
[02-23-2016 :: 20:36:24] [Crash] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 74693744)
[02-23-2016 :: 20:36:24] [Crash] 74693744 (KERNEL32): (filename not available): BaseThreadInitThunk
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77039E54)
[02-23-2016 :: 20:36:24] [Crash] 77039E54 (ntdll): (filename not available): RtlSetCurrentTransaction
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77039E1F)
[02-23-2016 :: 20:36:24] [Crash] 77039E1F (ntdll): (filename not available): RtlSetCurrentTransaction

ionhsmith 02-29-2016 03:56 PM
Hey Uleat ... have you had a chance to look at this anymore? Anything else I can contribute to helping figure this issues out for people?

Uleat 02-29-2016 06:55 PM
https://github.com/EQEmu/Server/blob.../bot.cpp#L3880


It's still too vague to determine what the actual cause is.

Group is taken from the bot owner - who should be leader in that case.

And the code that follows can only be accessed if the conditions that appear to lead to the crash are true. (The access of 'g->GetLeader()->GetID()' would crash if 'g' or
'GetLeader()' were nullptr..but, they're not. They could have been recently deleted..but, that type of diagnosis requires a hands-on testing.)

ponyboy_nd32 05-14-2016 11:39 AM
I was running into this same issue, however I did not receive a crash or anything when I zoned or died. The bots would simply despawn and I would have to respawn them.

After some investigation, I was able to fix the zoning issue by commenting out the the Depop(); line in:

https://github.com/EQEmu/Server/blob.../bot.cpp#L6960



I was also able to prevent my bots from despawning when I die with a couple other changes. Now when I die, my bots do not despawn but instead my group gets disbanded and my bots zone to my bind spot with me.

What I would like to happen is that when I die my bots stay where they are and continue to fight until they die also or better yet win. That way when I die they could Rez me to where we they are (assuming they didn't die also) and I wouldn't have to run back. I'm not sure if this is possible since looking at the code it seems that anytime the client zones the bots zone along with them.

Uleat 07-12-2016 10:22 PM
Not sure if this is relevant to this thread..

..but, I pushed a fix for a database-related issue that may solve client crashing when zoning with bots, for some people.


For some reason, the view in the database was causing serious hang and delaying zone boot-up - causing the client to disconnect after a few minutes.

This fix is not very elegant..but, is much faster than using the view for affected systems.

c0ncrete 07-14-2016 04:27 PM
I made some modifications to the source a long time ago that allowed a group leader to invite any group member's bots. If there is interest, I'll see if I can find it, test it with the current source, and post a patch here.

DanCanDo 07-15-2016 05:11 PM
Quote:
Originally Posted by c0ncrete (Post 249981)
I made some modifications to the source a long time ago that allowed a group leader to invite any group member's bots. If there is interest, I'll see if I can find it, test it with the current source, and post a patch here.
That would be an interest in my world (chuckle)

c0ncrete 07-16-2016 01:44 AM
affirmative. i'll fetch the old laptop out of storage and see what i can find. even if i'm unable, i think the alteration wasn't too difficult. it's been a long time since i've poked around in there, but i should be able to duplicate it without too much effort.

Random Gamer 02-13-2017 02:11 AM
I added logging to the Bot::Depop() It doesn't trigger when the bots are vanishing.

Bots basically only fudge up, when a party member zones into the zone, (Does not call Bot::Depop() yet bots vanish) or if the main toon zones in after other players. Bots go non-responsive, basically drop group, but not visually updated on client side.

So, what ever re-groups the players, when zoning, with bots is what is broken.


All times are GMT -4. The time now is 01:45 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.