champs-libres/biommap
5
0
Fork 0
Code Issues 5 Pull Requests Projects Releases Wiki Activity

Reinstallation fraiche donne une db incomplète #20

New Issue
Closed
opened 2021-09-15 11:39:41 +00:00 by juminet · 4 comments
juminet commented 2021-09-15 11:39:41 +00:00
Owner
Copy Link
• suivi les instructions du README
• le vendro se met bien à la version (mais la branche est détachée)
    ◦ julien@supertramp:/mnt/tera/ChampsLibres/Projets/BiomMap/repo/biommap/vendor/GeoNature-citizen$ git status
    ◦ HEAD detached at c5f36d3
    ◦ nothing to commit, working tree clean
• docker-compose up
    ◦ les conteneurs se crée très vite, car les images existent par ailleurs
• build du frontend :ok
• problème l’app ne marche pas car il manque plusieurs tables !!!!
    ◦ manque plusieurs table dans gnc_core, manque schema gnc_obstax, gnc_sites!
• suivi les instructions du README • le vendro se met bien à la version (mais la branche est détachée) ◦ julien@supertramp:/mnt/tera/ChampsLibres/Projets/BiomMap/repo/biommap/vendor/GeoNature-citizen$ git status ◦ HEAD detached at c5f36d3 ◦ nothing to commit, working tree clean • docker-compose up ◦ les conteneurs se crée très vite, car les images existent par ailleurs • build du frontend :ok • problème l’app ne marche pas car il manque plusieurs tables !!!! ◦ manque plusieurs table dans gnc_core, manque schema gnc_obstax, gnc_sites!
juminet added the
bug
 label 2021-09-15 11:39:48 +00:00
juminet commented 2021-09-15 12:00:26 +00:00
Author
Owner
Copy Link

Il faudrait:

  • essayer en rebuildant les images
  • essayer avec un état ancien des branches
Il faudrait: - essayer en rebuildant les images - essayer avec un état ancien des branches
juminet commented 2021-09-15 12:04:42 +00:00
Author
Owner
Copy Link

log installation

2021-09-15 11:49:30.942 UTC [35] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1             | 2021-09-15 11:49:30.954 UTC [36] LOG:  database system was shut down at 2021-09-15 11:49:30 UTC
db_1             | 2021-09-15 11:49:30.957 UTC [35] LOG:  database system is ready to accept connections
db_1             |  done
db_1             | server started
db_1             | 
db_1             | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
db_1             | CREATE DATABASE
db_1             | Loading PostGIS extensions into template_postgis
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | Loading PostGIS extensions into postgres
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | CREATE EXTENSION
db_1             | 
db_1             | waiting for server to shut down....2021-09-15 11:49:34.042 UTC [35] LOG:  received fast shutdown request
db_1             | 2021-09-15 11:49:34.043 UTC [35] LOG:  aborting any active transactions
db_1             | 2021-09-15 11:49:34.043 UTC [35] LOG:  background worker "logical replication launcher" (PID 42) exited with exit code 1
db_1             | 2021-09-15 11:49:34.045 UTC [37] LOG:  shutting down
db_1             | 2021-09-15 11:49:34.115 UTC [35] LOG:  database system is shut down
db_1             |  done
db_1             | server stopped
db_1             | 
db_1             | PostgreSQL init process complete; ready for start up.
db_1             | 
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1             | 2021-09-15 11:49:34.154 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1             | 2021-09-15 11:49:34.157 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1             | 2021-09-15 11:49:34.178 UTC [54] LOG:  database system was shut down at 2021-09-15 11:49:34 UTC
db_1             | 2021-09-15 11:49:34.183 UTC [1] LOG:  database system is ready to accept connections
db_1             | 2021-09-15 11:50:10.593 UTC [84] ERROR:  schema "taxonomie" already exists
db_1             | 2021-09-15 11:50:10.593 UTC [84] STATEMENT:  CREATE SCHEMA taxonomie;
db_1             | 2021-09-15 11:50:37.845 UTC [88] ERROR:  operator class "gist_trgm_ops" does not exist for access method "gist"
db_1             | 2021-09-15 11:50:37.845 UTC [88] STATEMENT:  CREATE INDEX i_tri_vm_taxref_list_forautocomplete_search_name
db_1             | 	  ON vm_taxref_list_forautocomplete
db_1             | 	  USING gist
db_1             | 	  (search_name  gist_trgm_ops);
db_1             | 2021-09-15 11:50:38.019 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.019 UTC [91] DETAIL:  Key (cd_nom)=(67111) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.019 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (67111, 67111, 'Ablette');
db_1             | 2021-09-15 11:50:38.019 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.019 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.019 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.020 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.020 UTC [91] DETAIL:  Key (cd_nom)=(60612) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.020 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (60612, 60612, 'Lynx boréal');
db_1             | 2021-09-15 11:50:38.020 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.020 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.020 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Key (cd_nom)=(351) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (351, 351, 'Grenouille rousse');
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Key (cd_nom)=(8326) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (8326, 8326, 'Cicindèle hybride');
db_1             | 2021-09-15 11:50:38.021 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.021 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.021 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Key (cd_nom)=(11165) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (11165, 11165, 'Coccinelle à 7 points');
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.022 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.022 UTC [91] DETAIL:  Key (cd_nom)=(18437) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.022 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (18437, 18437, 'Ecrevisse à pieds blancs');
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Key (cd_nom)=(81065) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (81065, 81065, 'Alchémille rampante');
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.023 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.023 UTC [91] DETAIL:  Key (cd_nom)=(95186) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.023 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (95186, 95186, 'Inule fétide');
db_1             | 2021-09-15 11:50:38.024 UTC [91] ERROR:  null value in column "id_nom" violates not-null constraint
db_1             | 2021-09-15 11:50:38.024 UTC [91] DETAIL:  Failing row contains (100, null).
db_1             | 2021-09-15 11:50:38.024 UTC [91] STATEMENT:  INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100);
db_1             | 2021-09-15 11:50:38.024 UTC [91] ERROR:  insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref"
db_1             | 2021-09-15 11:50:38.024 UTC [91] DETAIL:  Key (cd_nom)=(713776) is not present in table "taxref".
db_1             | 2021-09-15 11:50:38.024 UTC [91] STATEMENT:  INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais, comments) VALUES (713776, 209902, '-', 'un synonyme');
db_1             | 2021-09-15 11:50:39.345 UTC [92] ERROR:  function public.uuid_generate_v4() does not exist at character 146
db_1             | 2021-09-15 11:50:39.345 UTC [92] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
db_1             | 2021-09-15 11:50:39.345 UTC [92] STATEMENT:  CREATE TABLE IF NOT EXISTS t_roles (
db_1             | 	    groupe boolean DEFAULT false NOT NULL,
db_1             | 	    id_role serial NOT NULL,
db_1             | 	    uuid_role uuid NOT NULL DEFAULT public.uuid_generate_v4(),
db_1             | 	    identifiant character varying(100),
db_1             | 	    nom_role character varying(50),
db_1             | 	    prenom_role character varying(50),
db_1             | 	    desc_role text,
db_1             | 	    pass character varying(100),
db_1             | 	    pass_plus text,
db_1             | 	    email character varying(250),
db_1             | 	    id_organisme integer,
db_1             | 	    remarques text,
db_1             | 	    active boolean DEFAULT true,
db_1             | 	    champs_addi jsonb,
db_1             | 	    date_insert timestamp without time zone,
db_1             | 	    date_update timestamp without time zone
db_1             | 	);
db_1             | 2021-09-15 11:50:39.346 UTC [92] ERROR:  function public.uuid_generate_v4() does not exist at character 120
db_1             | 2021-09-15 11:50:39.346 UTC [92] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
db_1             | 2021-09-15 11:50:39.346 UTC [92] STATEMENT:  CREATE TABLE IF NOT EXISTS bib_organismes (
nginx_1          | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
db_1             | 	    id_organisme serial NOT NULL,
db_1             | 	    uuid_organisme uuid NOT NULL DEFAULT public.uuid_generate_v4(),
db_1             | 	    nom_organisme character varying(100) NOT NULL,
db_1             | 	    adresse_organisme character varying(128),
db_1             | 	    cp_organisme character varying(5),
db_1             | 	    ville_organisme character varying(100),
db_1             | 	    tel_organisme character varying(14),
db_1             | 	    fax_organisme character varying(14),
db_1             | 	    email_organisme character varying(100),
db_1             | 	    url_organisme character varying(255),
db_1             | 	    url_logo character varying(255),
db_1             | 	    id_parent integer
db_1             | 	);
db_1             | 2021-09-15 11:50:39.369 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.369 UTC [92] STATEMENT:  ALTER TABLE ONLY bib_organismes ADD CONSTRAINT pk_bib_organismes PRIMARY KEY (id_organisme);
db_1             | 2021-09-15 11:50:39.369 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.369 UTC [92] STATEMENT:  ALTER TABLE ONLY t_roles ADD CONSTRAINT pk_t_roles PRIMARY KEY (id_role);
db_1             | 2021-09-15 11:50:39.387 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.387 UTC [92] STATEMENT:  CREATE TRIGGER tri_modify_date_insert_t_roles BEFORE INSERT ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_insert();
db_1             | 2021-09-15 11:50:39.387 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.387 UTC [92] STATEMENT:  CREATE TRIGGER tri_modify_date_update_t_roles BEFORE UPDATE ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_update();
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY t_roles ADD CONSTRAINT t_roles_id_organisme_fkey FOREIGN KEY (id_organisme) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_groupe_fkey FOREIGN KEY (id_role_groupe) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_utilisateur_fkey FOREIGN KEY (id_role_utilisateur) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.388 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.388 UTC [92] STATEMENT:  ALTER TABLE ONLY bib_organismes ADD CONSTRAINT fk_bib_organismes_id_parent FOREIGN KEY (id_parent) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.391 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.391 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_liste ADD CONSTRAINT fk_cor_role_liste_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE;
db_1             | 2021-09-15 11:50:39.394 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.394 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_app_profil ADD CONSTRAINT fk_cor_role_app_profil_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.397 UTC [92] ERROR:  relation "t_roles" does not exist
db_1             | 2021-09-15 11:50:39.397 UTC [92] STATEMENT:  ALTER TABLE ONLY cor_role_token ADD CONSTRAINT cor_role_token_fk_id_role FOREIGN KEY (id_role)
db_1             | 	    REFERENCES t_roles (id_role) MATCH SIMPLE
db_1             | 	    ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.398 UTC [92] ERROR:  relation "bib_organismes" does not exist
db_1             | 2021-09-15 11:50:39.398 UTC [92] STATEMENT:  ALTER TABLE ONLY temp_users ADD CONSTRAINT temp_user_id_application_fkey FOREIGN KEY (id_organisme)
db_1             | 	    REFERENCES bib_organismes (id_organisme) MATCH SIMPLE
db_1             | 	    ON UPDATE CASCADE ON DELETE CASCADE;
db_1             | 2021-09-15 11:50:39.398 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.398 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_groupe
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (groupe);
db_1             | 2021-09-15 11:50:39.399 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.399 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_nom_prenom
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (nom_role, prenom_role);
db_1             | 2021-09-15 11:50:39.399 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist
db_1             | 2021-09-15 11:50:39.399 UTC [92] STATEMENT:  CREATE INDEX i_utilisateurs_active
db_1             | 	  ON utilisateurs.t_roles
db_1             | 	  USING btree
db_1             | 	  (active);
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist at character 888
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW v_userslist_forall_menu AS
db_1             | 	 SELECT a.groupe,
db_1             | 	    a.id_role,
db_1             | 	    a.uuid_role,
db_1             | 	    a.identifiant,
db_1             | 	    a.nom_role,
db_1             | 	    a.prenom_role,
db_1             | 	    (upper(a.nom_role::text) || ' '::text) || a.prenom_role::text AS nom_complet,
db_1             | 	    a.desc_role,
db_1             | 	    a.pass,
db_1             | 	    a.pass_plus,
db_1             | 	    a.email,
db_1             | 	    a.id_organisme,
db_1             | 	    a.organisme,
db_1             | 	    a.id_unite,
db_1             | 	    a.remarques,
db_1             | 	    a.date_insert,
db_1             | 	    a.date_update,
db_1             | 	    a.id_menu
db_1             | 	   FROM ( SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.uuid_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_liste AS id_menu
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_role_liste c ON c.id_role = u.id_role
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          WHERE u.groupe = false AND u.active = true
db_1             | 	        UNION
db_1             | 	         SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.uuid_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_liste AS id_menu
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role
db_1             | 	             JOIN utilisateurs.cor_role_liste c ON c.id_role = g.id_role_groupe
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          WHERE u.groupe = false AND u.active = true) a;
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.t_roles" does not exist at character 889
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW utilisateurs.v_roleslist_forall_applications AS
db_1             | 	SELECT a.groupe,
db_1             | 	    a.active,
db_1             | 	    a.id_role,
db_1             | 	    a.identifiant,
db_1             | 	    a.nom_role,
db_1             | 	    a.prenom_role,
db_1             | 	    a.desc_role,
db_1             | 	    a.pass,
db_1             | 	    a.pass_plus,
db_1             | 	    a.email,
db_1             | 	    a.id_organisme,
db_1             | 	    a.organisme,
db_1             | 	    a.id_unite,
db_1             | 	    a.remarques,
db_1             | 	    a.date_insert,
db_1             | 	    a.date_update,
db_1             | 	    max(a.id_droit) AS id_droit_max,
db_1             | 	    a.id_application
db_1             | 	   FROM ( SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 		    u.active,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_profil AS id_droit,
db_1             | 	            c.id_application
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_role_app_profil c ON c.id_role = u.id_role
db_1             | 	             JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	        UNION
db_1             | 	         SELECT u.groupe,
db_1             | 	            u.id_role,
db_1             | 	            u.identifiant,
db_1             | 	            u.nom_role,
db_1             | 	            u.prenom_role,
db_1             | 	            u.desc_role,
db_1             | 	            u.pass,
db_1             | 	            u.pass_plus,
db_1             | 	            u.email,
db_1             | 	            u.id_organisme,
db_1             | 	            u.active,
db_1             | 	            o.nom_organisme AS organisme,
db_1             | 	            0 AS id_unite,
db_1             | 	            u.remarques,
db_1             | 	            u.date_insert,
db_1             | 	            u.date_update,
db_1             | 	            c.id_profil AS id_droit,
db_1             | 	            c.id_application
db_1             | 	           FROM utilisateurs.t_roles u
db_1             | 	             JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role OR g.id_role_groupe = u.id_role
db_1             | 	             JOIN utilisateurs.cor_role_app_profil c ON c.id_role = g.id_role_groupe
db_1             | 	             LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme
db_1             | 	          ) a
db_1             | 	  WHERE a.active = true
db_1             | 	  GROUP BY a.groupe, a.active, a.id_role, a.identifiant, a.nom_role, a.prenom_role, a.desc_role, a.pass, a.pass_plus, a.email, a.id_organisme, a.organisme, a.id_unite, a.remarques, a.date_insert, a.date_update, a.id_application;
db_1             | 2021-09-15 11:50:39.401 UTC [92] ERROR:  relation "utilisateurs.v_roleslist_forall_applications" does not exist at character 86
db_1             | 2021-09-15 11:50:39.401 UTC [92] STATEMENT:  CREATE OR REPLACE VIEW utilisateurs.v_userslist_forall_applications AS
db_1             | 	SELECT * FROM utilisateurs.v_roleslist_forall_applications
db_1             | 	WHERE groupe = false;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "bib_organismes" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme, fax_organisme, email_organisme, id_organisme) VALUES 
db_1             | 	('Autre', '', '', '', '', '', '', -1)
db_1             | 	;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "bib_organismes" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme) VALUES 
db_1             | 	('ma structure test', 'Rue des bois', '00000', 'VILLE', '00-00-99-00-99');
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "t_roles" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques) VALUES 
db_1             | 	(true, 7, NULL, 'Grp_en_poste', NULL, 'Tous les agents en poste dans la structure', NULL, NULL, NULL, NULL, NULL, 'Groupe des agents de la structure avec droits d''écriture limité')
db_1             | 	,(true, 9, NULL, 'Grp_admin', NULL, 'Tous les administrateurs', NULL, NULL, NULL, NULL, NULL, 'Groupe à droit total')
db_1             | 	;
db_1             | 2021-09-15 11:50:39.496 UTC [94] ERROR:  relation "t_roles" does not exist at character 13
db_1             | 2021-09-15 11:50:39.496 UTC [94] STATEMENT:  INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques, pass_plus) VALUES 
db_1             | 	(false, 1, 'admin', 'Administrateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier', '$2y$13$TMuRXgvIg6/aAez0lXLLFu0lyPk4m8N55NDhvLoUHh/Ar3rFzjFT.')
db_1             | 	,(false, 2, 'agent', 'Agent', 'test', NULL, 'b33aed8f3134996703dc39f9a7c95783', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 3, 'partenaire', 'Partenaire', 'test', NULL, '5bd40a8524882d75f3083903f2c912fc', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 4, 'pierre.paul', 'Paul', 'Pierre', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	,(false, 5, 'validateur', 'Validateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL)
db_1             | 	;
db_1             | 2021-09-15 11:50:39.497 UTC [94] ERROR:  relation "utilisateurs.t_roles" does not exist at character 77
db_1             | 2021-09-15 11:50:39.497 UTC [94] STATEMENT:  SELECT pg_catalog.setval('t_roles_id_role_seq', (SELECT max(id_role)+1 FROM utilisateurs.t_roles), false);
log installation ``` 2021-09-15 11:49:30.942 UTC [35] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db_1 | 2021-09-15 11:49:30.954 UTC [36] LOG: database system was shut down at 2021-09-15 11:49:30 UTC db_1 | 2021-09-15 11:49:30.957 UTC [35] LOG: database system is ready to accept connections db_1 | done db_1 | server started db_1 | db_1 | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh db_1 | CREATE DATABASE db_1 | Loading PostGIS extensions into template_postgis db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | Loading PostGIS extensions into postgres db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | CREATE EXTENSION db_1 | db_1 | waiting for server to shut down....2021-09-15 11:49:34.042 UTC [35] LOG: received fast shutdown request db_1 | 2021-09-15 11:49:34.043 UTC [35] LOG: aborting any active transactions db_1 | 2021-09-15 11:49:34.043 UTC [35] LOG: background worker "logical replication launcher" (PID 42) exited with exit code 1 db_1 | 2021-09-15 11:49:34.045 UTC [37] LOG: shutting down db_1 | 2021-09-15 11:49:34.115 UTC [35] LOG: database system is shut down db_1 | done db_1 | server stopped db_1 | db_1 | PostgreSQL init process complete; ready for start up. db_1 | db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: starting PostgreSQL 12.7 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 db_1 | 2021-09-15 11:49:34.154 UTC [1] LOG: listening on IPv6 address "::", port 5432 db_1 | 2021-09-15 11:49:34.157 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" db_1 | 2021-09-15 11:49:34.178 UTC [54] LOG: database system was shut down at 2021-09-15 11:49:34 UTC db_1 | 2021-09-15 11:49:34.183 UTC [1] LOG: database system is ready to accept connections db_1 | 2021-09-15 11:50:10.593 UTC [84] ERROR: schema "taxonomie" already exists db_1 | 2021-09-15 11:50:10.593 UTC [84] STATEMENT: CREATE SCHEMA taxonomie; db_1 | 2021-09-15 11:50:37.845 UTC [88] ERROR: operator class "gist_trgm_ops" does not exist for access method "gist" db_1 | 2021-09-15 11:50:37.845 UTC [88] STATEMENT: CREATE INDEX i_tri_vm_taxref_list_forautocomplete_search_name db_1 | ON vm_taxref_list_forautocomplete db_1 | USING gist db_1 | (search_name gist_trgm_ops); db_1 | 2021-09-15 11:50:38.019 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.019 UTC [91] DETAIL: Key (cd_nom)=(67111) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.019 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (67111, 67111, 'Ablette'); db_1 | 2021-09-15 11:50:38.019 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.019 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.019 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.020 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.020 UTC [91] DETAIL: Key (cd_nom)=(60612) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.020 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (60612, 60612, 'Lynx boréal'); db_1 | 2021-09-15 11:50:38.020 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.020 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.020 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Key (cd_nom)=(351) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (351, 351, 'Grenouille rousse'); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Key (cd_nom)=(8326) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (8326, 8326, 'Cicindèle hybride'); db_1 | 2021-09-15 11:50:38.021 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.021 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.021 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Key (cd_nom)=(11165) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (11165, 11165, 'Coccinelle à 7 points'); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.022 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.022 UTC [91] DETAIL: Key (cd_nom)=(18437) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.022 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (18437, 18437, 'Ecrevisse à pieds blancs'); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Key (cd_nom)=(81065) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (81065, 81065, 'Alchémille rampante'); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.023 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.023 UTC [91] DETAIL: Key (cd_nom)=(95186) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.023 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais) VALUES (95186, 95186, 'Inule fétide'); db_1 | 2021-09-15 11:50:38.024 UTC [91] ERROR: null value in column "id_nom" violates not-null constraint db_1 | 2021-09-15 11:50:38.024 UTC [91] DETAIL: Failing row contains (100, null). db_1 | 2021-09-15 11:50:38.024 UTC [91] STATEMENT: INSERT INTO cor_nom_liste (id_nom, id_liste) VALUES ((SELECT max(id_nom) FROM taxonomie.bib_noms), 100); db_1 | 2021-09-15 11:50:38.024 UTC [91] ERROR: insert or update on table "bib_noms" violates foreign key constraint "fk_bib_nom_taxref" db_1 | 2021-09-15 11:50:38.024 UTC [91] DETAIL: Key (cd_nom)=(713776) is not present in table "taxref". db_1 | 2021-09-15 11:50:38.024 UTC [91] STATEMENT: INSERT INTO bib_noms (cd_nom, cd_ref, nom_francais, comments) VALUES (713776, 209902, '-', 'un synonyme'); db_1 | 2021-09-15 11:50:39.345 UTC [92] ERROR: function public.uuid_generate_v4() does not exist at character 146 db_1 | 2021-09-15 11:50:39.345 UTC [92] HINT: No function matches the given name and argument types. You might need to add explicit type casts. db_1 | 2021-09-15 11:50:39.345 UTC [92] STATEMENT: CREATE TABLE IF NOT EXISTS t_roles ( db_1 | groupe boolean DEFAULT false NOT NULL, db_1 | id_role serial NOT NULL, db_1 | uuid_role uuid NOT NULL DEFAULT public.uuid_generate_v4(), db_1 | identifiant character varying(100), db_1 | nom_role character varying(50), db_1 | prenom_role character varying(50), db_1 | desc_role text, db_1 | pass character varying(100), db_1 | pass_plus text, db_1 | email character varying(250), db_1 | id_organisme integer, db_1 | remarques text, db_1 | active boolean DEFAULT true, db_1 | champs_addi jsonb, db_1 | date_insert timestamp without time zone, db_1 | date_update timestamp without time zone db_1 | ); db_1 | 2021-09-15 11:50:39.346 UTC [92] ERROR: function public.uuid_generate_v4() does not exist at character 120 db_1 | 2021-09-15 11:50:39.346 UTC [92] HINT: No function matches the given name and argument types. You might need to add explicit type casts. db_1 | 2021-09-15 11:50:39.346 UTC [92] STATEMENT: CREATE TABLE IF NOT EXISTS bib_organismes ( nginx_1 | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh db_1 | id_organisme serial NOT NULL, db_1 | uuid_organisme uuid NOT NULL DEFAULT public.uuid_generate_v4(), db_1 | nom_organisme character varying(100) NOT NULL, db_1 | adresse_organisme character varying(128), db_1 | cp_organisme character varying(5), db_1 | ville_organisme character varying(100), db_1 | tel_organisme character varying(14), db_1 | fax_organisme character varying(14), db_1 | email_organisme character varying(100), db_1 | url_organisme character varying(255), db_1 | url_logo character varying(255), db_1 | id_parent integer db_1 | ); db_1 | 2021-09-15 11:50:39.369 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.369 UTC [92] STATEMENT: ALTER TABLE ONLY bib_organismes ADD CONSTRAINT pk_bib_organismes PRIMARY KEY (id_organisme); db_1 | 2021-09-15 11:50:39.369 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.369 UTC [92] STATEMENT: ALTER TABLE ONLY t_roles ADD CONSTRAINT pk_t_roles PRIMARY KEY (id_role); db_1 | 2021-09-15 11:50:39.387 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.387 UTC [92] STATEMENT: CREATE TRIGGER tri_modify_date_insert_t_roles BEFORE INSERT ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_insert(); db_1 | 2021-09-15 11:50:39.387 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.387 UTC [92] STATEMENT: CREATE TRIGGER tri_modify_date_update_t_roles BEFORE UPDATE ON t_roles FOR EACH ROW EXECUTE PROCEDURE modify_date_update(); db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY t_roles ADD CONSTRAINT t_roles_id_organisme_fkey FOREIGN KEY (id_organisme) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_groupe_fkey FOREIGN KEY (id_role_groupe) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY cor_roles ADD CONSTRAINT cor_roles_id_role_utilisateur_fkey FOREIGN KEY (id_role_utilisateur) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.388 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.388 UTC [92] STATEMENT: ALTER TABLE ONLY bib_organismes ADD CONSTRAINT fk_bib_organismes_id_parent FOREIGN KEY (id_parent) REFERENCES bib_organismes(id_organisme) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.391 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.391 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_liste ADD CONSTRAINT fk_cor_role_liste_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE; db_1 | 2021-09-15 11:50:39.394 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.394 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_app_profil ADD CONSTRAINT fk_cor_role_app_profil_id_role FOREIGN KEY (id_role) REFERENCES t_roles(id_role) ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.397 UTC [92] ERROR: relation "t_roles" does not exist db_1 | 2021-09-15 11:50:39.397 UTC [92] STATEMENT: ALTER TABLE ONLY cor_role_token ADD CONSTRAINT cor_role_token_fk_id_role FOREIGN KEY (id_role) db_1 | REFERENCES t_roles (id_role) MATCH SIMPLE db_1 | ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.398 UTC [92] ERROR: relation "bib_organismes" does not exist db_1 | 2021-09-15 11:50:39.398 UTC [92] STATEMENT: ALTER TABLE ONLY temp_users ADD CONSTRAINT temp_user_id_application_fkey FOREIGN KEY (id_organisme) db_1 | REFERENCES bib_organismes (id_organisme) MATCH SIMPLE db_1 | ON UPDATE CASCADE ON DELETE CASCADE; db_1 | 2021-09-15 11:50:39.398 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.398 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_groupe db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (groupe); db_1 | 2021-09-15 11:50:39.399 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.399 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_nom_prenom db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (nom_role, prenom_role); db_1 | 2021-09-15 11:50:39.399 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist db_1 | 2021-09-15 11:50:39.399 UTC [92] STATEMENT: CREATE INDEX i_utilisateurs_active db_1 | ON utilisateurs.t_roles db_1 | USING btree db_1 | (active); db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist at character 888 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW v_userslist_forall_menu AS db_1 | SELECT a.groupe, db_1 | a.id_role, db_1 | a.uuid_role, db_1 | a.identifiant, db_1 | a.nom_role, db_1 | a.prenom_role, db_1 | (upper(a.nom_role::text) || ' '::text) || a.prenom_role::text AS nom_complet, db_1 | a.desc_role, db_1 | a.pass, db_1 | a.pass_plus, db_1 | a.email, db_1 | a.id_organisme, db_1 | a.organisme, db_1 | a.id_unite, db_1 | a.remarques, db_1 | a.date_insert, db_1 | a.date_update, db_1 | a.id_menu db_1 | FROM ( SELECT u.groupe, db_1 | u.id_role, db_1 | u.uuid_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_liste AS id_menu db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_role_liste c ON c.id_role = u.id_role db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | WHERE u.groupe = false AND u.active = true db_1 | UNION db_1 | SELECT u.groupe, db_1 | u.id_role, db_1 | u.uuid_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_liste AS id_menu db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role db_1 | JOIN utilisateurs.cor_role_liste c ON c.id_role = g.id_role_groupe db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | WHERE u.groupe = false AND u.active = true) a; db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.t_roles" does not exist at character 889 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW utilisateurs.v_roleslist_forall_applications AS db_1 | SELECT a.groupe, db_1 | a.active, db_1 | a.id_role, db_1 | a.identifiant, db_1 | a.nom_role, db_1 | a.prenom_role, db_1 | a.desc_role, db_1 | a.pass, db_1 | a.pass_plus, db_1 | a.email, db_1 | a.id_organisme, db_1 | a.organisme, db_1 | a.id_unite, db_1 | a.remarques, db_1 | a.date_insert, db_1 | a.date_update, db_1 | max(a.id_droit) AS id_droit_max, db_1 | a.id_application db_1 | FROM ( SELECT u.groupe, db_1 | u.id_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | u.active, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_profil AS id_droit, db_1 | c.id_application db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_role_app_profil c ON c.id_role = u.id_role db_1 | JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | UNION db_1 | SELECT u.groupe, db_1 | u.id_role, db_1 | u.identifiant, db_1 | u.nom_role, db_1 | u.prenom_role, db_1 | u.desc_role, db_1 | u.pass, db_1 | u.pass_plus, db_1 | u.email, db_1 | u.id_organisme, db_1 | u.active, db_1 | o.nom_organisme AS organisme, db_1 | 0 AS id_unite, db_1 | u.remarques, db_1 | u.date_insert, db_1 | u.date_update, db_1 | c.id_profil AS id_droit, db_1 | c.id_application db_1 | FROM utilisateurs.t_roles u db_1 | JOIN utilisateurs.cor_roles g ON g.id_role_utilisateur = u.id_role OR g.id_role_groupe = u.id_role db_1 | JOIN utilisateurs.cor_role_app_profil c ON c.id_role = g.id_role_groupe db_1 | LEFT JOIN utilisateurs.bib_organismes o ON o.id_organisme = u.id_organisme db_1 | ) a db_1 | WHERE a.active = true db_1 | GROUP BY a.groupe, a.active, a.id_role, a.identifiant, a.nom_role, a.prenom_role, a.desc_role, a.pass, a.pass_plus, a.email, a.id_organisme, a.organisme, a.id_unite, a.remarques, a.date_insert, a.date_update, a.id_application; db_1 | 2021-09-15 11:50:39.401 UTC [92] ERROR: relation "utilisateurs.v_roleslist_forall_applications" does not exist at character 86 db_1 | 2021-09-15 11:50:39.401 UTC [92] STATEMENT: CREATE OR REPLACE VIEW utilisateurs.v_userslist_forall_applications AS db_1 | SELECT * FROM utilisateurs.v_roleslist_forall_applications db_1 | WHERE groupe = false; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "bib_organismes" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme, fax_organisme, email_organisme, id_organisme) VALUES db_1 | ('Autre', '', '', '', '', '', '', -1) db_1 | ; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "bib_organismes" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO bib_organismes (nom_organisme, adresse_organisme, cp_organisme, ville_organisme, tel_organisme) VALUES db_1 | ('ma structure test', 'Rue des bois', '00000', 'VILLE', '00-00-99-00-99'); db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "t_roles" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques) VALUES db_1 | (true, 7, NULL, 'Grp_en_poste', NULL, 'Tous les agents en poste dans la structure', NULL, NULL, NULL, NULL, NULL, 'Groupe des agents de la structure avec droits d''écriture limité') db_1 | ,(true, 9, NULL, 'Grp_admin', NULL, 'Tous les administrateurs', NULL, NULL, NULL, NULL, NULL, 'Groupe à droit total') db_1 | ; db_1 | 2021-09-15 11:50:39.496 UTC [94] ERROR: relation "t_roles" does not exist at character 13 db_1 | 2021-09-15 11:50:39.496 UTC [94] STATEMENT: INSERT INTO t_roles (groupe, id_role, identifiant, nom_role, prenom_role, desc_role, pass, email, date_insert, date_update, id_organisme, remarques, pass_plus) VALUES db_1 | (false, 1, 'admin', 'Administrateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier', '$2y$13$TMuRXgvIg6/aAez0lXLLFu0lyPk4m8N55NDhvLoUHh/Ar3rFzjFT.') db_1 | ,(false, 2, 'agent', 'Agent', 'test', NULL, 'b33aed8f3134996703dc39f9a7c95783', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 3, 'partenaire', 'Partenaire', 'test', NULL, '5bd40a8524882d75f3083903f2c912fc', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 4, 'pierre.paul', 'Paul', 'Pierre', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ,(false, 5, 'validateur', 'Validateur', 'test', NULL, '21232f297a57a5a743894a0e4a801fc3', NULL, NULL, NULL, -1, 'utilisateur test à modifier ou supprimer', NULL) db_1 | ; db_1 | 2021-09-15 11:50:39.497 UTC [94] ERROR: relation "utilisateurs.t_roles" does not exist at character 77 db_1 | 2021-09-15 11:50:39.497 UTC [94] STATEMENT: SELECT pg_catalog.setval('t_roles_id_role_seq', (SELECT max(id_role)+1 FROM utilisateurs.t_roles), false); ```
juminet commented 2021-09-15 12:07:37 +00:00
Author
Owner
Copy Link

cfr db.session.execute("CREATE SCHEMA IF NOT EXISTS gnc_obstax")

qui doit être exécuté avec python server.py.

Attention que ce fichier a changé avec une dernière version de Gn !

cfr `db.session.execute("CREATE SCHEMA IF NOT EXISTS gnc_obstax")` qui doit être exécuté avec python server.py. Attention que ce fichier a changé avec une dernière version de Gn !
juminet commented 2021-09-15 13:17:15 +00:00
Author
Owner
Copy Link

docker-compose exec db bash
psql -h localhost -U postgres -d referentielsdb
\dn

Les schémas existent bien, mais sont vide de tables.

docker-compose exec db bash psql -h localhost -U postgres -d referentielsdb \dn Les schémas existent bien, mais sont vide de tables.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
docker
documentation
fonctionnalité
prêt
No Label
bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
celinicolay julienfastre juminet LenaertsJ mathieu nblondiau
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: champs-libres/biommap#20
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?