Re: mariaDB - limits problem?

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?


On Mon, Mar 5, 2018 at 12:10 PM, Stuart Henderson <stu@spacehopper.org>
wrote:

> On 2018-03-05, Bambero <bambero@gmail.com> 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?
>
>
>