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?
