[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
>

ather thomas his advise i got the next info from tablespace just before i
start the upgrade.

Tablespace                      Size (MB)  Free (MB)     % Free     % Used
------------------------------ ---------- ---------- ---------- ----------
UNDO                                  500    418.625         84         16
SYSAUX                                550      56.25         10         90
SYSTEM                                350     2.0625          1         99
TEMP                                  124          0          0        100
USERS                                1610     6.0625          0        100



i can't collect the table space when the reposync hangs the reason is that
i can't connect anymore to the database.


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