Paused? I don't have no stinking time for pausing!

Ok, why are my indices all paused?
Ran out of diskspace the other day. Stopped the Service, moved the indices
to another drive (had a little problem with 1-2 of them which I believe I've
fixed.)
Have restarted, and every full text index on the machine, including one in a
different DB is in a paused state.
They have data and a search on them returns data.
But select fultextcatalogproperty('foo','populatestatus') returns 2.
What's up with that?
(This is on SQL 2000. Thankfully finally I'm moving off of SQL 7.0).
--
Greg D. Moore
President Green Mountain Software
Personal: http://stratton.greenms.com
MSSearch will pause for several reasons; low disk space; memory pressures,
or if you are running on battery power.
Use the gatherlog utility to see if it gives any more hints as to why they
are paused. You can find it in C:\Program Files\Common Files\MSSearch\Bin
and it is called gthrlog.vbs. Copy this file to %windir%\system32
Then open a command prompt and navigate to the C:\Program Files\Microsoft
SQL Server\MSSQL\FTData\SQLServer\Gatherlogs
then do a dir /od locate a recent log and do this
cscript.exe gthrlog.vbs SQL0000600005.1.gthr
Replacing SQL0000600005.1.gthr with the name of your log.
This should reveal more details as to why MSSearch is pausing.
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
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:Axfge.25950$ia6.18501@.twister.nyroc.rr.com...
> Ok, why are my indices all paused?
> Ran out of diskspace the other day. Stopped the Service, moved the
indices
> to another drive (had a little problem with 1-2 of them which I believe
I've
> fixed.)
> Have restarted, and every full text index on the machine, including one in
a
> different DB is in a paused state.
> They have data and a search on them returns data.
> But select fultextcatalogproperty('foo','populatestatus') returns 2.
> What's up with that?
> (This is on SQL 2000. Thankfully finally I'm moving off of SQL 7.0).
>
> --
> --
> Greg D. Moore
> President Green Mountain Software
> Personal: http://stratton.greenms.com
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O0yvusjVFHA.3176@.TK2MSFTNGP12.phx.gbl...
> MSSearch will pause for several reasons; low disk space; memory pressures,
> or if you are running on battery power.
> Use the gatherlog utility to see if it gives any more hints as to why they
> are paused. You can find it in C:\Program Files\Common Files\MSSearch\Bin
> and it is called gthrlog.vbs. Copy this file to %windir%\system32
> Then open a command prompt and navigate to the C:\Program Files\Microsoft
> SQL Server\MSSQL\FTData\SQLServer\Gatherlogs
> then do a dir /od locate a recent log and do this
> cscript.exe gthrlog.vbs SQL0000600005.1.gthr
> Replacing SQL0000600005.1.gthr with the name of your log.
>
Ok, to reduce the number of variables, I did this on the full text index in
a different database that I did not touch: (i.e. it's not due to me moving
stuff, etc...)
Results are:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
5/10/2005 11:22:04 AM Add The gatherer has started
5/10/2005 11:22:12 AM Add The recovery has completed
5/10/2005 11:38:52 AM Add The gatherer has started
5/10/2005 11:39:04 AM Add The recovery has completed
5/10/2005 12:13:52 PM Add The gatherer has started
5/10/2005 12:14:02 PM Add The recovery has completed
5/10/2005 1:28:02 PM Add The gatherer has started
5/10/2005 1:28:10 PM Add The recovery has completed
5/10/2005 2:03:02 PM Add The gatherer has started
5/10/2005 2:03:12 PM Add The recovery has completed
Yet, the index is still paused.
Just tried to STOP the population on this paused index.
The tail of the new gather file shows:
5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/00004418 Add
Error fe
tching URL, (80040d54 - The filtering has been aborted because of a user
action,
such as stopping the crawl. )
5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/00004c9a Add
Error fe
tching URL, (80040d54 - The filtering has been aborted because of a user
action,
such as stopping the crawl. )
5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/000043e6 Add
Error fe
tching URL, (80040d54 - The filtering has been aborted because of a user
action,
such as stopping the crawl. )
5/11/2005 5:59:14 PM Add Completed Incremental crawl
And the index still shows itself as paused.
Looking at a gather file on the index (which I did move) in the original DB:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
5/10/2005 11:22:04 AM Add The gatherer has started
5/10/2005 11:22:10 AM Add The initialization has completed
5/10/2005 11:38:52 AM Add The gatherer has started
5/10/2005 11:39:00 AM Add The initialization has completed
5/10/2005 12:13:52 PM Add The gatherer has started
5/10/2005 12:13:58 PM Add The initialization has completed
5/10/2005 1:28:02 PM Add The gatherer has started
5/10/2005 1:28:08 PM Add The initialization has completed
5/10/2005 2:03:02 PM Add The gatherer has started
5/10/2005 2:03:08 PM Add The initialization has completed
And
select fulltextcatalogproperty('foo_bar_1998','populatest atus') as
populatestatus , count(*) as '1998',
fulltextcatalogproperty('foo_bar_1998','itemcount' ) as itemcount,
fulltextcatalogproperty('foo_bar_1998','IndexSize' ) as IndexSize,
fulltextcatalogproperty('foo_bar_1998','UniqueKeyC ount') as
UniqueKeycount,fulltextcatalogproperty('foo_bar_19 98','Logsize') as
LogSize,fulltextcatalogproperty('foo_bar_1998','Po pulateCompletionAge') as
PopulateCompletionAge from foo_bar_1998 (nolock)
returns:
Populate status 1998 itemcount, indexssize, uniquekeycount,
logsize populatecompletionage
2 441 442 2
72004 328 482772780
Now, this index had been fully populated before any of these problems
happened, so it should be fine. (i.e. no reason to pause, etc.)
I'm bewildered at this point.
Any other thoughts. (I mean worse comes to worse I'll simply destroy the
indices and rebuild them, but then I'll lose a week or two of time waiting
for the larger ones.)

> This should reveal more details as to why MSSearch is pausing.
>
> --
> 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
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message[vbcol=seagreen]
> news:Axfge.25950$ia6.18501@.twister.nyroc.rr.com...
> indices
> I've
in
> a
>
|||I am not sure what you mean by restarted in your original post? Do you mean
a reboot? If not, I would reboot your server to see if this clears the
condition. It is baffling.
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
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:cnvge.26735$ia6.20761@.twister.nyroc.rr.com... [vbcol=seagreen]
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O0yvusjVFHA.3176@.TK2MSFTNGP12.phx.gbl...
pressures,[vbcol=seagreen]
they[vbcol=seagreen]
Files\MSSearch\Bin[vbcol=seagreen]
Files\Microsoft
> Ok, to reduce the number of variables, I did this on the full text index
in
> a different database that I did not touch: (i.e. it's not due to me moving
> stuff, etc...)
> Results are:
> Microsoft (R) Windows Script Host Version 5.6
> Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
> 5/10/2005 11:22:04 AM Add The gatherer has started
> 5/10/2005 11:22:12 AM Add The recovery has completed
> 5/10/2005 11:38:52 AM Add The gatherer has started
> 5/10/2005 11:39:04 AM Add The recovery has completed
> 5/10/2005 12:13:52 PM Add The gatherer has started
> 5/10/2005 12:14:02 PM Add The recovery has completed
> 5/10/2005 1:28:02 PM Add The gatherer has started
> 5/10/2005 1:28:10 PM Add The recovery has completed
> 5/10/2005 2:03:02 PM Add The gatherer has started
> 5/10/2005 2:03:12 PM Add The recovery has completed
>
> Yet, the index is still paused.
> Just tried to STOP the population on this paused index.
> The tail of the new gather file shows:
> 5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/00004418 Add
> Error fe
> tching URL, (80040d54 - The filtering has been aborted because of a user
> action,
> such as stopping the crawl. )
> 5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/00004c9a Add
> Error fe
> tching URL, (80040d54 - The filtering has been aborted because of a user
> action,
> such as stopping the crawl. )
> 5/11/2005 5:59:14 PM mssql75://sqlserver/2dffd964/000043e6 Add
> Error fe
> tching URL, (80040d54 - The filtering has been aborted because of a user
> action,
> such as stopping the crawl. )
> 5/11/2005 5:59:14 PM Add Completed Incremental crawl
> And the index still shows itself as paused.
>
> Looking at a gather file on the index (which I did move) in the original
DB:[vbcol=seagreen]
> Microsoft (R) Windows Script Host Version 5.6
> Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
> 5/10/2005 11:22:04 AM Add The gatherer has started
> 5/10/2005 11:22:10 AM Add The initialization has completed
> 5/10/2005 11:38:52 AM Add The gatherer has started
> 5/10/2005 11:39:00 AM Add The initialization has completed
> 5/10/2005 12:13:52 PM Add The gatherer has started
> 5/10/2005 12:13:58 PM Add The initialization has completed
> 5/10/2005 1:28:02 PM Add The gatherer has started
> 5/10/2005 1:28:08 PM Add The initialization has completed
> 5/10/2005 2:03:02 PM Add The gatherer has started
> 5/10/2005 2:03:08 PM Add The initialization has completed
> And
> select fulltextcatalogproperty('foo_bar_1998','populatest atus') as
> populatestatus , count(*) as '1998',
> fulltextcatalogproperty('foo_bar_1998','itemcount' ) as itemcount,
> fulltextcatalogproperty('foo_bar_1998','IndexSize' ) as IndexSize,
> fulltextcatalogproperty('foo_bar_1998','UniqueKeyC ount') as
> UniqueKeycount,fulltextcatalogproperty('foo_bar_19 98','Logsize') as
> LogSize,fulltextcatalogproperty('foo_bar_1998','Po pulateCompletionAge') as
> PopulateCompletionAge from foo_bar_1998 (nolock)
> returns:
> Populate status 1998 itemcount, indexssize, uniquekeycount,
> logsize populatecompletionage
> 2 441 442 2
> 72004 328 482772780
> Now, this index had been fully populated before any of these problems
> happened, so it should be fine. (i.e. no reason to pause, etc.)
>
> I'm bewildered at this point.
> Any other thoughts. (I mean worse comes to worse I'll simply destroy the
> indices and rebuild them, but then I'll lose a week or two of time waiting
> for the larger ones.)
>
>
> message
believe[vbcol=seagreen]
one
> in
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OImpBB2VFHA.2196@.TK2MSFTNGP09.phx.gbl...
> I am not sure what you mean by restarted in your original post? Do you
mean
> a reboot? If not, I would reboot your server to see if this clears the
> condition. It is baffling.
Well, restarted means just that, stopping and restarting all the services in
question.
No joy.
So today I rebooted the box, and still no joy.
So I completely removed one index, including the catalog and recreated it
from scratch.
Now at least the status is 1 - population in progress.
Yet after 4 hours, nothing has been indexed.
Very strange.

> --
> 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
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message[vbcol=seagreen]
> news:cnvge.26735$ia6.20761@.twister.nyroc.rr.com...
> pressures,
> they
> Files\MSSearch\Bin
> Files\Microsoft
> in
moving[vbcol=seagreen]
> DB:
as[vbcol=seagreen]
waiting[vbcol=seagreen]
> believe
> one
7.0).
>
|||when you run profiler does it show lots of activity from PKM, specifically
calls to sp_fulltext_getdata.
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
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:Awtie.39724$ia6.30323@.twister.nyroc.rr.com...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OImpBB2VFHA.2196@.TK2MSFTNGP09.phx.gbl...
> mean
> Well, restarted means just that, stopping and restarting all the services
in[vbcol=seagreen]
> question.
> No joy.
> So today I rebooted the box, and still no joy.
>
> So I completely removed one index, including the catalog and recreated it
> from scratch.
> Now at least the status is 1 - population in progress.
> Yet after 4 hours, nothing has been indexed.
> Very strange.
>
> message
why[vbcol=seagreen]
index[vbcol=seagreen]
> moving
user[vbcol=seagreen]
user[vbcol=seagreen]
user[vbcol=seagreen]
original[vbcol=seagreen]
completed[vbcol=seagreen]
completed[vbcol=seagreen]
completed[vbcol=seagreen]
completed[vbcol=seagreen]
completed[vbcol=seagreen]
LogSize,fulltextcatalogproperty('foo_bar_1998','Po pulateCompletionAge')[vbcol=seagreen]
> as
the[vbcol=seagreen]
> waiting
the[vbcol=seagreen]
including[vbcol=seagreen]
2.
> 7.0).
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eEZZSm0WFHA.2128@.TK2MSFTNGP14.phx.gbl...
> when you run profiler does it show lots of activity from PKM, specifically
> calls to sp_fulltext_getdata.
Well, I sorta "gave in"
I had a suspicion that a 4-5 of the full-text indices I moved may have been
the source of the problem (because I ended up having to hand edit their
registry entries.)
Removing those and the remaining ones started to work.
So now just running an incremental build on the ones that are behind.
Thanks for the help Hilary.

> --
> 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
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message[vbcol=seagreen]
> news:Awtie.39724$ia6.30323@.twister.nyroc.rr.com...
services[vbcol=seagreen]
> in
it[vbcol=seagreen]
> why
> index
> user
> user
> user
crawl[vbcol=seagreen]
> original
> completed
> completed
> completed
> completed
> completed
> LogSize,fulltextcatalogproperty('foo_bar_1998','Po pulateCompletionAge')
uniquekeycount,[vbcol=seagreen]
problems[vbcol=seagreen]
> the
in[vbcol=seagreen]
> the
> including
returns
> 2.
>