Database Media Storage : php bin/magento catalog:images:resize fails to generate cached images in database

[gwharton]

Preconditions (*)

1. magento 2.3-develop
2. Database Storage Mode Enabled

Steps to reproduce (*)

1. Deploy 2.3-develop
2. Change mode to database media storage mode
3. Clear cache
4. Create product and assign image
5. Save Product
6. Verify image exists on disk

www-data@dev:~/dev2$ find pub/media/catalog/product -name *.jpg
pub/media/catalog/product/a/_/a_1.jpg
www-data@dev:~/dev2$

7. Verify image exists in database

mysql> select filename,directory from media_storage_file_storage;
+----------------------------------+---------------------+
| filename                         | directory           |
+----------------------------------+---------------------+
| preview_image_5d2093b1ab619.jpeg | theme/preview       |
| preview_image_5d2093b1b954f.jpeg | theme/preview       |
| a_1.jpg                            | catalog/product/a/_ |
+----------------------------------+---------------------+
3 rows in set (0.00 sec)

8. run php/magento catalog:image:resize to generate cached images

www-data@dev:~/dev2$ php bin/magento catalog:images:resize
1/1 [============================] 100% < 1 sec 42.0 MiB        | /a/_/a_1.jpg
Product images resized successfully
www-data@dev:~/dev2$

Expected result (*)

Cached images generated in database and on file system

Actual result (*)

www-data@dev:~/dev2$ find pub/media/catalog/product -name *.jpg
pub/media/catalog/product/a/_/a_1.jpg
pub/media/catalog/product/cache/e793809b0880f758cc547e70c93ae203/a/_/a_1.jpg
pub/media/catalog/product/cache/3a98496dd7cb0c8b28c4c254a98f915a/a/_/a_1.jpg
pub/media/catalog/product/cache/2765542505660baab28ecd555e27366e/a/_/a_1.jpg
pub/media/catalog/product/cache/b3b166914d87ce343d4dc5ec5117b502/a/_/a_1.jpg
pub/media/catalog/product/cache/6af2da79007bbde83ac425b5e09ddcd4/a/_/a_1.jpg
pub/media/catalog/product/cache/6517c62f5899ad6aa0ba23ceb3eeff97/a/_/a_1.jpg
pub/media/catalog/product/cache/dc09e1c71e492175f875827bcbf6a37c/a/_/a_1.jpg
pub/media/catalog/product/cache/d7d52afd56287491cb7a52758a71b450/a/_/a_1.jpg
pub/media/catalog/product/cache/74c1057f7991b4edb2bc7bdaa94de933/a/_/a_1.jpg
pub/media/catalog/product/cache/207e23213cf636ccdef205098cf3c8a3/a/_/a_1.jpg
pub/media/catalog/product/cache/a32785f299d1d6627cb18126779d91a2/a/_/a_1.jpg
pub/media/catalog/product/cache/e6ff421fc4529233adbd59535b511bb6/a/_/a_1.jpg
pub/media/catalog/product/cache/7890263f8cc2b5a0499bf0617b669975/a/_/a_1.jpg
pub/media/catalog/product/cache/6360e336b2a70951114dbd37294096ee/a/_/a_1.jpg
pub/media/catalog/product/cache/5e1876c673de082c581639cdae9b2d13/a/_/a_1.jpg
pub/media/catalog/product/cache/aeb9a9c9add7300e510ce5e758b88849/a/_/a_1.jpg
pub/media/catalog/product/cache/033f609347571ebd72d8644cf9057fec/a/_/a_1.jpg
pub/media/catalog/product/cache/0c40cc075c35680261029fa6d255feee/a/_/a_1.jpg
pub/media/catalog/product/cache/215bb4aded9fb2a31ab57d5b5f4cd934/a/_/a_1.jpg
pub/media/catalog/product/cache/1f52cad7f867e6ab38ea8958d27dc24c/a/_/a_1.jpg
www-data@dev:~/dev2$

mysql> select filename,directory from media_storage_file_storage;
+----------------------------------+---------------------+
| filename                         | directory           |
+----------------------------------+---------------------+
| preview_image_5d2093b1ab619.jpeg | theme/preview       |
| preview_image_5d2093b1b954f.jpeg | theme/preview       |
| a_1.jpg                          | catalog/product/a/_ |
+----------------------------------+---------------------+
3 rows in set (0.00 sec)

mysql>

Cached image files are not present in database

[m2-assistant]

Hi @gwharton. Thank you for your report.
To help us process this issue please make sure that you provided the following information:

• Summary of the issue
• Information on your environment
• Steps to reproduce
• Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento give me 2.3-develop instance - upcoming 2.3.x release

For more details, please, review the Magento Contributor Assistant documentation.

@gwharton do you confirm that you were able to reproduce the issue on vanilla Magento instance following steps to reproduce?

• yes
• no

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[magento-engcom-team]

Hi @gwharton. Thank you for your report.
The issue has been fixed in #23598 by @gwharton in 2.3-develop branch
Related commit(s):

• 2f6238232a43c9fb8808f41683d7ab6584ade4b3

The fix will be available with the upcoming 2.3.3 release.