Verity Collections Disappearing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al M. - 31 Mar 2006 15:33 GMT

CFMX 7,0,1,116466 on Windows 2003 server (up to date with patches)

I had a website working perfectly for years under CF 4 and 5.. it uses 5
verity collections. When I moved it to a CFMX 7 shared server, it appeared to
work perfectly, but about once every 2 weeks (it happened 3 times now), one
collection just craps out... it triggers a runtime error :
==========================================================================
There was a problem executing the CFSearch tag with the following
collections.Collection (status code): feedback (-1705) The specific sequence of
files included or processed is: C:\websites\xxxx\search2.cfm, line: 84

================================================================================
Line 84 is a cfsearch of the collection "feedback"
When I look for this collection in the cf administrator, it doesn't show up.
It is always this one collection - never happened to the others on this
server.. It wouldn't allow me to add this collection so
I deleted the verity/feedback directory and restarted the server and then
was able to add the collection and reindex it and it worked perfectly for a few
weeks.. then it recurrs.
Looking at the size in windows explorer, when it is working, the
verity/feedback is 120 mb in size. When it stops working it is only 58kb in
size. Nothing is ever removed - I do not know why it is shrinking so much.

Any ideas?

Reply to this Message

liquid One - 31 Mar 2006 17:49 GMT

I have had a similar problem, and havent quite figured it out completely, but I
think it has something to do with server resources. When it starts to get to a
larger size, verity uses a lot of system resources to update or refresh the
results of the collection. It had started to timeout, and or not completekly
finish its operation, and the verity would not work half the time. It even
crashed my server once. When I put it on a faster server though, it started
running smoothely again, and has had no probs since. Im not sure why, but when
i watch the resource manager during the verity update, it skyrockets cpu and
pagefile usage. It was much harder for me, as mine needed to update every 4
hrs. Hopefully this was a little helpful

Reply to this Message

Al M. - 31 Mar 2006 21:38 GMT

Resources don't appear to be a problem. It is a dual-core 3 gighz processor
with 2 gigs ram. Perf monitor says there are 800megs of ram free.
Is there a size limit for the collections? This happens to be the largest
one by far... covers about 5 years of questions
Guess I can try to break it down by year then search individually and combine
the results later.

Reply to this Message

liquid One - 31 Mar 2006 22:24 GMT

Here i found this. . .
http://www.macromedia.com/devnet/server_archive/articles/understanding_verity_co
llections_in_cf.html

Reply to this Message

Al M. - 31 Mar 2006 23:31 GMT

thanks,
Sounds like a really stupid design. I do optimize them occasionally, but it takes time and the collection isn't avaiable while optimizing.

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / March 2006

Verity Collections Disappearing