DK0029 Cant create mysql dump

DevKinsta Bug Reports
1

Q: Date/Time this occurred (Provide your time zone also)
A:

Q: DevKinsta Version
A: latest 2.13.6

Q: OS Version
A: Win 11

Q: Docker Desktop Version
A: 4.83

Q: Were any error codes or messages observed? If so, what were they?
A: during p[ull ad the error itself was taken from main.log file

Q: Detailed Description of the Problem
A:

I have a problem with pulling from the live site to local. It stalls every time on the mysql dump operation with the following error every time:
error in operation SITE_PULL, step dumpDb: Error - DK0029: MYSQL_DUMP_COMMON: Error (3): omysqldump: Error 2013: Lost connection to server during query when dumping table wp4bd_options at row: 7804
This happens every time as this exact row. Any help appreciated.

2

Hello there :waving_hand: This sounds like there’s a row that cannot be dumped for some reason.

Can you please send us the main.log so we can check in detail?

Feel free to send it in DM to @jackirish and me at @VladimirM :folded_hands:

3

Thanks guys. I’ll send you both a DM with the log file now.

8

Hi @bendb ! Thank you for your patience.

Can you please try again now? I checked the site and saw that the max_packet_sizefor MariaDB was being reached on a number of database requests, so I’ve bumped that up here. I believe that should help, but if it fails again, it may need to be larger.

9

Hi Jack,

Looks like it’s still failing - just tried again this morning with the same error code appearing.

Can the max_packet_size be increased further?

Thanks