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 <[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? > > >
