Problem getting export 6.0.29 - package_repository - [SOLVED]

Moderator: crythias

Post Reply
kruegerM
Znuny expert
Posts: 213
Joined: 02 Dec 2010, 16:53
Znuny Version: 6.0.29
Real Name: Marc
Company: National Jewish Health
Location: Denver, CO

Problem getting export 6.0.29 - package_repository - [SOLVED]

Post by kruegerM »

After migrating to 6.0.29, we are getting the following error trying to do an export (mysqldump):

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

we have increased the max_allowed_packet in my.cnf to 3000M - still getting the error.

Any ideas/suggestions?

M
Last edited by kruegerM on 26 Oct 2020, 20:46, edited 1 time in total.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Problem getting export 6.0.29 - package_repository

Post by jojo »

mysqldump wants its own setting in the my.cnf (or as command line option)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
zzz
Znuny superhero
Posts: 889
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: Problem getting export 6.0.29 - package_repository

Post by zzz »

Just add '--max_allowed_packet=512M' to your mysqldump command.

— Emin
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
kruegerM
Znuny expert
Posts: 213
Joined: 02 Dec 2010, 16:53
Znuny Version: 6.0.29
Real Name: Marc
Company: National Jewish Health
Location: Denver, CO

Re: Problem getting export 6.0.29 - package_repository - [SOLVED]

Post by kruegerM »

Thank you - both solutions work - we'll stick with adding the [mysqldump] section to my.cnf
Post Reply