Error during Backup
Moderator: crythias
-
- Znuny newbie
- Posts: 90
- Joined: 24 Mar 2014, 13:58
- Znuny Version: 6.0.26
- Real Name: Krishna M S
- Company: Toradex AG
Error during Backup
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
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
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Error during Backup
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
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
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 90
- Joined: 24 Mar 2014, 13:58
- Znuny Version: 6.0.26
- Real Name: Krishna M S
- Company: Toradex AG
Re: Error during Backup
Hi,
I have already set this to 500M in my my.cnf file. Am i missing out anything?
Regards,
Krishna M S
I have already set this to 500M in my my.cnf file. Am i missing out anything?
Regards,
Krishna M S
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Error during Backup
Maybe you need more or your setting is in the wrong section of my.cnf
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Error during Backup
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
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
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Error during Backup
Hello Emin,
Since when is it necessary to restart the database service when a setting for a client has changed?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 90
- Joined: 24 Mar 2014, 13:58
- Znuny Version: 6.0.26
- Real Name: Krishna M S
- Company: Toradex AG
Re: Error during Backup
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
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
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: Error during Backup
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
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
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny newbie
- Posts: 90
- Joined: 24 Mar 2014, 13:58
- Znuny Version: 6.0.26
- Real Name: Krishna M S
- Company: Toradex AG
Re: Error during Backup
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
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
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Error during Backup
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
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
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?