Update 2.8.0 can't start and fails at db update with Postgres

[Billos]

Can the issue be reproduced with the latest available release? (y/n)
Yes

Which one is the environment gotify server is running in?

• Docker
• Linux machine
• Windows machine

Docker startup command or config file here (please mask sensitive information)

services:
  gotify:
    image: gotify/server:2.8.0
    env_file:
      - stack.env
    environment:
      - TZ=Europe/Paris
    volumes:
      - type: volume
        source: crucible
        target: /app/data
        volume:
          subpath: gotify

Do you have an reverse proxy installed in front of gotify server? (Please select None if the problem can be reproduced without the presense of a reverse proxy)

• None
• Nginx
• Apache
• Caddy

Reverse proxy configuration (please mask sensitive information)

proxy_read_timeout 1800;
proxy_send_timeout 1800;

On which client do you experience problems? (Select as many as you can see)

• WebUI
• gotify-cli
• Android Client
• Server

What did you do?
Updated from 2.7.2 to 2.8.0

What did you expect to see?

What did you see instead? (Include screenshots, android logcat/request dumps if possible)

Starting Gotify version 2.8.0@2026-01-02-12:02:25

2026/01/02 20:08:46  ERROR: constraint "uni_users_name" of relation "users" does not exist (SQLSTATE 42704)

[0.517ms] [rows:0] ALTER TABLE "users" DROP CONSTRAINT "uni_users_name"

panic: ERROR: constraint "uni_users_name" of relation "users" does not exist (SQLSTATE 42704)

goroutine 1 [running]:

main.main()

	/src/gotify/app.go:44 +0x33f

I tried manually creating the constraint, it is correctly removed by Gotify, but then nothing starts and it keeps trying to remove the constraint

[jmattheis]

Which database are you using?

[Billos]

I'm using a Postgresql

[jmattheis]

Could you dump your database schema with pg_dump and post it here? E.g.

$ pg_dump --schema-only -h127.0.0.1 -Uroot gotify
                          (host)    (user) (database name)

[Billos]

Yes here it is !

Details

-- Dumped from database version 17.7 (Debian 17.7-3.pgdg12+1)
-- Dumped by pg_dump version 17.7 (Ubuntu 17.7-0ubuntu0.25.10.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: applications; Type: TABLE; Schema: public; Owner: gotify
--

CREATE TABLE public.applications (
    id integer NOT NULL,
    token character varying(180),
    user_id integer,
    name text,
    description text,
    internal boolean,
    image text,
    default_priority integer,
    last_used timestamp with time zone
);


ALTER TABLE public.applications OWNER TO gotify;

--
-- Name: applications_id_seq; Type: SEQUENCE; Schema: public; Owner: gotify
--

CREATE SEQUENCE public.applications_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.applications_id_seq OWNER TO gotify;

--
-- Name: applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gotify
--

ALTER SEQUENCE public.applications_id_seq OWNED BY public.applications.id;


--
-- Name: clients; Type: TABLE; Schema: public; Owner: gotify
--

CREATE TABLE public.clients (
    id integer NOT NULL,
    token character varying(180),
    user_id integer,
    name text,
    last_used timestamp with time zone
);


ALTER TABLE public.clients OWNER TO gotify;

--
-- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: gotify
--

CREATE SEQUENCE public.clients_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.clients_id_seq OWNER TO gotify;

--
-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gotify
--

ALTER SEQUENCE public.clients_id_seq OWNED BY public.clients.id;


--
-- Name: messages; Type: TABLE; Schema: public; Owner: gotify
--

CREATE TABLE public.messages (
    id integer NOT NULL,
    application_id integer,
    message text,
    title text,
    priority integer,
    extras bytea,
    date timestamp with time zone
);


ALTER TABLE public.messages OWNER TO gotify;

--
-- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: gotify
--

CREATE SEQUENCE public.messages_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.messages_id_seq OWNER TO gotify;

--
-- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gotify
--

ALTER SEQUENCE public.messages_id_seq OWNED BY public.messages.id;


--
-- Name: plugin_confs; Type: TABLE; Schema: public; Owner: gotify
--

CREATE TABLE public.plugin_confs (
    id integer NOT NULL,
    user_id integer,
    module_path text,
    token character varying(180),
    application_id integer,
    enabled boolean,
    config bytea,
    storage bytea
);


ALTER TABLE public.plugin_confs OWNER TO gotify;

--
-- Name: plugin_confs_id_seq; Type: SEQUENCE; Schema: public; Owner: gotify
--

CREATE SEQUENCE public.plugin_confs_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.plugin_confs_id_seq OWNER TO gotify;

--
-- Name: plugin_confs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gotify
--

ALTER SEQUENCE public.plugin_confs_id_seq OWNED BY public.plugin_confs.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: gotify
--

CREATE TABLE public.users (
    id integer NOT NULL,
    name character varying(180),
    pass bytea,
    admin boolean
);


ALTER TABLE public.users OWNER TO gotify;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: gotify
--

CREATE SEQUENCE public.users_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.users_id_seq OWNER TO gotify;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gotify
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: applications id; Type: DEFAULT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.applications ALTER COLUMN id SET DEFAULT nextval('public.applications_id_seq'::regclass);


--
-- Name: clients id; Type: DEFAULT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.clients ALTER COLUMN id SET DEFAULT nextval('public.clients_id_seq'::regclass);


--
-- Name: messages id; Type: DEFAULT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.messages ALTER COLUMN id SET DEFAULT nextval('public.messages_id_seq'::regclass);


--
-- Name: plugin_confs id; Type: DEFAULT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.plugin_confs ALTER COLUMN id SET DEFAULT nextval('public.plugin_confs_id_seq'::regclass);


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);


--
-- Name: applications applications_pkey; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_pkey PRIMARY KEY (id);


--
-- Name: applications applications_token_key; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_token_key UNIQUE (token);


--
-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);


--
-- Name: clients clients_token_key; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_token_key UNIQUE (token);


--
-- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- Name: plugin_confs plugin_confs_pkey; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.plugin_confs
    ADD CONSTRAINT plugin_confs_pkey PRIMARY KEY (id);


--
-- Name: plugin_confs plugin_confs_token_key; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.plugin_confs
    ADD CONSTRAINT plugin_confs_token_key UNIQUE (token);

--
-- Name: users users_name_key; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_name_key UNIQUE (name);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: idx_applications_user_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE INDEX idx_applications_user_id ON public.applications USING btree (user_id);


--
-- Name: idx_clients_user_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE INDEX idx_clients_user_id ON public.clients USING btree (user_id);


--
-- Name: idx_messages_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE INDEX idx_messages_id ON public.messages USING btree (id);


--
-- Name: idx_plugin_confs_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE INDEX idx_plugin_confs_id ON public.plugin_confs USING btree (id);


--
-- Name: uix_applications_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_applications_id ON public.applications USING btree (id);


--
-- Name: uix_applications_token; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_applications_token ON public.applications USING btree (token);


--
-- Name: uix_clients_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_clients_id ON public.clients USING btree (id);


--
-- Name: uix_clients_token; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_clients_token ON public.clients USING btree (token);


--
-- Name: uix_plugin_confs_token; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_plugin_confs_token ON public.plugin_confs USING btree (token);


--
-- Name: uix_users_id; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_users_id ON public.users USING btree (id);


--
-- Name: uix_users_name; Type: INDEX; Schema: public; Owner: gotify
--

CREATE UNIQUE INDEX uix_users_name ON public.users USING btree (name);


--
-- Name: applications applications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: clients clients_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: messages messages_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_application_id_fkey FOREIGN KEY (application_id) REFERENCES public.applications(id) ON DELETE CASCADE;


--
-- Name: plugin_confs plugin_confs_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.plugin_confs
    ADD CONSTRAINT plugin_confs_application_id_fkey FOREIGN KEY (application_id) REFERENCES public.applications(id) ON DELETE CASCADE;


--
-- Name: plugin_confs plugin_confs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gotify
--

ALTER TABLE ONLY public.plugin_confs
    ADD CONSTRAINT plugin_confs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: -; Owner: root
--

ALTER DEFAULT PRIVILEGES FOR ROLE root GRANT ALL ON TABLES TO gotify WITH GRANT OPTION;

[Billos]

I found a solution, if it happens to anyone else, run this in the DB :

ALTER TABLE users ADD CONSTRAINT uni_users_name UNIQUE(name);
ALTER TABLE applications ADD CONSTRAINT uni_applications_token UNIQUE (token);
ALTER TABLE clients ADD CONSTRAINT uni_clients_token UNIQUE (token);
ALTER TABLE public.plugin_confs ADD CONSTRAINT uni_plugin_confs_token UNIQUE (token);

And then restart Gotify

[jmattheis]

I'm not sure yet why this happens, but your listed constraints shouldn't be needed. They are duplicating existing constraints.

It's also fixed by dropping these constraints. I'm not sure yet where they initially were created in gotify.

alter table users drop constraint users_name_key;
alter table applications drop constraint applications_token_key;
alter table clients drop constraint clients_token_key;
alter table plugin_confs drop constraint plugin_confs_token_key;

[Billos]

They were non existing in my schema and I don't know why, an IF EXISTS could help being more resilient

[jmattheis]

In a "normal" installation the constraints with the prefix "uni" aren't created. It some sort of side effect of the existing unique constraint "users_name_key" UNIQUE CONSTRAINT, btree (name) which also normally doesn't exist.

If the users_name_key constraint exists, the ORM framework somehow wants to drop uni_users_name.

I've tested these gotify versions, in none of them the users_name_key constraint is created. I don't know where this is coming from.

2.7.3
2.7.2
2.7.1
2.6.0
2.5.0
2.4.0
2.3.0
2.2.0
2.1.0
2.0.0
1.2.1
1.0.0

Have you done some manual tinkering with the database, or manually migrated between databases?

[Billos]

I switched a few months ago from SQLite to Postgresql, this might not have been a conventional migration, but I don't remember exactly

[jmattheis]

How did you migrate? Do you remember if you've used used a tool for this?

[Billos]

I don't remember exactly, this might have been a dirty SQLite conversion to Postgres SQL and fixed the issues by hand, as I probably really didn't want to reset the tokens in my other applications

[jmattheis]

Okay, seems like a probable cause for this. The database migration is misbehaving here, but it's due to a dirty database state.

Let's wait for more feedback from other users on this issue. If there is more then I'm open to automatically remove the constraint on startup but as of now, I'm not sure if it's originated from gotify.