Hi Dominik,
This is a problem i also periodically have (I never took the time to look at
this problem because i do not really like database stuff. :-) and actually we
did not have an open ticket for that. Therefore i created one based on your
report:
http://svn.oscar.openclustergroup.org/trac/oscar/ticket/361
Thanks for the bug report, this is very usefull, i am sure DongInn (our
database guy) will do his best to fix the bug.
If you see other issues in the future, feel free to fill up bug reports.
Regards,
Le mercredi 1 août 2007 07:36, Dominik Schips a écrit :
> Hello,
>
> I get into trouble with the current trunk (5.1).
>
> I am using openSUSE 10.2 (x86_64) and use the
> oscar-repo-suse-10.0-i386-5.1a1r6068M.tar.gz and
> oscar-repo-common-rpms-5.1a1r6068M.tar.gz packages.
>
> As I understood OSCAR I need to build these packages for openSUSE
> (x86_64) new but for the first try I install the repo-suse-10 and
> repo-common packages.
>
> I get this error:
>
> List of available OPKGs:
> [ /opt/oscar/packages/apitest /opt/oscar/packages/base
> /opt/oscar/packages/c3 /opt/oscar/packages/disable-services
> /opt/oscar/packages/ganglia /opt/oscar/packages/jobmonarch
> /opt/oscar/packages/lam /opt/oscar/packages/linux-ha
> /opt/oscar/packages/loghost /opt/oscar/packages/maui
> /opt/oscar/packages/mpich /opt/oscar/packages/mta-config
> /opt/oscar/packages/netbootmgr /opt/oscar/packages/networking
> /opt/oscar/packages/ntpconfig /opt/oscar/packages/oda
> /opt/oscar/packages/openmpi /opt/oscar/packages/opium
> /opt/oscar/packages/pfilter /opt/oscar/packages/pvm
> /opt/oscar/packages/rapt /opt/oscar/packages/sc3 /opt/oscar/packages/sge
> /opt/oscar/packages/sis /opt/oscar/packages/switcher
> /opt/oscar/packages/sync_files /opt/oscar/packages/torque
> /opt/oscar/packages/yume ] Array: 28 elements
> ERROR 1062 (23000) at line 311: Duplicate entry '0' for key 1
> DB_DEBUG>/opt/oscar/scripts/package_config_xmls_to_database:
> ====> cannot create OSCAR tables
> at /opt/oscar/scripts/package_config_xmls_to_database line 463.
> Couldn't set up oda database at ./wizard_prep line 383
>
> For me this looks like a wrong database entry or something similar but I
> didn't find the problem and I am no advanced database (mysql) user.
> A look at the mysql database look like every table is available and set
> up correct.
>
> In which file I have to look for line 311? There is no information or
> did I missed something?
>
> What cause this "ERROR 1062 (23000) at line 311: Duplicate entry '0' for
> key 1"?
>
>
> And (I think) a typo:
>
> In /opt/oscar/scripts/package_config_xmls_to_database the lines
>
> # The table information of all the OSCAR database tables is defined at
> # $ENV{OSCAR_HOME}/share/prereqs/oda/oscar_table.sql.
>
> are wrong. There is no
> $ENV{OSCAR_HOME}/share/prereqs/oda/oscar_table.sql
>
> Only /opt/oscar/packages/oda/scripts/oscar_table.sql
> Maybe the comment information isn't up to date in this file.
--
Geoffroy
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Oscar-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-devel
