Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Member List  Search  FAQ  Ticket List  Log Out

 

Index freeze for 2 days, no change!

  		Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Index freeze for 2 days, no change! Page: [1] 2   next >   >>
Login
Message << Older Topic   Newer Topic >>
Index freeze for 2 days, no change! - 3.Aug.2009 7:20:20 AM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		Good afternoon!

For me a problem with indexing, I will try to describe.

So:

There is an active base on MSSQL, the size - 96 GB, at reindexing attempt - reaches to 21000 indexed letters for 2 hours and hangs up. In such state passes 2 days - no changes. For this time process sqlsrv has 50% CPU load all time. Attachments index has disabled, debug mode enabled.

Try to rebuild many times, no result..

Another base, about 10 GB rebild index very fast, no problem.

I ask for help!

Thanks!

Servers config:

1. WS2008SP2 X64 - Exchange 2007 SP1 X64 CAS, HUB

2. WS2008SP2 X64 - Exchange 2007 SP1 X64 MB (Node1)

3. WS2008SP2 X64 - Exchange 2007 SP1 X64 MB (Node2)

4. WS2008SP2 X64 - GFI MA X64 6.1 (Build 20090526), SQL2005 SP2 X64,
(XEON 5520, 6GB DDR3, 3 SAS Drive: 1 - OS + SQL; 2 - BASE; 3 - INDEX + LOGS)
Post #: 1
RE: Index freeze for 2 days, no change! - 3.Aug.2009 7:23:46 AM   
roderickb

 

Posts: 41
Joined: 30.May2008
Status: offline 		Hi tiv,

can you send me the troubleshooter files at roderick(at)gfi.com please? Thanks.

_____________________________

Thanks and kind regards,
Roderick Buhagiar
GFI Software Ltd

(in reply to tiv)
Post #: 2
RE: Index freeze for 2 days, no change! - 3.Aug.2009 1:40:04 PM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		For this time our Security Dept. learning data taken from this report, its can take long time...
But i can post part of "IndexJob.log", where i find some cyclic errors: 

2009-08-03,20:05:59,431,1,"#00000A14","#0000000B","info   ","IndexJob","Database ID: 085eb477-17f8-4feb-9041-9a1e336b48df path: F:\MAIDX\EV2009, active False "
2009-08-03,20:05:59,431,1,"#00000A14","#0000000B","info   ","IndexJob",">> Start indexing on db: 085eb477-17f8-4feb-9041-9a1e336b48df"
2009-08-03,20:05:59,431,1,"#00000A14","#0000000B","info   ","IndexJob","Indexing in bulk mode, Cookie [202324,61251043]"
2009-08-03,20:08:00,494,1,"#00000A14","#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.
;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
;   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
;   at System.Data.SqlClient.SqlDataReader.Read()
;   at Store.Dal.Gateway.MsSql.EmailAttachment.GetAttachmentCollections(SqlDataReader reader)
;   at Store.Dal.Gateway.MsSql.EmailMessage.GetDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken[] tokens, Boolean fullAccess, Int64& maxTS)
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   --- End of inner exception stack trace ---
;
;Server stack trace: 
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   at Store.Dal.Mapper.EmailMessage.GetDetailedMessages(IDalEmailProvider provider, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
;
;Exception rethrown at [0]: 
;   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
;   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Search.Indexer.IndexingJob.RetrieveBulkMessages(Int32 maxCount) "
2009-08-03,20:08:00,494,1,"#00000A14","#0000000B","info   ","IndexJob","Failed getting bulk messages QueryFailed"
2009-08-03,20:08:00,500,1,"#00000A14","#0000000B","info   ","IndexJob","Database ID: 085eb477-17f8-4feb-9041-9a1e336b48df path: F:\MAIDX\EV2009, active False "
2009-08-03,20:08:00,500,1,"#00000A14","#0000000B","info   ","IndexJob",">> Start indexing on db: 085eb477-17f8-4feb-9041-9a1e336b48df"
2009-08-03,20:08:00,500,1,"#00000A14","#0000000B","info   ","IndexJob","Indexing in bulk mode, Cookie [202324,61251043]"
2009-08-03,20:10:01,612,1,"#00000A14","#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.
;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
;   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
;   at System.Data.SqlClient.SqlDataReader.Read()
;   at Store.Dal.Gateway.MsSql.EmailAttachment.GetAttachmentCollections(SqlDataReader reader)
;   at Store.Dal.Gateway.MsSql.EmailMessage.GetDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken[] tokens, Boolean fullAccess, Int64& maxTS)
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   --- End of inner exception stack trace ---
;
;Server stack trace: 
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   at Store.Dal.Mapper.EmailMessage.GetDetailedMessages(IDalEmailProvider provider, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
;
;Exception rethrown at [0]: 
;   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
;   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Search.Indexer.IndexingJob.RetrieveBulkMessages(Int32 maxCount) "
2009-08-03,20:10:01,612,1,"#00000A14","#0000000B","info   ","IndexJob","Failed getting bulk messages QueryFailed"
2009-08-03,20:10:01,621,1,"#00000A14","#0000000B","info   ","IndexJob","Database ID: 085eb477-17f8-4feb-9041-9a1e336b48df path: F:\MAIDX\EV2009, active False "
2009-08-03,20:10:01,621,1,"#00000A14","#0000000B","info   ","IndexJob",">> Start indexing on db: 085eb477-17f8-4feb-9041-9a1e336b48df"
2009-08-03,20:10:01,621,1,"#00000A14","#0000000B","info   ","IndexJob","Indexing in bulk mode, Cookie [202324,61251043]"
2009-08-03,20:12:03,117,1,"#00000A14","#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.
;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
;   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
;   at System.Data.SqlClient.SqlDataReader.Read()
;   at Store.Dal.Gateway.MsSql.EmailAttachment.GetAttachmentCollections(SqlDataReader reader)
;   at Store.Dal.Gateway.MsSql.EmailMessage.GetDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken[] tokens, Boolean fullAccess, Int64& maxTS)
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   --- End of inner exception stack trace ---
;
;Server stack trace: 
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Int64 end, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount, AdaToken faToken, Int64& maxTS)
;   at Store.Dal.Mapper.EmailMessage.GetDetailedMessages(IDalEmailProvider provider, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
;
;Exception rethrown at [0]: 
;   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
;   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Cookie& cookie, Nullable`1 startDate, Nullable`1 endDate, Int32 maxCount)
;   at Search.Indexer.IndexingJob.RetrieveBulkMessages(Int32 maxCount) "
2009-08-03,20:12:03,118,1,"#00000A14","#0000000B","info   ","IndexJob","Failed getting bulk messages QueryFailed"

(in reply to roderickb)
Post #: 3
RE: Index freeze for 2 days, no change! - 4.Aug.2009 1:10:50 PM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		At this time still have no change, mail index running but it freeze at 21000 letters..
I workaround for check mssql base for integrity and errors, but base in good state, no errors.

So, need help..

(in reply to tiv)
Post #: 4
RE: Index freeze for 2 days, no change! - 10.Aug.2009 9:21:36 AM   
Encode

 

Posts: 113
Joined: 29.Jul.2008
Status: offline 		Try switching off debug mode.

The database server might just not be fast enough for the workload.

What's the disk utilisation like whilst it's indexing ?

See http://technet.microsoft.com/en-gb/library/cc966534.aspx

Did you get the same problem with 6.0?

_____________________________

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

(in reply to tiv)
Post #: 5
RE: Index freeze for 2 days, no change! - 10.Aug.2009 12:47:23 PM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		Thanks for your answer!

Phisical drive time not over 10%, and this is not linked with problem, because after 5hrs of starting new index job, index count grow util is rich 21000 and just stop. After this SQL Server process utilize 100% one core time, and index no more grow. I see the logs and find the same cyclic messages (see up).

I use next configuration:
VM in Hyper-V enviroment with 3 SAS Phisical Disks linked

1. Drive (SAS 15K): System + SQL Install
2. Drive (SAS 15K): Active database (MDF)
3. Drive (SAS 15K): Indexes and database logs (LDF)

Have upgrade to 16GB RAM, but no change...

At this time, i do new import job of emails that not indexed in new base, and have good result. But affraid, what i'll do if problem come back again..

Jeers!

(in reply to Encode)
Post #: 6
RE: Index freeze for 2 days, no change! - 11.Aug.2009 2:07:20 AM   
Encode

 

Posts: 113
Joined: 29.Jul.2008
Status: offline 		Have a check to make sure that attachment indexing is still switched off. If you ever do an upgrade of GFI it will revert to it's default (attachments = indexed)

http://kbase.gfi.com/showarticle.asp?id=KBID003164

_____________________________

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

(in reply to tiv)
Post #: 7
RE: Index freeze for 2 days, no change! - 12.Aug.2009 9:33:26 AM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		Thanks for answer..

Attachment indexing set to <attachments indexing="false">

I done this after update.

For this time bad news, index for the new database stop again!!

But now in indexjob.log i have this: 
2009-08-12,16:27:00,442,1,"#00001478","#0000000B","info   ","IndexJob","Database ID: 83551325-0a94-4e0d-9fb8-608134cc66dd path: F:\MAIDX\EV2009-1, active False "
2009-08-12,16:27:00,442,1,"#00001478","#0000000B","info   ","IndexJob",">> Start indexing on db: 83551325-0a94-4e0d-9fb8-608134cc66dd"
2009-08-12,16:27:00,442,1,"#00001478","#0000000B","info   ","IndexJob","Indexing in normal mode, ts: 1821215"
2009-08-12,16:29:00,732,1,"#00001478","#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.
;   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
;   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
;   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
;   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
;   at System.Data.SqlClient.SqlDataReader.Read()
;   at Store.Dal.Gateway.MsSql.EmailAttachment.GetAttachmentCollections(SqlDataReader reader)
;   at Store.Dal.Gateway.MsSql.EmailMessage.GetDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken[] tokens, Boolean fullAccess)
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken faToken)
;   --- End of inner exception stack trace ---
;
;Server stack trace: 
;   at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken faToken)
;   at Store.Dal.Mapper.EmailMessage.GetDetailedMessages(IDalEmailProvider provider, String userId, Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Int64 start, Int32 maxCount)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
;   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
;
;Exception rethrown at [0]: 
;   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
;   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
;   at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Int64 start, Int32 maxCount)
;   at Search.Indexer.IndexingJob.RetrieveMessages(Int32 maxCount)"
2009-08-12,16:29:00,732,1,"#00001478","#0000000B","error  ","IndexJob","Error: QueryFailed"


I dont know what i have to do...

So, please help me with this problem!

Cheers!

P.S. This is database stat:

Archive Store Name: EV 2009 Jan-Jun 
Archive Store Type: Microsoft SQL Server database
Archive Store created on: 05.08.2009 21:10
First email archived on: 05.08.2009 22:04
Last email archived on: 12.08.2009 10:21
Archive store contains: 363929 emails

Server: (localhost)
Database: EV2009-1
Database size: 45080.00 MB


Path to search index: F:\MAIDX\EV2009-1
Search index size: 776,69 MB
Indexed emails: 295744

Allow user browsing and searching: Yes
Allow further archiving: Yes

< Message edited by tiv -- 12.Aug.2009 9:45:15 AM >

(in reply to Encode)
Post #: 8
RE: Index freeze for 2 days, no change! - 12.Aug.2009 9:55:27 AM   
Encode

 

Posts: 113
Joined: 29.Jul.2008
Status: offline 		If it's possible try and split the database into 2 smaller ones e.g. "EV 2009 Q1 Jan - Mar" and "EV 2009 Q2 Apr - Jun"

_____________________________

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

(in reply to tiv)
Post #: 9
RE: Index freeze for 2 days, no change! - 12.Aug.2009 12:44:41 PM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		So, there no other choise available. I do this today..
Also, maybe here available some kind of timeout settings, so i can encrease this setting for tune up the MA for access large SQL database?

Thanks!

< Message edited by tiv -- 12.Aug.2009 12:47:10 PM >

(in reply to tiv)
Post #: 10
RE: Index freeze for 2 days, no change! - 12.Aug.2009 2:20:37 PM   
tiv

 

Posts: 12
Joined: 15.Aug.2008
Status: offline 		I find some solutions, maybe its be helpful for me, but i don't know how they apply...

http://www.tipsstation.com/article/Timeout-expired-server-is-not-responding-Asp-Dot-Net.aspx

Thanks!

(in reply to tiv)
Post #: 11
RE: Index freeze for 2 days, no change! - 8.Sep.2009 9:13:17 PM   
ewctm38

 

Posts: 65
Joined: 7.Mar.2006
Status: offline 		Hi tiv

Have you sorted this indexing problem yet?
Do you have the binaries kept on the file system or included in the SQL database?

If its fixed what was your resolution?

Thanks

(in reply to tiv)
Post #: 12
RE: Index freeze for 2 days, no change! - 9.Sep.2009 9:07:09 AM   
John Letourneau

 

Posts: 1659
Joined: 28.Apr.2008
Status: offline 		ewctm38,

Are you having similar problems with your indexing? I don't want to leave you out in the cold in case tiv does not answer back in the forum thread since it does appear to be a bit old. Would it be possible to post some of your indexjob.log?

_____________________________

Regards,
John Letourneau - Technical Support Team Lead
GFI Software - www.gfi.com

(in reply to ewctm38)
Post #: 13
RE: Index freeze for 2 days, no change! - 9.Sep.2009 2:21:20 PM   
ewctm38

 

Posts: 65
Joined: 7.Mar.2006
Status: offline 		Hi John

I have a case opened for this - GFI Case GFI-090702-8537.
Brett has been looking at this since May this year.


I was getting the same time outs error in the index log.

Cheers

(in reply to John Letourneau)
Post #: 14
RE: Index freeze for 2 days, no change! - 11.Sep.2009 12:22:11 AM   
ewctm38

 

Posts: 65
Joined: 7.Mar.2006
Status: offline 		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.
; at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
; at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
; at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
; at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
; at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
; at System.Data.SqlClient.SqlDataReader.Read()
; at Store.Dal.Gateway.MsSql.EmailAddress.GetAddressCollections(SqlDataReader reader)
; at Store.Dal.Gateway.MsSql.EmailMessage.GetDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken[] tokens, Boolean fullAccess)
; at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken faToken)
; --- End of inner exception stack trace ---
;
;Server stack trace:
; at Store.Dal.MsSqlEmailProvider.GetBulkDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken faToken)
; at Store.Dal.FSEmailProvider.GetBulkDetailedMessages(Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount, AdaToken faToken)
; at Store.Dal.Mapper.EmailMessage.GetDetailedMessages(IDalEmailProvider provider, String userId, Int64 start, Nullable`1 startDate, Nullable`1 endDate, Int32 transactionIdTimeFrame, Int32 maxCount)
; at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Int64 start, Int32 maxCount)
; at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
; at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
; at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
;
;Exception rethrown at [0]:
; at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
; at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
; at Store.Core.EmailMessageRetrieval.GetBulkDetailedMessages(Guid databaseId, String userId, Int64 start, Int32 maxCount)
; at Search.Indexer.IndexingJob.RetrieveMessages(Int32 maxCount)"
2009-09-10,17:25:13,500,1,"#00000628","#0000000B","error ","IndexJob","Error: QueryFailed"

(in reply to ewctm38)
Post #: 15
Page:   [1] 2   next >   >>
All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Index freeze for 2 days, no change! Page: [1] 2   next >   >>
Jump to:





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