Fred, On Wed, Sep 6, 2017 at 8:55 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), > This is CentOS release 6.7 (Final). What would we look for there? > 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 > > -- Enjoy great *Bahamian Music* at: Bahamain Or Nuttin - http://www.bahamianornuttin.com <http://www.bahamianornuttin.com/>
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
