Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 10137 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sophos Management Console did not start error:0x080040300

tedz

Hi,

Anyone help us to solve our problem.

Initialization failed.

Step: Enforcing invariants for the SUM administration service
Error: Runtime error
Data: 0x80040300 - SQL error: 823

Sophos.Management.GeneralException: SQL error: 823 ---> System.Data.SqlClient.SqlException: The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x00000000f66000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\tempdb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Sophos.Management.Data.GeneralCommand.ExecuteImpl()
--- End of inner exception stack trace ---
at Sophos.Management.Data.SPErrorHandler.AnalyseAndConvertException(Exception e)
at Sophos.Management.Data.GeneralCommand.ExecuteImpl()
at Sophos.Management.Data.Utils.ExecuteAndHandleTransientErrors(ISqlConnectionContext scc, MethodThatMayThrowTransientError methodToCall)
at Sophos.Management.Data.GeneralCommand.Execute()
at Sophos.Management.Data.CrudPersister.Execute(GeneralCommandMetadata commandMetadata)
at Sophos.Management.Data.Sddma.SddmServerSql.EnsureAllServersHaveDefaults()
at Sophos.Management.Data.Sddma.Dali.ServerDao.EnsureAllServersHaveDefaults()
at Sophos.Management.Services.Sddma.SddmaService.EnsureAllServersHaveDefaults()
at Sophos.Management.Services.Sddma.SddmaService.EnforceInvariants()

Thank you,

tedz

:35785


This thread was automatically locked due to age.
Parents
  • 0

    Hi jak,

    Here are the result. And why our logs in sql can reached into 34gb we need to stop it.

    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    C:\Documents and Settings\Administrator>sqlcmd -E -S .\sophos -d master -Q "DBCC
    CHECKDB ('tempdb')"
    DBCC results for 'tempdb'.
    DBCC CHECKDB will not check SQL Server catalog or Service Broker consistency bec
    ause a database snapshot could not be created or because WITH TABLOCK was specif
    ied.
    DBCC results for 'sys.sysrscols'.
    There are 682 rows in 8 pages for object "sys.sysrscols".
    DBCC results for 'sys.sysrowsets'.
    There are 111 rows in 1 pages for object "sys.sysrowsets".
    DBCC results for 'sys.sysallocunits'.
    There are 123 rows in 2 pages for object "sys.sysallocunits".
    DBCC results for 'sys.sysfiles1'.
    There are 2 rows in 1 pages for object "sys.sysfiles1".
    DBCC results for 'sys.syspriorities'.
    There are 0 rows in 0 pages for object "sys.syspriorities".
    DBCC results for 'sys.sysfgfrag'.
    There are 2 rows in 1 pages for object "sys.sysfgfrag".
    DBCC results for 'sys.sysphfg'.
    There are 1 rows in 1 pages for object "sys.sysphfg".
    DBCC results for 'sys.sysprufiles'.
    There are 2 rows in 1 pages for object "sys.sysprufiles".
    DBCC results for 'sys.sysftinds'.
    There are 0 rows in 0 pages for object "sys.sysftinds".
    DBCC results for 'sys.sysowners'.
    There are 14 rows in 1 pages for object "sys.sysowners".
    DBCC results for 'sys.sysprivs'.
    There are 131 rows in 1 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 71 rows in 1 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 526 rows in 10 pages for object "sys.syscolpars".
    DBCC results for 'sys.sysnsobjs'.
    There are 1 rows in 1 pages for object "sys.sysnsobjs".
    DBCC results for 'sys.syscerts'.
    There are 0 rows in 0 pages for object "sys.syscerts".
    DBCC results for 'sys.sysxprops'.
    There are 0 rows in 0 pages for object "sys.sysxprops".
    DBCC results for 'sys.sysscalartypes'.
    There are 34 rows in 1 pages for object "sys.sysscalartypes".
    DBCC results for 'sys.systypedsubobjs'.
    There are 0 rows in 0 pages for object "sys.systypedsubobjs".
    DBCC results for 'sys.sysidxstats'.
    There are 114 rows in 1 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 257 rows in 2 pages for object "sys.sysiscols".
    DBCC results for 'sys.sysbinobjs'.
    There are 23 rows in 1 pages for object "sys.sysbinobjs".
    DBCC results for 'sys.sysaudacts'.
    There are 0 rows in 0 pages for object "sys.sysaudacts".
    DBCC results for 'sys.sysobjvalues'.
    There are 102 rows in 13 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.sysclsobjs'.
    There are 16 rows in 1 pages for object "sys.sysclsobjs".
    DBCC results for 'sys.sysrowsetrefs'.
    There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
    DBCC results for 'sys.sysremsvcbinds'.
    There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
    DBCC results for 'sys.sysxmitqueue'.
    There are 0 rows in 0 pages for object "sys.sysxmitqueue".
    DBCC results for 'sys.sysrts'.
    There are 1 rows in 1 pages for object "sys.sysrts".
    DBCC results for 'sys.sysconvgroup'.
    There are 0 rows in 0 pages for object "sys.sysconvgroup".
    DBCC results for 'sys.sysdesend'.
    There are 0 rows in 0 pages for object "sys.sysdesend".
    DBCC results for 'sys.sysdercv'.
    There are 0 rows in 0 pages for object "sys.sysdercv".
    DBCC results for 'sys.syssingleobjrefs'.
    There are 164 rows in 1 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 106 rows in 1 pages for object "sys.sysmultiobjrefs".
    DBCC results for 'sys.sysguidrefs'.
    There are 0 rows in 0 pages for object "sys.sysguidrefs".
    DBCC results for 'sys.syscompfragments'.
    There are 0 rows in 0 pages for object "sys.syscompfragments".
    DBCC results for 'sys.sysftstops'.
    There are 0 rows in 0 pages for object "sys.sysftstops".
    DBCC results for 'sys.sysqnames'.
    There are 97 rows in 1 pages for object "sys.sysqnames".
    DBCC results for 'sys.sysxmlcomponent'.
    There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
    DBCC results for 'sys.sysxmlfacet'.
    There are 112 rows in 1 pages for object "sys.sysxmlfacet".
    DBCC results for 'sys.sysxmlplacement'.
    There are 18 rows in 1 pages for object "sys.sysxmlplacement".
    DBCC results for 'sys.sysobjkeycrypts'.
    There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
    DBCC results for 'sys.sysasymkeys'.
    There are 0 rows in 0 pages for object "sys.sysasymkeys".
    DBCC results for 'sys.syssqlguides'.
    There are 0 rows in 0 pages for object "sys.syssqlguides".
    DBCC results for 'sys.sysbinsubobjs'.
    There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
    DBCC results for 'sys.syssoftobjrefs'.
    There are 0 rows in 0 pages for object "sys.syssoftobjrefs".
    DBCC results for 'sys.fulltext_thesaurus_phrase_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_phrase_table".
    DBCC results for '#4CA06362'.
    There are 0 rows in 1 pages for object "#4CA06362".
    DBCC results for '#4E88ABD4'.
    There are 0 rows in 1 pages for object "#4E88ABD4".
    DBCC results for '#4F7CD00D'.
    There are 0 rows in 1 pages for object "#4F7CD00D".
    DBCC results for '#5070F446'.
    There are 0 rows in 1 pages for object "#5070F446".
    DBCC results for '#5165187F'.
    There are 0 rows in 1 pages for object "#5165187F".
    DBCC results for '#52593CB8'.
    There are 0 rows in 1 pages for object "#52593CB8".
    DBCC results for '#571DF1D5'.
    There are 0 rows in 0 pages for object "#571DF1D5".
    DBCC results for '#5812160E'.
    There are 0 rows in 0 pages for object "#5812160E".
    DBCC results for '#59063A47'.
    There are 0 rows in 0 pages for object "#59063A47".
    DBCC results for '#59FA5E80'.
    There are 0 rows in 0 pages for object "#59FA5E80".
    DBCC results for '#5AEE82B9'.
    There are 0 rows in 1 pages for object "#5AEE82B9".
    DBCC results for '#5BE2A6F2'.
    There are 0 rows in 1 pages for object "#5BE2A6F2".
    DBCC results for '#5DCAEF64'.
    There are 0 rows in 1 pages for object "#5DCAEF64".
    DBCC results for '#5FB337D6'.
    There are 0 rows in 1 pages for object "#5FB337D6".
    DBCC results for 'sys.queue_messages_1977058079'.
    There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
    DBCC results for 'sys.queue_messages_2009058193'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
    DBCC results for 'sys.queue_messages_2041058307'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
    DBCC results for 'sys.filestream_tombstone_2073058421'.
    There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
    DBCC results for 'sys.syscommittab'.
    There are 0 rows in 0 pages for object "sys.syscommittab".
    DBCC results for 'sys.fulltext_thesaurus_metadata_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_metadata_table".
    DBCC results for 'sys.service_broker_map'.
    There are 12 rows in 1 pages for object "sys.service_broker_map".
    DBCC results for 'sys.fulltext_thesaurus_state_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_state_table".
    CHECKDB found 0 allocation errors and 0 consistency errors in database 'tempdb'.

    DBCC execution completed. If DBCC printed error messages, contact your system ad
    ministrator.

    Thanks,

    tedz

    :35921
Reply
  • 0

    Hi jak,

    Here are the result. And why our logs in sql can reached into 34gb we need to stop it.

    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    C:\Documents and Settings\Administrator>sqlcmd -E -S .\sophos -d master -Q "DBCC
    CHECKDB ('tempdb')"
    DBCC results for 'tempdb'.
    DBCC CHECKDB will not check SQL Server catalog or Service Broker consistency bec
    ause a database snapshot could not be created or because WITH TABLOCK was specif
    ied.
    DBCC results for 'sys.sysrscols'.
    There are 682 rows in 8 pages for object "sys.sysrscols".
    DBCC results for 'sys.sysrowsets'.
    There are 111 rows in 1 pages for object "sys.sysrowsets".
    DBCC results for 'sys.sysallocunits'.
    There are 123 rows in 2 pages for object "sys.sysallocunits".
    DBCC results for 'sys.sysfiles1'.
    There are 2 rows in 1 pages for object "sys.sysfiles1".
    DBCC results for 'sys.syspriorities'.
    There are 0 rows in 0 pages for object "sys.syspriorities".
    DBCC results for 'sys.sysfgfrag'.
    There are 2 rows in 1 pages for object "sys.sysfgfrag".
    DBCC results for 'sys.sysphfg'.
    There are 1 rows in 1 pages for object "sys.sysphfg".
    DBCC results for 'sys.sysprufiles'.
    There are 2 rows in 1 pages for object "sys.sysprufiles".
    DBCC results for 'sys.sysftinds'.
    There are 0 rows in 0 pages for object "sys.sysftinds".
    DBCC results for 'sys.sysowners'.
    There are 14 rows in 1 pages for object "sys.sysowners".
    DBCC results for 'sys.sysprivs'.
    There are 131 rows in 1 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 71 rows in 1 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 526 rows in 10 pages for object "sys.syscolpars".
    DBCC results for 'sys.sysnsobjs'.
    There are 1 rows in 1 pages for object "sys.sysnsobjs".
    DBCC results for 'sys.syscerts'.
    There are 0 rows in 0 pages for object "sys.syscerts".
    DBCC results for 'sys.sysxprops'.
    There are 0 rows in 0 pages for object "sys.sysxprops".
    DBCC results for 'sys.sysscalartypes'.
    There are 34 rows in 1 pages for object "sys.sysscalartypes".
    DBCC results for 'sys.systypedsubobjs'.
    There are 0 rows in 0 pages for object "sys.systypedsubobjs".
    DBCC results for 'sys.sysidxstats'.
    There are 114 rows in 1 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 257 rows in 2 pages for object "sys.sysiscols".
    DBCC results for 'sys.sysbinobjs'.
    There are 23 rows in 1 pages for object "sys.sysbinobjs".
    DBCC results for 'sys.sysaudacts'.
    There are 0 rows in 0 pages for object "sys.sysaudacts".
    DBCC results for 'sys.sysobjvalues'.
    There are 102 rows in 13 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.sysclsobjs'.
    There are 16 rows in 1 pages for object "sys.sysclsobjs".
    DBCC results for 'sys.sysrowsetrefs'.
    There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
    DBCC results for 'sys.sysremsvcbinds'.
    There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
    DBCC results for 'sys.sysxmitqueue'.
    There are 0 rows in 0 pages for object "sys.sysxmitqueue".
    DBCC results for 'sys.sysrts'.
    There are 1 rows in 1 pages for object "sys.sysrts".
    DBCC results for 'sys.sysconvgroup'.
    There are 0 rows in 0 pages for object "sys.sysconvgroup".
    DBCC results for 'sys.sysdesend'.
    There are 0 rows in 0 pages for object "sys.sysdesend".
    DBCC results for 'sys.sysdercv'.
    There are 0 rows in 0 pages for object "sys.sysdercv".
    DBCC results for 'sys.syssingleobjrefs'.
    There are 164 rows in 1 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 106 rows in 1 pages for object "sys.sysmultiobjrefs".
    DBCC results for 'sys.sysguidrefs'.
    There are 0 rows in 0 pages for object "sys.sysguidrefs".
    DBCC results for 'sys.syscompfragments'.
    There are 0 rows in 0 pages for object "sys.syscompfragments".
    DBCC results for 'sys.sysftstops'.
    There are 0 rows in 0 pages for object "sys.sysftstops".
    DBCC results for 'sys.sysqnames'.
    There are 97 rows in 1 pages for object "sys.sysqnames".
    DBCC results for 'sys.sysxmlcomponent'.
    There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
    DBCC results for 'sys.sysxmlfacet'.
    There are 112 rows in 1 pages for object "sys.sysxmlfacet".
    DBCC results for 'sys.sysxmlplacement'.
    There are 18 rows in 1 pages for object "sys.sysxmlplacement".
    DBCC results for 'sys.sysobjkeycrypts'.
    There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
    DBCC results for 'sys.sysasymkeys'.
    There are 0 rows in 0 pages for object "sys.sysasymkeys".
    DBCC results for 'sys.syssqlguides'.
    There are 0 rows in 0 pages for object "sys.syssqlguides".
    DBCC results for 'sys.sysbinsubobjs'.
    There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
    DBCC results for 'sys.syssoftobjrefs'.
    There are 0 rows in 0 pages for object "sys.syssoftobjrefs".
    DBCC results for 'sys.fulltext_thesaurus_phrase_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_phrase_table".
    DBCC results for '#4CA06362'.
    There are 0 rows in 1 pages for object "#4CA06362".
    DBCC results for '#4E88ABD4'.
    There are 0 rows in 1 pages for object "#4E88ABD4".
    DBCC results for '#4F7CD00D'.
    There are 0 rows in 1 pages for object "#4F7CD00D".
    DBCC results for '#5070F446'.
    There are 0 rows in 1 pages for object "#5070F446".
    DBCC results for '#5165187F'.
    There are 0 rows in 1 pages for object "#5165187F".
    DBCC results for '#52593CB8'.
    There are 0 rows in 1 pages for object "#52593CB8".
    DBCC results for '#571DF1D5'.
    There are 0 rows in 0 pages for object "#571DF1D5".
    DBCC results for '#5812160E'.
    There are 0 rows in 0 pages for object "#5812160E".
    DBCC results for '#59063A47'.
    There are 0 rows in 0 pages for object "#59063A47".
    DBCC results for '#59FA5E80'.
    There are 0 rows in 0 pages for object "#59FA5E80".
    DBCC results for '#5AEE82B9'.
    There are 0 rows in 1 pages for object "#5AEE82B9".
    DBCC results for '#5BE2A6F2'.
    There are 0 rows in 1 pages for object "#5BE2A6F2".
    DBCC results for '#5DCAEF64'.
    There are 0 rows in 1 pages for object "#5DCAEF64".
    DBCC results for '#5FB337D6'.
    There are 0 rows in 1 pages for object "#5FB337D6".
    DBCC results for 'sys.queue_messages_1977058079'.
    There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
    DBCC results for 'sys.queue_messages_2009058193'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
    DBCC results for 'sys.queue_messages_2041058307'.
    There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
    DBCC results for 'sys.filestream_tombstone_2073058421'.
    There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
    DBCC results for 'sys.syscommittab'.
    There are 0 rows in 0 pages for object "sys.syscommittab".
    DBCC results for 'sys.fulltext_thesaurus_metadata_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_metadata_table".
    DBCC results for 'sys.service_broker_map'.
    There are 12 rows in 1 pages for object "sys.service_broker_map".
    DBCC results for 'sys.fulltext_thesaurus_state_table'.
    There are 0 rows in 0 pages for object "sys.fulltext_thesaurus_state_table".
    CHECKDB found 0 allocation errors and 0 consistency errors in database 'tempdb'.

    DBCC execution completed. If DBCC printed error messages, contact your system ad
    ministrator.

    Thanks,

    tedz

    :35921
Children
No Data