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
