none
sql server 2008中的错误 30059 RRS feed

  • 问题

  • 我们的sql server经常会有mssqlserver 30059错误

    Event Type:    Error
    Event Source:    MSSQLSERVER
    Event Category:    Server
    Event ID:    30059
    Date:        4/19/2010
    Time:        3:06:06 AM
    User:        N/A
    Computer:    NMS
    Description:
    A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is abc.com (id: 10); catalog name is abc_com_full_text (id: 5); table name news (id: 978102525). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    Data:
    0000: 6b 75 00 00 10 00 00 00   ku......
    0008: 04 00 00 00 4e 00 4d 00   ....N.M.
    0010: 53 00 00 00 07 00 00 00   S.......
    0018: 6d 00 61 00 73 00 74 00   m.a.s.t.
    0020: 65 00 72 00 00 00         e.r... 

    伴随而来的就是几个小时后这个数据库down掉。

     

    C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log下的sqlft0001000005.log文件发下很多类似错误:

    2010-04-19 08:42:43.02 spid19s     Informational: Resuming full-text population for table or indexed view '[abc.com].[dbo].[news]' in database 'abc.com' (table or indexed view ID '978102525', database ID '10'). Prior number of documents processed: 0, error encountered: 0.
    2010-04-19 08:42:43.12 spid19s     Informational: Resuming full-text population for table or indexed view '[abc.com].[dbo].[events]' in database 'abc.com' (table or indexed view ID '1042102753', database ID '10'). Prior number of documents processed: 0, error encountered: 0.
    2010-04-19 08:42:43.50 spid19s     Informational: Resuming full-text population for table or indexed view '[abc.com].[dbo].[content]' in database 'abc.com' (table or indexed view ID '1682105033', database ID '10'). Prior number of documents processed: 0, error encountered: 0.
    2010-04-19 08:44:19.89 spid13s     Informational: Full-text Full population completed for table or indexed view '[abc.com].[dbo].[news]' (table or indexed view ID '978102525', database ID '10'). Number of documents processed: 0. Number of documents failed: 0. Number of documents that will be retried: 0.
    2010-04-19 08:44:19.89 spid13s     Error: 30059, Severity: 16, State: 1.
    2010-04-19 08:44:19.89 spid13s     A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is abc.com (id: 10); catalog name is abc_com_full_text (id: 5); table name news (id: 978102525). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.
    2010-04-19 08:45:02.13 spid28s     Informational: Full-text Full population completed for table or indexed view '[abc.com].[dbo].[events]' (table or indexed view ID '1042102753', database ID '10'). Number of documents processed: 0. Number of documents failed: 0. Number of documents that will be retried: 0.
    2010-04-19 08:45:02.13 spid28s     Error: 30059, Severity: 16, State: 1.
    2010-04-19 08:45:02.13 spid28s     A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is abc.com (id: 10); catalog name is abc_com_full_text (id: 5); table name events (id: 1042102753). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.
    2010-04-19 08:46:38.30 spid27s     Informational: Full-text Full population completed for table or indexed view '[abc.com].[dbo].[content]' (table or indexed view ID '1682105033', database ID '10'). Number of documents processed: 0. Number of documents failed: 0. Number of documents that will be retried: 0.
    2010-04-19 08:46:38.30 spid27s     Error: 30059, Severity: 16, State: 1.
    2010-04-19 08:46:38.30 spid27s     A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is abc.com (id: 10); catalog name is abc_com_full_text (id: 5); table name content (id: 1682105033). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

    在网上搜了一下。好像解决方法就是更改sql full-text filter daemon launcher的账号。

    有的说使用 SQL Server service account账号(不太清楚这个账户是什么 账号),有的说是用Local System account, 到底用哪一个呢。

    我们的sql server (mssqlserver), sql serve agent, sql server analysis services, sql server integration service, sql server vss writer都是用的是local system, sql active directory helper service用的是nt authority\network service登陆, sql server reporting services 用的是我们域的一个管理员账号登陆,full-text f filter用的是nt-authority\local service登陆。

     

    请指教!

    还有,如果是使用 SQL Server service account账号,到底是指那一个账号呢。

     

    谢谢。

     

    2010年4月19日 13:44

答案

  • http://technet.microsoft.com/zh-cn/library/cc645727%28SQL.105%29.aspx

     

    请修复全文爬网日志中记录的错误。然后恢复填充。用于恢复填充的基本 Transact-SQL 语法为: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION。

     

    2010年4月19日 15:04
  • Sql service account is the account to run sql service, you can find and change it in sql configure manager. Yes, better to run sql and full text index service with same account. Or you can add full text index service account to sysadmin role in sql. In your case, change full text index service accout to local system.
    2010年4月19日 15:50

全部回复

  • http://technet.microsoft.com/zh-cn/library/cc645727%28SQL.105%29.aspx

     

    请修复全文爬网日志中记录的错误。然后恢复填充。用于恢复填充的基本 Transact-SQL 语法为: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION。

     

    2010年4月19日 15:04
  • Sql service account is the account to run sql service, you can find and change it in sql configure manager. Yes, better to run sql and full text index service with same account. Or you can add full text index service account to sysadmin role in sql. In your case, change full text index service accout to local system.
    2010年4月19日 15:50
  • 谢谢啊!我去试试看!
    2010年4月19日 15:59
  • 谢谢。我去琢磨琢磨看!!
    2010年4月19日 16:00