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

[rob morrien]

>
> 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
>
>
> hello support:

afther the reposync problems i can't connect to oracle anymore


that means i can't check the database anymore.

pls can you test it overthere , because we have this problem on many test
spacewalk systems.

regards rob



 _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>