MS SQL server log file shrink failed while AMQ DB maintenance.

Solution Verified - Updated -

Issue

  • AMQ is using MS SQL Server as the message store. When attempting to shrink the database log, the following error is encountered.
Cannot shrink log file 2 (sgamqxd1_log) because the logical log file located at the end of the file is in use.
DbId   FileId      CurrentSize MinimumSize UsedPages   EstimatedPages
------ ----------- ----------- ----------- ----------- --------------
8      2           29640       1280        29640       1280
  • Only after stopping AMQ services, the shrink completed successfully. It seems that there is uncommitted transactions in the DB, causing the DB logs to be locked (in used).

Environment

  • Red Hat JBoss A-MQ
    • 6.1.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.