502 Bad Gateway with Local by Flywheel

I’m getting a 502 Bad Gateway error message when I activate Loops & Logic using:

  • Local Connect (localwp.com) running on Windows 10
  • MariaDB 10.4.10
  • Wordpress 5.9.2 with Nginx and PHP 7.4.1
  • All other plugins disabled

local-lightning.log
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] %%resourcesPath%%\lightning-services\mariadb-10.4.10+4\bin\win32\bin\mysqld.exe (mysqld 10.4.10-MariaDB) starting as process 17796 …”,“timestamp”:“2022-03-15T06:33:51.234Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“InnoDB: using atomic writes.”,“timestamp”:“2022-03-15T06:33:51.235Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions”,“timestamp”:“2022-03-15T06:33:51.235Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Uses event mutexes”,“timestamp”:“2022-03-15T06:33:51.236Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11”,“timestamp”:“2022-03-15T06:33:51.236Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Number of pools: 1”,“timestamp”:“2022-03-15T06:33:51.236Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Using SSE2 crc32 instructions”,“timestamp”:“2022-03-15T06:33:51.237Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M”,“timestamp”:“2022-03-15T06:33:51.237Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Completed initialization of buffer pool”,“timestamp”:“2022-03-15T06:33:51.238Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=34497781”,“timestamp”:“2022-03-15T06:33:51.238Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.”,“timestamp”:“2022-03-15T06:33:51.239Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:"2022-03-15 6:33:51 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1"”,“timestamp”:“2022-03-15T06:33:51.239Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables”,“timestamp”:“2022-03-15T06:33:51.240Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: Setting file ‘.\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …”,“timestamp”:“2022-03-15T06:33:51.241Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: File ‘.\ibtmp1’ size is now 12 MB.”,“timestamp”:“2022-03-15T06:33:51.241Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: Waiting for purge to start”,“timestamp”:“2022-03-15T06:33:51.242Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: 10.4.10 started; log sequence number 34497790; transaction id 7488”,“timestamp”:“2022-03-15T06:33:51.243Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\run\-NTMj3bfb\mariadb\data\ib_buffer_pool”,“timestamp”:“2022-03-15T06:33:51.244Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] Plugin ‘FEEDBACK’ is disabled.”,“timestamp”:“2022-03-15T06:33:51.244Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 6:33:51”,“timestamp”:“2022-03-15T06:33:51.245Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] Server socket created on IP: ‘127.0.0.1’.”,“timestamp”:“2022-03-15T06:33:51.245Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] Reading of all Master_info entries succeeded”,“timestamp”:“2022-03-15T06:33:51.713Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] Added new Master_info ‘’ to hash table”,“timestamp”:“2022-03-15T06:33:51.714Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:33:51 0 [Note] %%resourcesPath%%\lightning-services\mariadb-10.4.10+4\bin\win32\bin\mysqld.exe: ready for connections.”,“timestamp”:“2022-03-15T06:33:51.714Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“Version: ‘10.4.10-MariaDB’ socket: ‘’ port: 10010 mariadb.org binary distribution”,“timestamp”:“2022-03-15T06:33:51.714Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:36:12 40 [Warning] Aborted connection 40 to db: ‘local’ user: ‘root’ host: ‘localhost’ (Got an error reading communication packets)”,“timestamp”:“2022-03-15T06:36:12.409Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mariadb”,“level”:“warn”,“message”:“2022-03-15 6:36:14 41 [Warning] Aborted connection 41 to db: ‘local’ user: ‘root’ host: ‘localhost’ (Got an error reading communication packets)”,“timestamp”:“2022-03-15T06:36:14.520Z”}

+1 but on MacOS - using latest version of Local, PHP 7.4.1. - MySQL 8.0.16, WordPress 5.9.2

Thank you for the issue report. This was an issue with Local by Flywheel, where a perfectly valid PHP syntax was causing an NGINX error for some mysterious reason. It’s been solved in the newest plugin version 2.4.2.

1 Like