Contradiction with Proverbs 3:24
While Psalms 78:65 describes God as awakening, Proverbs 3:24 suggests peaceful sleep without sudden awakening.
Proverbs 3:24: When thou liest down, thou shalt not be afraid: yea, thou shalt lie down, and thy sleep shall be sweet.
Contradiction with Numbers 23:19
Psalms 78:65 suggests God acts like a man waking from sleep, Numbers 23:19 states that God is not a man and does not change or act like humans.
Numbers 23:19: God [is] not a man, that he should lie; neither the son of man, that he should repent: hath he said, and shall he not do [it]? or hath he spoken, and shall he not make it good?
Contradiction with Isaiah 40:28
Contradicts the idea of God sleeping as presented in Psalms 78:65 by affirming that God does not faint or grow weary.
Isaiah 40:28: Hast thou not known? hast thou not heard, [that] the everlasting God, the LORD, the Creator of the ends of the earth, fainteth not, neither is weary? [there is] no searching of his understanding.
Contradiction with Psalm 121:4
In direct contrast to Psalms 78:65, it asserts that God never slumbers or sleeps.
Psalm 121:4: Behold, he that keepeth Israel shall neither slumber nor sleep.
Paradox #1
Psalms 78:65 describes God waking up as if from sleep. This might conflict with the belief that God is always aware and active, as He is often described as omniscient (all-knowing) and omnipresent (present everywhere) in other parts of the Bible. Suggesting that God is like a person who sleeps could seem inconsistent with these attributes.
Paradox #2
The contradiction or inconsistency in Psalms 78:65 might be seen in the portrayal of God suddenly awakening with power and action after a period of silence or seeming inaction. This could conflict with the understanding of God as always being watchful and responsive. Some might find it inconsistent with the idea of a consistently attentive and proactive deity.