I deactivated all my plugins and got the following critical error from the debug log:
[04-Sep-2023 12:41:24 UTC] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_0d4by0kan6_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (1, ‘2023-09-04 12:41:24’, ‘0000-00-00 00:00:00’, ”, ”, ‘Auto Draft’, ”, ‘auto-draft’, ‘post’, ‘open’, ‘open’, ”, ”, ”, ”, ‘2023-09-04 12:41:24’, ‘0000-00-00 00:00:00’, 0, 0, ”, ”) made by wp_dashboard, do_meta_boxes, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post
[04-Sep-2023 12:41:46 UTC] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_0d4by0kan6_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, post_type, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (1, ‘2023-09-04 12:41:46’, ‘0000-00-00 00:00:00’, ”, ”, ‘Auto Draft’, ”, ‘auto-draft’, ‘page’, ‘closed’, ‘closed’, ”, ”, ”, ”, ‘2023-09-04 12:41:46’, ‘0000-00-00 00:00:00’, 0, 0, ”, ”) made by get_default_post_to_edit, wp_insert_post
[04-Sep-2023 12:41:46 UTC] PHP Warning: Attempt to read property “post_type” on null in /var/www/wp-admin/includes/post.php on line 748
[04-Sep-2023 12:41:46 UTC] PHP Fatal error: Uncaught Error: Attempt to assign property “post_content” on null in /var/www/wp-admin/includes/post.php:787
Stack trace: 0 /var/www/wp-admin/post-new.php(66): get_default_post_to_edit(‘page’, true) 1 {main}
thrown in /var/www/wp-admin/includes/post.php on line 787