Firebird 3.0.2, 3.0.3, 3.0.4 Super crashing randomly ----------------------------------------------------
Key: CORE-5956 URL: http://tracker.firebirdsql.org/browse/CORE-5956 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.4 Environment: CentOS Linux release 7.5.1804 (Core) Linux version 3.10.0-862.14.4.el7.x86_64 (mockbu...@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-28) (GCC) ) #1 SMP Wed Sep 26 15:12:11 UTC 2018 Reporter: Mezamon Hi, Our firebird server is hangs and when it happened we can't read/write any data from database. also my server memory and cpu usage doesn't changing. I mean if firebird uses 23 gb ram while it crash, it still use 23gb until i restart the firebird service but i can't communicate with firebird server any way. I tried several times backup and restore, also gfix doesn't show any error message. My database server has 40 core cpu and ddr 4 128gb ram. I suspected for hw failure and i changed my server 2 times and every time i changed firebird version (3.0.2,3.0.3,3.0.4). Firebird doesn't use my resources even half of them. I can't reproduce the issue. I am getting errors at firebird.log like below; RMPH022.RMPH.local Wed Oct 31 12:19:49 2018 Operating system call mmap failed. Error code 12 RMPH022.RMPH.local Wed Oct 31 12:19:49 2018 LockManager::LockManager() operating system directive mmap failed Cannot allocate memory RMPH022.RMPH.local Wed Oct 31 12:19:49 2018 Authentication error cannot attach to password database Error in isc_attach_database() API call when working with legacy security database operating system directive mmap failed Cannot allocate memory RMPH022.RMPH.local Wed Oct 31 12:19:49 2018 Operating system call mmap failed. Error code 12 RMPH022.RMPH.local Wed Oct 31 12:19:49 2018 LockManager::LockManager() operating system directive mmap failed Cannot allocate memory RMPH022.RMPH.local Wed Oct 31 12:20:19 2018 Operating system call pthread_create failed. Error code 11 RMPH022.RMPH.local Wed Oct 31 12:20:19 2018 Operating system call pthread_create failed. Error code 11 RMPH022.RMPH.local Wed Oct 31 12:20:19 2018 Operating system call pthread_create failed. Error code 11 RMPH022.RMPH.local Wed Oct 31 12:20:19 2018 Operating system call pthread_create failed. Error code 11 RMPH022.RMPH.local Wed Oct 31 12:20:19 2018 Operating system call pthread_create failed. Error code 11 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel