Page 1 of 1
ERROR 2853
Posted: Tue Oct 23, 2012 4:31 pm
by ncreekmur
"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
Re: ERROR 2853
Posted: Wed Oct 24, 2012 1:37 am
by JimKnicely
Hi,
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
What is the out put on your system?
Re: ERROR 2853
Posted: Wed Oct 24, 2012 9:45 pm
by ncreekmur
Glad to share.
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
Thanks for the help.
Re: ERROR 2853
Posted: Thu Oct 25, 2012 8:09 am
by id10t
Re: ERROR 2853
Posted: Thu Oct 25, 2012 6:10 pm
by ncreekmur
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!