Database Error-What Does It Mean?

Store Builder Questions
1

Hello,

I received the below database errors yesterday. Have not had a database error in about 2 years or more. Would like any insight as to what it means. I am on cs-cart 4.3.5. I am not actively using the cart much so there is very little activity. Do not see any errors today.

Thank you,

Bob

Database (error)
Error: Out of resources when opening file '/tmp/#sql_35be_1.MAI' (Errcode: 24 "Too many open files") (23)
Query: SHOW COLUMNS FROM cscart_sessions

Backtrace››
app/Tygh/Session.php (shutdown): 543
app/Tygh/Session.php (write): 132
app/Tygh/Session.php (write): 160
app/Tygh/Backend/Session/Database.php (db_query): 60
app/functions/fn.database.php (call_user_func_array): 130
app/Tygh/Database.php (query): 344
app/Tygh/Database.php (checkTableFields): 444
app/Tygh/Database.php (getTableFields): 579
app/Tygh/Database.php (getColumn): 549
app/Tygh/Database.php (call_user_func_array): 230
app/Tygh/Database.php (query): 359
— — 04/09/2018, 06:45 PM
Database (error)
Error: Out of resources when opening file '/tmp/#sql_35be_1.MAI' (Errcode: 24 "Too many open files") (23)
Query: SHOW COLUMNS FROM cscart_logs
— — 04/09/2018, 06:45 PM

2

Out of memory or disk space?

3

What is your open_files_limit? You probably need to increase it.

4

Your /tmp directory is full and there's not enough space to create the temporary table for sorting.

suggest you have your hosting change the location of mySQL temp files to the same filesystem where the normal database tables are located but in a tmp directory.