Lovász Local Lemma (LLL) is a very powerful tool in combinatorics and probability theory to show the possibility of avoiding all "bad" events under some "weakly dependent" condition. Over the last decades, the algorithmic aspect of LLL has also attracted lots of attention in theoretical computer science [23,28,35]. A tight criterion under which the abstract version LLL (ALLL) holds was given by Shearer [44]. It turns out that Shearer's bound is generally not tight for variable version LLL (VLLL) [24]. Recently, Ambainis et al. [3] introduced a quantum version LLL (QLLL), which was then shown to be powerful for the quantum satisfiability problem.In this paper, we prove that Shearer's bound is tight for QLLL, i.e., the relative dimension of the smallest satisfying subspace is completely characterized by the independent set polynomial, affirming a conjecture proposed by Sattath et al. [34,39]. Our result also shows the tightness of Gilyén and Sattath's algorithm [18], and implies that the lattice gas partition function fully characterizes quantum satisfiability for almost all Hamiltonians with large enough qudits [39].Commuting LLL (CLLL), LLL for commuting local Hamiltonians which are widely studied in the literature, is also investigated here. We prove that the tight regions of CLLL and QLLL are different in general. This result might imply that it is possible to design an algorithm for CLLL which is still efficient beyond Shearer's bound.In applications of LLLs, the symmetric cases are most common, i.e., the events are with the same probability [15,16] and the Hamiltonians are with the same relative dimension [3,39]. We give the first lower bound on the gap between the symmetric VLLL and Shearer's bound. Our result can be viewed as a quantitative study on the separation between quantum and classical constraint satisfaction problems. Additionally, we obtain similar results for the symmetric CLLL. As an application, we give lower bounds on the critical thresholds of VLLL and CLLL for several of the most common lattices.Classical Lovász Local Lemma Lovász Local Lemma (or LLL) is a very powerful tool in combinatorics and probability theory to show the possibility of avoiding all "bad" events under some "weakly dependent" condition, and has numerous applications. Formally, given a set A of bad events in a probability space, LLL provides the condition under which P(∩ A∈A A) > 0. The dependency among events is usually characterized by the dependency graph. A dependency graph is an undirected graph G D = ([m], E D ) such that for any vertex i, A i is independent of {A j : j / ∈ Γ i ∪ {i}}, where Γ i stands for the set of neighbors of i in G D . In this setting, finding the conditions under which P(∩ A∈A A) > 0 is reduced to the following problem: given a graph G D , determine its abstract interior I(G D ) which is the set of vectors p such that P ∩ A∈A A > 0 for any event set A with dependency graph G D and probability vector p. Local solutions to this problem, including the first LLL proved in 1975 by Erdős and Lovász ...