-
Notifications
You must be signed in to change notification settings - Fork 9.4k
Closed
Labels
Component: MediaStorageComponent: MysqlMqFixed in 2.3.xThe issue has been fixed in 2.3 release lineThe issue has been fixed in 2.3 release lineIssue: Clear DescriptionGate 2 Passed. Manual verification of the issue description passedGate 2 Passed. Manual verification of the issue description passedIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedIssue: Format is validGate 1 Passed. Automatic verification of issue format passedGate 1 Passed. Automatic verification of issue format passedIssue: Ready for WorkGate 4. Acknowledged. Issue is added to backlog and ready for developmentGate 4. Acknowledged. Issue is added to backlog and ready for developmentReproduced on 2.3.xThe issue has been reproduced on latest 2.3 releaseThe issue has been reproduced on latest 2.3 release
Description
Preconditions (*)
- magento 2.3-develop
Steps to reproduce (*)
- Deploy 2.3-develop
Stores -> Configuration
Advanced -> System
Storage Configuration for Media
Media Storage = Database
Select Media Database = default_setup
Synchronize
Save Config
Catalog -> Products
Add Product
Name = Test
Price = 111
Images and Videos
Upload image "a.jpg"
Save & Close
Verify cached images exist in filesystem
www-data@dev:~/dev1$ find pub/media/catalog/product/cache -name *.jpg
pub/media/catalog/product/cache/6e14adab429f71aeb7223303a247c563/a/_/a.jpg
pub/media/catalog/product/cache/f62d29ead3f33fe6484fbdb6d3785dc1/a/_/a.jpg
pub/media/catalog/product/cache/be852cb44d0b54faab62ffaae6be8535/a/_/a.jpg
pub/media/catalog/product/cache/cec7ecf00f20929af760713af4400fed/a/_/a.jpg
pub/media/catalog/product/cache/37bfafdfb226dffa175577a00672b1ba/a/_/a.jpg
pub/media/catalog/product/cache/8b2dc6afd39ee28ff58514eb10993c8f/a/_/a.jpg
pub/media/catalog/product/cache/d975e82a925000253a32e9c4541ea68c/a/_/a.jpg
pub/media/catalog/product/cache/09c5a17c8da4235f70a8c07e75bb5ef0/a/_/a.jpg
pub/media/catalog/product/cache/9fda6c6842c3f655bbb560bcbe7ed6d5/a/_/a.jpg
pub/media/catalog/product/cache/d5f386a768d7e7f87cc4fb8a6c1ef14f/a/_/a.jpg
pub/media/catalog/product/cache/52952a29dad7e0f0b516b44cc9fe0760/a/_/a.jpg
pub/media/catalog/product/cache/06dfa18d55e0337076e1f5ddd2129562/a/_/a.jpg
pub/media/catalog/product/cache/faa05d146573dd135d15c4c56517ffdb/a/_/a.jpg
pub/media/catalog/product/cache/3ced2c8980660288e4ea38fe4970b4e9/a/_/a.jpg
pub/media/catalog/product/cache/2bdb51d37a492679108b7c6c17f34e97/a/_/a.jpg
pub/media/catalog/product/cache/4ed1686d54d03efa60ce0fb8e68e54e9/a/_/a.jpg
pub/media/catalog/product/cache/ee5242f5f0a2a47237a7610f0274bc15/a/_/a.jpg
pub/media/catalog/product/cache/8f18f3a902701264b776ead80189598e/a/_/a.jpg
pub/media/catalog/product/cache/39fe0b11cb432d7c2d562e3c5b5d5f43/a/_/a.jpg
pub/media/catalog/product/cache/34c2321368257a27e78b60f1cf77ce60/a/_/a.jpg
www-data@dev:~/dev1$
Verify cached images exist in database
mysql> mysql> select filename,directory from media_storage_file_storage where directory LIKE 'catalog/product/cache%';
+----------+------------------------------------------------------------+
| filename | directory |
+----------+------------------------------------------------------------+
| a.jpg | catalog/product/cache/9fda6c6842c3f655bbb560bcbe7ed6d5/a/_ |
| a.jpg | catalog/product/cache/f62d29ead3f33fe6484fbdb6d3785dc1/a/_ |
| a.jpg | catalog/product/cache/d5f386a768d7e7f87cc4fb8a6c1ef14f/a/_ |
| a.jpg | catalog/product/cache/52952a29dad7e0f0b516b44cc9fe0760/a/_ |
| a.jpg | catalog/product/cache/ee5242f5f0a2a47237a7610f0274bc15/a/_ |
| a.jpg | catalog/product/cache/cec7ecf00f20929af760713af4400fed/a/_ |
| a.jpg | catalog/product/cache/09c5a17c8da4235f70a8c07e75bb5ef0/a/_ |
| a.jpg | catalog/product/cache/39fe0b11cb432d7c2d562e3c5b5d5f43/a/_ |
| a.jpg | catalog/product/cache/3ced2c8980660288e4ea38fe4970b4e9/a/_ |
| a.jpg | catalog/product/cache/8f18f3a902701264b776ead80189598e/a/_ |
| a.jpg | catalog/product/cache/06dfa18d55e0337076e1f5ddd2129562/a/_ |
| a.jpg | catalog/product/cache/34c2321368257a27e78b60f1cf77ce60/a/_ |
| a.jpg | catalog/product/cache/37bfafdfb226dffa175577a00672b1ba/a/_ |
| a.jpg | catalog/product/cache/be852cb44d0b54faab62ffaae6be8535/a/_ |
| a.jpg | catalog/product/cache/4ed1686d54d03efa60ce0fb8e68e54e9/a/_ |
| a.jpg | catalog/product/cache/2bdb51d37a492679108b7c6c17f34e97/a/_ |
| a.jpg | catalog/product/cache/d975e82a925000253a32e9c4541ea68c/a/_ |
| a.jpg | catalog/product/cache/6e14adab429f71aeb7223303a247c563/a/_ |
| a.jpg | catalog/product/cache/faa05d146573dd135d15c4c56517ffdb/a/_ |
| a.jpg | catalog/product/cache/8b2dc6afd39ee28ff58514eb10993c8f/a/_ |
+----------+------------------------------------------------------------+
20 rows in set (0.00 sec)
mysql>
System -> Cache Management
Flush Catalog Images Cache
Verify cached images no longer exist in filesystem
www-data@dev:~/dev1$ find pub/media/catalog/product/cache -name *.jpg
find: ‘pub/media/catalog/product/cache’: No such file or directory
www-data@dev:~/dev1$
Verify cached images no longer exist in database
mysql> select filename,directory from media_storage_file_storage where directory LIKE 'catalog/product/cache%';
+----------+------------------------------------------------------------+
| filename | directory |
+----------+------------------------------------------------------------+
| a.jpg | catalog/product/cache/9fda6c6842c3f655bbb560bcbe7ed6d5/a/_ |
| a.jpg | catalog/product/cache/f62d29ead3f33fe6484fbdb6d3785dc1/a/_ |
| a.jpg | catalog/product/cache/d5f386a768d7e7f87cc4fb8a6c1ef14f/a/_ |
| a.jpg | catalog/product/cache/52952a29dad7e0f0b516b44cc9fe0760/a/_ |
| a.jpg | catalog/product/cache/ee5242f5f0a2a47237a7610f0274bc15/a/_ |
| a.jpg | catalog/product/cache/cec7ecf00f20929af760713af4400fed/a/_ |
| a.jpg | catalog/product/cache/09c5a17c8da4235f70a8c07e75bb5ef0/a/_ |
| a.jpg | catalog/product/cache/39fe0b11cb432d7c2d562e3c5b5d5f43/a/_ |
| a.jpg | catalog/product/cache/3ced2c8980660288e4ea38fe4970b4e9/a/_ |
| a.jpg | catalog/product/cache/8f18f3a902701264b776ead80189598e/a/_ |
| a.jpg | catalog/product/cache/06dfa18d55e0337076e1f5ddd2129562/a/_ |
| a.jpg | catalog/product/cache/34c2321368257a27e78b60f1cf77ce60/a/_ |
| a.jpg | catalog/product/cache/37bfafdfb226dffa175577a00672b1ba/a/_ |
| a.jpg | catalog/product/cache/be852cb44d0b54faab62ffaae6be8535/a/_ |
| a.jpg | catalog/product/cache/4ed1686d54d03efa60ce0fb8e68e54e9/a/_ |
| a.jpg | catalog/product/cache/2bdb51d37a492679108b7c6c17f34e97/a/_ |
| a.jpg | catalog/product/cache/d975e82a925000253a32e9c4541ea68c/a/_ |
| a.jpg | catalog/product/cache/6e14adab429f71aeb7223303a247c563/a/_ |
| a.jpg | catalog/product/cache/faa05d146573dd135d15c4c56517ffdb/a/_ |
| a.jpg | catalog/product/cache/8b2dc6afd39ee28ff58514eb10993c8f/a/_ |
+----------+------------------------------------------------------------+
20 rows in set (0.00 sec)
mysql>
Expected result (*)
- When the image cache is cleared, all cached images are removed from filesystem and database
Actual result (*)
- Cached images are removed from filesystem only. They remain in the database.
Metadata
Metadata
Assignees
Labels
Component: MediaStorageComponent: MysqlMqFixed in 2.3.xThe issue has been fixed in 2.3 release lineThe issue has been fixed in 2.3 release lineIssue: Clear DescriptionGate 2 Passed. Manual verification of the issue description passedGate 2 Passed. Manual verification of the issue description passedIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedIssue: Format is validGate 1 Passed. Automatic verification of issue format passedGate 1 Passed. Automatic verification of issue format passedIssue: Ready for WorkGate 4. Acknowledged. Issue is added to backlog and ready for developmentGate 4. Acknowledged. Issue is added to backlog and ready for developmentReproduced on 2.3.xThe issue has been reproduced on latest 2.3 releaseThe issue has been reproduced on latest 2.3 release