Skip to content

Instantly share code, notes, and snippets.

@parap
Created August 23, 2022 11:01
Show Gist options
  • Save parap/ae0517412e55c7390c5f6d3ccbeeec95 to your computer and use it in GitHub Desktop.
Save parap/ae0517412e55c7390c5f6d3ccbeeec95 to your computer and use it in GitHub Desktop.
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from queue_message where message like '%738969%' ";
array(1) {
[0]=>
array(10) {
["id"]=>
string(7) "2152123"
["queue_name"]=>
string(5) "media"
["message"]=>
string(118) "O:47:"App\Media\Queue\Message\RemoveMediaQueueMessage":2:{s:13:"*sourcePath";s:0:"";s:10:"*mediaId";s:6:"738969";}"
["delivery_id"]=>
NULL
["redeliver_after"]=>
string(1) "0"
["published_at"]=>
string(10) "1661250607"
["status"]=>
string(1) "0"
["try_count"]=>
string(1) "0"
["consumer_response"]=>
NULL
["updated_at"]=>
string(10) "1661250607"
}
}
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from media where id = 738969";
array(1) {
[0]=>
array(10) {
["id"]=>
string(6) "738969"
["type"]=>
string(24) "product_photo_collection"
["owner_id"]=>
string(73) "f10d9f2d-a7c9-11ea-9209-a8a159075cff|8ed3e0cc-f987-11ea-a2f9-544810f2e8cd"
["filename"]=>
string(27) "6304ab71284e65.82749808.jpg"
["hash"]=>
string(40) "b819d677e3b62d546fb2e8632f59de683bc6683a"
["variants"]=>
string(19) "["small","yf_show"]"
["status"]=>
string(9) "processed"
["status_changed_at"]=>
string(26) "2022-08-23 13:32:49.095541"
["source"]=>
string(97) "/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg"
["details"]=>
string(15) "{"size":319608}"
}
}
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from media where id = 738969";
array(0) {
}
[deploy@cabinetmsk-www-msk03 current]$
[deploy@cabinetmsk-www-msk03 current]$
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from queue_message where message like '%738969%' ";
array(1) {
[0]=>
array(10) {
["id"]=>
string(7) "2152219"
["queue_name"]=>
string(5) "media"
["message"]=>
string(1085) "O:50:"App\Media\Queue\Message\StoreBulkMediaQueueMessage":3:{s:60:"App\Media\Queue\Message\StoreBulkMediaQueueMessagemessages";a:3:{i:0;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";N;s:13:"*sourcePath";s:97:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg";s:10:"*mediaId";s:6:"738969";}i:1;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";s:5:"small";s:13:"*sourcePath";s:103:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_small.jpg";s:10:"*mediaId";s:6:"738969";}i:2;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";s:7:"yf_show";s:13:"*sourcePath";s:105:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_yf_show.jpg";s:10:"*mediaId";s:6:"738969";}}s:13:"*sourcePath";s:0:"";s:10:"*mediaId";s:6:"738969";}"
["delivery_id"]=>
NULL
["redeliver_after"]=>
string(1) "0"
["published_at"]=>
string(10) "1661250769"
["status"]=>
string(1) "0"
["try_count"]=>
string(1) "0"
["consumer_response"]=>
NULL
["updated_at"]=>
string(10) "1661250769"
}
}
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from media where id = 738969";
array(0) {
}
[deploy@cabinetmsk-www-msk03 current]$ ls /home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff\|89ZaxT6.jpg
'/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg'
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from media where id = 738969";
array(0) {
}
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from queue_message where message like '%738969%' ";
array(1) {
[0]=>
array(10) {
["id"]=>
string(7) "2152219"
["queue_name"]=>
string(5) "media"
["message"]=>
string(1085) "O:50:"App\Media\Queue\Message\StoreBulkMediaQueueMessage":3:{s:60:"App\Media\Queue\Message\StoreBulkMediaQueueMessagemessages";a:3:{i:0;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";N;s:13:"*sourcePath";s:97:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg";s:10:"*mediaId";s:6:"738969";}i:1;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";s:5:"small";s:13:"*sourcePath";s:103:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_small.jpg";s:10:"*mediaId";s:6:"738969";}i:2;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"App\Media\Queue\Message\StoreMediaQueueMessagevariant";s:7:"yf_show";s:13:"*sourcePath";s:105:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_yf_show.jpg";s:10:"*mediaId";s:6:"738969";}}s:13:"*sourcePath";s:0:"";s:10:"*mediaId";s:6:"738969";}"
["delivery_id"]=>
string(36) "0b11cdc2-605d-47f7-bb2d-7ba2078f97d6"
["redeliver_after"]=>
string(10) "1661251243"
["published_at"]=>
string(10) "1661250769"
["status"]=>
string(1) "0"
["try_count"]=>
string(1) "3"
["consumer_response"]=>
string(40) "Media #738969 not found on "store" stage"
["updated_at"]=>
string(10) "1661251228"
}
}
[deploy@cabinetmsk-www-msk03 current]$ ls /home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg
-bash: 89ZaxT6.jpg: command not found
ls: cannot access '/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff': No such file or directory
[deploy@cabinetmsk-www-msk03 current]$ ls /home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff\|89ZaxT6.jpg
'/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg'
[deploy@cabinetmsk-www-msk03 current]$ ls /home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff\|89ZaxT6.jpg
'/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg'
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from queue_message where message like '%738969%' ";
array(0) {
}
[deploy@cabinetmsk-www-msk03 current]$ dql "select top 1 * from media where id = 738969";
array(0) {
}
[deploy@cabinetmsk-www-msk03 current]$
@parap
Copy link
Author

parap commented Aug 23, 2022

[deploy@cabinetmsk-www-msk03 log]$ cat media_worker.error.log | grep 738969
13:37:49 ERROR [queue] Media #738969 not found on "remove" stage ["id" => "2152124","message" => "O:47:"App\Media\Queue\Message\RemoveMediaQueueMessage":2:{s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
13:38:05 ERROR [queue] Media #738969 not found on "remove" stage ["id" => "2152124","message" => "O:47:"App\Media\Queue\Message\RemoveMediaQueueMessage":2:{s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
13:38:21 ERROR [queue] Media #738969 not found on "remove" stage ["id" => "2152124","message" => "O:47:"App\Media\Queue\Message\RemoveMediaQueueMessage":2:{s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
13:39:56 ERROR [queue] Media #738969 not found on "store" stage ["id" => "2152219","message" => "O:50:"App\Media\Queue\Message\StoreBulkMediaQueueMessage":3:{s:60:"\x00App\Media\Queue\Message\StoreBulkMediaQueueMessage\x00messages";a:3:{i:0;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";N;s:13:"\x00*\x00sourcePath";s:97:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:1;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:5:"small";s:13:"\x00*\x00sourcePath";s:103:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_small.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:2;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:7:"yf_show";s:13:"\x00*\x00sourcePath";s:105:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_yf_show.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}}s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
13:40:12 ERROR [queue] Media #738969 not found on "store" stage ["id" => "2152219","message" => "O:50:"App\Media\Queue\Message\StoreBulkMediaQueueMessage":3:{s:60:"\x00App\Media\Queue\Message\StoreBulkMediaQueueMessage\x00messages";a:3:{i:0;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";N;s:13:"\x00*\x00sourcePath";s:97:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:1;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:5:"small";s:13:"\x00*\x00sourcePath";s:103:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_small.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:2;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:7:"yf_show";s:13:"\x00*\x00sourcePath";s:105:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_yf_show.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}}s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
13:40:28 ERROR [queue] Media #738969 not found on "store" stage ["id" => "2152219","message" => "O:50:"App\Media\Queue\Message\StoreBulkMediaQueueMessage":3:{s:60:"\x00App\Media\Queue\Message\StoreBulkMediaQueueMessage\x00messages";a:3:{i:0;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";N;s:13:"\x00*\x00sourcePath";s:97:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:1;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:5:"small";s:13:"\x00*\x00sourcePath";s:103:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_small.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}i:2;O:46:"App\Media\Queue\Message\StoreMediaQueueMessage":3:{s:55:"\x00App\Media\Queue\Message\StoreMediaQueueMessage\x00variant";s:7:"yf_show";s:13:"\x00*\x00sourcePath";s:105:"/home/deploy/temp_media/product_photo_collection_f10d9f2d-a7c9-11ea-9209-a8a159075cff|89ZaxT6_yf_show.jpg";s:10:"\x00*\x00mediaId";s:6:"738969";}}s:13:"\x00*\x00sourcePath";s:0:"";s:10:"\x00*\x00mediaId";s:6:"738969";}"]
[deploy@cabinetmsk-www-msk03 log]$

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment