"Could not execute user procedure: fork error "
Encountered this error on two separate stored procedures we have scheduled to fire from cron jobs overnight.
I've been able to re-execute these by hand this morning, so it doesn't appear to be an issue in the VSQL.
Can anyone share any insight into this error, how to troubleshoot, and possible steps to rectify the issue?
Thanks,
Nick
ERROR 2853
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: ERROR 2853
Hi,
I wonder if this is an issue where you are exceeding the max processes?
On my system:
What is the out put on your system?
I wonder if this is an issue where you are exceeding the max processes?
On my system:
Code: Select all
[root@vertica01 ~]# ulimit -u
606208
[root@vertica01 ~]# cat /proc/sys/kernel/threads-max
1212416
[root@vertica01 ~]# cat /etc/security/limits.conf | grep -i nproc
# - nproc - max number of processes
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
Jim Knicely
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
![Image](http://vertica-forums.com/MyUploads/ASE_ebadge.png)
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: ERROR 2853
Glad to share.
Thanks for the help.
Code: Select all
[root@vertica01 ~]# ulimit -u
1024
[root@vertica01 ~]# cat /proc/sys/kernel/threads-max
1547434
[root@vertica01 ~]# cat /etc/security/limits.conf | grep -i nproc
# - nproc - max number of processes
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
dbadmin soft nproc 96732
dbadmin hard nproc 96732
Re: ERROR 2853
Hi!
Probably the problem with maximum number of open files (ulimit).
See :
1.Verify that Kernel and User Parameters Were Set
2.Increase the Maximum Number of Files Open
3.Increase the max_map_count Parameter
Probably the problem with maximum number of open files (ulimit).
See :
1.Verify that Kernel and User Parameters Were Set
2.Increase the Maximum Number of Files Open
3.Increase the max_map_count Parameter
Re: ERROR 2853
We were missing the fs.file-max setting in our sysctl.conf file, but had open file limit set up correctly in a few other ways according to our sys admin.
At any rate, is adding that parameter going to make a difference in some substantial way if we had it covered from somewhere else, or does it perform a unique function?
Thanks!
At any rate, is adding that parameter going to make a difference in some substantial way if we had it covered from somewhere else, or does it perform a unique function?
Thanks!