Error during Backup

[msksharma]

Hi,

I am getting this error while trying to take a backup of OTRS

root@otrs-test:/opt/otrs/scripts# ./backup.pl -d /mnt/backup
Backup /mnt/backup/2020-10-27_03-38/Config.tar.gz ... done
Backup /mnt/backup/2020-10-27_03-38/Application.tar.gz ... done
Dump MySQL data to /mnt/backup/2020-10-27_03-38/DatabaseBackup.sql.gz ... mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `article_data_mime_attachment` at row: 21926
failed
Deleting incomplete backup /mnt/backup/2020-10-27_03-38 ... done
[Tue Oct 27 06:12:02 2020] backup.pl: Backup failed
root@otrs-test:/opt/otrs/scripts#

Please help me out.

Regards,
Krishna M S

[root]

Hi,

from the error message I assume two things to fix:

- the permission of OTRS' database user, I always grant all permission on the otrs database
- increases the setting max_allowed_packet in your global my.cnf, the location deepends of your distribution or add a ~/.my.cnf for the otrs user with the setting

- Roy

[msksharma]

Hi,

I have already set this to 500M in my my.cnf file. Am i missing out anything?

Regards,
Krishna M S

[root]

I have already set this to 500M in my my.cnf file. Am i missing out anything?

Maybe you need more or your setting is in the wrong section of my.cnf

- Roy

[zzz]

Hello Krishna,

Yesterday we had a similar problem on the forum.
Add max_allowed_packet=512M to the [mysqldump] section in your my.cnf and restart your database service.

Best regards
Emin

[root]

Add max_allowed_packet=512M to the [mysqldump] section in your my.cnf and restart your database service.

Hello Emin,

Since when is it necessary to restart the database service when a setting for a client has changed?

- Roy

[msksharma]

Hi,

I did everything as u suggested and restarted the service. I still get the same error

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

[mysqldump]
quick
quote-names
#max_allowed_packet = 16M
max_allowed_packet = 1024M

Regards,
Krishna M S

[zzz]

Hey Roy,

Thanks for pointing that out. You're correct, the setting is a dynamic, client-sided value and doesn't require a restart of the database server.

@Krishna: Check if you have files that overwrite your settings (custom directories).

Best regards
Emin

[msksharma]

Hi,

I do not have any other settings defined.

I do not if this is due to a specific attachment. Since the error always shows up at this particular row.

Is there a way to find out?

Regards,
Krishna M S

[root]

Hi,

You can check the size of each records columns content for the affected table to geet more details. Your DBA should be able to assist you.

- Roy