Mailinglist Archive: opensuse-buildservice (287 mails)

< Previous Next >
Re: [opensuse-buildservice] frontend and sqlite3
  • From: Marcus Rueckert <mrueckert@xxxxxxx>
  • Date: Mon, 3 Sep 2007 16:24:41 +0200
  • Message-id: <20070903142441.GP3255@xxxxxxx>
On 2007-09-03 17:19:49 +0400, AgBr wrote:
> 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:
[...]
> 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?

afaik sqlite only supports one index per table. and you get the error
when it tries to add the 2nd index. imho this index might be a candidate
for a drop. but we have other tables where we definitely need 2 indeces.

    darix

-- 
          openSUSE - SUSE Linux is my linux
              openSUSE is good for you
                  www.opensuse.org
---------------------------------------------------------------------
To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse-buildservice+help@xxxxxxxxxxxx

< Previous Next >
Follow Ups
References