activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alnaimi.aysha@gmail.com" <alnaimi.ay...@gmail.com>
Subject Re: ActiveMQ is causing the database log to grow huge
Date Thu, 08 Sep 2016 08:58:30 GMT
Thankx Tim,
Actually I can capture what is running against the database in different
time and every time it shows me this:

session_id

Login Name

Database

Begin Time

Log Records

Log Bytes Used

Log Bytes Rsvd

statement_text

Last T-SQL Text

65

db_user

dbname

51:05.5

33097

4104092

7142883

NULL

(@p1 bigint)UPDATE ACTIVEMQ_LOCK SET TIME =  @p1  WHERE ID = 1





















On Wed, Sep 7, 2016 at 8:41 AM, Tim Bain [via ActiveMQ] <
ml-node+s2283324n4716226h67@n4.nabble.com> wrote:

> Nothing says that the open transaction is the same transaction at time A
> and time B; I've been repeatedly unable to truncate a table in Oracle (in
> an application unrelated to ActiveMQ, but it illustrates the point)
> because
> there were lots and lots of transactions per second against the table.  As
> such, your conclusion/assumption that there's a single open transaction
> that remains open for a long period of time may be inaccurate.  (Or it may
> not, but unless you've got something concrete to prove that the same
> transaction is alive between the two points in time, I'd assume that's not
> it.)  In either case, I'm not aware of a way to force a running broker to
> commit any particular database connection.
>
> I'd suggest you contact Blackboard for advice on how to manage their
> application; they might have a way to suspend the system to allow the
> broker's database to be cleaned up.
>
> Tim
>
> On Tue, Sep 6, 2016 at 2:08 AM, [hidden email]
> <http:///user/SendEmail.jtp?type=node&node=4716226&i=0> <
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4716226&i=1>>
> wrote:
>
> > Hi ,we have Blackboard application which use ActiveMQ, it is causing the
> > database to grew huge in size , we can't truncate because there is
> always
> > active transaction. transaction Logs never get cleared out after taking
> > backup  due to an open transaction. , s there any way to force AMQ to
> > commit
> > the transaction on a schedule? or what else could be preventing the
> commit
> > from  happening .
> >
> >
> >
> > --
> > View this message in context: http://activemq.2283324.n4.
> > nabble.com/ActiveMQ-is-causing-the-database-log-to-
> > grow-huge-tp4716176.html
> > Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://activemq.2283324.n4.nabble.com/ActiveMQ-is-
> causing-the-database-log-to-grow-huge-tp4716176p4716226.html
> To unsubscribe from ActiveMQ is causing the database log to grow huge, click
> here
> <http://activemq.2283324.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4716176&code=YWxuYWltaS5heXNoYUBnbWFpbC5jb218NDcxNjE3NnwtMTQ2MTk0MTYwMg==>
> .
> NAML
> <http://activemq.2283324.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://activemq.2283324.n4.nabble.com/ActiveMQ-is-causing-the-database-log-to-grow-huge-tp4716176p4716293.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message