Playground plugin: exceeded max execution time

[bph]

Error when executing the blueprint step #1 ({"step":"runSql","sql":{"resource":"vfs","path":"/wordpress/wp-content/database/database.sql"}}) : Could not read "/wordpress/wp-content/database/database.sql": There is no such file or directory OR the parent directory does not exist.

I installed https://wordpress.org/plugins/playground/ (v.0.1.1) on icodeforapurpose.com site and attempted to create a sandbox site.

As I wasn't able to catch the Browser console error before it disappeared, I did a screen recording.

Screen.Recording.2024-04-08.at.19.34.08.mov

If there is anything, I am missing let me know.

The site is hosted on Digital Ocean via SpinupWP.

[bph]

debug.log

[08-Apr-2024 17:26:57 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /sites/icodeforapurpose.com/files/wp-content/plugins/playground/vendor/maennchen/zipstream-php/src/Time.php on line 29

[08-Apr-2024 17:26:57 UTC] PHP Notice: Function is_embed was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /sites/icodeforapurpose.com/files/wp-includes/functions.php on line 6078

[08-Apr-2024 17:26:57 UTC] PHP Notice: Function is_search was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /sites/icodeforapurpose.com/files/wp-includes/functions.php on line 6078

--
edited for brevity

[bgrgicak]

[08-Apr-2024 17:33:49 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /sites/icodeforapurpose.com/files/wp-content/plugins/playground/vendor/maennchen/zipstream-php/src/File.php on line 339

Looks like this is a performance issue. We will need to create a test site with a larger amount of data and see when it breaks.
Longterm we should consider lazy loading static data and not bundling it with the ZIP.

[adamziel]

What could help:

• Increasing max execution time (easy).
• Switching to a custom zip encoder like the one shipped in https://github.com/WordPress/blueprints-library/, zip-stream doesn't seem highly optimized (medium).
• Split the process over multiple requests (difficult).

Overall, this is a Site Transfer Protocol problem. Once we prioritize that project, this issue will get resolved "for free".