Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: relation "goose_db_version" does not exist #31

Open
g0rrrr opened this issue Jul 3, 2024 · 0 comments
Open

ERROR: relation "goose_db_version" does not exist #31

g0rrrr opened this issue Jul 3, 2024 · 0 comments

Comments

@g0rrrr
Copy link

g0rrrr commented Jul 3, 2024

`2024-07-03 18:13:37.864 +04 [14151] ERROR: relation "goose_db_version" does not exist at character 36
2024-07-03 18:13:37.864 +04 [14151] STATEMENT: SELECT version_id, is_applied from goose_db_version ORDER BY id DESC
2024-07-03 18:13:37.864 +04 [14151] ERROR: permission denied for schema public at character 14
2024-07-03 18:13:37.864 +04 [14151] STATEMENT: CREATE TABLE goose_db_version (
id serial NOT NULL,
version_id bigint NOT NULL,
is_applied boolean NOT NULL,
tstamp timestamp NULL default now(),
PRIMARY KEY(id)
);
2024-07-03 18:13:37.866 +04 [14151] ERROR: relation "settings" does not exist at character 27
2024-07-03 18:13:37.866 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1;
2024-07-03 18:18:31.840 +04 [14117] LOG: checkpoint starting: time
2024-07-03 18:18:32.194 +04 [14117] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.108 s, total=0.355 s; sync files=2, longest=0.058 s, average=0.054 s; distance=0 kB, estimate=0 kB; lsn=0/1972B60, redo lsn=0/1972B28
2024-07-03 18:54:41.767 +04 [14151] ERROR: relation "boards" does not exist at character 88
2024-07-03 18:54:41.767 +04 [14151] STATEMENT:
SELECT
boards.*,
views.time AS viewed_on
FROM boards
LEFT OUTER JOIN views ON
views.post_id=(SELECT id FROM posts WHERE board_id=boards.id AND parent_id IS NULL ORDER BY latest_reply DESC LIMIT 1) AND
views.user_id=$1
ORDER BY
ordering ASC

2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 22
2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT COUNT() FROM users
2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 15
2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT * FROM users ORDER BY created_on DESC LIMIT 1
2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "posts" does not exist at character 22
2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT COUNT(
) FROM posts
2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 15
2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT * FROM users WHERE last_seen > current_timestamp - interval '5 minutes' AND hide_online != true
2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "settings" does not exist at character 27
2024-07-03 18:54:41.768 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1;
2024-07-03 18:54:41.769 +04 [14151] ERROR: relation "settings" does not exist at character 27
2024-07-03 18:54:41.769 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1;
2024-07-03 18:54:41.769 +04 [14151] ERROR: relation "settings" does not exist at character 27
2024-07-03 18:54:41.769 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1;

`
here is the log of postgres

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant