Thanks, a lot. I think this is the point.
But is there a way to chceck currently locked files?
Open files I can check with:
fstat | awk ' { print ( $1 ) }' | sort | uniq -c | sort -n
or:
sysctl kern.nfiles
On Mon, Mar 5, 2018 at 1:02 PM, Otto Moerbeek <[email protected]> wrote:
> On Mon, Mar 05, 2018 at 12:43:05PM +0100, Bambero wrote:
>
> > Thanks for the answer.
> > This prblem is not related with open-files limit. This error is completly
> > different.
> > I have a special class in login.conf so open files limit we should
> exclude
> > in this case:
> >
> > mysqld:\
> > <------>:openfiles-cur=1024:\
> > <------>:openfiles-max=2048:\
> > <------>:tc=daemon:
> >
> > I found in source that there is file locks limit:
> >
> > int maxlocksperuid = 1024;
> > https://github.com/openbsd/src/blob/2452e2a8d7e9b5090ff527bcb559d0
> > 2899e5c6af/sys/kern/vfs_lockf.c
> >
> > Maybe this is a reason?
>
> Try
>
> sysctl kern.maxlocksperuid=2048
>
> -Otto
>
> >
> >
> > On Mon, Mar 5, 2018 at 12:10 PM, Stuart Henderson <[email protected]>
> > wrote:
> >
> > > On 2018-03-05, Bambero <[email protected]> wrote:
> > > > Hi,
> > > >
> > > > After move to OpenBSD 6.2 I have problem with MySQL. I looks like
> file
> > > > locks limit problem.
> > > > On fresh MySQL install, when try to restore dump, MySQL hangs
> restore at
> > > > 1500th table (each time). There are no other connections only my
> restore
> > > > commands which looks like this:
> > > >
> > > > for i in `ls`; do tab=`echo $i | rev | cut -c 5- | rev`; echo $tab;
> echo
> > > > 'CREATE DATABASE `'$tab'`' | mysql ; cat $i | mysql "$tab"; sleep 3;
> done
> > > >
> > > > Each database is restored separatelly.
> > > >
> > > > /var/mysql-error.log throws:
> > > >
> > > > 180304 17:32:00 [ERROR] InnoDB: Unable to lock ./tui_pap/class.ibd,
> > > error:
> > > > 77
> > > > 2018-03-04 17:32:00 63e1a24fa38 InnoDB: Operating system error
> number 77
> > > > in a file operation.
> > > > InnoDB: Error number 77 means 'No locks available'.
> > > > InnoDB: Some operating system error numbers are described at
> > > > InnoDB:
> > > > http://dev.mysql.com/doc/refman/5.6/en/operating-
> system-error-codes.html
> > > > 180304 17:32:00 [ERROR] InnoDB: Cannot create file
> './tui_pap/class.ibd'
> > > >
> > > > I found in man page https://man.openbsd.org/errno.2
> > > > 77 ENOLCK *No locks available*. A system-imposed limit on the number
> of
> > > > simultaneous file locks was reached.
> > > > So the quastion is what is the limit of file locks, and how to
> change it
> > > up?
> > > >
> > > > How can i check how many locks are currently made?
> > > >
> > > > Thanks for any help.
> > > >
> > > > Bambero
> > > >
> > >
> > > Not sure if locks are accounted separately, are you just running out of
> > > file descriptors? Did you follow the instructions in the pkg-readme?
> > >
> > >
> > >
>
