Pdox 4.02 DOS - File Locking Problem - Steve Green

Pdox 4.02 DOS - File Locking Problem - Steve Green

Post by Steven Polin » Sat, 11 Apr 1998 04:00:00



We are experiencing abends from Paradox 4.02 for DOS on a Pentium
workstation.  The following command line is being used:

paradox -extk 3096 -emk 0 -diag -share

The diag file follows, any help much appreciated....
PS. This app is installed on a Windows NT Network.

Paradox Dump:

Unexpected condition: Locking error (byte lock failure #1)
H:\PDOXDATA\DYMD\CHEK_PRT.DB -- Leaving Paradox
Paradox 4.02 - English Version (402AG  04/22/93 )
Memory  Utilization - hit any key to continue

 Job Cnt  Total    Lo    Hi   Mov   Swp   Pur   HiC  LowC  File   EMS
PUR
   0   5      8     0     0     8     0     0     8     0     0
0     0
   1  56   2191     0     0  2191     0     0  2191     0     0
0     0
   2   4     64     0     0    64     0     0    48    16     0
0     0
   3   1      8     0     0     8     0     0     8     0     0
0     0
   4   3     33     0     0    33     0     0    33     0     0
0     0
   5   2     16     0     0    16     0     0    16     0     0
0     0
   6   1      8     0     0     8     0     0     8     0     0
0     0
   7   1      8     0     0     8     0     0     8     0     0
0     0
   8   1      8     0     0     8     0     0     8     0     0
0     0
   9   3    129     0     0   129     0     0    65    64     0
0     0
  10   1      8     0     0     8     0     0     8     0     0
0     0
  11   1      8     0     0     8     0     0     8     0     0
0     0
  12   1      8     0     0     8     0     0     8     0     0
0     0
etc.   4     48     0     0    48     0     0     8    40     0
0     0
Free   9    322     0     0   322     0     0     3   320     0
0     0
Sum   93   2867     0     0  2867     0     0  2428   439     0
0     0

heap 1, temp 3, proc 4, stack 5, hash 6, menu 8, cache 9
Numeric Coprocessor: PRESENT
MemLeft  802
Codepool:  actual 652   desired 652
                     D D D D A U U U U J F F F
                     l R D F L D D D A F D D D
 Net Compatibility   k L R L k L R D L L L R D FileName
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_BUD.DB*
<     Locked       > 0 0 0 0 1 0 0 0 0 0 C:\PDOX402\PARADOX.DIR
DL DR DD    DF DJ NL 8 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\PARADOX.DIR
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_MRZ.DB*
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_NOS.DB*
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_PRT.DB*
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_PRT.F1*
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_MRZ.F1*
DL DR DD    DF DJ NL 1 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\CHEK_ACC.DB*
9 registered files
user      FAYE
network   Other
session   14449
net control file: H:\PDOXDATA\

Table c:\PDOX402\$PALMEM$ is on chain but not registered
Table CHANGED.DB is on chain but not registered
Never used stack: 19892 bytes
#VFD  #fd  filelen  #blk/cache  #blk/swap  filename
---------------------------------------------------
   1    9     4096           0          4  c:\PDOX402\$PALMEM$
   2   -2     4864           8          0  c:\PDOX402\INIT.SC2
   3   -2     4352           8          0  h:\PDOXDATA\DYMD\FAY.SC2
   4   -2    55296           0          0  h:\PDOXDATA\DYMD\PMT_HOLD.DB
   5   -2     3072           0          0  h:\PDOXDATA\DYMD\PMT_HOLD.PX
   6   -2    94208           0          0  h:\PDOXDATA\DYMD\PMT_HIST.DB
   7   -2     3072           0          0  h:\PDOXDATA\DYMD\PMT_HIST.PX
   8   15    22528           0          2  c:\pdox402\CHANGED.DB
   9   13     9472          12          0  h:\PDOXDATA\DYMD\FAYE_ADM.SC2

  10   14     4352           8          0  h:\PDOXDATA\DYMD\BANK.SC2
  11   16     4608           8          0  h:\PDOXDATA\DYMD\CHEK_BK0.SC2

  12   17     3840           4          0  h:\PDOXDATA\DYMD\CHEK_BK1.SC2

  13   12     8192           8          0  h:\PDOXDATA\DYMD\CHEK_ENT.SC2

  14   18    36864           0          4  h:\PDOXDATA\DYMD\CHEK_BUD.DB
  15   19     3072           0          0  h:\PDOXDATA\DYMD\CHEK_BUD.PX
  16   20    16384           0         14  h:\PDOXDATA\DYMD\CHEK_MRZ.DB
  17   21     3072           0          0  h:\PDOXDATA\DYMD\CHEK_MRZ.PX
  18   22     3072           0          2  h:\PDOXDATA\DYMD\CHEK_NOS.DB
  19   23     3072           0          0  h:\PDOXDATA\DYMD\CHEK_NOS.PX
  20   24     3072           0          2  h:\PDOXDATA\DYMD\CHEK_PRT.DB
  21   27     3072           0          2  h:\PDOXDATA\DYMD\CHEK_PRT.PX
  22   -2      395           4          0  h:\PDOXDATA\DYMD\CHEK_PRT.VAL

  23   -2     2108           4          0  h:\PDOXDATA\DYMD\Chek_prt.F1
  24   -2     1731           4          0  h:\PDOXDATA\DYMD\Chek_mrz.F1
  25   25    12288           0          4  h:\PDOXDATA\DYMD\CHEK_ACC.DB
  26   26     3072           0          2  h:\PDOXDATA\DYMD\CHEK_ACC.PX
  257 Hash Table Size
  128 Cache Table Size
  128 Kbytes Allocated
  128 Kbytes Loaded
    0 Kbytes Purgeable
   21 Number of Reads
    4 Read Hits
   17 Number of Writes
    0 Write Hits
    0 Number of Vfd Flushes
    0 Number of Collisions

;WHO <VARIABLE > Scope: 28
;ANSR <VARIABLE > Scope: 28
;MEMO <VARIABLE > Scope: 28
;WHERE4 <VARIABLE > Scope: 28
;NAME <VARIABLE > Scope: 28
;WHAT <VARIABLE > Scope: 28
;WHERE1 <VARIABLE > Scope: 28
;ADDRE <VARIABLE > Scope: 28
;CHOICE <VARIABLE > Scope: 28
;STATE <VARIABLE > Scope: 28
;ZIP <VARIABLE > Scope: 28
;CHECK_NO <VARIABLE > Scope: 28
;ANSER <VARIABLE > Scope: 28
;RETVAL <VARIABLE > Scope: 28
;CITY <VARIABLE > Scope: 28
;N <VARIABLE > Scope: 28
;BNK <VARIABLE > Scope: 28
;ACCT <VARIABLE > Scope: 28
;CHECK_AMT <VARIABLE > Scope: 28
;WHERE2 <VARIABLE > Scope: 28
;WHERE3 <VARIABLE > Scope: 28
;M <VARIABLE > Scope: 28
;ANSW <VARIABLE > Scope: 28

;H:\PDOXDATA\DYMD\CHEK_ENT . ()
;    Scope: 28, Status: Current
;
;H:\PDOXDATA\DYMD\CHEK_BK1 . ()
;    Scope: 28, Status: Defined
;
;H:\PDOXDATA\DYMD\BANK . ()
;    Scope: 28, Status: Defined
;
;KEYMACRO<0> . ()
;    Scope: 28, Status: Defined
;
;H:\PDOXDATA\DYMD\FAY . ()
;    Scope: 28, Status: Defined
;
;H:\PDOXDATA\DYMD\CHEK_BK0 . ()
;    Scope: 28, Status: Defined
;
;H:\PDOXDATA\DYMD\FAYE_ADM . ()
;    Scope: 28, Status: Defined
;

File: CHEK_ENT   Line: 39   Offset: 486

?????????????????????????????????????????????????????????????????????????????

3 Script CHEK_ENT
3????????????????????????????????????????????????????????????????????????????

33 Script CHEK_BK1
33???????????????????????????????????????????????????????????????????????????

333 Script CHEK_BK0
333??????????????????????????????????????????????????????????????????????????

3333 Script BANK
3333?????????????????????????????????????????????????????????????????????????

33333 Script FAYE_ADM
33333????????????????????????????????????????????????????????????????????????

333333 Script FAY
333333???????????????????????????????????????????????????????????????????????

3333333 Script KEYMACRO<0>

Paradox Dump:

Unexpected condition: Locking error (byte lock failure #1)
H:\PDOXDATA\DYMD\CHEK_PTD.DB -- Leaving Paradox
Paradox 4.02 - English Version (402AG  04/22/93 )
Memory  Utilization - hit any key to continue

 Job Cnt  Total    Lo    Hi   Mov   Swp   Pur   HiC  LowC  File   EMS
PUR
   0   4      8     0     0     8     0     0     8     0     0
0     0
   1  58   2174     0     0  2174     0     0  2174     0     0
0     0
   2   2     32     0     0    32     0     0    32     0     0
0     0
   3   1      8     0     0     8     0     0     8     0     0
0     0
   4   2     17     0     0    17     0     0    17     0     0
0     0
   5   2     16     0     0    16     0     0    16     0     0
0     0
   6   1      8     0     0     8     0     0     8     0     0
0     0
   7   1      8     0     0     8     0     0     8     0     0
0     0
   8   1      8     0     0     8     0     0     8     0     0
0     0
   9   4    193     0     0   193     0     0   129    64     0
0     0
Free   8    395     0     0   395     0     0    20   375     0
0     0
Sum   84   2867     0     0  2867     0     0  2428   439     0
0     0

heap 1, temp 3, proc 4, stack 5, hash 6, menu 8, cache 9
Numeric Coprocessor: PRESENT
MemLeft  939
Codepool:  actual 652   desired 652
                     D D D D A U U U U J F F F
                     l R D F L D D D A F D D D
 Net Compatibility   k L R L k L R D L L L R D FileName
<     Locked       > 0 0 0 0 1 0 0 0 0 0 C:\PDOX402\PARADOX.DIR
DL DR DD    DF DJ NL 2 0 0 0 0 0 0 0 0 0 H:\PDOXDATA\DYMD\PARADOX.DIR
2 registered files
user      FAYE
network   Other
session   14450
net control file: H:\PDOXDATA\

Table c:\PDOX402\$PALMEM$ is on chain but not registered
Never used stack: 19892 bytes
#VFD  #fd  filelen  #blk/cache  #blk/swap  filename
---------------------------------------------------
   1    7     4096           0          4  c:\PDOX402\$PALMEM$
   2   -2     4864           8          0  c:\PDOX402\INIT.SC2
   3   -3     4352           8          0  h:\PDOXDATA\DYMD\FAY.SC2
   4   -2    55296           0          0  h:\PDOXDATA\DYMD\PMT_HOLD.DB
   5   -2     3072           0          0  h:\PDOXDATA\DYMD\PMT_HOLD.PX
   6   -2    94208           0          0  h:\PDOXDATA\DYMD\PMT_HIST.DB
   7   -2     3072           0          0  h:\PDOXDATA\DYMD\PMT_HIST.PX
   9   -2     9472          12          0  h:\PDOXDATA\DYMD\FAYE_ADM.SC2

  10   -2     4352           8          0  h:\PDOXDATA\DYMD\BANK.SC2
  11   -2     4608      
...

read more »

 
 
 

Pdox 4.02 DOS - File Locking Problem - Steve Green

Post by FE Lt » Tue, 14 Apr 1998 04:00:00



> We are experiencing abends from Paradox 4.02 for DOS on a Pentium
> workstation.  The following command line is being used:

> paradox -extk 3096 -emk 0 -diag -share

Steve, it could be that you need to give more memory to the pc i.e use
-extk 12000 (for a 16Mb machine).

I think the problem is that the server is cacheing the table & index
data and not writing the data back quickly enough before another user
attempts to access that data.  Try using SAVETABLES after a COEDIT -
DO_IT! etc.

Also make sure that you match any LOCK commands with UNLOCK commands.

Good Luck


 
 
 

Pdox 4.02 DOS - File Locking Problem - Steve Green

Post by Steve Gree » Thu, 16 Apr 1998 04:00:00



> I think the problem is that the server is cacheing the table & index
> data and not writing the data back quickly enough before another user
> attempts to access that data.  Try using SAVETABLES after a COEDIT -
> DO_IT! etc.

The SAVETABLES command only applies to private tables.. anything shared
is automatically released back to the server immediately..

--
Steve Green
Corel CTech - Paradox
Diamond Software Group, Inc.
Waldorf, Maryland  USA

 
 
 

1. Attn: Steve Green Upgrade to Pdox 4.5 Dos

I have read your suggestions that if we own a higher version we can
downgrade our license to an older program.  I am currently using Dos 4.0
and would like to upgrade to Dos 4.5.   I own a copy of Windows 4.5, but
don't use it.  What is the process to downgrade a license?

Thanks,

Daniel Sherburne
Systems Manager
Specialty Seals & Accessories

2. Advanced Revelation/Open Insight

3. PDOX DOS 4.02 Print File question

4. Help: 2 row data in one line

5. DOS 4.02 Lock file blues

6. Bad performance with DBSPACETMP enabled

7. Pdox 3.5 vs.Pdox 4.02 vs. Pdox 4.5

8. T-SQL: NOT IN not working

9. Pdox DOS 4.02 and Win XP

10. TKMenu substitute for PDOX DOS 4.02?

11. Help Dos Pdox 4.02 Application Workshop

12. LABELS PDOX 4.02 DOS

13. Importing Text Files into Pdox 4.02 Tables