Maximo Open Forum

 View Only

 Maximo is down ,shows replication error

  • Everything Maximo
Trisha S's profile image
Trisha S posted 09-19-2023 12:51

Hello Everyone,

Very often from past few weeks we see our non prod environments getting down. SystemErr logs show "transaction log for db is full due to replication" . We have not done any changes in maximo or from db end.

The db team says the log files are increasing in size and thus increasing the disk space but they say replication do not cause extra logs ,they just read logs.

Has anyone faced this kind of situation? How do i troubleshooting or understand how and why suddenly the logs are increasing and application getting down. 

Thanks

Trisha

mark robbins's profile image
mark robbins posted 09-20-2023 09:25

You need the dbas to help you understand what is happening at the database level.

it would be interesting to see the full error message and stack.

How is the replication implemented?

Is there a script / Java class that is copying the data from Maximo to the replica?

If there is a script/Java class then the error may actually be generated by the replica database in response to the replication process.

The DBAs should be able to get you more information about what is happening e.g. which database tables are growing and where the data is being stored.

Jason VenHuizen's profile image
Jason VenHuizen posted 09-20-2023 10:57

First a disclaimer, I am not a DBA and as Mark says you should talk with your DBAs, though it sounds like they are not being particularly helpful.

A quick search turned up this Microsoft discussion that sounds like a similar situation to what you are experiencing. Even if the disk isn't full the logs may become full depending on their limits or possibly the target system is full.  In either case, clearly a database issue that your DB team should address.

https://learn.microsoft.com/en-us/answers/questions/824827/the-transaction-log-for-database-is-full-due-to-re

Related Content