| Groups | Blog | Home |
sql server full text search : Full Text is locking up
We have a SQL 2005 std server running on Windows 2003. We are having an issue where it looks like the full text service is locking up. In the activity monitor we will start to see processes waiting on MSSEARCH. The processes will continue to wait until I stop the SQL Server FullText Search Service. The service does not stop nicely either. When you attempt to stop it, it will hang and say it is stopping. This will stay in the stopping state until I restart the sql server process its self, or kill the msftesql.exe process manually. I have seen the activity monitor processes hang for our VB 6 app, doing a database backup through a maintenance plan, and dropping old databases. In the error log, I see several “Error: 3633, Severity: 16, State: 1†messages as well as “The operating system returned the error ‘32(The process cannot access the file because it is being used by another process.)’ while attempting ‘CreateFile’ on ‘d:\mssql\ftdata\radiology0000\sql.hdr’ at ‘fulltext.cpp’(529). I am new to supporting sql server and have had a hard time finding information about this error on the internet. Thank you for any help you can provide. Keith Sirmons
Hilary,
Windows is already at SP1. Has a SP been released for SQL 2005 yet? My sql version is 9.0.1399 The time stamps for the sql.hdr errors do look to correlate with the transaction log backups. EXECUTE master.dbo.xp_sqlmaint N'-PlanID 5C950084-E7F8-436E-AD81-3FCBE7CD910E -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -BkExt "TRN"' How can I tell where it is hanging? When I start the FullText service I can normally stop it with out any problems after just a few minutes, but if I wait too long, I will not be able to stop the service without killing the msftesql.exe process. Thank you, Keith [quoted text, click to view] "Hilary Cotter" wrote:
> Upgrade to SP1. Are you only getting the message from SQL.HDR when you dump > your transaction logs? > > Regarding the hanging - exactly where is it hanging? Does it hang during the > population process or at other times? > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message > news:42BA10C2-30BC-4878-900A-11CDA6E308D4@microsoft.com... > > Howdy, > > > > We have a SQL 2005 std server running on Windows 2003. > > We are having an issue where it looks like the full text service is > > locking > > up. In the activity monitor we will start to see processes waiting on > > MSSEARCH. The processes will continue to wait until I stop the SQL Server > > FullText Search Service. > > > > The service does not stop nicely either. When you attempt to stop it, it > > will hang and say it is stopping. This will stay in the stopping state > > until > > I restart the sql server process its self, or kill the msftesql.exe > > process > > manually. > > > > I have seen the activity monitor processes hang for our VB 6 app, doing a > > database backup through a maintenance plan, and dropping old databases. > > > > In the error log, I see several "Error: 3633, Severity: 16, State: 1" > > messages as well as "The operating system returned the error '32(The > > process > > cannot access the file because it is being used by another process.)' > > while > > attempting 'CreateFile' on 'd:\mssql\ftdata\radiology0000\sql.hdr' at > > 'fulltext.cpp'(529). > > > > I am new to supporting sql server and have had a hard time finding > > information about this error on the internet. > > > > Thank you for any help you can provide. > > Keith Sirmons > > > >
Upgrade to SP1. Are you only getting the message from SQL.HDR when you dump
your transaction logs? Regarding the hanging - exactly where is it hanging? Does it hang during the population process or at other times? -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message news:42BA10C2-30BC-4878-900A-11CDA6E308D4@microsoft.com... > Howdy, > > We have a SQL 2005 std server running on Windows 2003. > We are having an issue where it looks like the full text service is > locking > up. In the activity monitor we will start to see processes waiting on > MSSEARCH. The processes will continue to wait until I stop the SQL Server > FullText Search Service. > > The service does not stop nicely either. When you attempt to stop it, it > will hang and say it is stopping. This will stay in the stopping state > until > I restart the sql server process its self, or kill the msftesql.exe > process > manually. > > I have seen the activity monitor processes hang for our VB 6 app, doing a > database backup through a maintenance plan, and dropping old databases. > > In the error log, I see several "Error: 3633, Severity: 16, State: 1" > messages as well as "The operating system returned the error '32(The > process > cannot access the file because it is being used by another process.)' > while > attempting 'CreateFile' on 'd:\mssql\ftdata\radiology0000\sql.hdr' at > 'fulltext.cpp'(529). > > I am new to supporting sql server and have had a hard time finding > information about this error on the internet. > > Thank you for any help you can provide. > Keith Sirmons >
Yes, SP 1 for SQL Server has been released.
Its hard to say, I would capture everything using profiler and then run the statements individually through query analyzer. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message news:E9A83B28-C925-4E52-A462-D4C358E3E105@microsoft.com... > Hilary, > > Windows is already at SP1. Has a SP been released for SQL 2005 yet? My > sql > version is 9.0.1399 > > The time stamps for the sql.hdr errors do look to correlate with the > transaction log backups. > > EXECUTE master.dbo.xp_sqlmaint N'-PlanID > 5C950084-E7F8-436E-AD81-3FCBE7CD910E -WriteHistory -VrfyBackup -BkUpMedia > DISK -BkUpLog -UseDefDir -BkExt "TRN"' > > How can I tell where it is hanging? When I start the FullText service I > can > normally stop it with out any problems after just a few minutes, but if I > wait too long, I will not be able to stop the service without killing the > msftesql.exe process. > > Thank you, > Keith > > > "Hilary Cotter" wrote: > >> Upgrade to SP1. Are you only getting the message from SQL.HDR when you >> dump >> your transaction logs? >> >> Regarding the hanging - exactly where is it hanging? Does it hang during >> the >> population process or at other times? >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message >> news:42BA10C2-30BC-4878-900A-11CDA6E308D4@microsoft.com... >> > Howdy, >> > >> > We have a SQL 2005 std server running on Windows 2003. >> > We are having an issue where it looks like the full text service is >> > locking >> > up. In the activity monitor we will start to see processes waiting on >> > MSSEARCH. The processes will continue to wait until I stop the SQL >> > Server >> > FullText Search Service. >> > >> > The service does not stop nicely either. When you attempt to stop it, >> > it >> > will hang and say it is stopping. This will stay in the stopping state >> > until >> > I restart the sql server process its self, or kill the msftesql.exe >> > process >> > manually. >> > >> > I have seen the activity monitor processes hang for our VB 6 app, doing >> > a >> > database backup through a maintenance plan, and dropping old databases. >> > >> > In the error log, I see several "Error: 3633, Severity: 16, State: 1" >> > messages as well as "The operating system returned the error '32(The >> > process >> > cannot access the file because it is being used by another process.)' >> > while >> > attempting 'CreateFile' on 'd:\mssql\ftdata\radiology0000\sql.hdr' at >> > 'fulltext.cpp'(529). >> > >> > I am new to supporting sql server and have had a hard time finding >> > information about this error on the internet. >> > >> > Thank you for any help you can provide. >> > Keith Sirmons >> > >> >> >>
Thank you,
Installing SP1 for sql did fix our issues. Thank you for your help. Keith [quoted text, click to view] "Hilary Cotter" wrote:
> Yes, SP 1 for SQL Server has been released. > > Its hard to say, I would capture everything using profiler and then run the > statements individually through query analyzer. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message > news:E9A83B28-C925-4E52-A462-D4C358E3E105@microsoft.com... > > Hilary, > > > > Windows is already at SP1. Has a SP been released for SQL 2005 yet? My > > sql > > version is 9.0.1399 > > > > The time stamps for the sql.hdr errors do look to correlate with the > > transaction log backups. > > > > EXECUTE master.dbo.xp_sqlmaint N'-PlanID > > 5C950084-E7F8-436E-AD81-3FCBE7CD910E -WriteHistory -VrfyBackup -BkUpMedia > > DISK -BkUpLog -UseDefDir -BkExt "TRN"' > > > > How can I tell where it is hanging? When I start the FullText service I > > can > > normally stop it with out any problems after just a few minutes, but if I > > wait too long, I will not be able to stop the service without killing the > > msftesql.exe process. > > > > Thank you, > > Keith > > > > > > "Hilary Cotter" wrote: > > > >> Upgrade to SP1. Are you only getting the message from SQL.HDR when you > >> dump > >> your transaction logs? > >> > >> Regarding the hanging - exactly where is it hanging? Does it hang during > >> the > >> population process or at other times? > >> > >> -- > >> Hilary Cotter > >> Director of Text Mining and Database Strategy > >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > >> > >> This posting is my own and doesn't necessarily represent RelevantNoise's > >> positions, strategies or opinions. > >> > >> Looking for a SQL Server replication book? > >> http://www.nwsu.com/0974973602.html > >> > >> Looking for a FAQ on Indexing Services/SQL FTS > >> http://www.indexserverfaq.com > >> > >> > >> > >> "Keith Sirmons" <KeithSirmons@discussions.microsoft.com> wrote in message > >> news:42BA10C2-30BC-4878-900A-11CDA6E308D4@microsoft.com... > >> > Howdy, > >> > > >> > We have a SQL 2005 std server running on Windows 2003. > >> > We are having an issue where it looks like the full text service is > >> > locking > >> > up. In the activity monitor we will start to see processes waiting on > >> > MSSEARCH. The processes will continue to wait until I stop the SQL > >> > Server > >> > FullText Search Service. > >> > > >> > The service does not stop nicely either. When you attempt to stop it, > >> > it > >> > will hang and say it is stopping. This will stay in the stopping state > >> > until > >> > I restart the sql server process its self, or kill the msftesql.exe > >> > process > >> > manually. > >> > > >> > I have seen the activity monitor processes hang for our VB 6 app, doing > >> > a > >> > database backup through a maintenance plan, and dropping old databases. > >> > > >> > In the error log, I see several "Error: 3633, Severity: 16, State: 1" > >> > messages as well as "The operating system returned the error '32(The > >> > process > >> > cannot access the file because it is being used by another process.)' > >> > while > >> > attempting 'CreateFile' on 'd:\mssql\ftdata\radiology0000\sql.hdr' at > >> > 'fulltext.cpp'(529). > >> > > >> > I am new to supporting sql server and have had a hard time finding > >> > information about this error on the internet. > >> > > >> > Thank you for any help you can provide. > >> > Keith Sirmons > >> > > >> > >> > >> > >
I am also experiencing this issue. Unfortunately my server is already
on SP1 (windows and sql). Has any one experienced this issue and it wasn't fixed by SP1? Also, my server is a cluster. Could that be causing it?
Its unlikely that the cluster is causing the problem. You might want to set
the resource level to something smaller than 3, try sp_fulltext_service 'resource_level',2 -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Crystal Manson" <missismanson@yahoo.fr> wrote in message news:OtVAuXkxGHA.1288@TK2MSFTNGP03.phx.gbl... >I am also experiencing this issue. Unfortunately my server is already > on SP1 (windows and sql). Has any one experienced this issue and it > wasn't fixed by SP1? Also, my server is a cluster. Could that be > causing it? > > *** Sent via Developersdex http://www.developersdex.com ***
Do you mean:
sp_fulltext_service 'resource_usage',2 I do not see resource_level as an option.
Exactly, my mistake.
-- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Crystal Manson" <missismanson@yahoo.fr> wrote in message news:eIaZIWyxGHA.4092@TK2MSFTNGP04.phx.gbl... > Do you mean: > > sp_fulltext_service 'resource_usage',2 > > I do not see resource_level as an option. > > *** Sent via Developersdex http://www.developersdex.com ***
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |