Can’t create mysql dump DK0029

Hi,

I just install docker and Kinsta on Windows 10,
I tried to import a website from KInsta but got DK0029 with those logs :

2023/01/28 22:29:02 [error] 80#80: *272 FastCGI sent in stderr: "PHP message: Xdebug: [Log Files] File '/var/log/fpm/xdebug.log' could not be opened.PHP message: Xdebug: [Step Debug] Could not connect to debugging client. Tried: host.docker.internal:9000 (through xdebug.client_host/xdebug.client_port) :-(" while reading response header from upstream, client: 172.172.0.3, server: marcia-test-1.local, request: "POST /wp-cron.php?doing_wp_cron=1674944942.7635939121246337890625 HTTP/1.1", upstream: "fastcgi://172.172.0.3:9003", host: "marcia-test-1.local", referrer: "http://marcia-test-1.local/wp-cron.php?doing_wp_cron=1674944942.7635939121246337890625"
2023/01/28 22:29:05 [error] 80#80: *276 FastCGI sent in stderr: "PHP message: Xdebug: [Log Files] File '/var/log/fpm/xdebug.log' could not be opened.PHP message: Xdebug: [Step Debug] Could not connect to debugging client. Tried: host.docker.internal:9000 (through xdebug.client_host/xdebug.client_port) :-(" while reading response header from upstream, client: 172.172.0.3, server: marcia-test-1.local, request: "GET / HTTP/1.1", upstream: "fastcgi://172.172.0.3:9003", host: "marcia-test-1.local", referrer: "https://marcia-test-1.local/"
2023/01/28 22:29:05 [error] 80#80: *276 FastCGI sent in stderr: "PHP message: Xdebug: [Step Debug] Could not connect to debugging client. Tried: host.docker.internal:9000 (through xdebug.client_host/xdebug.client_port) :-(PHP message: Xdebug: [Step Debug] Could not connect to debugging client. Tried: host.docker.internal:9000 (through xdebug.client_host/xdebug.client_port) :-(" while reading upstream, client: 172.172.0.3, server: marcia-test-1.local, request: "GET / HTTP/1.1", upstream: "fastcgi://172.172.0.3:9003", host: "marcia-test-1.local", referrer: "https://marcia-test-1.local/"

Can you help me please ?

Hello @Doriane :wave: Welcome to DevKinsta community!

The DK0029 error (during the site pull/import site from MyKinsta) usually means DevKinsta is unable to create a MySQL dump on the remote server.

So that we can check and review this case further, could you please send (DM) me the main.log file of your DevKinsta application? You can check here to see how to see/get that main.log file.

Cheers,
Agus

Hello again Doriane :slight_smile:

I’ve checked the main.log file you sent (DM) me and noticed these for example (saw these error DK0029 have been recorded there for several times).

[2023-01-28 23:29:41.442] [warn]  [dumpSiteDatabase] Some warnings from mysql: {mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `your_wp_xxxxxxx_options` at row: 904 
[2023-01-28 23:29:41.443] [error] Error - DK0029: MYSQL_DUMP_COMMON: Error (3): {mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `your_wp_xxxxxxx_options` at row: 904

(Note: I changed that your_wp_xxxxxxx_options table name on purpose here, for security reason, but you can also check the main.log with your text editor on your computer and seach for the DK0029: MYSQL_DUMP_COMMON keyword for example. ).

So the issue here indeed due to DevKinsta was unable to create a MySQL dump on the remote server, as shown in that error ( mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table ).

For this case, please kindly reach out to our support ( via chat from my.kinsta.com) and ask them to temporarily increase the " max_allowed_packet " value (let’s say to 64M) for the [mysqldump] section of your site in question (hosted on our Kinsta server).

Then once updated, you may want to give it a try to pull / import the site in question to your DevKinsta (to your local computer), and see if it’s no longer throwing DK0029 error message.

Cheers,
Agus

Hi Agus,
I will ask them,

Many thanks
Doriane

Alright!

You’re most welcome Doriane :smiley:

Cheers,
Agus