Hello, I am trying to install a new discourse on a clean server but I get this error: I, [2018-10-11T04:28:17.965799 #14] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' 2018-10-11 04:28:24.160 UTC [365] discourse@discourse ERROR: relation "users" does not exist at character 566 2018-10-11 04:28:24.160 UTC [365] discourse@discourse STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod, c.collname, col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation WHERE a.attrelid = '"users"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum 2018-10-11 04:28:35.564 UTC [374] discourse@discourse LOG: duration: 100.559 ms statement: ALTER TABLE "users" ADD "staged" boolean DEFAULT FALSE NOT NULL This is definitely a bug, I tried on multiple servers with different OS versions. Probably it is something with the current version of discourse it alway end with this message error: I, [2018-10-11T07:15:34.658740 #14] INFO -- : Terminating async processes I, [2018-10-11T07:15:34.658882 #14] INFO -- : Sending INT to HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/10/bin/postmaster -D /etc/postgresql/10/main pid: 84 I, [2018-10-11T07:15:34.659052 #14] INFO -- : Sending TERM to exec chpst -u redis -U redis /usr/bin/redis-server /etc/redis/redis.conf pid: 200 200:signal-handler (1539242134) Received SIGTERM scheduling shutdown... 2018-10-11 07:15:34.659 UTC [84] LOG: received fast shutdown request 2018-10-11 07:15:34.680 UTC [84] LOG: aborting any active transactions 2018-10-11 07:15:34.685 UTC [84] LOG: worker process: logical replication launcher (PID 93) exited with exit code 1 2018-10-11 07:15:34.688 UTC [88] LOG: shutting down 200:M 11 Oct 07:15:34.758 # User requested shutdown... 200:M 11 Oct 07:15:34.758 * Saving the final RDB snapshot before exiting. 200:M 11 Oct 07:15:34.787 * DB saved on disk 200:M 11 Oct 07:15:34.787 # Redis is now ready to exit, bye bye... 2018-10-11 07:15:34.873 UTC [84] LOG: database system is shut down FAILED -------------------- Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake assets:precompile' failed with return # Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn' exec failed with the params {"cd"=>"$home", "hook"=>"bundle_exec", "cmd"=>["su discourse -c 'bundle install --deployment --verbose --without test --without development --retry 3 --jobs 4'", "su discourse -c 'bundle exec rake db:migrate'", "su discourse -c 'bundle exec rake assets:precompile'"]} 6e330632df0aef58e54069e5041a77d3624c8f870d1a7939cb738df4b2c6adba ** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one

To confirm as of 4:47PM, the error: I, [2018-10-11T15:37:48.991417 #14] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' 2018-10-11 15:37:59.592 UTC [374] discourse@discourse ERROR: relation "users" does not exist at character 566 2018-10-11 15:37:59.592 UTC [374] discourse@discourse STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod, c.collname, col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation WHERE a.attrelid = '"users"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum Does appear during an install, but the build succeeds. [03%20AM] That’s the full recommended install, with domain name specified (IP address based install not supported), SMTP details provided, and Let’s Encrypt enabled. Did you add any files to your install between git pull and ./discourse-setup? Did you add any plugins before completing the build at least once?

[image] tgxworld: The error is actually harmless but I’ll see if I can hunt down what is trying to connect to the users table even before the table has been created. This has been fixed in https://github.com/discourse/discourse/commit/6edf285c893fdca4584e73a7274febcd586c665b

Error "relation 'users' does not exist" when installing discourse

Product Support Self-hosting

codinghorror (Jeff Atwood) October 11, 2018, 9:31am 2

Possible, @tgxworld?

Topic		Replies	Views
Migration failed: relation "user_required_fields_versions" already exists Self-hosting unsupported-install	18	745	September 9, 2024
Createdb: error: database creation failed: ERROR: database "discourse" already exists Self-hosting	5	1569	July 13, 2023
PG::UndefinedTable: ERROR Self-hosting unsupported-install	10	966	April 24, 2023
Restore problem: relation "theme_fields" does not exist Self-hosting	10	2977	June 5, 2020
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	925	February 7, 2019

Error "relation 'users' does not exist" when installing discourse

Related topics