Cannot pull from Wp-engine

Hi Everyone,
I’m wondering if anyone else is getting these errors. I’m using a windows 10 machine.
I have made sure that local is up to date.

Please see attached image for error and I have also attached the logs from wp local.

{"thread":"main","class":"DeleteSiteService","level":"warn","message":"Could not trash","timestamp":"2023-01-05T11:39:07.800Z"}
{"thread":"main","reason":{},"p":{},"eventId":"e8455420c11e4f32a16d04aef2f5c45a","level":"warn","message":"Unhandled Rejection.","timestamp":"2023-01-05T11:39:35.212Z"}
{"thread":"main","reason":{},"p":{},"eventId":"062935008f974628914586ffd04c85dc","level":"warn","message":"Unhandled Rejection.","timestamp":"2023-01-05T11:39:35.227Z"}
{"thread":"main","reason":{},"p":{},"eventId":"69f64e83d3c746c8bb3a79e92eef15d2","level":"warn","message":"Unhandled Rejection.","timestamp":"2023-01-05T11:39:35.236Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:07.533373Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 16916","timestamp":"2023-01-05T11:45:11.205Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:07.535169Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2023-01-05T11:45:11.206Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:11.010728Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-01-05T11:45:11.207Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:11.205866Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10090  MySQL Community Server - GPL.","timestamp":"2023-01-05T11:45:11.207Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:42.191874Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 29008","timestamp":"2023-01-05T11:45:47.742Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:42.195838Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2023-01-05T11:45:47.743Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:46.352874Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2023-01-05T11:45:47.744Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:46.361576Z 0 [System] [MY-010232] [Server] Crash recovery finished.","timestamp":"2023-01-05T11:45:47.745Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:47.637463Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-01-05T11:45:47.746Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-01-05T11:45:47.744064Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10023  MySQL Community Server - GPL.","timestamp":"2023-01-05T11:45:47.747Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqladmin.exe ping\n\u0007mysqladmin: connect to server at '::1' failed\r\nerror: 'Can't connect to MySQL server on '::1' (10061)'\r\nCheck that mysqld is running on ::1 and that the port is 10052.\r\nYou can check this by doing 'telnet ::1 10052'\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"error","message":"Database did NOT respond to ping after 15 tries.","timestamp":"2023-01-05T11:45:55.206Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqladmin.exe ping\n\u0007mysqladmin: connect to server at '::1' failed\r\nerror: 'Can't connect to MySQL server on '::1' (10061)'\r\nCheck that mysqld is running on ::1 and that the port is 10052.\r\nYou can check this by doing 'telnet ::1 10052'\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"error","message":"Database did NOT respond to ping after 15 tries.","timestamp":"2023-01-05T11:45:55.454Z"}
{"thread":"main","class":"DevKitService","message":"Could not create directory '/home/timwi/.ssh'.\r\n","level":"warn","timestamp":"2023-01-05T11:46:15.346Z"}
{"thread":"main","class":"DevKitService","message":"Failed to add the host to the list of known hosts (/home/timwi/.ssh/known_hosts).\r\n","level":"warn","timestamp":"2023-01-05T11:46:15.473Z"}
{"thread":"main","class":"DevKitService","message":"wpe_cli+rsync+pull+inflightdub@inflightdub.ssh.wpengine.net: Permission denied (publickey).\r\n","level":"warn","timestamp":"2023-01-05T11:46:15.912Z"}
{"thread":"main","class":"DevKitService","message":"rsync: connection unexpectedly closed (0 bytes received so far) [Receiver]\n","level":"warn","timestamp":"2023-01-05T11:46:15.915Z"}
{"thread":"main","class":"DevKitService","message":"rsync error: error in rsync protocol data stream (code 12) at io.c(226) [Receiver=3.1.2]\n","level":"warn","timestamp":"2023-01-05T11:46:15.915Z"}
{"thread":"main","class":"DevKitService","message":"Could not create directory '/home/timwi/.ssh'.\r\n","level":"warn","timestamp":"2023-01-05T11:46:29.126Z"}
{"thread":"main","class":"DevKitService","message":"Failed to add the host to the list of known hosts (/home/timwi/.ssh/known_hosts).\r\n","level":"warn","timestamp":"2023-01-05T11:46:29.262Z"}
{"thread":"main","class":"DevKitService","message":"wpe_cli+db+pull+inflightdub@inflightdub.ssh.wpengine.net: Permission denied (publickey).\r\n","level":"warn","timestamp":"2023-01-05T11:46:29.548Z"}
{"thread":"main","class":"ImporterWPE","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';","level":"error","stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","message":"Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n","timestamp":"2023-01-05T11:46:36.381Z"}
{"thread":"main","class":"ImporterWPE","stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"warn","message":"Unable to import site.","timestamp":"2023-01-05T11:46:36.382Z"}
{"thread":"main","class":"DevKitService","message":"Could not create directory '/home/timwi/.ssh'.\r\n","level":"warn","timestamp":"2023-01-05T12:01:58.914Z"}
{"thread":"main","class":"DevKitService","message":"Failed to add the host to the list of known hosts (/home/timwi/.ssh/known_hosts).\r\n","level":"warn","timestamp":"2023-01-05T12:01:59.052Z"}
{"thread":"main","class":"DevKitService","message":"wpe_cli+rsync+pull+inflightdub@inflightdub.ssh.wpengine.net: Permission denied (publickey).\r\n","level":"warn","timestamp":"2023-01-05T12:01:59.316Z"}
{"thread":"main","class":"DevKitService","message":"rsync: connection unexpectedly closed (0 bytes received so far) [Receiver]\nrsync error: error in rsync protocol data stream (code 12) at io.c(226) [Receiver=3.1.2]\n","level":"warn","timestamp":"2023-01-05T12:01:59.319Z"}
{"thread":"main","class":"DevKitService","message":"Could not create directory '/home/timwi/.ssh'.\r\n","level":"warn","timestamp":"2023-01-05T12:02:19.620Z"}
{"thread":"main","class":"DevKitService","message":"Failed to add the host to the list of known hosts (/home/timwi/.ssh/known_hosts).\r\n","level":"warn","timestamp":"2023-01-05T12:02:19.749Z"}
{"thread":"main","class":"DevKitService","message":"wpe_cli+db+pull+inflightdub@inflightdub.ssh.wpengine.net: Permission denied (publickey).\r\n","level":"warn","timestamp":"2023-01-05T12:02:20.005Z"}
{"thread":"main","class":"ImporterWPE","code":1,"killed":false,"signal":null,"cmd":"%%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';","level":"error","stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","message":"Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n","timestamp":"2023-01-05T12:02:22.283Z"}
{"thread":"main","class":"ImporterWPE","stack":"Error: Command failed: %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysql.exe local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = 'siteurl';\nERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist\r\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:302:5)","level":"warn","message":"Unable to import site.","timestamp":"2023-01-05T12:02:22.283Z"}

Fixed the Issue had to disconnect from wp-engine and regen credentials

1 Like

Hi @TimWild - Glad to hear it! This is a frequent step for WPE users that we are looking to improve in the future. For any future users you can find information here:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.