Fred, we're using the Centos 6-based Appliance system for our workstations, pointing to a MySQL server. Do you know what would be different for MySQL? Updating open_files_limit in /etc/my.conf, maybe?
I'll guess we need to restart Rivendell on all of the workstations after the MySQL server is restarted, since any open connections will be dropped. Thanks for publishing this. I've been seeing these errors for a while. Regards, Mike C On Wed, Sep 6, 2017 at 5:56 PM Fred Gleason <[email protected]> wrote: > On Sep 6, 2017, at 20:11, drew Roberts <[email protected]> wrote: > > mysqldump: Got error: 1016: Can't open file: > './Rivendell/adins_2015_12_24_LOG.frm' (errno: 24) when using LOCK TABLES > > > Looks like your DB server process is hitting its open file limit. The > specifics of how to increase that vary depending on your distro. If you’re > running a SystemD-based setup (such as CentOS 7 or Fedora), you can change > the limit by creating a file called ‘limits.conf’ in the > ‘/etc/systemd/system/mariadb.service.d/‘ directory (you may have to create > that directory as well). Put two lines in that file: > > [Service] > LimitNOFILE=<limit> > > where <limit> is the file open limit. The default is 1024, which can be > too small for a large Rivendell system. I typically use 16768. > > Once the file is in place, restart the DB server and Rivendell by doing > (as root): > > systemctl daemon-reload > systemctl restart mariadb > service rivendell restart > > (WARNING: this *will* stop any Rivendell audio playout! Plan accordingly.) > > > The uptime on the machine is only 47 days, not somewhere back in 2015. > > > The filename referenced in the error message is that of an underlying data > table in the DB. It has nothing to do with system uptime. > > Cheers! > > > |----------------------------------------------------------------------| > | Frederick F. Gleason, Jr. | Chief Developer | > | | Paravel Systems | > |----------------------------------------------------------------------| > | A room without books is like a body without a soul. | > | -- Cicero | > |----------------------------------------------------------------------| > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
