Unexplainable log file growth

book

Article ID: 221316

calendar_today

Updated On:

Products

CA Infrastructure Management

Issue/Introduction

Since last week we have daily logfiles of over 20GB in size. Previously they were about 300MB in size.

More info:
- the log files are in /opt/CA/PerformanceCenter/EM/logs
- they are named 'wrapper-<date>.log'
- the log file of the 22nd was about  220MB, the log file of the 23rd 11GB and the 24th was 32GB.

I did some checking, it seems that there is just one (maybe two) error in the log responsible for the change in size. The error is like this:

-------------------------
INFO   | jvm 1    | 2021/06/29 00:00:34 |       | org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [INSERT INTO item_grouppath_work(ItemID, GroupPath) VALUES (15882479,'#1#12402876#12402879#12402878#4#12402873#5#12402872#12402874#12402869#9#12402868#12402871#11#12402870#12#12402865#13#12402864#12402867#12402866#12357804#12402860#12402863#12402862#12402858#12402853#12402855#12357792#12402849#12402848#12402851#11825300#33#12402844#12402846#12357784#12402840#12357786#12402842#12402836#12357782#12402838#12357776#12357779#12402834#11825284#12357772#11825285#12402
...
.... 12G of text!!!!!!
...
 49#12402448#12402451#12402450#12402445#12402444#12402447#12402446#12402441#12402443#12402442#12402437#12402436#12402439#12402438#12287749#12402435#12287748#12287867#12402557#12402532#12402531#12402520#12287818#12402504#12402507#12287808#12402498#')]; Packet for query is too large (91940805 > 67108864). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (91940805 > 67108864). You can change this value on the server by setting the max_allowed_packet' variable.
-------------------------



Cause

Possible reasons for increase in log size

1. added new low level group 

2. added more items to a low level group.

3.Ran full EM sync

Environment

Release :20.2

Component :IMADMN

Resolution

Login to CAPC server

 

Edit /etc/my.cnf 

Change max_allowed_packet setting value

From

max_allowed_packet=64MB

To
max_allowed_packet=128MB

 

Recycle mysql services

service mysql stop 

service mysql start