[Spacewalk-list] spacewalk-repo-sync corrupts database

[Thomas von Steiger]

On 16.04.2010, at 14:09, rob morrien wrote:

>> On 16 April 2010 10:17, rob morrien <rmorrien at xs4all.nl> wrote:
>> 
>>> hello spacewalk support,
>>> 
>>> I did the next steps
>>> 
>>> 1 reposync --repoid=epel -c /etc/reposync.conf -p
>>> /var/www/html/pub/CentOS5-i386          ( no problems)
>>> 2 cd /var/www/html/pub/CentOS5-i386/epel  (no problems)
>>> 3 createrepo /var/www/html/pub/CentOS5-i386/epel  ( no problems )
>>> 
>>> 
>>> 4 /usr/bin/spacewalk-repo-sync --channel epel5-i386 \
>>>                            --url
>>> file:///var/www/html/pub/CentOS5-i386/epel/ \
>>>                            --type yum --label epel5-i386
>>> info from system repo file:///var/www/html/pub/CentOS5-i386/epel/ has
>>> 4764
>>> packages.
>>> 
>>> now 635 packages will be added to the epel channel from spacewalk
>>> 
>>> process started to upload packages
>>> 
>>> 613/635 : libwsman1-2.2.0-5.el5-0.i386
>>> 614/635 : perl-Nmap-Parser-1.19-4.el5-0.noarch
>>> 615/635 : nntpgrab-gui-base-0.6.1-1.el5-0.i386
>>> 
>>> the repo sync is hanging
>>> 
>>> logon to spacewalk not working anymore
>>> 
>>> the only way to fix it is restoring the database
>>> 
>>> i tested this on 5 different machines and all the machines are hanging
>>> on the spacewalk-repo-sync aktion.
>>> 
>>> 
>>> 
>>> Pls help to fix this problem
>>> 
>>> 
>> are you hitting the 4gb limit of the db ?
> 
> sorry how can i check this?
> 

create ssh tunnel to your spacewalk 
ssh -L 9000:localhost:9000 -l root -N yourspacewalk.domain.com
and browse to http://127.0.0.1:9000/apex
login with sys and your pw.
then you can got to Home>Administration>Storage


or


ssh to your spacewalk
su - oracle
rlwrap  sqlplus / as sysdba

and use this sql query:

http://www.orafaq.com/wiki/Tablespace#Check_free.2Fused_space_per_tablespace



Thomas