When Drupal is installed, node_install() creates a record in the node_access table with nid = 0. Zero is not a valid value for nid and violates the foreign key constraint declared in node_schema(). The default should be stored some other way or a default node with nid = 0 should be added to the node table.
Needs work
11.0 🔥
node system
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.