Magento – Request Timeout

As written on stackoverflow by Joeri Hendrickx

All cookies expire as per the cookie specification, so this is not a PHP limitation.

Use a far future date. For example, set a cookie that expires in ten years:

setcookie(
  "CookieName",
  "CookieValue",
  time() + (10 * 365 * 24 * 60 * 60)
);

Note that if you set a date past 2038 in PHP, the number will wrap around and you'll get a cookie that expires instantly.

It seems like a native issue in 2.1.8: https://github.com/magento/magento2/issues/10531

It seems I stumble upon some kind of solution. I'm not sure what I did but I will tell you what I remember doing.

1. Enable maintenance mode: bin/magento maintenance:enable
2. Reset indexes: bin/magento indexer:reset
3. Make sure that no database processes regarding indexing is running
4. Open your database administration client like PHPMyAdmin
5. Run query: SHOW PROCESSLIST;
6. Run query: KILL QUERY xxxxx (where xxxxx is the ID of processes you want to kill)
7. bin/magento setup:upgrade
8. Clear cache
9. bin/magento setup:static-content:deploy -j 1
10. bin/magento indexer:reindex
11. Disable maintenance mode bin/magento maintenance:disable

Now the only thin missing is some of the product images on the category page. The weird thing is that if I go to the product page I can see the product image. There is also a small version in the cache folder.