Error 80070006

Hello everyone,
I have a large table (around 15m rows) I'm trying to Full-Text index using
the Japanese wordbreaker.
When I do a full process, after processing 3-4 million rows, I see a couple
of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather
Log, followed by many many c0000005 records in the log.
At that point, the MSSearch service is still running, but if I try to shut
it down using the sql server service manager or the windows tasks control
panel, it hangs while stopping. I have to kill it using the task manager
process panel.
I tried applying SP4 and recreating the catalog, but I have the same problem.
Any suggestions?
Regards,
Jonathan
does this apply -
http://support.microsoft.com/default...b;en-us;298794
Hilary Cotter
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
"Jonathan Levine" <myfoo2@.nospam.nospam> wrote in message
news:23546C67-AAE7-43AB-B435-C255BB43CF0B@.microsoft.com...
> Hello everyone,
> I have a large table (around 15m rows) I'm trying to Full-Text index using
> the Japanese wordbreaker.
> When I do a full process, after processing 3-4 million rows, I see a
couple
> of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather
> Log, followed by many many c0000005 records in the log.
> At that point, the MSSearch service is still running, but if I try to shut
> it down using the sql server service manager or the windows tasks control
> panel, it hangs while stopping. I have to kill it using the task manager
> process panel.
> I tried applying SP4 and recreating the catalog, but I have the same
problem.
> Any suggestions?
> Regards,
> Jonathan
|||Hilary,
Thanks very much for your reply.
"Hilary Cotter" wrote:
> does this apply -
> http://support.microsoft.com/default...b;en-us;298794
I don't think so. I have increased MaxPropStoreCacheSize gradually to 0x0460.
Regards,
Jonathan
|||This is possibly a buffer overrun. How are you storing your data? Is it in
char, varchar, text or image? If Image what is your document format?
Hilary Cotter
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
"Jonathan Levine" <myfoo2@.nospam.nospam> wrote in message
news:23546C67-AAE7-43AB-B435-C255BB43CF0B@.microsoft.com...
> Hello everyone,
> I have a large table (around 15m rows) I'm trying to Full-Text index using
> the Japanese wordbreaker.
> When I do a full process, after processing 3-4 million rows, I see a
couple
> of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather
> Log, followed by many many c0000005 records in the log.
> At that point, the MSSearch service is still running, but if I try to shut
> it down using the sql server service manager or the windows tasks control
> panel, it hangs while stopping. I have to kill it using the task manager
> process panel.
> I tried applying SP4 and recreating the catalog, but I have the same
problem.
> Any suggestions?
> Regards,
> Jonathan
|||Hi again Hilary,
"Hilary Cotter" wrote:
> This is possibly a buffer overrun. How are you storing your data? Is it in
> char, varchar, text or image? If Image what is your document format?
>
Buffer overrun sounds likely to me.
The data is in two columns: one big nvarchar, and an ntext.
It is Japanese text from web pages (the web pages have been stripped of HTML
tags).
Regards,
Jonathan
|||just out of curiosity, do you get the problem when you index the content
with the neutral word breaker?
Hilary Cotter
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
"Jonathan Levine" <myfoo2@.nospam.nospam> wrote in message
news:21043DBE-5885-41FC-A68B-462A7A6DEA47@.microsoft.com...
> Hi again Hilary,
>
> "Hilary Cotter" wrote:
> Buffer overrun sounds likely to me.
> The data is in two columns: one big nvarchar, and an ntext.
> It is Japanese text from web pages (the web pages have been stripped of
> HTML
> tags).
> Regards,
> Jonathan
>
|||Hilary,
"Hilary Cotter" wrote:
> just out of curiosity, do you get the problem when you index the content
> with the neutral word breaker?
>
I haven't tried the neutral word breaker. The neutral word breaker doesn't
handle Japanese text very well: most Japanese is written without whitespace
between the words, so I don't think the neutral word breaker index would be
very useful even if it worked.
Jonathan
|||I realize you are loosing the language capabilities you need - however if it
works using the neutral word breaker the problem is with the Japanese word
breaker and you can raise this as a bug with MS. If it fails with the
neutral word breaker something is wrong with your environment which might be
solved with a reapplication of the service pack, or by removing and
reinstalling SQL FTS.
Hilary Cotter
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
"Jonathan Levine" <myfoo2@.nospam.nospam> wrote in message
news:51A6B6D7-D439-4351-B619-D8645494DDF5@.microsoft.com...
> Hilary,
> "Hilary Cotter" wrote:
> I haven't tried the neutral word breaker. The neutral word breaker
doesn't
> handle Japanese text very well: most Japanese is written without
whitespace
> between the words, so I don't think the neutral word breaker index would
be
> very useful even if it worked.
> Jonathan
|||"Hilary Cotter" wrote:
> I realize you are loosing the language capabilities you need - however if it
> works using the neutral word breaker the problem is with the Japanese word
> breaker and you can raise this as a bug with MS. If it fails with the
> neutral word breaker something is wrong with your environment which might be
> solved with a reapplication of the service pack, or by removing and
> reinstalling SQL FTS.
Hilary,
Your instincts were right on. The problem was in the Windows 2003
wordbreaker -- upgrading to SP1 fixed the problem. (see KB article 885899)
Thanks for your help!
Jonathan
http://kerblog.com/earlyedition/arch...05/27/460.aspx