[Samba] oplocks w2k excel

[Martin Schmidt]

Hi,

I have the problem:
Clients with W2K and Office 2k try to open a xls-file on a samba share.
It worked fine until a few weeks ago.
The few weeks because there were holidays, our clerks wern't working, but I 
did some maintenance on IT equipment (Yes: my fault! so I am in great 
distress. I did my best to convince the workers, they did something wrong, 
but they don't believe me, can You imagine?).

Now there are the following results possible (ordered by occurence):
1. Can open, but it takes a long time, can change, but cannot save, not even 
with a new name in the same folder or anywhere on the share,
2. Cannot open at all, Excel freezes (Maybe the same than 1, but it takes more 
time I can spare waiting for
3. Opens at once, You can change and save to the same file

Number 3 was happening when I
opened the file
saved it to local HD-folder
copied it with Explorer to a new directory on the samba share
Then it worked once. Additional attempts produced 1 or 2.

The copy on the local filesystem works fine.

When I watched the account with "smbstatus | grep pid" I had the impression 
that when Excel tried to open there file there was 
first:  one entry saying that the user had opened the desired file in 
DENY_NONE RW mode,
second: there was a few seconds later the same entry as in first still 
present, but additionally a second one, saying the client had opened the same 
file in RO mode, and
third: when excel was finally ready, showing the file and You were able to 
edit, the process for the client had a new ID, the old one was gone and there 
were no files open at all.
It is the first time I tried to watch via smbstatus whats going on, so I do ot 
know, wether this behavior is normal or show something significant.

Afterwards I have the following entries in samba.log.%m:
[2004/08/26 17:18:33, 0] smbd/oplock.c:oplock_break(807)
  oplock_break: receive_smb timed out after 30 seconds.
  oplock_break failed for file sichLohnEHW/Controlling/km_kst.xls (dev = 3a00, 
inode = 1695812, file_id = 20).
[2004/08/26 17:18:33, 0] smbd/oplock.c:oplock_break(879)
  oplock_break: client failure in oplock break in file sichLohnEHW/
Controlling/km_kst.xls
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service EHWLohn
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service cdrom2
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service stahle
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service hne2_unix1
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service Marktplatz
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service Marktplatz
[2004/08/26 17:19:35, 1] smbd/service.c:close_cnum(887)
  gh571 (172.23.2.224) closed connection to service EHWLohn
[2004/08/26 17:19:36, 1] smbd/service.c:make_connection_snum(705)
  gh571 (172.23.2.224) connect to service EHWLohn initially as user klaus 
(uid=510, gid=109) (pid 14179)
[2004/08/26 17:19:36, 1] smbd/service.c:make_connection_snum(705)

The files are located directly on the samba-server, a lvm-volume I increased 
from 100GB to 250GB, there are odbc-connections in this xls-files to 
txt-based datas on a nfs-volume from an DEC/OSF1 ( yes, a little bit in the 
ages). But I tried to copy the data-files to the samba server, but there was 
no change.

I use SuSE 8.1 professional, samba 3.01, this is unchanged since several 
month, to clients I did the latest MS - update for win2k.
I also connected the clients to the domain, my samba is master controller.

My smb.conf (partially):

;
[global]
   workgroup = xyz
   guest account = nobody
   server string = xyz4 
   ; keep alive = 20
   os level = 64
   kernel oplocks = no
   security = user
   hide dot files = yes
   domain master = yes
   prefered master = yes
   local master = yes
   dos charset = 850
   add user script = /usr/sbin/addsmbuser.sh %u
   add group script = /usr/sbin/smbgradd.sh %g
   add printer command = /usr/bin/addprinter.sh

   log level = 1
   log file = /usr/local/samba/var/samba.log.%m
   max log size = 50

   encrypt passwords = yes

   printing = LPRNG
   printcap name = /etc/printcap
   load printers =  yes
        printer admin = @ntadmin

   socket options = SO_KEEPALIVE IPTOS_LOWDELAY TCP_NODELAY

   map to guest = Bad User

   interfaces = 192.168.1.4/255.255.255.0
   wins support = yes
   name resolve order = hosts wins bcast
   dns proxy = yes

   logon script =%U.bat
   domain logons = yes
 [netlogon]
   path = /var/lib/samba/netlogon
   browseable = no
   read only = yes
   public = no


[homes]
   comment = Heimatverzeichnis
   browseable = no
   read only = no
   create mode = 0750
   veto files = /.*/

>>>>>>>>The share with the problems on<<<<<<<<<<
[EHWLohn]
        comment = Lohn-Buchhaltung
        path = /share/Lohn/ehwlohn
        browseable = no
        read only = no
        public = yes
        create mode = 0660
        directory mode = 0775
        force group = Lohn






mit freundlichen Grüßen

Martin Schmidt

Tel: 09843/988095
Fax: 09843/988096
email: martin.schmidt at jielo.de