RE: Index freeze for 2 days, no change!
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
RE: Index freeze for 2 days, no change! - 11.Sep.2009 4:04:38 AM
|
|
|
Encode
Posts: 113
Joined: 29.Jul.2008
Status: offline
|
quote:
2009-09-10,17:23:13,046,1,"#00000628","#0000000B","info ","IndexJob","Database ID: 55a56de4-69f8-40e9-8e8e-b04ff2c0dfa2 path: D:\GFI\Indexes\Archive 2009 July, active True "
2009-09-10,17:23:13,046,1,"#00000628","#0000000B","info ","IndexJob",">> Start indexing on db: 55a56de4-69f8-40e9-8e8e-b04ff2c0dfa2"
2009-09-10,17:23:13,046,1,"#00000628","#0000000B","info ","IndexJob","Indexing in normal mode, ts: 5594650"
2009-09-10,17:25:13,500,1,"#00000628","#0000000B","error ","IndexJob","Error: failed to get updates Store.Exceptions.DalException: QueryFailed ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The log seems to indicate that indexing started at 17:23:13, but failed 2 minutes later at 17:25:13 - this seems different from what you are seeing (start index, indexes for 2 hours, then fails)?
It looks like there is a 2 minute (or 120 seconds) timeout set somewhere (probably within the GFI Archive application itself).
You could try reindexing all the indexes in the SQL database. 1 physical disk for a 96GB database could be the problem so may just not be able to process the query within the 2 minutes. Is it possible during that 2 minutes to measure the disk reads/second, disk writes/second, and current disk queue (for each of the 3 drives independantly).
< Message edited by Encode -- 11.Sep.2009 6:21:07 AM >
_____________________________
GFI Mail Archiver 6 Customer.
Running V6.1 (20090526) on Firebird.
Patches installed:
20090514_01
20090728_01
20090804_02
20090812_01
20090817_01
20090825_01
20090831_01
20090903_01
20090928_01
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 11.Sep.2009 6:08:43 AM
|
|
|
tiv
Posts: 12
Joined: 15.Aug.2008
Status: offline
|
Hi ewctm38,
My problem is still exist, so i sympathize you, because our high skill C# and MSSQL programmers says:
"That is problem in GFI code, we can't do nothing"
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 11.Sep.2009 6:23:48 AM
|
|
|
Encode
Posts: 113
Joined: 29.Jul.2008
Status: offline
|
SQL and OS are on the same drives, the OS drive by default is heavily used by GFI Archive during the indexing process (search puts temporary files in the system temp folder (set by environment variables)) so they could be battling with each other for the same drive.
I don't know what you have on disk 2 - BASE, but you could try moving the SQL database you are trying to reindex onto that or move the system's temp folder location (via environment variables then a reboot when it's ok to do so).
< Message edited by Encode -- 11.Sep.2009 6:24:49 AM >
_____________________________
GFI Mail Archiver 6 Customer.
Running V6.1 (20090526) on Firebird.
Patches installed:
20090514_01
20090728_01
20090804_02
20090812_01
20090817_01
20090825_01
20090831_01
20090903_01
20090928_01
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 16.Sep.2009 1:03:05 PM
|
|
|
craftedpacket
Posts: 6
Joined: 16.Sep.2009
Status: offline
|
I have the exact same issue. I am running in a distributed install. The Store and web interfaces on are one server, indexing on another, and the exchange pieces are installed on the exchange server.
I run into the same issue where indexing runs for a while then stops. I am getting the same failed to get updates messages in the logs. ON the Store server I have OS on one raid 5 disk set, GFI/SQL on another, and the actuall databases on another.
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 16.Sep.2009 4:46:55 PM
|
|
|
ewctm38
Posts: 65
Joined: 7.Mar.2006
Status: offline
|
Hi
The OS and the SQL are on different disk sub systems. The data disks are 838GB Raid 5.
Even if I restart the indexing it hangs after some time, but at another point of the number of messages indexed not at the same number of messages as previously.
I had increased the timeout from 2 minutes to 3 minutes in one of the config files but made no difference to the indexing status.
We use SQL + File system for the binaries.
Cheers
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 17.Sep.2009 2:07:04 AM
|
|
|
tiv
Posts: 12
Joined: 15.Aug.2008
Status: offline
|
Hi, all!
Yesterday, i spoke to GFI support team, and they says:
quote:
With SQL enterprise editions we have a 40 gigabyte upper limit, which you also appear to have exceeded. At present the recommended course of action would be to split this archive into separate smaller stores, and then after verifying the stores are find, decommission the store which is too large. Please find below KB article which details how to split:
http://kbase.gfi.com/showarticle.asp?id=KBID003061
So this is it, need split the bases..
Cheers!
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 17.Sep.2009 10:13:51 AM
|
|
|
craftedpacket
Posts: 6
Joined: 16.Sep.2009
Status: offline
|
Tiv,
How do you manage to contact support? We can never get them to call us back or respond.
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 17.Sep.2009 10:20:10 AM
|
|
|
craftedpacket
Posts: 6
Joined: 16.Sep.2009
Status: offline
|
Tiv,
With your SQL+Binaries setup how many emails did you have that created a 40 gig database?
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 17.Sep.2009 2:57:58 PM
|
|
|
ewctm38
Posts: 65
Joined: 7.Mar.2006
Status: offline
|
quote:
ORIGINAL: tiv
Hi, all!
Yesterday, i spoke to GFI support team, and they says:
quote:
With SQL enterprise editions we have a 40 gigabyte upper limit, which you also appear to have exceeded. At present the recommended course of action would be to split this archive into separate smaller stores, and then after verifying the stores are find, decommission the store which is too large. Please find below KB article which details how to split:
http://kbase.gfi.com/showarticle.asp?id=KBID003061
So this is it, need split the bases..
Cheers!
Hi
We use SQL + File systems and have had combined sizes of over 40GB. The SQL database was 4.5 GB and Binaries of 39GB.
We roll over every 3 months and for each period the combined size is over 40GB. Have had GFI since 2007.
Never had this indexing problem untill around May/June this year.
Cheers
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 18.Sep.2009 2:22:33 AM
|
|
|
tiv
Posts: 12
Joined: 15.Aug.2008
Status: offline
|
Hi, craftedpacket!
quote:
How do you manage to contact support? We can never get them to call us back or respond.
I contact support, throuth http://support.gfi.com/Support/supportrequest.aspx?lcode=en, and they answer very quick.
quote:
With your SQL+Binaries setup how many emails did you have that created a 40 gig database?
Archive Store Name: EV 2009
Archive Store Type: Microsoft SQL Server database
Archive Store created on: 05.08.2009 21:10
First email archived on: 25.03.2009 23:38
Last email archived on: 02.08.2009 19:27
Archive store contains: 958523 emails
Server: (localhost)
Database: EV2009
Database size: 114805.69 MB
Path to search index: F:\MAIDX\EV2009
Search index size: 491,05 MB
Indexed emails: 30000
This is the original database, i split it tomorrow to a 3 smaller.
In this case one smaller store conatin approximately 320K e-mails
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 20.Sep.2009 5:38:15 PM
|
|
|
ewctm38
Posts: 65
Joined: 7.Mar.2006
Status: offline
|
Hi
Have got a solution for the timeout. Appears to be working and now re indexing from where it used to hang.
Here is the solution provided by support. It might or not work for you.
Stop all GFI MailArchiver services, then follow these steps:
1) Open MailArchiver\Store\Data\product.config in a text editor
2) Add the following line under <appSettings>
<add key="CommandTimeout" value="1200"/>
Note the quote marks, as they are important
3) Restart the GFI MailArchiver Store Service
Cheers
|
|
|
|
|
RE: Index freeze for 2 days, no change! - 10.Nov.2009 6:29:33 PM
|
|
|
tiv
Posts: 12
Joined: 15.Aug.2008
Status: offline
|
ewctm38,
Thank you very much!!!
That what i need - and that working!
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
