Various "ERROR: relation" in logs: what is it and should I care?

Support
1

I have multiple errors like this in my logs:

Job exception: PG::UndefinedTable: ERROR: relation "application_requests" does not exist LINE 1: SELECT "application_requests"."id" FROM "application_request...

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "user_auth_tokens" does not exist LINE 1: SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((...

Should I be worried about that?

The forum is working fine though.
I migrated a vbulletin to a development Discourse, then I made a backup from this dev Discourse and successfully restored it on my standard installation.
I don’t seem to have these errors on the dev version. No error or fatal errors.

2

You might need to do a

rake db:migrate

You might also have a database problem that keeps the migration from succeeding.

4 Likes
3

Thank you, I’ll try that :slight_smile:

1 Like
4

I ran this command but it didn’t seem to resolve the issue.
I did: ran the command, made a full backup, tried to restore this backup (on the same and another server).
These errors messages are in fact generated during a restore.

I did a backup, tried to restore: The restore logs in the Discourse interface stops at the “unpacking” part, but after waiting a bit, I’m logged out and on a working, restored version of my forum.
Discourse logs then show these errors:

Job exception: PG::UndefinedTable: ERROR: relation "application_requests" does not exist LINE 1: SELECT "application_requests"."id" FROM "application_request...
ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "user_auth_tokens" does not exist LINE 1: SELECT "user_auth_tokens".* FROM "user_auth_tokens" WHERE ((...

Same on my development Discourse, with a different number of errors and exceptions. Forum working as well.

So I restored (on my development Discourse) an earlier version of my forum, which only has imported users.

The error logs didn’t go to the “restore successful” step as well (stopped before), but I was, again, properly logged out, and on a working Discourse. Errors during the restore were slightly different:

Job exception: PG::UndefinedTable: ERROR: relation "topics" does not exist LINE 1: UPDATE "topics" SET "pinned_at" = NULL, "pinned_globally" = ... ^
7:18 pm
Job exception: PG::UndefinedTable: ERROR: relation "scheduler_stats" does not exist LINE 1: UPDATE "scheduler_stats" SET "duration_ms" = 22741, "live_sl... ^

So… I’m not sure what I should do. The forums work after these restore, but the errors generated during these restore scare me.

1 Like