can't create a backup

Question

Hello,

Problem 1:

I'm unable to create a backup from my confluence instance.
When i start a backup either using the scheduled job or manually, i get a 502 timeout proxy error.

Problem 2:

This might cause the problem of not being able to backup the system, i'm also unable to reindex the confluence instance. when i try to do so i get the following error

2020-01-02 13:30:57,648 WARN [alert-dispatch:thread-1] [confluence.alert-log] log 1577968257565 ; WARNING ; JVM ; JVM-1002 ; Garbage collection exceeded time limit ; not-detected ;  ;  ; {"durationInMillis":2770,"windowInMillis":2$

2020-01-02 13:30:57,650 WARN [alert-dispatch:thread-1] [atlassian-monitor] log 2020-01-02T12:30:57.565Z Component 'Java' alerted 'Garbage collection exceeded time limit' (details: {"durationInMillis":2770,"windowInMillis":20000,"l$

2020-01-02 13:31:27,487 WARN [alert-dispatch:thread-1] [confluence.alert-log] log 1577968287484 ; WARNING ; OS ; OS-1001 ; Low free memory ; not-detected ;  ;  ; {"freeInMegabytes":80,"totalInMegabytes":8005,"minimumInMegabytes":2$

2020-01-02 13:31:27,489 WARN [alert-dispatch:thread-1] [atlassian-monitor] log 2020-01-02T12:31:27.484Z Component 'Operating System' alerted 'Low free memory' (details: {"freeInMegabytes":80,"totalInMegabytes":8005,"minimumInMegab$

i allocated a total of 3GB for my confluence instance.

If there is more information needed about this problem, please feel free to ask me.

Tom Lakerveld · Answer

When i try to dump my database using mysqldump command i get the following message:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `plugindata` at row: 3

when changing the "max_allowed_packet" size, the same error is shown.

Tom Lakerveld · Answer

Hello JP,

Thanks for answering to my questions.

Confluence instance:

It's not a big instance of confluence, we got about 30 spaces and somewhere around 90 users.

We use the following version/systems:

- Confluence Server 6.13.10.
- Linux/apache2 server.
- mysql version 5.5.62
- total memory: 8GB

Errors/Warnings:

I get the following messages in my confluence logs, when clicking on the "create backup" button on admin/backup.action

2020-01-03 12:42:16,718 WARN [alert-dispatch:thread-1] [confluence.alert-log] log 1578051736676 ; WARNING ; JVM ; JVM-1002 ; Garbage collection exceeded time limit ; not-detected ;  ;  ; {"durationInMillis":2101,"windowInMillis":20000,"limitPercent":10,"threadMemoryAllocations":"","threadDump":[]}

2020-01-03 12:42:16,724 WARN [alert-dispatch:thread-1] [atlassian-monitor] log 2020-01-03T11:42:16.676Z Component 'Java' alerted 'Garbage collection exceeded time limit' (details: {"durationInMillis":2101,"windowInMillis":20000,"limitPercent":10,"threadMemoryAllocations":"","threadDump":[]}, trigger: {"pluginKey": "not-detected"})

2020-01-03 12:42:26,061 WARN [http-nio-8090-exec-12] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:

->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1926390826)

-- url: /rest/mywork/1/notification/metadata | traceId: ad0ea01bcc408198

2020-01-03 12:42:26,065 ERROR [http-nio-8090-exec-12] [atlassian.confluence.event.ConfluenceEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.confluence.event.events.security.LogoutEvent[source=com.atlassian.confluence.user.listeners.UserSessionExpiryListener@4ff3be48]] from the invoker [com.atlassian.confluence.event.ConfluenceListenerHandlersConfiguration$TimingListenerHandler$1$1@7d696714]

Thanks in advance,

Tom

JP _AC Bielefeld Leader_ · Answer

Hi,

is this a huge Confluence installation you're trying to backup? Could you give us some info on OS & Confluence version?

Creating a backup using this method is not recommended for large installations. I would try to stop Confluence, take a file based backup of the installation & data directory & a backup of the Confluence database. Restart the server after these steps.

Best

JP