[progress Communities] [progress Openedge Abl] Forum Post: Re: Database Continues To Crash...

Status
Not open for further replies.
C

cverbiest

Guest
reply to the 14:13 question what the process was doing found following 4gl trace, unfortunately trace level is too low to be really useful The second log file shows lsof output that is produced by the batch job prior to the quit statement code fragment : output close. /* batcherror logfile */ if opsys = "unix" then os-command silent value(subst("sudo /usr/sbin/lsof -p &1 >> &2", WZ-PID, WZ-LOGFILE)). run WriteMemo. quit. first log file # cat /tmp/batch_9539.log [16/07/25@12:54:48.609+0200] P-009540 T-485005120 1 4GL -- Logging level set to = 1 [16/07/25@12:55:11.829+0200] P-009540 T-485005120 1 4GL -- Invalid semaphore id (1132) [16/07/25@12:55:11.829+0200] P-009540 T-485005120 1 4GL -- SYSTEM ERROR: Unable to set semaphore set : semid = 2, errno = 22. (10839) [16/07/25@12:55:11.830+0200] P-009540 T-485005120 1 4GL -- Invalid semaphore id (1132) [16/07/25@12:55:11.830+0200] P-009540 T-485005120 1 4GL -- SYSTEM ERROR: Unable to get value of semaphore set : semid = 0, errno = 22. (10839) [16/07/25@12:55:11.830+0200] P-009540 T-485005120 1 4GL -- semLockLog_2: semValue val = -1 # cat be9540.log print.sh -f acrobat blancke01 1 /tmp/Kat46489_9540.pdf 2>&1 Acrobat exitcode: 0 print.sh -f acrobat blancke01 1 /tmp/Kat46493_9540.pdf 2>&1 Acrobat exitcode: 0 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME _progres 9540 proadmin cwd DIR 8,2 12288 2228226 /usr2/cce/applprod _progres 9540 proadmin rtd DIR 8,1 4096 2 / _progres 9540 proadmin txt REG 8,1 12589577 400553 /usr/oe116/bin/_progres _progres 9540 proadmin mem REG 8,1 110808 394029 /usr/lib64/libresolv-2.17.so _progres 9540 proadmin mem REG 8,1 27512 394017 /usr/lib64/libnss_dns-2.17.so _progres 9540 proadmin mem REG 8,1 156770 1054635 /usr/oe116/lib/libproxml.so _progres 9540 proadmin mem REG 8,1 113328 394011 /usr/lib64/libnsl-2.17.so _progres 9540 proadmin mem REG 8,1 5102967 1054636 /usr/oe116/lib/libxerces_psc.so _progres 9540 proadmin mem REG 8,1 2546137 1054640 /usr/oe116/lib/libicui18n48_psc.so _progres 9540 proadmin mem REG 8,1 1751412 1054642 /usr/oe116/lib/libicuuc48_psc.so _progres 9540 proadmin mem REG 8,1 18187923 1054638 /usr/oe116/lib/libicudata48_psc.so _progres 9540 proadmin DEL REG 0,4 98305 /SYSV00000000 _progres 9540 proadmin mem REG 8,1 37441 1054490 /usr/oe116/lib/libenhlog.so _progres 9540 proadmin mem REG 8,1 61928 394019 /usr/lib64/libnss_files-2.17.so _progres 9540 proadmin mem REG 8,1 11376 393960 /usr/lib64/libfreebl3.so _progres 9540 proadmin mem REG 8,1 2112384 394001 /usr/lib64/libc-2.17.so _progres 9540 proadmin mem REG 8,1 88720 393235 /usr/lib64/libgcc_s-4.8.5-20150702.so.1 _progres 9540 proadmin mem REG 8,1 995840 394050 /usr/lib64/libstdc++.so.6.0.19 _progres 9540 proadmin mem REG 8,1 1141560 394009 /usr/lib64/libm-2.17.so _progres 9540 proadmin mem REG 8,1 40816 394005 /usr/lib64/libcrypt-2.17.so _progres 9540 proadmin mem REG 8,1 44096 394031 /usr/lib64/librt-2.17.so _progres 9540 proadmin mem REG 8,1 19520 394007 /usr/lib64/libdl-2.17.so _progres 9540 proadmin mem REG 8,1 142304 394027 /usr/lib64/libpthread-2.17.so _progres 9540 proadmin mem REG 8,1 164440 402388 /usr/lib64/ld-2.17.so _progres 9540 proadmin 0r CHR 1,3 0t0 1028 /dev/null _progres 9540 proadmin 1w REG 8,6 14110 25 /tmp/batcherr32 _progres 9540 proadmin 2w REG 8,6 14110 25 /tmp/batcherr32 _progres 9540 proadmin 3r REG 8,1 1749843 400498 /usr/oe116/promsgs _progres 9540 proadmin 4r REG 8,1 944417 400495 /usr/oe116/convmap.cp _progres 9540 proadmin 5r REG 8,1 944417 400495 /usr/oe116/convmap.cp _progres 9540 proadmin 6u REG 8,6 74955 7235 /tmp/lbiN5u92T (deleted) _progres 9540 proadmin 7w REG 8,7 3082181 13528468 /data/cce/applprod/data/LISA.lg _progres 9540 proadmin 8u REG 8,7 655360 13528466 /data/cce/applprod/data/LISA.db _progres 9540 proadmin 9u REG 8,7 655360 13528466 /data/cce/applprod/data/LISA.db _progres 9540 proadmin 10u REG 8,7 26869760 13500420 /data/cce/applprod/data/LISA.b1 _progres 9540 proadmin 11u REG 8,7 15204352 13500421 /data/cce/applprod/data/LISA.d1 _progres 9540 proadmin 12u REG 8,7 15204352 13500421 /data/cce/applprod/data/LISA.d1 _progres 9540 proadmin 13u REG 8,7 524288000 13500422 /data/cce/applprod/data/LISA_10.d1 _progres 9540 proadmin 14u REG 8,7 524288000 13500423 /data/cce/applprod/data/LISA_10.d2 _progres 9540 proadmin 15u REG 8,7 524288000 13500424 /data/cce/applprod/data/LISA_10.d3 _progres 9540 proadmin 16u REG 8,7 131072 13500425 /data/cce/applprod/data/LISA_10.d4 _progres 9540 proadmin 17u REG 8,7 131072 13500425 /data/cce/applprod/data/LISA_10.d4 _progres 9540 proadmin 18u REG 8,7 262144000 13500426 /data/cce/applprod/data/LISA_11.d1 _progres 9540 proadmin 19u REG 8,7 262144000 13500427 /data/cce/applprod/data/LISA_11.d2 _progres 9540 proadmin 20u REG 8,7 262144000 13500428 /data/cce/applprod/data/LISA_11.d3 _progres 9540 proadmin 21u REG 8,7 131072 13500429 /data/cce/applprod/data/LISA_11.d4 _progres 9540 proadmin 22u REG 8,7 131072 13500429 /data/cce/applprod/data/LISA_11.d4 _progres 9540 proadmin 23u REG 8,7 131072 13500430 /data/cce/applprod/data/LISA_12.d1 _progres 9540 proadmin 24u REG 8,7 131072 13500430 /data/cce/applprod/data/LISA_12.d1 _progres 9540 proadmin 25u REG 8,7 2147352576 13500431 /data/cce/applprod/data/LISA_20.d1 _progres 9540 proadmin 26u REG 8,7 2147352576 13500432 /data/cce/applprod/data/LISA_20.d2 _progres 9540 proadmin 27u REG 8,7 2147352576 13500433 /data/cce/applprod/data/LISA_20.d3 _progres 9540 proadmin 28u REG 8,7 2147352576 13500434 /data/cce/applprod/data/LISA_20.d4 _progres 9540 proadmin 29u REG 8,7 2147352576 13500435 /data/cce/applprod/data/LISA_20.d5 _progres 9540 proadmin 30u REG 8,7 2147352576 13500436 /data/cce/applprod/data/LISA_20.d6 _progres 9540 proadmin 31u REG 8,7 2147352576 13500437 /data/cce/applprod/data/LISA_20.d7 _progres 9540 proadmin 32u REG 8,7 2147352576 13500438 /data/cce/applprod/data/LISA_20.d8 _progres 9540 proadmin 33u REG 8,7 2147352576 13500439 /data/cce/applprod/data/LISA_20.d9 _progres 9540 proadmin 34u REG 8,7 2147352576 13500440 /data/cce/applprod/data/LISA_20.d10 _progres 9540 proadmin 35u REG 8,7 2147352576 13500441 /data/cce/applprod/data/LISA_20.d11 _progres 9540 proadmin 36u REG 8,7 2147352576 13500442 /data/cce/applprod/data/LISA_20.d12 _progres 9540 proadmin 37u REG 8,7 2147352576 13500443 /data/cce/applprod/data/LISA_20.d13 _progres 9540 proadmin 38u REG 8,7 2147352576 13500444 /data/cce/applprod/data/LISA_20.d14 _progres 9540 proadmin 39u REG 8,7 2147352576 13500445 /data/cce/applprod/data/LISA_20.d15 _progres 9540 proadmin 40u REG 8,7 2147352576 13500446 /data/cce/applprod/data/LISA_20.d16 _progres 9540 proadmin 41u REG 8,7 2147352576 13500447 /data/cce/applprod/data/LISA_20.d17 _progres 9540 proadmin 42u REG 8,7 2147352576 13500448 /data/cce/applprod/data/LISA_20.d18 _progres 9540 proadmin 43u REG 8,7 2147352576 13500449 /data/cce/applprod/data/LISA_20.d19 _progres 9540 proadmin 44u REG 8,7 2147352576 13500450 /data/cce/applprod/data/LISA_20.d20 _progres 9540 proadmin 45u REG 8,7 2147352576 13500451 /data/cce/applprod/data/LISA_20.d21 _progres 9540 proadmin 46u REG 8,7 2147352576 13500452 /data/cce/applprod/data/LISA_20.d22 _progres 9540 proadmin 47u REG 8,7 524288 13500453 /data/cce/applprod/data/LISA_20.d23 _progres 9540 proadmin 48u REG 8,7 524288 13500453 /data/cce/applprod/data/LISA_20.d23 _progres 9540 proadmin 49u REG 8,7 2147352576 13500454 /data/cce/applprod/data/LISA_21.d1 _progres 9540 proadmin 50u REG 8,7 2147352576 13500455 /data/cce/applprod/data/LISA_21.d2 _progres 9540 proadmin 51u REG 8,7 2147352576 13500456 /data/cce/applprod/data/LISA_21.d3 _progres 9540 proadmin 52u REG 8,7 2147352576 13500457 /data/cce/applprod/data/LISA_21.d4 _progres 9540 proadmin 53u REG 8,7 2147352576 13500458 /data/cce/applprod/data/LISA_21.d5 _progres 9540 proadmin 54u REG 8,7 2147352576 13500459 /data/cce/applprod/data/LISA_21.d6 _progres 9540 proadmin 55u REG 8,7 2147352576 13500460 /data/cce/applprod/data/LISA_21.d7 _progres 9540 proadmin 56u REG 8,7 2147352576 13500461 /data/cce/applprod/data/LISA_21.d8 _progres 9540 proadmin 57u REG 8,7 2147352576 13500462 /data/cce/applprod/data/LISA_21.d9 _progres 9540 proadmin 58u REG 8,7 2147352576 13500463 /data/cce/applprod/data/LISA_21.d10 _progres 9540 proadmin 59u REG 8,7 2147352576 13500464 /data/cce/applprod/data/LISA_21.d11 _progres 9540 proadmin 60u REG 8,7 2147352576 13500465 /data/cce/applprod/data/LISA_21.d12 _progres 9540 proadmin 61u REG 8,7 524288 13500466 /data/cce/applprod/data/LISA_21.d13 _progres 9540 proadmin 62u REG 8,7 524288 13500466 /data/cce/applprod/data/LISA_21.d13 _progres 9540 proadmin 63u REG 8,7 1572864 13500467 /data/cce/applprod/data/LISA_22.d1 _progres 9540 proadmin 64u REG 8,7 1572864 13500467 /data/cce/applprod/data/LISA_22.d1 _progres 9540 proadmin 65u REG 8,7 131072000 13500468 /data/cce/applprod/data/LISA_30.d1 _progres 9540 proadmin 66u REG 8,7 131072000 13500469 /data/cce/applprod/data/LISA_30.d2 _progres 9540 proadmin 67u REG 8,7 131072000 13500470 /data/cce/applprod/data/LISA_30.d3 _progres 9540 proadmin 68u REG 8,7 524288000 13500471 /data/cce/applprod/data/LISA_30.d4 _progres 9540 proadmin 69u REG 8,7 524288000 13500472 /data/cce/applprod/data/LISA_30.d5 _progres 9540 proadmin 70u REG 8,7 524288000 13500473 /data/cce/applprod/data/LISA_30.d6 _progres 9540 proadmin 71u REG 8,7 524288 13500474 /data/cce/applprod/data/LISA_30.d7 _progres 9540 proadmin 72u REG 8,7 524288 13500474 /data/cce/applprod/data/LISA_30.d7 _progres 9540 proadmin 73u REG 8,7 131072000 13500475 /data/cce/applprod/data/LISA_31.d1 _progres 9540 proadmin 74u REG 8,7 131072000 13500476 /data/cce/applprod/data/LISA_31.d2 _progres 9540 proadmin 75u REG 8,7 131072000 13500477 /data/cce/applprod/data/LISA_31.d3 _progres 9540 proadmin 76u REG 8,7 131072000 13500478 /data/cce/applprod/data/LISA_31.d4 _progres 9540 proadmin 77u REG 8,7 524288 13500479 /data/cce/applprod/data/LISA_31.d5 _progres 9540 proadmin 78u REG 8,7 524288 13500479 /data/cce/applprod/data/LISA_31.d5 _progres 9540 proadmin 79u REG 8,7 524288 13500480 /data/cce/applprod/data/LISA_32.d1 _progres 9540 proadmin 80u REG 8,7 524288 13500480 /data/cce/applprod/data/LISA_32.d1 _progres 9540 proadmin 81ur REG 8,6 84 7248 /tmp/batch_9539.log _progres 9540 proadmin 82u REG 8,6 0 7250 /tmp/srtVk4EVZ (deleted) _progres 9540 proadmin 83u REG 8,6 46351608 7251 /tmp/rcdhNobO5 (deleted) _progres 9540 proadmin 84u REG 8,6 819200 7256 /tmp/DBI485005120kkz8Gb (deleted) _progres 9540 proadmin 88r REG 8,1 4949823 1054570 /usr/oe116/tty/adecomm.pl _progres 9540 proadmin 89r REG 8,1 26771 1054866 /usr/oe116/tty/OpenEdge.ServerAdmin.pl _progres 9540 proadmin 90r REG 8,1 586073 1054581 /usr/oe116/tty/adeedit.pl _progres 9540 proadmin 91r REG 8,1 20580737 1054623 /usr/oe116/tty/prodict.pl _progres 9540 proadmin 92r REG 8,1 56999 1054864 /usr/oe116/tty/OpenEdge.BusinessLogic.pl _progres 9540 proadmin 93r REG 8,1 1499066 1054865 /usr/oe116/tty/OpenEdge.Core.pl _progres 9540 proadmin 94r REG 8,1 2631412 1054577 /usr/oe116/tty/adeshar.pl _progres 9540 proadmin 95r REG 8,1 240309 1054584 /usr/oe116/tty/adecomp.pl _progres 9540 proadmin 96r REG 8,1 14002200 1054621 /usr/oe116/tty/dataadmin.pl

Continue reading...
 
Status
Not open for further replies.

Similar threads

G
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: lbi File Growing Like Mad - how to diagnose
Replies
0
Views
561
George Potemkin
G
C
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Is database a replication source? Or is it a target?
Replies
0
Views
378
ChUIMonster
C
M
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Database slowness
Replies
0
Views
466
mboubidi
M
G
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: What is the minimum non-zero value of the -usernotifytime?
Replies
0
Views
437
George Potemkin
G
D
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: Garbage collection for the sake of static temp-tables (in long-running _progres)
Replies
0
Views
794
dbeavon
D
Top