Today when I was crawling my SharePoint， the crawler report there was an error during the crawling. But it didn't tell me what was wrong. It is really annoying. You can check your errors using the crawl log inside search admin. But as a "Geek" do we have something much more fun? After some research, I found this useful query.
select msscrawlurllog.lasttouchstart as Time, msscrawlurllog.displayurl as CrawlURL, msscrawlurllog.errorid as ErrorCode, msscrawlerrorlist.errormsg as ErrorDescription from msscrawlurllog inner join msscrawlerrorlist on msscrawlurllog.errorid = msscrawlerrorlist.errorid order by msscrawlurllog.lasttouchstart
Run this query against your SharedService Search Database. We can see all errors happen during the crawling as a real IT geek :D.
7afe302f-3a1b-4473-985b-440602d8926c|0|.0
Technology, Sharepoint
sharepoint search