Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Firebird 3.0.2, 3.0.3, 3.0.4 Super crashing randomly [CORE5956] #2230

Open
firebird-automations opened this issue Oct 31, 2018 · 3 comments
Open

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Mezamon (mezamon)

Hi,

My 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

@firebird-automations
Copy link
Collaborator Author

Commented by: Mezamon (mezamon)

typo

@firebird-automations
Copy link
Collaborator Author

Modified by: Mezamon (mezamon)

description: 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

=>

Hi,

My 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

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Did you try to check - what does error 12 in mmap system call mean? For example such case:

   ENOMEM The process's maximum number of mappings would have been exceeded\.  This error can  also  occur  for  munmap\(\),  when
          unmapping a region in the middle of an existing mapping, since this results in two smaller mappings on either side of
          the region being unmapped\.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant