Issue #2966607 by Wim Leers, Berdir, claudiu.cristea, dww, Fabianx, effulgentsia, bendev, mondrake, Grayle, neclimdul, markgifford, larowlan: Invalidating 'node_list' and other broad cache tags early in a transaction severely increases lock wait time and probability of deadlock

(cherry picked from commit dbca960d4374a735bff9d2a4e28fcc4531b32e91)