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
