We are running SQL two node active-active cluster. Since yester day It failed over because of â'BPool::map: No remappable address foundâ' error.
Did some one face the problem? As this is a critical server, we need to fix the same at the earliest. Your valuable input is required.
Is this because of low memory or is it a bug'
( Sql Instance is running with 8GB memory and total OS memory is 15GB)
Following is the part of Logs before fail over:
Todays log:
2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234 Free=1498 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=949, Other=814174
2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835036
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20 TotalPages=204 InUsePages=202
2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS Reserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068 Locks=112941
SQLCache=82 Replication=2
LockBytes=2 ServerGlobal=44
Xact=42
2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7 Maximum=89476 Available=0
2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226 Free=1506 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=948, Other=814175
2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835028
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20 TotalPages=204 InUsePages=202
2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS Reserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
Yesterday log:
2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002 Free=1171 Procedures=174
2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002 Free=1171 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5 Waiting=10 Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5 Waiting=10 Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003 Free=1170 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835621
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74I would contact PSS about this one
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a
I can't recall seeing this before but it sounds like there may be an issue
with AWE. Do you have both /3GB and /PAE enabled or just /PAE in boot.ini ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hemant" <anonymous@.discussions.microsoft.com> wrote in message
news:2F94E672-07F4-4554-9D0D-BC2F7CC3E164@.microsoft.com...
> We are running SQL two node active-active cluster. Since yester day It
failed over because of "BPool::map: No remappable address found" error.
> Did some one face the problem? As this is a critical server, we need to
fix the same at the earliest. Your valuable input is required.
> Is this because of low memory or is it a bug'
> ( Sql Instance is running with 8GB memory and total OS memory is 15GB)
> Following is the part of Logs before fail over:
> Todays log:
>
> 2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234
Free=1498 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=949, Other=814174
> 2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835036
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> 2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068
Locks=112941
> SQLCache=82 Replication=2
> LockBytes=2 ServerGlobal=44
> Xact=42
> 2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7
Maximum=89476 Available=0
> 2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226
Free=1506 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=948, Other=814175
> 2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835028
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> Yesterday log:
> 2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> 2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003
Free=1170 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835621
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
>
Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts
Tuesday, March 27, 2012
ERROR: BPool::map: No remappable address
We are running SQL two node active-active cluster. Since yester day It faile
d over because of “BPool::map: No remappable address found” error.
Did some one face the problem? As this is a critical server, we need to fi
x the same at the earliest. Your valuable input is required.
Is this because of low memory or is it a bug'
( Sql Instance is running with 8GB memory and total OS memory is 15GB)
Following is the part of Logs before fail over:
Todays log:
2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234 Free=14
98 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=949, Other=814174
2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835036
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068 Locks
=112941
SQLCache=82 Replication=2
LockBytes=2 ServerGlobal=44
Xact=42
2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7 M
aximum=89476 Available=0
2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226 Free=15
06 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=948, Other=814175
2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835028
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
Yesterday log:
2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003 Free=11
70 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835621
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74I would contact PSS about this one
http://support.microsoft.com/defaul...us;Prodoffer41a
I can't recall seeing this before but it sounds like there may be an issue
with AWE. Do you have both /3GB and /PAE enabled or just /PAE in boot.ini ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hemant" <anonymous@.discussions.microsoft.com> wrote in message
news:2F94E672-07F4-4554-9D0D-BC2F7CC3E164@.microsoft.com...
> We are running SQL two node active-active cluster. Since yester day It
failed over because of "BPool::map: No remappable address found" error.
> Did some one face the problem? As this is a critical server, we need to
fix the same at the earliest. Your valuable input is required.
> Is this because of low memory or is it a bug'
> ( Sql Instance is running with 8GB memory and total OS memory is 15GB)
> Following is the part of Logs before fail over:
> Todays log:
>
> 2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234
Free=1498 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=949, Other=814174
> 2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835036
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> 2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068
Locks=112941
> SQLCache=82 Replication=2
> LockBytes=2 ServerGlobal=44
> Xact=42
> 2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7
Maximum=89476 Available=0
> 2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226
Free=1506 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=948, Other=814175
> 2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835028
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> Yesterday log:
> 2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> 2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003
Free=1170 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835621
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
>
d over because of “BPool::map: No remappable address found” error.
Did some one face the problem? As this is a critical server, we need to fi
x the same at the earliest. Your valuable input is required.
Is this because of low memory or is it a bug'
( Sql Instance is running with 8GB memory and total OS memory is 15GB)
Following is the part of Logs before fail over:
Todays log:
2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234 Free=14
98 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=949, Other=814174
2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835036
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068 Locks
=112941
SQLCache=82 Replication=2
LockBytes=2 ServerGlobal=44
Xact=42
2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7 M
aximum=89476 Available=0
2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226 Free=15
06 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=948, Other=814175
2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835028
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
Yesterday log:
2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003 Free=11
70 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835621
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74I would contact PSS about this one
http://support.microsoft.com/defaul...us;Prodoffer41a
I can't recall seeing this before but it sounds like there may be an issue
with AWE. Do you have both /3GB and /PAE enabled or just /PAE in boot.ini ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hemant" <anonymous@.discussions.microsoft.com> wrote in message
news:2F94E672-07F4-4554-9D0D-BC2F7CC3E164@.microsoft.com...
> We are running SQL two node active-active cluster. Since yester day It
failed over because of "BPool::map: No remappable address found" error.
> Did some one face the problem? As this is a critical server, we need to
fix the same at the earliest. Your valuable input is required.
> Is this because of low memory or is it a bug'
> ( Sql Instance is running with 8GB memory and total OS memory is 15GB)
> Following is the part of Logs before fail over:
> Todays log:
>
> 2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234
Free=1498 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=949, Other=814174
> 2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835036
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> 2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068
Locks=112941
> SQLCache=82 Replication=2
> LockBytes=2 ServerGlobal=44
> Xact=42
> 2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7
Maximum=89476 Available=0
> 2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226
Free=1506 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=948, Other=814175
> 2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835028
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> Yesterday log:
> 2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> 2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003
Free=1170 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835621
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
>
Monday, March 26, 2012
Error: 66030
Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
>> Hi,
>> On one of our SQL 2000 cluster servers we have been
>> getting a lot of error messages in our SQL Server log
ile.
>> Error: 66030, Severity: 15, State: 1
>> Occasionally it also reports
>> Error: 66040, Severity: 15, State: 1.
>> I have been unable to find any information on these
error
>> messages. I would be grateful if someone could shed
some
>> light on what these messages actually mean. Thanks.
>
>.
>sql
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
>> Hi,
>> On one of our SQL 2000 cluster servers we have been
>> getting a lot of error messages in our SQL Server log
ile.
>> Error: 66030, Severity: 15, State: 1
>> Occasionally it also reports
>> Error: 66040, Severity: 15, State: 1.
>> I have been unable to find any information on these
error
>> messages. I would be grateful if someone could shed
some
>> light on what these messages actually mean. Thanks.
>
>.
>sql
Error: 66030
Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some[vbcol=seagreen]
>
>.
>
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some[vbcol=seagreen]
>
>.
>
Error: 66030
Hi,
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.
The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>
|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some
>
>.
>
On one of our SQL 2000 cluster servers we have been
getting a lot of error messages in our SQL Server log ile.
Error: 66030, Severity: 15, State: 1
Occasionally it also reports
Error: 66040, Severity: 15, State: 1.
I have been unable to find any information on these error
messages. I would be grateful if someone could shed some
light on what these messages actually mean. Thanks.
The fact that the error number is > 50000 suggests that this actually an
application specific error message rather than a generic SQL message. Have a
look in master..sysmessages to see the text of the message, it might give
you a clue
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"PaulaC" <anonymous@.discussions.microsoft.com> wrote in message
news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
> Hi,
> On one of our SQL 2000 cluster servers we have been
> getting a lot of error messages in our SQL Server log ile.
> Error: 66030, Severity: 15, State: 1
> Occasionally it also reports
> Error: 66040, Severity: 15, State: 1.
> I have been unable to find any information on these error
> messages. I would be grateful if someone could shed some
> light on what these messages actually mean. Thanks.
>
|||Thanks for the suggestion. Unfortunately, I cannot find
anything like my error messages in sysmessages.
Paula.
>--Original Message--
>The fact that the error number is > 50000 suggests that
this actually an
>application specific error message rather than a generic
SQL message. Have a
>look in master..sysmessages to see the text of the
message, it might give
>you a clue
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"PaulaC" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:bdac01c4380c$671e2b90$a501280a@.phx.gbl...
ile.[vbcol=seagreen]
error[vbcol=seagreen]
some
>
>.
>
Error: 605, Severity: 21, State: 1
Environment:
SQL SERVER 2000 sp3 with security patch 818
Cluster environment: active-passive
HP running Windows 2003 with patches
Situation:
A stored procedure is running along with several other BCP
running.
I truned on DBCC TRACEON (818 -1)
I would like help with this error:
ERROR:
DATE/TIME: 10/1/2003 10:16:52 AM
DESCRIPTION: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:3360903) in
database 'WaveAggDetach' belongs to
object 'aggTradePlanVolume', not to
object 'aggTradePlanVolumeInvoiced'.
COMMENT: (None)
JOB RUN: (None)Does the database come out clean from a DBCC CHECKDB?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Katherine" <kphelps@.oceanspray.com> wrote in message news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>|||Does the stored procedure contain a cursor..?
If so try changing the cursor type to INSESNSITIVE.
Have a look at :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q156662
--
HTH
Ryan Waight, MCDBA, MCSE
"Katherine" <kphelps@.oceanspray.com> wrote in message
news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>
SQL SERVER 2000 sp3 with security patch 818
Cluster environment: active-passive
HP running Windows 2003 with patches
Situation:
A stored procedure is running along with several other BCP
running.
I truned on DBCC TRACEON (818 -1)
I would like help with this error:
ERROR:
DATE/TIME: 10/1/2003 10:16:52 AM
DESCRIPTION: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:3360903) in
database 'WaveAggDetach' belongs to
object 'aggTradePlanVolume', not to
object 'aggTradePlanVolumeInvoiced'.
COMMENT: (None)
JOB RUN: (None)Does the database come out clean from a DBCC CHECKDB?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Katherine" <kphelps@.oceanspray.com> wrote in message news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>|||Does the stored procedure contain a cursor..?
If so try changing the cursor type to INSESNSITIVE.
Have a look at :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q156662
--
HTH
Ryan Waight, MCDBA, MCSE
"Katherine" <kphelps@.oceanspray.com> wrote in message
news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>
Subscribe to:
Posts (Atom)