Help needed for this error

Moderator: NorbertKrupa

Post Reply
User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Help needed for this error

Post by nnani » Thu Apr 19, 2012 4:20 am

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.
nnani........
Long way to go

You can check out my blogs at vertica-howto

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Help needed for this error

Post by JimKnicely » Thu Apr 19, 2012 11:49 am

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:

Code: Select all

[root@verticatst01 ~]# ulimit -n
65536
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:

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

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Error Codes”