trumpsbrah
Cadet
- Joined
- Apr 28, 2020
- Messages
- 1
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:
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:
Here's my testparm output. orl_sql is the share in question:
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