Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Unable to update the Team Calendar plugin

Frederick Plante
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 3, 2018

Hi everyone,

So I'm currently trying to upgrade our team calendar confluence plugin, but I'm seeing a weird behaviour. There seems to be a database lock when trying to update the plugin.

ID Type Waiting Wait Active Mode DB Table Index Ins Intent Special
201262 RECORD 1 00:09 00:09 X lab_confluence plugindata PRIMARY 0 rec but not gap
[RO] Locks (? for help) localhost, 5d, InnoDB 1s :-), 1.37k QPS, 65/2/0 con/run/cac thds, 5.7.23

________________________________________________ InnoDB Locks ________________________________________________
ID Type Waiting Wait Active Mode DB Table Index Ins Intent Special
201262 RECORD 1 00:10 00:10 X lab_confluence plugindata PRIMARY 0 rec but not gap

This happens everytime I try, and with all versions as well. We are currently using version 5.3.17 and trying to update to the latest since we want to update our confluence instance.

Has this happend to any of you?

We are using the following versions : 

- Confluence 6.12.0

- MySQL 5.7

- JDBC 5.1.42

Thanks!

Frederick

1 answer

1 accepted

0 votes
Answer accepted
Diego
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 12, 2018

Hello there!
In our ticket, we were able to solve the issue at hand by changing the my.cnf file.
The original was


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

symbolic-links=0

lower_case_table_names=1
default-storage-engine=InnoDB
collation_server=utf8_bin
character-set-server=utf8
transaction-isolation=READ-COMMITTED
max_allowed_packet=256M
binlog_format=row
innodb_log_file_size=2G
connect_timeout=1000
innodb_lock_wait_timeout=1000
wait_timeout=57600
interactive_timeout=57600


general_log = on
general_log_file=/var/log/mysql/query.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

and we changed it to:

Important notes

- Always backup your files before changing them
- Never apply changes to the database while Confluence is running
- Always have a rollback plan if things do not go as expected
- Try the changes in a test environment before applying to your production


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

#symbolic-links=0

lower_case_table_names=1

default-storage-engine=InnoDB
collation_server=utf8_bin
character-set-server=utf8
transaction-isolation=READ-COMMITTED
max_allowed_packet=768M
binlog_format=row
innodb_log_file_size=2G

#connect_timeout=1000
#innodb_lock_wait_timeout=1000

wait_timeout=28800

#interactive_timeout=28800

max_connections=500


general_log = on
general_log_file=/var/log/mysql/query.log

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

After changing the .cnf file, the Team Calendars plugin was successfully installed! Also, look out for interference from your anti-virus.
During the troubleshooting, Frederick was able to verify that the anti-virus software was interfering with the installation of other add ons as well.

Important notes

- Always backup your files before changing them
- Never apply changes to the database while Confluence is running
- Always have a rollback plan if things do not go as expected
- Try the changes in a test environment before applying to your production


Thank you for raising this issue with the Community Frederick! Hoping that our thread can help other customers as well.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events