|Subject||Locks conflict and corruption on win 2003 standard edition|
> long-running transactions that simply exhaust system resourcesDelphi 7 + FB 220.127.116.1131 + IBX + CommitRetaining all the time.
The Win 2003 Standard Server of my client is:
A Dell PowerEdge SC420 computer:
PREPARATION MATERIAL, DEV, SRV, INCRS #1
PREPARATION MATERIAL, DEV, SRV, INCRS #2
GUIDE, PRODUCT, INFORMATION, POWEREDGE, DAO/BCC
GUIDE, GETTING STARTED, SC420, DAO/BCC
PROCESSOR, 80547, PENTIUM 4 PRESCOTT DT, Pentium 4 Prescott DT, 3.0GHZ, 1 MEGB, 800FSB, SOCKET T, E0, MALE
CARD (CIRCUIT), PLANAR (MOTHERBOARD), TRANSFORMER SKY DIVE MINITOWER, PE420SC
KEYBOARD, 104, UNITED STATES, NMB, LOW COST, MIDNIGHT GRAY
DUAL IN-LINE MEMORY MODULE, 256, 533M, 32X72, 8, 240, 1RX8
COMPACT DISK DRIVE, 48X, IDE (INTEGRATED DRIVE ELECTRONICS), HITACHI LG DATA STORAGE, HALF HEIGHT, INTERNAL, CHASSIS 2001
KIT, MOUSE, PERSONAL SYSTEM 2, 2BTN, WHEEL, LOGITECH
ASSEMBLY, FLOPPY DRIVE, 1.44MEGB, NEC CORPORATION, CHASSIS 2001, ULD
SYSTEM INTEGRATION, FEE (CHARGE), INTEGRATION, BRAZIL CUSTOMER CENTER
SYSTEM INTEGRATION, CASE, COMPACT DISKETTE, LEATHER, BRAZIL CUSTOMER CENTER
HARD DRIVE, 160GB, Serial ATA, 8MB, 7.2K, WD-XL80
KIT, DOCUMENTATION ON COMPACT DISK, DOCUMENT OBJECT MODEL, SINGLE CHANNEL, V2.2, WORLD WIDE
It's a small company with one server and ten workstations.
When FB works on a Win XP Pro workstation as the 'server' everything goes right. However, when FB is running on the Dell PowerEdge SC420, after some hours I start getting the message "lock conflict on no wait transaction" all the time.
If I leave this 2003 working for 3 days, I have to stop all users, use gfix with mend option, and gbak with ignore option always; sometimes with garbage option, and, other times with limbo option.
What could this problem?
[Non-text portions of this message have been removed]