 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / August 2006Full Text is locking up
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?  SignatureHilary 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 > Howdy, > [quoted text clipped - 28 lines] > 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 > Upgrade to SP1. Are you only getting the message from SQL.HDR when you dump > your transaction logs? [quoted text clipped - 34 lines] > > 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. SignatureHilary 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 > Hilary, > [quoted text clipped - 61 lines] >> > 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 > Yes, SP 1 for SQL Server has been released. > [quoted text clipped - 66 lines] > >> > 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 SignatureHilary 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 >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. SignatureHilary 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 > Do you mean: > [quoted text clipped - 3 lines] > > *** Sent via Developersdex http://www.developersdex.com *** |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.