Uh-oh! Unable to import site. (autoload.sql)

Support
1

What issue or error are you experiencing?

Trying to setup a new site and pull from WPengine

Uh-oh! Unable to import site.
Error: Local was unable to import the following SQL files:

• /app/public/_wpeprivate/autoload.sql

It doesn’t look like wp-config was setup correctly either. I have half a dozen sites setup and pulled down no problem. This seems to be either a new problem, or something specific to this install

It does seem to be complaining about a duplicate primary key, but doesn’t say what table and not sure whether or not its related

Local
Local1370×762 82.2 KB

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

System Details

  • Local Version:

  • Operating System (OS) and OS version:

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

{"class":"ImporterWPE","level":"error","message":"Unable to import /Users/todd/sites/yak-local/app/public/_wpeprivate/autoload.sql","stack":"Error: ERROR 1062 (23000) at line 497: Duplicate entry '24981-???-0' for key 'PRIMARY'\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-08-16T15:34:46.970Z"}
{"class":"ImporterWPE","level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/public/_wpeprivate/autoload.sql\n    at ImporterWPE.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","thread":"main","timestamp":"2024-08-16T15:34:46.972Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:39:57.864Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:41:05.449Z"}
{"class":"ImporterWPE","level":"error","message":"Unable to import /Users/todd/sites/yak-local/app/public/_wpeprivate/autoload.sql","stack":"Error: ERROR 1062 (23000) at line 497: Duplicate entry '24981-???-0' for key 'PRIMARY'\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-08-16T15:43:38.596Z"}
{"class":"ImporterWPE","level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/public/_wpeprivate/autoload.sql\n    at ImporterWPE.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","thread":"main","timestamp":"2024-08-16T15:43:38.598Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:44:11.086Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:44:49.895189Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 29895","process":"mysql","thread":"main","timestamp":"2024-08-16T15:44:52.000Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:44:49.899018Z 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.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:44:52.001Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:44:49.900117Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2024-08-16T15:44:52.001Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:44:51.979037Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:44:52.002Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:44:52.000009Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld: ready for connections. Version: '8.0.16'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10039  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:44:52.002Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:45:12.474Z"}
{"class":"ImporterWPE","level":"error","message":"Unable to import /Users/todd/sites/yak-local/app/public/_wpeprivate/autoload.sql","stack":"Error: ERROR 1062 (23000) at line 497: Duplicate entry '24981-???-0' for key 'PRIMARY'\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-08-16T15:47:58.780Z"}
{"class":"ImporterWPE","level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/public/_wpeprivate/autoload.sql\n    at ImporterWPE.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","thread":"main","timestamp":"2024-08-16T15:47:58.782Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:50:41.394Z"}
{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to connectManifestWpeService:create","stringifiedCallback":"(e,t,i,n,s,r,a,o)=>this.create(e,t,i,n,s,r,a,o)","thread":"main","timestamp":"2024-08-16T15:55:40.628Z"}
{"level":"warn","linuxEdition":null,"localVersion":"9.0.5+6706","message":"Electron Event ready","osArch":"x64","osPlatform":"darwin","osRelease":"23.5.0","timestamp":"2024-08-16T15:55:41.159Z","windowsEdition":null}
{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to connectManifestWpeService:create","stringifiedCallback":"(e,t,i,n,s,r,a,o)=>this.create(e,t,i,n,s,r,a,o)","thread":"main","timestamp":"2024-08-16T15:57:23.812Z"}
{"level":"warn","linuxEdition":null,"localVersion":"9.0.5+6706","message":"Electron Event ready","osArch":"x64","osPlatform":"darwin","osRelease":"23.5.0","timestamp":"2024-08-16T15:57:24.288Z","windowsEdition":null}
{"class":"Process","level":"warn","message":"2024-08-16T15:58:20.851807Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 36256","process":"mysql","thread":"main","timestamp":"2024-08-16T15:58:21.239Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:58:20.853061Z 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.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:58:21.240Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:58:20.853738Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2024-08-16T15:58:21.240Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:58:21.221524Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:58:21.240Z"}
{"class":"Process","level":"warn","message":"2024-08-16T15:58:21.238977Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld: ready for connections. Version: '8.0.16'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10039  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2024-08-16T15:58:21.241Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T15:59:29.980Z"}
{"class":"ImporterWPE","level":"error","message":"Unable to import /Users/todd/sites/yak-board-site/app/public/_wpeprivate/autoload.sql","stack":"Error: ERROR 1062 (23000) at line 497: Duplicate entry '24981-???-0' for key 'PRIMARY'\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-08-16T16:02:10.291Z"}
{"class":"ImporterWPE","level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/public/_wpeprivate/autoload.sql\n    at ImporterWPE.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","thread":"main","timestamp":"2024-08-16T16:02:10.293Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T16:02:23.056Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T16:14:34.790Z"}
{"class":"ImporterWPE","level":"error","message":"Unable to import /Users/todd/sites/yak-board-site/app/public/_wpeprivate/autoload.sql","stack":"Error: ERROR 1062 (23000) at line 497: Duplicate entry '24981-???-0' for key 'PRIMARY'\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)","thread":"main","timestamp":"2024-08-16T16:17:19.259Z"}
{"class":"ImporterWPE","level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/public/_wpeprivate/autoload.sql\n    at ImporterWPE.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)","thread":"main","timestamp":"2024-08-16T16:17:19.261Z"}
{"class":"SshService","level":"warn","message":"Warning: Permanently added 'yak.ssh.wpengine.net' (RSA) to the list of known hosts.\r\n","thread":"main","timestamp":"2024-08-16T16:18:50.239Z"}

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

2

Hi @todditron

Another WPE user ran into this here and one of the Devs provided some helpful tips that might be useful for troubleshooting:

3

Thanks for getting back to me. Could be a similar issue, or something else. That file '_wpeprivate/autoload.sql` only exists briefly and then gets cleared. I was able to catch it - seems to be pointing to a record with relevanssi. Has that ever come up before?

4

Looks like this is a WordPress plugin. Searching the forums here I can see users have brought it up in logs in the past, I do see some mentions on the hosting side as well with it breaking migrations. Is this a plugin you have on the site or have used in the past?

5

relevanssi a very common plugin and generates a very beefy index table (with 1.6m records in this case). I can manually export the database (sans that problematic table) and do this the hard way, but the point of the Local app is to not have to do this stuff manually, and its great when it just works, so I figured I would check here first.

6

@todditron

Ah okay that could certainly be the issue. With Local Connect specifically, we generally recommend manually importing large sites or databases anyway, as the sync can get spotty and have intermittent success depending on the overall size of the site, DB, and connection. Using the manual import method of just dragging and dropping a zip or importing through CLI I usually don’t see too much trouble or time passage with large sites and DBs, except specifically in instances where the DB has massive tables with millions of rows for example. Here was a user who came in this week and manually imported such a DB and said it took almost 24 hours.

We have some instructions here if you go the manual route or want to save for later:

Manually Import a Local Site

7

Yeah, I will take it from here, thanks for looking into it for me

1 Like