Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problems with Semaphores / SAP_APPL SPs

Hi there,

I was patching our SAP ERP 6.0 system with SAP_APPL Packages. After one week i took a look at the processes (background import) and everything seemed to stand in wait mode.... I even couldnt connect to SAP via Gui.

Restarting some processes and the system itself, didnt help.<br>

Database seems to be running but no connect possible and if i look to dpmon, its clear:<br>

<br>

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User <br>

Action Table<br>

-


<br>

0 DIA 5941 Run no 0 0 0<br>

1 DIA 5942 Run no 0 4 0<br>

2 DIA 5943 Run no 0 4 0<br>

3 DIA 5944 Run no 0 4 0<br>

4 DIA 5945 Run no 0 4 0<br>

5 DIA 5946 Run no 0 4 0<br>

6 UPD 5947 Run no 0 4 0<br>

7 ENQ 5948 Run no 0 4 0<br>

8 BTC 5949 Run no 0 4 0<br>

9 BTC 5950 Run no 0 4 0<br>

10 BTC 5951 Run no 0 4 0<br>

11 SPO 5952 Run no 0 4 0<br>

12 UP2 5953 Run no 0 4 0<br>

<br>

Any idea? I already tried doing some work with ipcs/ipcrm with no success. It just results in stopping DB&SAP. Here a print from ipcs, thanks for any help & idea!<br>

-


Shared Memory Segments -


<br>

key shmid owner perms bytes nattch status<br>

0x00004dbe 32768 root 777 523458 1<br>

0x44000001 131075 sdb 666 131208 1<br>

0x44000002 163844 sdb 666 262360 1<br>

0x44000003 196613 sdb 666 3278856 9<br>

0x44000004 229382 sdb 666 3278856 8<br>

0x00000000 262151 adaadm 777 1024 1<br>

0x0382be85 294920 adaadm 666 4096 2<br>

0x00002796 327689 adaadm 740 4194304 1<br>

0x00000000 360458 adaadm 777 1024 1<br>

0x0382be84 393227 adaadm 666 4096 18<br>

0x00002749 425996 adaadm 740 1158876 15<br>

0x0000271a 3833869 adaadm 740 132000000 16<br>

0x00002711 3866638 adaadm 740 576 17<br>

0x00002712 3899407 adaadm 740 6704432 16<br>

0x00002713 3932176 adaadm 740 13059200 16<br>

0x00002744 3964945 adaadm 740 72968 16<br>

0x0000272f 3997714 adaadm 740 5771512 16<br>

0x00002743 4030483 adaadm 740 18227140 14<br>

0x0000274e 4096020 adaadm 740 86132792 14<br>

0x00002725 7503893 adaadm 740 954592 1<br>

0x0000271e 7536662 adaadm 740 4400000 1<br>

0x00002719 7569431 adaadm 740 268435456 1<br>

0x00002718 7602200 adaadm 740 268435456 1<br>

0x00002722 7634969 adaadm 740 2622496 1<br>

0x00002738 7667738 adaadm 740 114000000 1<br>

0x00002717 7700507 adaadm 740 12176 1<br>

0x00002714 7766044 adaadm 740 558424 1<br>

0x00002754 7798813 adaadm 740 74304 3<br>

0x00002755 7831582 adaadm 740 312368 3<br>

0x00002759 11468831 adaadm 740 60000000 0<br>

0x00002739 11501600 adaadm 740 39274200 1<br>

0x00002723 11534369 adaadm 740 29999888 1<br>

0x00002731 11567138 adaadm 740 10239960 1<br>

0x00002746 11599907 adaadm 740 4194552 1<br>

0x00002751 11632676 adaadm 740 4194552 1<br>

0x00002750 11665445 adaadm 740 4194424 1<br>

<br>

-


Semaphore Arrays -


<br>

key semid owner perms nsems<br>

0x00000000 32769 sdb 666 1<br>

0x00000000 65538 sdb 666 1<br>

0x00000000 98307 sdb 666 1<br>

0x00000000 131076 sdb 666 1<br>

0x00000000 163845 sdb 666 1<br>

0x00000000 196614 sdb 666 1<br>

0x00000000 229383 sdb 666 1<br>

0x00000000 262152 sdb 666 1<br>

0x00000000 294921 sdb 666 1<br>

0x00000000 327690 sdb 666 1<br>

0x00000000 360459 sdb 666 1<br>

0x00000000 393228 sdb 666 1<br>

0x00000000 425997 sdb 666 1<br>

0x00000000 458766 sdb 666 1<br>

0x00000000 491535 sdb 666 1<br>

0x00004e9e 1376273 adaadm 777 1<br>

0x00004e4e 1409064 adaadm 777 1<br>

0x00004e24 1441833 adaadm 777 1<br>

0x00004e25 1474602 adaadm 777 1<br>

0x00004e67 1507371 adaadm 777 1<br>

0x00004e29 1540140 adaadm 777 1<br>

0x00004e42 1572909 adaadm 777 1<br>

0x00004e37 1605678 adaadm 777 1<br>

0x00004e22 1638447 adaadm 777 1<br>

0x00004e23 1671216 adaadm 777 1<br>

0x002dedcf 1703985 adaadm 740 1<br>

0x002dedce 1736754 adaadm 740 1<br>

0x002dedcd 1769523 adaadm 740 1<br>

0x002dedcc 1802292 adaadm 740 1<br>

0x002dedcb 1835061 adaadm 740 1<br>

0x002dedca 1867830 adaadm 740 1<br>

0x002dedc9 1900599 adaadm 740 1<br>

0x002dedc8 1933368 adaadm 740 1<br>

0x002dedc7 1966137 adaadm 740 1<br>

0x002dedc6 1998906 adaadm 740 1<br>

0x002dedc5 2031675 adaadm 740 1<br>

0x002dedc4 2064444 adaadm 740 1<br>

0x002dedc3 2097213 adaadm 740 1<br>

0x00004e40 2129982 adaadm 777 1<br>

0x00004e41 2162751 adaadm 777 1<br>

0x00004e47 2195520 adaadm 777 1<br>

0x00004e54 2228289 adaadm 777 1<br>

0x00004e21 2261058 adaadm 777 1<br>

0x00004e26 2293827 adaadm 777 1<br>

0x00004e27 2326596 adaadm 777 1<br>

0x00004e2b 2359365 adaadm 777 1<br>

0x00004e2c 2392134 adaadm 777 1<br>

0x00004e2d 2424903 adaadm 777 1<br>

0x00004e2e 2457672 adaadm 777 1<br>

0x00004e30 2490441 adaadm 777 1<br>

0x00004e31 2523210 adaadm 777 1<br>

0x00004e32 2555979 adaadm 777 1<br>

0x00004e33 2588748 adaadm 777 1<br>

0x00004e34 2621517 adaadm 777 1<br>

0x00004e35 2654286 adaadm 777 1<br>

0x00004e36 2687055 adaadm 777 1<br>

0x00004e38 2719824 adaadm 777 1<br>

0x00004e39 2752593 adaadm 777 1<br>

0x00004e3a 2785362 adaadm 777 1<br>

0x00004e3b 2818131 adaadm 777 1<br>

0x00004e3c 2850900 adaadm 777 1<br>

0x00004e3d 2883669 adaadm 777 1<br>

0x00004e3e 2916438 adaadm 777 1<br>

0x00004e3f 2949207 adaadm 777 1<br>

0x00004e43 2981976 adaadm 777 1<br>

0x00004e46 3014745 adaadm 777 1<br>

0x00004e4a 3047514 adaadm 777 1<br>

0x00004e4b 3080283 adaadm 777 1<br>

0x00004e4c 3113052 adaadm 777 1<br>

0x00004e4f 3145821 adaadm 777 1<br>

0x00004e51 3178590 adaadm 777 1<br>

0x00004e50 3211359 adaadm 777 1<br>

0x00004e53 3244128 adaadm 777 1<br>

0x00004e55 3276897 adaadm 777 1<br>

0x00004e56 3309666 adaadm 777 1<br>

0x00004e57 3342435 adaadm 777 1<br>

0x00004e58 3375204 adaadm 777 1<br>

0x00004e59 3407973 adaadm 777 1<br>

0x00004e5a 3440742 adaadm 777 1<br>

0x00004e65 3473511 adaadm 777 1<br>

0x00000000 3506280 sdb 666 1<br>

0x00000000 3539049 sdb 666 1<br>

0x00000000 3571818 sdb 666 1<br>

0x00000000 3604587 sdb 666 1<br>

0x00000000 3637356 sdb 666 1<br>

0x00000000 3670125 sdb 666 1<br>

0x00000000 3702894 sdb 666 1<br>

0x00000000 3735663 sdb 666 1<br>

0x00000000 3768432 sdb 666 1<br>

0x00000000 3801201 sdb 666 1<br>

0x00004e2a 3833970 adaadm 777 1<br>

0x00000000 3866739 sdb 666 1<br>

0x00000000 3899508 sdb 666 1<br>

0x00004e5c 3932277 adaadm 777 1<br>

0x00000000 3965046 adaadm 777 1<br>

0x00000000 11698295 sdb 666 1<br>

0x00000000 11305080 sdb 666 1<br>

0x00000000 11731065 sdb 666 1<br>

0x00000000 11763834 sdb 666 1<br>

0x00004e64 4227195 adaadm 777 1<br>

Former Member
Former Member replied

Hello ,

To solve the LOG_FULL issue please create the log backup.

You could create the Log backup using DBMGUI tool, for example, when the database is in ADMIN or ONLINE status. A log backup can also be created by switching on automatic log backup.

See more details in the SAP note:: 869267 FAQ: MaxDB LOG area

< 21. How do I resolve a LOG full situation? >

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on Apr 10, 2009 3:01 PM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question