table not found The requested resource could not be found. It may have been deleted or you may not h

appwrite-postgresql | 2026-10-12 05:00:08.506 UTC [10344] WARNING: there is no transaction in progress
appwrite-postgresql | 2026-10-12 05:00:08.511 UTC [10344] ERROR: could not resize shared memory segment "/PostgreSQL.3192248898" to 33554432 bytes: No space left on device
appwrite-postgresql | 2026-10-12 05:00:08.511 UTC [10344] STATEMENT: /* host: d2447dc35992 /
appwrite-postgresql | / project: printa4 */
appwrite-postgresql |
appwrite-postgresql | DELETE FROM "appwrite"."_7_database_1_collection_2_perms"
appwrite-postgresql | WHERE _document = '6acb027400245ce0a20f'
appwrite-postgresql |
appwrite-postgresql |
appwrite | http.request · 197.7ms · f06377bd

appwrite | level error
appwrite | http.method GET
appwrite | http.hostname jmkin.top
appwrite | http.locale en
appwrite | project.id printa4
appwrite | user.id 6ac8be9b41d360061fd7
appwrite | database.host database_db_main
appwrite | http.path /v1/tablesdb/:databaseId/tables/:tableId/columns
appwrite | http.response.code 404
appwrite |
appwrite | Appwrite\Extend\Exception: Table with the requested ID 'shopprotected' could not be found.
appwrite | at /usr/src/code/src/Appwrite/Platform/Modules/Databases/Http/Databases/Collections/Attributes/XList.php:81
appwrite | at /usr/src/code/src/Appwrite/Platform/Modules/Databases/Http/TablesDB/Tables/Columns/XList.php:65
appwrite | at /usr/src/code/packages/http/src/Http.php:649
appwrite | at /usr/src/code/packages/http/src/Http.php:877
appwrite | ... 4 more
appwrite |
appwrite | ────────────────────────────────────────────────────────────

ok seemingly deleted the permissions

appwrite-postgresql | DELETE FROM "appwrite"."_7_database_1_collection_2_perms"
appwrite-postgresql | WHERE _document = '6acb027400245ce0a20f'

how to recover?

how did you delete it first of all?

and also i can't delete the sites that i have deployed

bro i haven't deleted anything

first the postgress got the issue i have mentioned no space left on device

and then i have added this in docker shm_size: 256mb

then everything came back but this table haven't came

and the thing is i can't recreated the table

if it allow me then i will recreate it with the same id shopprotected

and upload my rows

We need to find out the table is deleted or its in a bad state
Can you connect to the self hosted instances' postgres and try this command

YEA SURE

appwrite=# SELECT tablename FROM pg_tables
WHERE schemaname = 'appwrite'
AND tablename LIKE '%database_1_collection_2%';
tablename

_7_database_1_collection_2
_7_database_1_collection_2_perms
_6_database_1_collection_2
_6_database_1_collection_2_perms
_4_database_1_collection_2
_4_database_1_collection_2_perms
_8_database_1_collection_2
_8_database_1_collection_2_perms
(8 rows)

_7_database_1_collection_2
_7_database_1_collection_2_perms

can you query these tables with select * from them

now one more chance could be sync issue between the database and table collection
so can you run this query as well

SELECT _uid, "name", "enabled" FROM "appwrite"."_7_database_1"
WHERE _uid = 'shopprotected';

appwrite=# SELECT * FROM appwrite."_7_database_1_collection_2_perms";
_id | _tenant | _type | _permission | _document
-----+---------+-------+-------------+-----------
(0 rows)

appwrite=# SELECT _uid, "name", "enabled" FROM "appwrite"."_7_database_1"
WHERE _uid = 'shopprotected';
_uid | name | enabled
---------------+---------------+---------
shopprotected | shopprotected | t
(1 row)

and for _7_database_1_collection_2 its showing multiple rows

hmm so they are in sync already

can you run this
SELECT _uid, "name", "documentSecurity", "enabled"
FROM "appwrite"."_7_database_1" WHERE _uid = 'shopprotected';

will give us security things as well then

appwrite=# SELECT _uid, "name", "documentSecurity", "enabled"
FROM "appwrite"."_7_database_1" WHERE _uid = 'shopprotected';
_uid | name | documentSecurity | enabled
---------------+---------------+------------------+---------
shopprotected | shopprotected | t | t
(1 row)

coolz that means perms table is not in correct shape and no perms for the documents are present so you can't access
is your data important for this collection or its more of dummy data?