Bonjour,
Je suis entrain de rédiger la doc développeur Mageia 6 pour Ekylbtre v2:
https://wiki.ekylibre.org/fr/guides/installation-on-mageia-6
La partie de création de la base de données et le schéma par defaut se passe bien via la commande:
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk rake db:create db:migrate
Apres avoir recréer et supprimer les 2 bases Postgresql pour Ekylibre et lancer la commande de création de l’instance de démonstration (derniere version du depot git) via
rake first_run name=demo folder=demo max=80
Je me retrouve avec des problèmes au niveau de requetes SQL concernant une erreur sur la relation “index_account_balances_on_account_id” qui existe déjà :
-- Name: intervention_participations fk_rails_e81467e70f; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY intervention_participations
ADD CONSTRAINT fk_rails_e81467e70f FOREIGN KEY (product_id) REFERENCES products(id);
--
-- Name: outgoing_payments fk_rails_ee973f6d0f; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY outgoing_payments
ADD CONSTRAINT fk_rails_ee973f6d0f FOREIGN KEY (journal_entry_id) REFERENCES journal_entries(id);
--
-- Name: financial_year_exchanges fk_rails_f0120f1957; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY financial_year_exchanges
ADD CONSTRAINT fk_rails_f0120f1957 FOREIGN KEY (financial_year_id) REFERENCES financial_years(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- PostgreSQL database dump complete
--
/home/user/ekylibre/ekylibre/lib/ekylibre/tenant.rb:52:in `create'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:75:in `secure_tenant'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:56:in `launch'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:23:in `launch!'
/home/user/ekylibre/ekylibre/lib/tasks/first_run.rake:46:in `block in <top (required)>'
Caused by:
PG::DuplicateTable: ERROR: relation "index_account_balances_on_account_id" already exists
/home/user/ekylibre/ekylibre/lib/ekylibre/tenant.rb:52:in `create'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:75:in `secure_tenant'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:56:in `launch'
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:23:in `launch!'
/home/user/ekylibre/ekylibre/lib/tasks/first_run.rake:46:in `block in <top (required)>'
Tasks: TOP => first_run
(See full trace by running task with --trace)
La log en version trace:
[user@localhost first_runs (master)]$ rake first_run name=demo folder=demo max=80 --trace
(in /home/user/ekylibre/ekylibre)
JAVA_HOME has not been set automatically because it’s not Debian here.
** Invoke first_run (first_time)
** Invoke environment (first_time)
** Execute environment
W, [2018-03-06T00:00:22.899538 #16657] WARN – : [SKYLIGHT] [1.5.0] Running Skylight in development mode. No data will be reported until you deploy your app.
(To disable this message for all local apps, run skylight disable_dev_warning
.)
** Execute first_run
rake aborted!
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation “preferences” does not exist
LIGNE 5 : WHERE a.attrelid = ‘“preferences”’::regclass
** ^**
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
** pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod**
** FROM pg_attribute a LEFT JOIN pg_attrdef d**
** ON a.attrelid = d.adrelid AND a.attnum = d.adnum**
** WHERE a.attrelid = ‘“preferences”’::regclass**
** AND a.attnum > 0 AND NOT a.attisdropped**
** ORDER BY a.attnum**
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in async_exec' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in
block in exec_no_cache’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in block in log' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:in
instrument’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in log' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in
exec_no_cache’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in execute_and_clear' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in
exec_query’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:733:in column_definitions' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-postgis-adapter-3.1.5/lib/active_record/connection_adapters/postgis/schema_statements.rb:9:in
columns’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/schema_cache.rb:43:in columns' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/attributes.rb:93:in
columns’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/attributes.rb:98:in columns_hash' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in
block in find_by’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in each' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in
all?’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in find_by' /home/user/ekylibre/ekylibre/app/models/preference.rb:122:in
get!’
/home/user/ekylibre/ekylibre/app/models/preference.rb:115:in []' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run/base.rb:24:in
initialize’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:60:in new' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:60:in
block in launch’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:77:in block in secure_tenant' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/apartment-1.2.0/lib/apartment/adapters/abstract_adapter.rb:106:in
switch’
/home/user/ekylibre/ekylibre/lib/ekylibre/tenant.rb:219:in switch' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:76:in
secure_tenant’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:56:in launch' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:23:in
launch!’
/home/user/ekylibre/ekylibre/lib/tasks/first_run.rake:46:in block in <top (required)>' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in
call’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in
each’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:195:in
block in invoke_with_call_chain’
/home/user/.rbenv/versions/2.2.3/lib/ruby/2.2.0/monitor.rb:211:in mon_synchronize' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:188:in
invoke_with_call_chain’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:181:in invoke' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:160:in
invoke_task’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block (2 levels) in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in
each’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:125:in
run_with_threads’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:110:in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:83:in
block in run’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:186:in standard_exception_handling' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:80:in
run’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/exe/rake:27:in <top (required)>' /home/user/.rbenv/versions/2.2.3/bin/rake:23:in
load’
/home/user/.rbenv/versions/2.2.3/bin/rake:23:in `’
Caused by:
PG::UndefinedTable: ERROR: relation “preferences” does not exist
LIGNE 5 : WHERE a.attrelid = ‘“preferences”’::regclass
** ^**
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in async_exec' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in
block in exec_no_cache’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:484:in block in log' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activesupport-4.2.10/lib/active_support/notifications/instrumenter.rb:20:in
instrument’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract_adapter.rb:478:in log' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in
exec_no_cache’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in execute_and_clear' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in
exec_query’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/postgresql_adapter.rb:733:in column_definitions' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-postgis-adapter-3.1.5/lib/active_record/connection_adapters/postgis/schema_statements.rb:9:in
columns’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/connection_adapters/schema_cache.rb:43:in columns' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/attributes.rb:93:in
columns’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/attributes.rb:98:in columns_hash' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in
block in find_by’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in each' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in
all?’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/activerecord-4.2.10/lib/active_record/core.rb:173:in find_by' /home/user/ekylibre/ekylibre/app/models/preference.rb:122:in
get!’
/home/user/ekylibre/ekylibre/app/models/preference.rb:115:in []' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run/base.rb:24:in
initialize’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:60:in new' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:60:in
block in launch’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:77:in block in secure_tenant' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/apartment-1.2.0/lib/apartment/adapters/abstract_adapter.rb:106:in
switch’
/home/user/ekylibre/ekylibre/lib/ekylibre/tenant.rb:219:in switch' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:76:in
secure_tenant’
/home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:56:in launch' /home/user/ekylibre/ekylibre/lib/ekylibre/first_run.rb:23:in
launch!’
/home/user/ekylibre/ekylibre/lib/tasks/first_run.rake:46:in block in <top (required)>' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in
call’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in block in execute' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in
each’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:251:in execute' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:195:in
block in invoke_with_call_chain’
/home/user/.rbenv/versions/2.2.3/lib/ruby/2.2.0/monitor.rb:211:in mon_synchronize' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:188:in
invoke_with_call_chain’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/task.rb:181:in invoke' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:160:in
invoke_task’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block (2 levels) in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in
each’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:116:in block in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:125:in
run_with_threads’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:110:in top_level' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:83:in
block in run’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:186:in standard_exception_handling' /home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/lib/rake/application.rb:80:in
run’
/home/user/.rbenv/versions/2.2.3/lib/ruby/gems/2.2.0/gems/rake-12.3.0/exe/rake:27:in <top (required)>' /home/user/.rbenv/versions/2.2.3/bin/rake:23:in
load’
/home/user/.rbenv/versions/2.2.3/bin/rake:23:in `'
Tasks: TOP => first_run
[user@localhost first_runs (master)]$