[Spacewalk-list] Nightly/git version question ! (new git build)
Franz Skale
franz.skale at cubit.at
Mon Oct 19 23:53:31 UTC 2009
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
also same problem.
1.) desc RHNPACKAGE
desc rhnPackage
Name Null? Type
----------------------------------------- --------
- ----------------------------
ID NOT NULL NUMBER
ORG_ID NUMBER
NAME_ID NOT NULL NUMBER
EVR_ID NOT NULL NUMBER
PACKAGE_ARCH_ID NOT NULL NUMBER
PACKAGE_GROUP NUMBER
RPM_VERSION VARCHAR2(16)
DESCRIPTION VARCHAR2(4000)
SUMMARY VARCHAR2(4000)
PACKAGE_SIZE NOT NULL NUMBER
PAYLOAD_SIZE NUMBER
BUILD_HOST VARCHAR2(256)
BUILD_TIME DATE
SOURCE_RPM_ID NUMBER
CHECKSUM_ID NOT NULL NUMBER
VENDOR NOT NULL VARCHAR2(64)
PAYLOAD_FORMAT VARCHAR2(32)
COMPAT NUMBER(1)
PATH VARCHAR2(1000)
HEADER_SIG VARCHAR2(64)
COPYRIGHT VARCHAR2(128)
COOKIE VARCHAR2(128)
LAST_MODIFIED NOT NULL DATE
CREATED NOT NULL DATE
MODIFIED NOT NULL DATE
HEADER_START NOT NULL NUMBER
HEADER_END NOT NULL NUMBER
2.) osa-dispatcher problem:
osa-dispatcher -N -v -v -v
RHN 31453 2009/10/20 01:45:08 +02:00: ('Invalid password',)
3.) Package sync: (traceback)
Extra information about this error:
SQL Error generated: ('ORA-00904: "P"."MD5SUM": invalid identifier\n',
904, 'select p.md5sum md5sum, p.path path from rhnPackageEVR pe,
rhnPackageName pn, rhnPackage p, rhnPackageArch pa where pn.name =
:pkg_name and ( pe.epoch = :pkg_epoch or ( pe.epoch is null and
:pkg_epoch is null ) ) and pe.version = :pkg_version and
pe.release = :pkg_rel and ( p.org_id = :orgid or ( p.org_id is null
and :orgid is null ) ) and p.name_id = pn.id and p.evr_id =
pe.id and p.package_arch_id = pa.id and pa.label = :pkg_arch and
p.md5sum =: md5sum')
Packages: (build from git via git / master)
eventReceivers-2.20.13-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
MessageQueue-3.26.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
nocpulse-common-2.1.18-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
nocpulse-db-perl-3.6.3-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
NOCpulsePlugins-2.208.10-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
NPalert-1.126.10-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
oracle-instantclient-selinux-10.2-16.git.45e659b10d0ac8f0af5058190c6a33d64888df96
oracle-instantclient-sqlplus-selinux-10.2-16.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-CLAC-1.9.8-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Debug-1.23.15-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Gritch-1.27.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Object-1.26.10-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-OracleDB-1.28.17-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-PersistentConnection-1.5.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Probe-1.183.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-ProcessPool-0.10.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Scheduler-1.58.12-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-SetID-1.6.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-NOCpulse-Utils-1.14.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
perl-Satcon-1.10-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
ProgAGoGo-1.11.6-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-check-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-client-tools-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-custom-info-5.4.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-kickstart-5.4.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-kickstart-common-5.4.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhnlib-2.5.13-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhnmd-5.3.2-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-setup-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
rhn-setup-gnome-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-bootstrap-1.11.5-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-bootstrap-server-1.13.3-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-cluster-1.54.7-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-dbsynch-1.3.2-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-general-1.216.16-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-generator-2.29.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-installer-3.24.6-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SatConfig-spread-1.1.3-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
scdb-1.15.6-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SNMPAlerts-0.5.5-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-admin-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-base-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-base-minimal-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-branding-0.7.1-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-common-0.7.2-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-config-0.7.1-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-cypress-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-dobby-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-doc-indexes-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-grail-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-html-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-koan-0.2.2-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-monitoring-0.7.1-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-moon-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-oracle-0.7.2-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-proxy-docs-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-proxy-html-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-proxy-monitoring-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-pxt-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-repo-0.7-3.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-search-0.7.0-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-setup-0.7.6-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-sniglets-0.7.4-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
spacewalk-ssl-cert-check-1.9-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SputLite-client-0.48.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
SputLite-server-0.48.11-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
ssl_bridge-1.9.3-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
status_log_acceptor-0.12.8-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
tsdb-1.27.21-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
yum-rhn-plugin-0.7.6-1.git.45e659b10d0ac8f0af5058190c6a33d64888df96
kind regards
franz
Michael Mraka schrieb:
> Franz Skale wrote: % -----BEGIN PGP SIGNED MESSAGE----- % Hash:
> SHA1 % % Hi, % i have installed the lastest version for testing
> purposes. % THe nighty build don't work as expected so i tested the
> git version % and rebuild all packages. % But the problem still
> extists. % Neither rhnpush nor spacewalk-repo-sync is working. %
> The exception isn't so clear to me and i hope someone can bring %
> something to light. % The exception is as follows: % % Extra
> information about this error: % SQL Error generated: ('ORA-00904:
> "P"."MD5SUM": invalid identifier\n', % 904, 'select p.md5sum
> md5sum, p.path path from rhnPackageEVR pe, % rhnPackageName pn,
> rhnPackage p, rhnPackageArch pa where pn.name = % :pkg_name and
> ( pe.epoch = :pkg_epoch or ( pe.epoch is null and % :pkg_epoch is
> null ) ) and pe.version = :pkg_version and % pe.release =
> :pkg_rel and ( p.org_id = :orgid or ( p.org_id is null % and
> :orgid is null ) ) and p.name_id = pn.id and p.evr_id = %
> pe.id and p.package_arch_id = pa.id and pa.label = :pkg_arch
> and % p.md5sum =: md5sum') % % Is there a problem in
> checksum/md5sum handling or is the schema % different ?
>
> We are currently in the middle of checksum/md5sum changes but these
> changes are being done in separate branch. You should not
> experience such errors in git master.
>
> Could you post how your rhnPackage table looks like? # sqlplus
> spacewalk/spacewalk at xe SQL> desc rhnPackage
>
>
> % Thanks in advance % % Franz
>
> -- Michael Mráka Satellite Engineering, Red Hat
>
- --
kind regards, +43-664-8468643
Franz Skale +43-1-7189880-0
Senior Systems Engineer www.cubit.at
PGP KeyID 0xB294D39A
Key Fingerprint B508 8896 B83C B374 770D 80EF 3AD9 4A66 B294 D39A
Neuer Standort: 1070 Wien, Zieglergasse 67/3/1
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkrc+/sACgkQOtlKZrKU05ra8gCdE3PwoRrlXfygk6yokmayOI43
Ps0An1OxiwbTHf9nBMWUI9TPyY8OPPzi
=Aa/W
-----END PGP SIGNATURE-----
More information about the Spacewalk-list
mailing list