Ai cứu em với "The transaction log for database 'MuOnline' is full"

[bkromeo]

Titanlink cứ báo bị full hoài mà ko hiểu nguyên nhân tại sao bác nào khắc phục dùm em với.

Yahoo: a_g

Có cảm ơn và hậu tại.

SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:03 UPDATE Character SET MagicList=? WHERE Name='Kill1994'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:03 UPDATE Character SET Quest=? WHERE Name='Kill1994'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:03 EXEC WZ_GetItemSerial
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:03 EXEC WZ_GetItemSerial
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:04 SELECT cLevel, Class, LevelUpPoint, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, DbVersion, Leadership, ChatLimitTime, FruitPoint, SCFExtInventory, SCFUpdatedPShop FROM Character WHERE Name='CanCuu' AND AccountID='khoanhotg'
15:35:04 SELECT Inventory from Character where Name='CanCuu'
15:35:04 SELECT MagicList from Character where Name='CanCuu'
15:35:04 SELECT Quest from Character where Name='CanCuu'
15:35:04 UPDATE AccountCharacter SET GameIDC='CanCuu' WHERE Id='khoanhotg'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:04 SELECT * FROM OptionData WHERE Name='CanCuu'
15:35:04 [WzExDB] [ExDB][Guild Member Info Request] Member [CanCuu].
15:35:04 SELECT G_Name, G_Level, G_Status FROM GuildMember where Name='CanCuu'
15:35:04 SELECT Name FROM MuOnline.dbo.OfficialHelper WHERE Name = 'CanCuu'
15:35:04 SELECT SCFMasterLevel, SCFMasterPoints, Resets, SCFPCPoints, SCFSealItem, SCFSealTime, SCFScrollItem, SCFScrollTime, SCFMarried, SCFMarryHusbandWife, SCFGensFamily, SCFGensContribution,SCFGensRank,SCFGensRecvReward, SCFGensDD = (CAST((DATEDIFF(dd,SCFGensDateLeave,GETDATE())) as int)+1) FROM MuOnline.dbo.Character WHERE Name = 'CanCuu'
15:35:04 [WzExDB] [ExDB][Send Guild Member Info] No info returned from sManager->db.
15:35:04 SELECT Name FROM MuOnline.dbo.SCFS5Quest WHERE Name = 'CanCuu' and AccountID = 'khoanhotg'
15:35:04 SELECT SCFS5Quest FROM MuOnline.dbo.SCFS5Quest where Name = 'CanCuu' and AccountID = 'khoanhotg'
15:35:04 [WzExDB] [ExDB][Friend List Request] Name[CanCuu].
15:35:04 SELECT GUID, MemoTotal FROM T_FriendMain where Name = 'CanCuu'
15:35:04 SELECT FriendGuid, FriendName, Del FROM T_FriendList where GUID = 49969
15:35:04 [WzExDB] [ExDB][Friend List Send] Name[CanCuu].
15:35:04 [WzExDB] [ExDB][Friend List Send] Friend Count[0].
15:35:04 SELECT FriendName FROM T_WaitFriend where GUID=49969
[WzExDB] [ExDB][Mail List Request] Name[CanCuu].
15:35:04 [WzExDB] [ExDB][Mail List Send] Name[CanCuu].
15:35:04 SELECT MemoIndex, FriendName, wDate, Subject, bRead FROM T_FriendMail where GUID=49969
15:35:04 [WzExDB] [ExDB][Mail List Send] Mail Count: 0.
[PostServer] [PostServer][1][GS:1](Garen) )))))
15:35:04 UPDATE Character SET cLevel=400,Class=96,LevelUpPoint=1500, Experience=0, Strength=32, Dexterity=27, Vitality=25, Energy=20, Money=5000000, Life=60, MaxLife=6186, Mana=4390, MaxMana=4390, MapNumber=0, MapPosX=145, MapPosY=136, MapDir=4, PkCount=0, PkLevel=3, PkTime=522, DbVersion=3, Leadership=0, ChatLimitTime=0, FruitPoint=0, SCFExtInventory=0, SCFUpdatedPShop=1 WHERE Name = 'MayMuonSao'
15:35:04 EXEC WZ_DISCONNECT_MEMB 'saygaboy'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:04 UPDATE Character SET Inventory=? WHERE Name='MayMuonSao'
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
[Player] saygaboy has been deleted
SQLSTATE:42000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MuOnline' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
15:35:04 UPDATE Character SET MagicList=? WHERE Name='MayMuonSao'

[Jackieldm]

Cái này bạn làm thử nha, Properties cái DB MuOnline => Chọn Options => Recovery Mode Chọn Simple xem sao. Ngày trước mình dính xong chọn lại là hết đó bạn.
Dính cái khởi động server chạy chút văng ra, rất khó chịu. Trước khi dính cái này không biết bạn có chạy cái Query nào mang tính chất giảm log db hay không, nếu có thì có thể do nó gây ra đó chuyển cái Recovery Mode là mọi chuyện sẽ ổn đi. Chúc bạn may mắn

[Only registered and activated users can see links. ]

[lequangvu]

Đây đã có cao thủ từng bị chỉ cho bạn rồi nè, vào xem mà fix thử

[bkromeo]

Bị Full log xóa log và db đi thay DB khác vào lại ngon lành các bác ợ.