When I try to execute this SQL query I get the following error
Error - SQL submitted to ODBC data source <DSN_EDW_Vertica> resulted in error <ERROR: FileColumnReader: Error opening file /verticadb/PRDEDWDBS01/v_prdedwdbs01_node0001_data/891/45035996294428891/45035996294428891_0.fdb for read: Too many open files;
The SQL query fired is
DELETE FROM FACT.FCT_ONE_TIME_CHARGES WHERE EXISTS (SELECT 1 FROM STAGING.STG_BL1_CHARGE_REQUEST A WHERE A.REQUEST_SEQ_NO = FCT_ONE_TIME_CHARGES.OC_CHARGE_SEQ_NO AND FCT_ONE_TIME_CHARGES.CORRECTION_SEQ_NO = A.CORR)
Also the same error pop ups when executing another query
Error - SQL submitted to ODBC data source <DSN_EDW_Vertica> resulted in error <ERROR: FileColumnReader: Error opening file /verticadb/PRDEDWDBS01/v_prdedwdbs01_node0001_data/537/45035996283008537/45035996283008537_0.fdb for read: Too many open files; Error while executing the query>.
The SQL query used is
DELETE FROM FACT.FCT_ACC_CREDIT WHERE EXISTS (SELECT 1 FROM STAGING.STG_AR1_CUSTOMER_CREDIT A WHERE FACT.FCT_ACC_CREDIT.CREDIT_ID = A.CREDIT_ID AND FACT.FCT_ACC_CREDIT.ACCOUNT_NO = A.ACCOUNT_ID)
I cannot get why Vertica is giving this error, Can someone please let me know the roort cause for this or the solution over this.
Help needed for this error
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Help needed for this error
Hi,
At the Linux prompt run the command ulimit -n. This will tell you the upper limit on the number of "open files" permitted on your system.
On my server:
This value must be at least 65,536. That's what Vertica will try to set it to during the installation. If you look at the tail end of the "/etc/security/limits.conf" file you'll be able to see what Vertica added.
On my server:
At the Linux prompt run the command ulimit -n. This will tell you the upper limit on the number of "open files" permitted on your system.
On my server:
Code: Select all
[root@verticatst01 ~]# ulimit -n
65536
On my server:
Code: Select all
[root@verticatst01 ~]# tail -6 /etc/security/limits.conf
#
# Added by Vertica
* soft nofile 65536
# Added by Vertica
* hard nofile 65536
# End of file
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.