Mailinglist Archive: opensuse-buildservice (287 mails)

< Previous Next >
[opensuse-buildservice] frontend and sqlite3
  • From: AgBr <agbr@xxxxxxxxx>
  • Date: Mon, 03 Sep 2007 17:19:49 +0400
  • Message-id: <fbh1lf$so5$1@xxxxxxxxxxxxx>
Hello,

I use obs-api-0.1.1-37.1. Is it possible to use frontend with sqlite3
database 
engine?

my /srv/www/obs/frontend/config/database.yml:

development:
  adapter: sqlite3
  database: db/frontend_development.sqlite3

rake migrate returns an error:

(in /srv/www/obs/frontend)
>>>>>>>>>>>>>>>>>>>>>>> /srv/www/obs/common/lib <<<<<<<<<<<<<<<<<<<<<<<<<<
Using global 
environment /srv/www/obs/frontend/config/../config/environments/development_base.rb
Using global 
environment /srv/www/obs/frontend/config/../config/environments/development_base.rb
== InitialDatabase: migrating 
=================================================
-- create_table("groups", {:force=>true})
   -> 0.5798s
-- add_index("groups", ["parent_id"], {:name=>"groups_parent_id_index"})
   -> 0.2343s
-- create_table("groups_roles", {:force=>true, :id=>false})
   -> 0.4251s
-- add_index("groups_roles", ["group_id", "role_id"], 
{:name=>"groups_roles_all_index", :unique=>true})
   -> 0.0716s
-- add_index("groups_roles", ["role_id"], {:name=>"role_id"})
   -> 0.2138s
-- create_table("groups_users", {:force=>true, :id=>false})
   -> 0.2460s
-- add_index("groups_users", ["group_id", "user_id"], 
{:name=>"groups_users_all_index", :unique=>true})
   -> 0.0992s
-- add_index("groups_users", ["user_id"], {:name=>"user_id"})
   -> 0.1558s
-- create_table("roles", {:force=>true})
   -> 0.4221s
-- add_index("roles", ["parent_id"], {:name=>"roles_parent_id_index"})
   -> 0.1087s
-- create_table("roles_static_permissions", {:force=>true, :id=>false})
   -> 0.2324s
-- add_index("roles_static_permissions",
["static_permission_id", "role_id"], 
{:name=>"roles_static_permissions_all_index", :unique=>true})
   -> 0.1104s
-- add_index("roles_static_permissions", ["role_id"], {:name=>"role_id"})
rake aborted!
SQLite3::SQLException: index role_id already exists: CREATE  INDEX "role_id" 
ON roles_static_permissions ("role_id")

(See full trace by running task with --trace)

What's wrong?

---------------------------------------------------------------------
To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse-buildservice+help@xxxxxxxxxxxx

< Previous Next >
Follow Ups