diff options
| author | Joerg Steffens <joerg.steffens@bareos.com> | 2017-09-12 22:43:02 +0300 |
|---|---|---|
| committer | Joerg Steffens <joerg.steffens@bareos.com> | 2017-09-12 22:43:02 +0300 |
| commit | 0ba27b5ab8edbd40fa346b0d627a1fa2dda44652 (patch) | |
| tree | 0ca6b06331efd5aeb04613a48eda3f2a74e9cf7a | |
| parent | 859641ff6182aa89b1d67ec2c412513076442071 (diff) | |
MySQL: Lock Wait Timeout
| -rw-r--r-- | manuals/en/main/bareos.sty | 2 | ||||
| -rw-r--r-- | manuals/en/main/catmaintenance.tex | 20 |
2 files changed, 21 insertions, 1 deletions
diff --git a/manuals/en/main/bareos.sty b/manuals/en/main/bareos.sty index 7302e29..aa43555 100644 --- a/manuals/en/main/bareos.sty +++ b/manuals/en/main/bareos.sty @@ -656,7 +656,7 @@ Version $>=$ #3% } \lstnewenvironment{bareosConfigResource}[3]{% - % #1 compontent + % #1 component % #2 resource type % #3 resource name \renewcommand*{\lstlistingname}{Resource} diff --git a/manuals/en/main/catmaintenance.tex b/manuals/en/main/catmaintenance.tex index 4b7e904..c8c5df2 100644 --- a/manuals/en/main/catmaintenance.tex +++ b/manuals/en/main/catmaintenance.tex @@ -1129,6 +1129,26 @@ set: +\subsection{MySQL: Lock Wait Timeout} + +In large environments, the Bareos \mysql backend may run in a lock wait timeout. +This can be seen as Bareos message, e.g.: + +\begin{bmessage}{Bareos error message because of \mysql lock time timeout} +Fatal error: sql_create.c:899 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=Lock wait timeout exceeded; try restarting transaction +\end{bmessage} + +In this case the \mysql \configline{innodb_lock_wait_timeout} must be increased. +A value of 300 should be sufficient. + +\begin{config}{/etc/my.cnf.d/server.cnf} +... +[mysqld] +innodb_lock_wait_timeout = 300 +... +\end{config} + + % TODO: hidden, because outdated information. should we improve or remove it? \hide{ |