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

[Colin Coe]

As root, or with root privilege:
---
yum install -y rlwrap
---

CC

On Tue, Apr 20, 2010 at 12:25 PM, rob morrien <rmorrien at xs4all.nl> wrote:
>>
>> 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
>>
>
> thomans,
>
>  i did  the next commands on my centos  5.4  spacewalk machine
>  su - oracle
> -bash-3.2$ rlwrap  sqlplus / as sysdba
> -bash: rlwrap: command not found   <-----------------
> -bash-3.2$ whoami
> oracle
> -bash-3.2$
>
>
>
>
>>
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
RHCE#805007969328369