Endpoint Protection

 View Only
Back to discussions
Expand all | Collapse all

Embedded Database stops regularly-will restart

Rafeeq

RafeeqAug 22, 2013 07:27 PM

Any patches installed lately?

  • 1.  Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 06:06 PM

    Server SBS2008 / Symantec Endpoint Protection 12.1.671.4971 . Embedded database service stops but can be restarted. Ran a repair of the SEPM successfully. Ran dbvalidator which said it passed. Attached scm-server-0.log. Service stays running for about 6-8 hours.

    Also a fatal error in Windows Application log. image attached

     

    What's next?

    Attachment(s)

    zip
    scm-server-0.zip   88 KB 1 version


  • 2.  RE: Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 06:20 PM

    "Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found"

    Have you considered upgrading to the latest version, RU3? You're running the first version of 12.1.

    How's the space on C:?

    When did this start? Any changes made previously, updates, etc?

    Similar thread here:

    https://www-secure.symantec.com/connect/forums/symantec-embedded-database-121-ru2-problems



  • 3.  RE: Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 07:27 PM

    Any patches installed lately?



  • 4.  RE: Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 09:02 PM

    My mistake - SEP on server is 12.1 SEPM is 12.1.2015.2015 (RU2)

    Started about 1 month ago.

    LAst windows updates installed 4/22/2013

    Free space on Sepm drive C = 64g; db size = 4g

     

    I could upgrade to 12.3 but if it doesn't work ?? I could restore from backups before 1 month ago, but what to restore. What exactly is causing the service to stop? The db passes the tests and it does start. 

    I would say the server log is showing the dtabasae server can't be found because the database service is stopped. I can start it but it stops a few hour later.



  • 5.  RE: Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 09:15 PM

    Enable the logging and paste it here

    http://www.symantec.com/business/support/index?page=content&id=TECH102413



  • 6.  RE: Embedded Database stops regularly-will restart

    Posted Aug 22, 2013 09:29 PM

    Enable loggin

    http://www.symantec.com/business/support/index?page=content&id=TECH102413



  • 7.  RE: Embedded Database stops regularly-will restart

    Posted Aug 23, 2013 04:18 AM

    If it's the DB service that's stopping, then the logs you posted and the aforementioned logging won't really help (all they'll say is that the DB is unavailable).

    Looking within the directory containing the DB itself, can you see an err.log or out.log file?  Also what'are the sizes of the sem5.db and sem5.log files?

    Directory is usually: %ProgramFiles%\Symantec\Symantec Endpoint Protection Manager\db



  • 8.  RE: Embedded Database stops regularly-will restart

    Trusted Advisor
    Posted Aug 23, 2013 07:51 AM

    Hello,

    It is recommended to Migrate the same to the Latest version of SEP 12.1.3001

    http://www.symantec.com/docs/TECH206823

    As an alternative, try these steps below:

    1) Stop the Symantec Endpoint Protection Manager and Symantec Embedded Databaseservices. 
    2) Rename or delete the current sem5.log
    3) Click Start > Run and type CMD then click OK 
    4) In the Command Prompt type:
        For 32-bit: CD C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\
        For 64-bit: CD C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\ASA\win32\
    5) Press Enter. This will change directories to the folder containing dbsrv11.exe. 
    6) To force the recreation of sem5.log, type:
        For 32-bit: dbsrv11 -f "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db"      (There is a space after -f and "C:\...)
        For 64-bit: dbsrv11 -f "C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\db\sem5.db"     (There is a space after -f and "C:\...)
    7) Press Enter
    8) Click Start > Run and type services.msc then click OK
    9) Start the Symantec Endpoint Protection Manager and Symantec Embedded Databaseservices.

    Hope that helps!!



  • 9.  RE: Embedded Database stops regularly-will restart

    Posted Aug 23, 2013 08:01 AM

    Erm, don't do these steps unless you have to, as you will lose any data not yet committed to the DB (this  deletes and recreates the transaction log).  And as such, never do these without first investigating the err.log and out.log files I mentioned earlier.

    Also, the above won't work for your version of SEP.  SEP12.1RU2 requires you use dbsrv12 as per:

    http://www.symantec.com/docs/TECH134782



  • 10.  RE: Embedded Database stops regularly-will restart

    Trusted Advisor
    Posted Aug 23, 2013 08:27 AM

    Hello,

    I agree with SMLatCST. It would important to check your err.log and out.log files before you work on those steps provided above.

    Secondly, when was the last time you restart your server? Consider restarting your server.

    However, you may consider the above steps as an alternative.smiley

    Possibly, you may also check the Disaster recovery steps - http://www.symantec.com/docs/TECH160736

    Hope that helps!!



  • 11.  RE: Embedded Database stops regularly-will restart

    Posted Aug 23, 2013 08:48 AM

    Trying to answer all the questions and give you all the information you requested--

     

    db size - 4g

    sqla000.tmo file size = 270,600

    err.log has only

    08/01 11:28:19. Fatal error:  A disk read from file "C:\Windows\TEMP\sqla0000.tmp" failed with error code: (1167)
    08/15 12:30:18. Fatal error:  A disk read from file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (1167)
    08/19 09:44:02. Fatal error:  A disk read from file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (1167)
    08/20 00:02:24. Fatal error:  A disk write to file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (1167)
    08/22 12:24:33. Fatal error:  A disk read from file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (1167)
    08/22 20:04:22. Fatal error:  A disk read from file "C:\Windows\TEMP\sqla0000.tmp" failed with error code: (1167)
     
    out.log shows (from just before the end)
     
    I. 08/22 11:51:05. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:51
    I. 08/22 11:55:04. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:04. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:04. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:05. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:05. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:05. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:05. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 11:55:05. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 11:55
    I. 08/22 12:11:37. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:11:37. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:11:37. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:11:37. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:11:37. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:11:38. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:11
    I. 08/22 12:17:45. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:46. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:46. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:46. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:46. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:47. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:47. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:47. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:48. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:49. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:49. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:17:49. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:17
    I. 08/22 12:24:29. SQL Anywhere Network Server Version 12.0.1.3554
     
    I. 08/22 12:24:29. OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
    I. 08/22 12:24:29. 
     
    I. 08/22 12:24:29. Copyright © 2001-2012, iAnywhere Solutions, Inc.
    I. 08/22 12:24:29. Portions copyright © 1988-2012, Sybase, Inc. All rights reserved.
    I. 08/22 12:24:29. Use of this software is governed by the Sybase License Agreement.
    I. 08/22 12:24:29. Refer to http://www.sybase.com/softwarelicenses.
    I. 08/22 12:24:29. 
     
    I. 08/22 12:24:29. Connection limit (licensed seats): 1
    I. 08/22 12:24:29. Processors detected: 2 (containing 4 logical processors)
    I. 08/22 12:24:29. Maximum number of physical processors the server will use: 2
    I. 08/22 12:24:29. This server is licensed to:
    I. 08/22 12:24:29.     Symantec Corporation
    I. 08/22 12:24:29.     Symantec Corporation
    I. 08/22 12:24:29. Running Windows 2008 Build 6002 Service Pack 2 on X86 (X86_64)
    I. 08/22 12:24:29. Server built for X86 processor architecture
    I. 08/22 12:24:29. 131072K of memory used for caching
    I. 08/22 12:24:29. Minimum cache size: 131072K, maximum cache size: 131072K
    I. 08/22 12:24:29. Using a maximum page size of 8192 bytes
    I. 08/22 12:24:29. Multiprogramming level: minimum:4, current:80, maximum:320
    I. 08/22 12:24:29. Automatic tuning of multiprogramming level is enabled
    I. 08/22 12:24:29. Starting database "sem5" (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Thu Aug 22 2013 12:24
    I. 08/22 12:24:29. Performance warning: Database file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 328 disk fragments
    I. 08/22 12:24:29. Database recovery in progress
    I. 08/22 12:24:29.     Last checkpoint at Thu Aug 22 2013 12:17
    I. 08/22 12:24:29.     Checkpoint log...
    I. 08/22 12:24:30.     Transaction log: sem5.log...
    I. 08/22 12:24:31.     Rollback log...
    I. 08/22 12:24:31.     Checkpointing...
    I. 08/22 12:24:31. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:24
    I. 08/22 12:24:31. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 12:24
    I. 08/22 12:24:31. Recovery complete
    I. 08/22 12:24:31. Database "sem5" (sem5.db) started at Thu Aug 22 2013 12:24
    I. 08/22 12:24:31. This database is licensed for use with:
    I. 08/22 12:24:31.     Application: Symantec Endpoint Protection Manager
    I. 08/22 12:24:31.     Company: Symantec Corp
    I. 08/22 12:24:31. Performance warning: Server cache size is too small for database "sem5"
    I. 08/22 12:24:31. Database server started at Thu Aug 22 2013 12:24
    I. 08/22 12:24:31. Trying to start SharedMemory link ...
    I. 08/22 12:24:31.     SharedMemory link started successfully
    I. 08/22 12:24:31. Trying to start TCPIP link ...
    I. 08/22 12:24:31. Starting on port 2638
    I. 08/22 12:24:31.     TCPIP link started successfully
    I. 08/22 12:24:31. Now accepting requests
    E. 08/22 12:24:33. Fatal error:  A disk read from file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (1167)
    I. 08/22 12:24:44. Connection terminated abnormally
    I. 08/22 12:24:44. Disconnected TCPIP client's AppInfo: IP=10.0.0.9;HOST=Server2;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE='C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\SemSvc.exe';PID=0x9e4;THREAD=0x14d0;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
    I. 08/22 12:24:44. Connection terminated abnormally
    I. 08/22 12:24:44. Disconnected TCPIP client's AppInfo: IP=10.0.0.9;HOST=Server2;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE='C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\SemSvc.exe';PID=0x9e4;THREAD=0xbd4;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
    I. 08/22 12:24:44. Connection terminated abnormally
    I. 08/22 12:24:44. Connection terminated abnormally
    I. 08/22 12:24:44. Disconnected TCPIP client's AppInfo: IP=10.0.0.9;HOST=Server2;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE='C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\SemSvc.exe';PID=0x9e4;THREAD=0xb0c;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
    I. 08/22 12:24:44. Database server shutdown requested via server console
    I. 08/22 12:24:44. Connection terminated abnormally
    I. 08/22 12:24:44. Disconnected TCPIP client's AppInfo: IP=10.0.0.9;HOST=Server2;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE='C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\SemSvc.exe';PID=0x9e4;THREAD=0x10a8;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
    I. 08/22 19:53:41. SQL Anywhere Network Server Version 12.0.1.3554
     
    I. 08/22 19:53:41. OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
    I. 08/22 19:53:41. 
     
    I. 08/22 19:53:41. Copyright © 2001-2012, iAnywhere Solutions, Inc.
    I. 08/22 19:53:41. Portions copyright © 1988-2012, Sybase, Inc. All rights reserved.
    I. 08/22 19:53:41. Use of this software is governed by the Sybase License Agreement.
    I. 08/22 19:53:41. Refer to http://www.sybase.com/softwarelicenses.
    I. 08/22 19:53:41. 
     
    I. 08/22 19:53:41. Connection limit (licensed seats): 1
    I. 08/22 19:53:41. Processors detected: 2 (containing 4 logical processors)
    I. 08/22 19:53:41. Maximum number of physical processors the server will use: 2
    I. 08/22 19:53:41. This server is licensed to:
    I. 08/22 19:53:41.     Symantec Corporation
    I. 08/22 19:53:41.     Symantec Corporation
    I. 08/22 19:53:41. Running Windows 2008 Build 6002 Service Pack 2 on X86 (X86_64)
    I. 08/22 19:53:41. Server built for X86 processor architecture
    I. 08/22 19:53:41. 131072K of memory used for caching
    I. 08/22 19:53:41. Minimum cache size: 131072K, maximum cache size: 131072K
    I. 08/22 19:53:41. Using a maximum page size of 8192 bytes
    I. 08/22 19:53:41. Multiprogramming level: minimum:4, current:80, maximum:320
    I. 08/22 19:53:41. Automatic tuning of multiprogramming level is enabled
    I. 08/22 19:53:41. Starting database "sem5" (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:41. Performance warning: Database file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 328 disk fragments
    I. 08/22 19:53:41. Database recovery in progress
    I. 08/22 19:53:41.     Last checkpoint at Thu Aug 22 2013 12:24
    I. 08/22 19:53:41.     Checkpoint log...
    I. 08/22 19:53:41.     Transaction log: sem5.log...
    I. 08/22 19:53:41.     Rollback log...
    I. 08/22 19:53:42.     Checkpointing...
    I. 08/22 19:53:42. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:42. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:42. Recovery complete
    I. 08/22 19:53:42. Database "sem5" (sem5.db) started at Thu Aug 22 2013 19:53
    I. 08/22 19:53:42. This database is licensed for use with:
    I. 08/22 19:53:42.     Application: Symantec Endpoint Protection Manager
    I. 08/22 19:53:42.     Company: Symantec Corp
    I. 08/22 19:53:42. Performance warning: Server cache size is too small for database "sem5"
    I. 08/22 19:53:42. Database server started at Thu Aug 22 2013 19:53
    I. 08/22 19:53:42. Trying to start SharedMemory link ...
    I. 08/22 19:53:42.     SharedMemory link started successfully
    I. 08/22 19:53:42. Trying to start TCPIP link ...
    I. 08/22 19:53:42. Starting on port 2638
    I. 08/22 19:53:42.     TCPIP link started successfully
    I. 08/22 19:53:42. Now accepting requests
    I. 08/22 19:53:43. Performance warning: No unique index or primary key for table "SERVER_SYSTEM_LOG_1" in database "sem5"
    I. 08/22 19:53:43. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:44. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:44. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:44. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:45. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:45. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:45. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:45. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:46. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:46. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:46. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:46. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:47. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:47. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:48. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 19:53:48. Finished checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 19:53
    I. 08/22 20:04:21. Starting checkpoint of "sem5" (sem5.db) at Thu Aug 22 2013 20:04
    E. 08/22 20:04:22. Fatal error:  A disk read from file "C:\Windows\TEMP\sqla0000.tmp" failed with error code: (1167)
    I. 08/22 20:04:33. Database server shutdown requested via server console
    I. 08/22 20:04:33. Connection terminated abnormally
    I. 08/22 20:04:33. Disconnected TCPIP client's AppInfo: IP=10.0.0.9;HOST=Server2;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE='C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\SemSvc.exe';PID=0x9e4;THREAD=0x1b0c;VERSION=12.0.1.3554;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
     

    I saved the old sem5.log and did create a new one, verified the Embedded database started, opened the SEPM and verfied clients were online. I then restarted the server. All Symantec services started and clients beginning to show online

    .err.log unchanged

    out.log since restart

    I. 08/23 07:24:51. Finished checkpoint of "sem5" (sem5.db) at Fri Aug 23 2013 07:24
    I. 08/23 07:31:09. Database server shutdown due to machine shutdown
    W. 08/23 07:31:10. TCPIP listener on IP address 127.0.0.1:2638 is exiting
    W. 08/23 07:31:10. TCPIP listener on IP address (::1):2638 is exiting
    I. 08/23 07:31:10. Starting checkpoint of "sem5" (sem5.db) at Fri Aug 23 2013 07:31
    I. 08/23 07:31:11. Finished checkpoint of "sem5" (sem5.db) at Fri Aug 23 2013 07:31
    I. 08/23 07:31:12. Database server stopped at Fri Aug 23 2013 07:31
    I. 08/23 07:36:03. SQL Anywhere Network Server Version 12.0.1.3554
     
    I. 08/23 07:36:03. OEM Authenticated Edition, licensed only for use with authenticated OEM applications.
    I. 08/23 07:36:03. 
     
    I. 08/23 07:36:03. Copyright © 2001-2012, iAnywhere Solutions, Inc.
    I. 08/23 07:36:03. Portions copyright © 1988-2012, Sybase, Inc. All rights reserved.
    I. 08/23 07:36:03. Use of this software is governed by the Sybase License Agreement.
    I. 08/23 07:36:03. Refer to http://www.sybase.com/softwarelicenses.
    I. 08/23 07:36:03. 
     
    I. 08/23 07:36:03. Connection limit (licensed seats): 1
    I. 08/23 07:36:03. Processors detected: 2 (containing 4 logical processors)
    I. 08/23 07:36:03. Maximum number of physical processors the server will use: 2
    I. 08/23 07:36:03. This server is licensed to:
    I. 08/23 07:36:03.     Symantec Corporation
    I. 08/23 07:36:03.     Symantec Corporation
    I. 08/23 07:36:03. Running Windows 2008 Build 6002 Service Pack 2 on X86 (X86_64)
    I. 08/23 07:36:03. Server built for X86 processor architecture
    I. 08/23 07:36:04. 131072K of memory used for caching
    I. 08/23 07:36:04. Minimum cache size: 131072K, maximum cache size: 131072K
    I. 08/23 07:36:04. Using a maximum page size of 8192 bytes
    I. 08/23 07:36:04. Multiprogramming level: minimum:4, current:80, maximum:320
    I. 08/23 07:36:04. Automatic tuning of multiprogramming level is enabled
    I. 08/23 07:36:05. Starting database "sem5" (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Fri Aug 23 2013 07:36
    I. 08/23 07:36:05. Performance warning: Database file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 327 disk fragments
    I. 08/23 07:36:11. Transaction log: sem5.log
    I. 08/23 07:36:13. Starting checkpoint of "sem5" (sem5.db) at Fri Aug 23 2013 07:36
    I. 08/23 07:36:14. Finished checkpoint of "sem5" (sem5.db) at Fri Aug 23 2013 07:36
    I. 08/23 07:36:15. Database "sem5" (sem5.db) started at Fri Aug 23 2013 07:36
    I. 08/23 07:36:15. This database is licensed for use with:
    I. 08/23 07:36:15.     Application: Symantec Endpoint Protection Manager
    I. 08/23 07:36:15.     Company: Symantec Corp
    I. 08/23 07:36:15. Performance warning: Server cache size is too small for database "sem5"
    I. 08/23 07:36:15. Database server started at Fri Aug 23 2013 07:36
    I. 08/23 07:36:15. Trying to start SharedMemory link ...
    I. 08/23 07:36:15.     SharedMemory link started successfully
    I. 08/23 07:36:15. Trying to start TCPIP link ...
    I. 08/23 07:36:15. Starting on port 2638
    I. 08/23 07:36:15.     TCPIP link started successfully
    I. 08/23 07:36:15. Now accepting requests

     

     

     



  • 12.  RE: Embedded Database stops regularly-will restart

    Posted Aug 23, 2013 09:07 AM

    Might be worth running a chkdsk if the disk read errors in the err.log file are anything to go by.

    Also, the below articles suggests the sqla000.tmp files you reported should no longer be created now that you've recreated the transaction log:

    http://www.symantec.com/docs/TECH188303



  • 13.  RE: Embedded Database stops regularly-will restart

    Posted Nov 29, 2013 02:38 AM

     

    Hello SMLatCST, i started seeing this database is down lately at client site... The error is fatal read/write of the hard disk, i keep repairing the DB which does not resolve this... i will run disk check and post the error here too... It`s embarrassing to see read/write error all the time when the hard disk has over 140gb free space, what could be the problem?