Intermittent Timeouts on SMB Share

[trumpsbrah]

I'm having an issue lately with a handful of jobs that copy SQL backup files from a handful of SQL servers. We're seeing the jobs fail after a given amount of time (maybe an hour or so). When this happens, I lose access to the shares on the filer (running FreeNAS 11.2-U6). After 90 minutes or so, access is restored. Permissions authenticate against AD, and wbinfo commands work fine. The one common element seems to be that the backup jobs are failing from servers running older versions of SQL, but they've been going without a hitch for the past six months, until just now.

It looks like the jobs start properly. I'm seeing tons of write logs in /var/log/messages similar to:

Code:

Apr 28 00:01:59 myfiler smbd[81319]:   smb2: fnum 3403170790, file SQLSERVER/communicator_backup_2020_04_27_204638_6683920.bak, length=65536 offset=0 wrote=65536

As far as errors go, though, I'm not seeing much useful in the message logs other than a recurrence of error messages along the lines of:

Code:

Apr 28 02:28:13 myfiler winbindd[89689]:   msrpc_sid_to_name: failed to lookup sids: STATUS_SOME_UNMAPPED



Apr 28 07:39:01 myfiler smbd[3742]:   sys_get_vfs_quota() failed for mntpath[SQLSERVER/model_backup_2020_04_27_200013_9145033.bak] bdev[(null)] qtype[3] id[-1]: Operation not supported

Here's my testparm output. orl_sql is the share in question:

Code:

psys-orl-dbbk2# testparm
Registered MSG_REQ_POOL_USAGE
Registered MSG_REQ_DMALLOC_MARK and LOG_CHANGED
Load smb config files from /usr/local/etc/smb4.conf
Processing section "[orl_sql]"
Processing section "[sec_sql]"
Processing section "[test]"
Loaded services file OK.
Server role: ROLE_DOMAIN_MEMBER

Press enter to see a dump of your service definitions

# Global parameters
[global]
        ads dns update = No
        aio max threads = 2
        allow trusted domains = No
        disable spoolss = Yes
        dns proxy = No
        domain master = No
        dos charset = CP437
        kernel change notify = No
        lm announce = Yes
        load printers = No
        local master = No
        logging = syslog:3
        max log size = 51200
        max open files = 927371
        nsupdate command = /usr/local/bin/samba-nsupdate -g
        obey pam restrictions = Yes
        preferred master = No
        printcap name = /dev/null
        realm = XDOMAIN.YDOMAIN.COM
        security = ADS
        server min protocol = SMB2_02
        server role = member server
        server string = DBA Data
        template shell = /bin/sh
        winbind cache time = 7200
        winbind enum groups = Yes
        winbind enum users = Yes
        winbind max domain connections = 10
        winbind use default domain = Yes
        workgroup = DOMAIN
        idmap config domain: unix_nss_info = no
        idmap config domain: unix_primary_group = yes
        idmap config domain: schema mode = sfu
        idmap config domain: range = 600000000-700000000
        idmap config domain: backend = ad
        idmap config *: range = 90000001-100000000
        idmap config * : backend = tdb
        acl allow execute always = Yes
        create mask = 0666
        directory mask = 0777
        directory name cache size = 0
        dos filemode = Yes
        strict locking = No


[orl_sql]
        aio write size = 0
        path = "/mnt/data/orl_sql"
        read only = No
        veto files = /.snapshot/.windows/.mac/.zfs/
        vfs objects = zfs_space zfsacl streams_xattr
        zfsacl:acesort = dontcare
        nfs4:chown = true
        nfs4:acedup = merge
        nfs4:mode = special


[sec_sql]
        aio write size = 0
        path = "/mnt/data/sec_sql"
        read only = No
        veto files = /.snapshot/.windows/.mac/.zfs/
        vfs objects = zfs_space zfsacl streams_xattr
        zfsacl:acesort = dontcare
        nfs4:chown = true
        nfs4:acedup = merge
        nfs4:mode = special


[test]
        aio write size = 0
        path = "/mnt/data/test"
        read only = No
        veto files = /.snapshot/.windows/.mac/.zfs/
        vfs objects = zfs_space zfsacl streams_xattr
        zfsacl:acesort = dontcare
        nfs4:chown = true
        nfs4:acedup = merge
        nfs4:mode = special