Faulting application sqlservr.exe, version 2007.100.4000.0, time stamp 0x4c935741, faulting module PGNP64.dll, version 1.3.0.2251, time stamp 0x4e6e25ae, exception code 0xc0000409, fault offset 0x0000000000230ec6, process id 0xf08, application start time 0x01ccf63034b3db42.
I've been using PGNP successfully for a few months now without any issues, however today running a simple query is crashing SQL Server as noted above. The query in question is very simple:
- Code: Select all
USE *database*
SET XACT_ABORT ON
BEGIN TRAN
DECLARE @rate_centers TABLE (
cache_id INT NOT NULL PRIMARY KEY IDENTITY(1,1),
lineclasscode1 VARCHAR(255),
lcg_rate_center_id INT
)
INSERT INTO @rate_centers (
lineclasscode1,
lcg_rate_center_id
)
SELECT
d.switch_value,
d.lcg_rate_center_id
FROM
OPENQUERY(BBI, '
SELECT
ms.switch_value,
lc.lcg_rate_center_id
FROM
metaswitch_rate_centers AS ms,
lcg_rate_centers AS lc,
lcg_rate_center_metaswitch_rate_center_mapping AS ma
WHERE
lc.lcg_rate_center_id = ma.lcg_rate_center_id
AND ms.rate_center_id = ma.ms_rate_center_id
') AS d
ROLLBACK TRAN
The 'BBI' Linked Server is configured with the following options:
- Code: Select all
EXEC master.dbo.sp_addlinkedserver @server = N'BBI', @srvproduct=N'PGNP', @provider=N'PGNP', @datasrc=N'*server*', @catalog=N'*database*'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'BBI',@useself=N'False',@locallogin=NULL,@rmtuser=N'*username*',@rmtpassword='*password*'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'BBI', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO
And the PGNP provider is configured with:
- Dynamic Parameter
Nested Queries
Allow inprocess
Supports 'Like' operator
And is connecting to a Postgres 8.4.2 server.
Any ideas? I'm planning a full reboot of the server later and some more testing to try and narrow things down, however I can't do any testing during the day.
