sqlserver 2017 replication EXCEPTION_ACCESS_VIOLATION sp_replcmds

anky chen 0 Reputation points
2025-08-12T13:50:51.0933333+00:00

Hello, we have been running in the SQL Server 2017 version database for many years. We used replication to synchronize to another database. But suddenly one day we encountered the following issues, which caused the primary database to be unable to synchronize using the publish-subscribe method. Even reinstalling the software does not resolve the problem; we still encounter the same issue. It reports a memory access violation.please help,ths!

你好,我们在sqlserver2017 版本的数据库中,运行了好多年。采用复制的方式,同步到另一个库。但忽然有一天忽然报以下内容,导致主库无法使用发布订阅的方式同步。即使软件重装之类都不行,还是会遇到一样的问题。报内存访问冲突。请帮忙,谢谢

2024-06-17 12:32:12.55 spid145 CImageHelper::Init () Failed load of symbol file with path = C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn;C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\BINN Error Code 0xc0000004

2024-06-17 13:18:46.62 spid145 CImageHelper::Init () Failed load of symbol file with path = C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn;C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\BINN Error Code 0xc0000004

2024-06-17 13:20:22.50 spid515 ***Stack Dump being sent to E:\MSSQL14.MSSQLSERVER\MSSQL\LOG\SQLDump0013.txt

2024-06-17 13:20:22.50 spid515 SqlDumpExceptionHandler: Process 515 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

2024-06-17 13:20:22.50 spid515 * *******************************************************************************

2024-06-17 13:20:22.50 spid515 *

2024-06-17 13:20:22.50 spid515 * BEGIN STACK DUMP:

2024-06-17 13:20:22.50 spid515 * 06/17/24 13:20:22 spid 515

2024-06-17 13:20:22.50 spid515 *

2024-06-17 13:20:22.50 spid515 *

2024-06-17 13:20:22.50 spid515 * Exception Address = 00007FFFAB28CE2F Module(sqlmin+00000000000CCE2F)

2024-06-17 13:20:22.50 spid515 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

2024-06-17 13:20:22.50 spid515 * Access Violation occurred reading address 000000000000002A

2024-06-17 13:20:22.50 spid515 * Input Buffer 109 bytes -

2024-06-17 13:20:22.50 spid515 * 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00

2024-06-17 13:20:22.50 spid515 * s p _ r e p 01 00 00 00 0b 00 73 00 70 00 5f 00 72 00 65 00 70 00

2024-06-17 13:20:22.50 spid515 * l c m d s & Ð 6c 00 63 00 6d 00 64 00 73 00 00 00 00 00 26 04 04 d0

2024-06-17 13:20:22.50 spid515 * & & ÿ 07 00 00 00 00 26 04 04 00 00 00 00 00 00 26 04 04 ff

2024-06-17 13:20:22.50 spid515 * ÿÿÿ ¥ & è ff ff ff 00 00 a5 0a 00 00 00 00 00 26 04 04 e8 03 00

2024-06-17 13:20:22.50 spid515 * & & ¡ 00 00 00 26 04 04 00 00 00 00 00 00 26 04 04 20 a1 07

2024-06-17 13:20:22.50 spid515 * 00

SQL Server Database Engine
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.