[Spacewalk-list] spacewalk-dobby problem

[stefano ciavarella]

'SPACEWALK-SCHEMA-1.5-TO-SPACEWALK-SCHEMA-1.6/125-ALTER-INDEX-RHNRAM.SQL.ORACL
------------------------------------------------------------------------------
spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle


Index dropped.

    ON rhnRam (server_id)
       *
ERROR at line 2:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


this is the error into  spacewalk-schema-1.7.log




On Fri, May 25, 2012 at 3:57 PM, Jan Pazdziora <jpazdziora at redhat.com>wrote:

> On Fri, May 25, 2012 at 03:28:51PM +0200, stefano ciavarella wrote:
> > when i try to import the oracle's dump :
> >
> > PGPASSWORD=spacepw psql -h localhost -U spaceuser spaceschema <
> > /var/spacewalk/spacewalk-oracle.dump
> >  setval
> > --------
> >   10926
> > (1 row)
> >
> >  setval
> > --------
> >       1
> > (1 row)
> >
> >  setval
> > --------
> >       1
> > (1 row)
> >
> >  setval
> > --------
> >       1
> > (1 row)
> >
> >  setval
> > --------
> >       1
> > (1 row)
> >
> >  setval
> > --------
> >       1
> > (1 row)
> >
> > ERROR:  relation "rhn_appinst_instance_id_seq" does not exist
> > LINE 1: select pg_catalog.setval('rhn_appinst_instance_id_seq', 1, f...
> >                                  ^
>
> This means your current database schema is <= 1.6 while the new one
> that you have in PostgreSQL is 1.7. As noted in
>
>        https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle
>
>        Therefore, you need the PostgreSQL schema to be of the same
>        version as the one in Oracle. In other words, you need to
>        upgrade the Spacewalk and the Oracle schema to the latest
>        version, to match the schema that you will likely have in
>        PostgreSQL.
>
> --
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
Stefano Ciavarella
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120529/cfd85e13/attachment.htm>