Error Messages and Troubleshooting
| No | error message | state | component | version | cause(extract posting) | solution |
|---|---|---|---|---|---|---|
| 1 | ERROR CA001 CUBRIDCUBRID ODBC DriverTransaction(index1, dba@localhost|20383) has been unilaterally aborted by the system. |
During Inserting records | Engine | CUBRID 2008 | Occurs when DB server is forcely terminated. | There are various reasons which terminated server or causes disconnection. (EX: deadlock) Please check the logs if a problem occurs at the moment. |
| 2 | -2003 Cannot communicate with broker | When CUBRID Manager's JDBC version is incompatible with DB server version. | CM | CUBRID 2008 R2.2 | JDBC driver should be same as server version | choose aright version of JDBC driver in CUBRID Manager and retry to connect |
| 3 | A network read/write error occurred for socket 5 associated with your transaction (index 2, root@master|17705) |
Cannot start server after deleting 170,000 rows by DELETE ALL statement.
|
Engine | CUBRID 2008 | When DB process is terminated abnormally, the previous logs remains still unclearly. | On the console, run the following commands. 1) csql -S DB_NAME 2) cubrid emergency_patchlog DB_NAME 3) cubrid emergency_patchlog -r DB_NAME |
| 4 | serial object delete error | Cannot DROP SERIAL when deleting a table. | Engine | CUBRID 2008 R3.0 | A bug was found in CUBRID 8.3.0 or lower versions. SERIAL should be dropped with a table together. | A bug fixed. As long as you are an owner of objects, SERIALs drops when deleting a table. |
| 5 | Cannot connect to master server... bad file descriptor | On Windows7 32 bits, cannot start DB server. | Engine | CUBRID 2008 | Among cubrid service, cub_master seems not running | On the console, 1) cubrid service stop 2) cubrid service start See if every process is on. 3) cubrid server start See if a process is not running, see the log file (*_master) in CUBRID/log/ directory and server logs( DB_NAME*) in CUBRID/log/server directory |
| 6 | C:\CUBRID\databases\ |
After DB backup in the old version, I removed CUBRID in the system. Then I installed CUBRID server and tried restoring. | Engine | CUBRID 2008 R3.1 | The error occurs when restoring a backup file which cannot read in a new version. | Althugh you have only DB backup file without DB and other files, you can restore only when DB server version and file directory is as same as old environment. |
| 7 | ERROR -673 0 1 Your connection to the server has been closed since the server is going down immediately | After creating a DB, I cannot create a table even if I logged-in | Engine | CUBRID 2008 R3.1 | This error occurs when the DB server is terminated. | On the console, run a command. cubrid server start |
| 8 | @ cubrid master start ++ cubrid master start: success @ cubrid broker start ++ cubrid broker is running. @ cubrid manager server start bind: Address already in use bind: Address already in use ++ cubrid manager server start: fail |
I messed up installation. I installed CUBRID new version while curbid service is on runnning. | Engine | CUBRID 2008 R2.2 | Linux account that you installed a old CUBRID is not same as that of a new version. | On the console, run a following command. ps -ef | grep cub_ Then kill cubridrelated processes. |
| . | ||||||
| 10 | Unable to mount disk volume "directory/file(lgar)"... . No such file or directory | lgar files are not deleted after cubrid backup -r option. The error occurs when trying backup after moving log files. | Engine | CUBRID 2008 | In When DB process is terminated abnormally, the previous logs remains still unclearly. | On the console, 1) cubrid service stop 2) cubrid service start See if every process is on. 3) cubrid server start See if a process is not running, see the log file (*_master) in CUBRID/log/ directory and server logs( DB_NAME*) in CUBRID/log/server directory |
| 11 | SqlMapClient operation; uncategorized SQLException for SQL []; SQL state null; error code -670 | When a specific method is executed, an error occurs | Framework | - | Error code: 670 is "Operation would have caused one or more unique constraint violations" | A certain SQL violates UNIQUE constraints. Search SQL causing -670 error under $CUBRID/log/broker/sql_log/ |
| 12 | -2147467259 : Your transaction (index 23, dba@localhost|28478) has been unilaterally aborted by the system. | Engine | CUBRID 2008 3.0 | Occurs when DB server is forcely terminated. | There are various reasons which terminated server or causes disconnection. (EX: deadlock) Avoid deadlock with short transaction and low isolation level. | |
| 13 | Attempt to execute the query when not all the parameters are binded | During SELECT execution, an error occurs. | Engine | CUBRID 2008 | Occurs when the number of parameters are not matched to your binding values. | When binding values, it should one to one match to parameters in the SQL. |
| 14 | ERROR -33 5 47 Last out of space notification for volumes with temporary data as the main storage purpose. Total number of pages = 20480, total number of free pages = -25 | I have found an error in the server log file. The fast query turns slower all of sudden. | Engine | - | DB temp volume is out of space. | Temp volume is mostly used to execute JOIN, Sorting. Run a following command on the console. cubrid addvoldb -p temp DB_NAME |
| 15 | Server no longer responding.... Resource temporarily unavailable *** Unable to mount log disk volume/file "/data/cubrid/db_svr2/db_lgat".... No such file or directory Your connection to the server has been closed since the server is going down immediately. CLIENT = svr1:copylogdb(21448), EID = 2 Has been interrupted. CLIENT = svr1:copylogdb(21448), EID = 3 Server communications error: connection status: CONN_CLOSING |
After upgrading to 8.3.1, cannot connect to DB. | Engine, HA | CUBRID 2008 R3.1 | In the conf, there is <common> section and <db> section. Your server conf file says log_page_buffer paraeter is located in <db> section however it is supposed to be <common> section. Since HA process cannot read <db> section parameters, they couldn't boot up and the master server stays as "to-be-active' state. |
Edit cubrid.conf file. Put log_page_buffer parameter to <common> section and then restart server. |
| 16 | Can't start up the distributor database. ############ Stopped by error... ############ Cannot make connection to master server. getting local host by name for host "TEST-S". Host not found. |
Engine, HA | CUBRID 2008 3.0 | The host names belonging to HA nodes shouldbe configured correctly. | See the /etc/hosts file if host name is correctly registered. | |
| 17 | This object is in a zombie state | Occurs in the ASP application having a logic of loop 1 loop 2 end end | Engine, ASP | CUBRID 2008 3.1 patch1 | Error occurs when the 1st query is closed automatically when the 2nd query is running in the nested query. | Set AutoCommit=False and create 2 connections to execute a query on each. |
| 18 | cubrid.jdbc.driver.CUBRIDException: Attempt to access a closed ResultSet. at cubrid.jdbc.driver.CUBRIDResultSet.checkIsOpen(CUBRIDResultSet.java:1648) at cubrid.jdbc.driver.CUBRIDResultSet.findColumn(CUBRIDResultSet.java:670) at cubrid.jdbc.driver.CUBRIDResultSet.getString(CUBRIDResultSet.java:559) at jeemin.Test1.main(Test1.java:28) | Occurs in the JDBC application having a loop | Engine, Java | CUBRID 2008 R2 | Error occurs when the 1st ResultSet is closed in the loop | When using a nested query, set connection.setAutoCommit(false) |
| 19 | -899 Stored procedure execute error: java.lang.NullPointerException | Occurs when executing Java Stored Procedure. | Engine, Java Store Procedure | CUBRID 2008 | Procedure information should match to class file and function names. | Check if a simple typo exists in your procedure, comparing with class files and function names. |
| 20 | Java VM is not running | Occurs when executing Java Stored Procedure. | Engine, Java Store Procedure | CUBRID 2008 | JAVA VM is not running. See if jvm.dll setting. | See JAVA_HOME and PATH settings if jvm.dll is in PATH. After setting, you should restart cubrid. cubrid service stop cubrid service start |
| 21 | Warning: Error: DBMS, 0, Unknown DBMS error | I can connect to DB via CUBRID Manager, but not my PHP application. | Engine, PHP | CUBRID 2008 | Error occurs when cannot conenct to a DB. | Start a DB and see if your connection information9broker IP and port) is correct in your PHP. |
| 22 | Warning -> Current user(0) does not match CUBRID user(501). Server may have unpredictable behavior. Continuing... Warning -> Current user(0) does not match CUBRID user(501). Server may have unpredictable behavior. Continuing... Error : Serverpid=2546 already running. Error : Serverpid=2549 already running. ++ cubrid manager server start: fail | When I start cubrid manager, error occurred. | CM | CUBRID 2008 3.0 | See the Linux account and CUBRID installation account with permission. | Check the user account info of "cub_" processes and set a right user permission. |
| 23 | . Failed to connect to database server, 'UPS', on the followiong host(s): localhost compactdb : Failed to connect to database server, 'UPS', on the following host(s):localhost. | When run compactdb via CUBRID Manager, it failed. | CM | CUBRID 2008 3.1 patch 1 | Bug only in CUBRID Manager. You can run command on console. | If DB is offline, cubrid compactdb -S <DB_NAME> If DB is online, cubrid compactdb <DB_NAME> |
| 24 | Cannot get a connection. Check the status of broker and DB server. |
After I upgraded DB server vesion, DB Log-in failed via CUBRID Manager |
CM | CUBRID 2008 R3.1 1002 | JDBC version used in CUBRID Manager should be same as DB server's version. | Find a right version of JDBC and set it in CM. http://ftp.cubrid.org/CUBRID_Drivers/JDBC_Driver/ |
| 25 | Cannot get a connection. Check the status of broker and DB server. | I can log-in to DB via local CM however I cannot connect to the DB via a remote CM. | CM | CUBRID 2008 | CM in a remote cannot get thru DB server. See the Firewall in CUBRID DB server host. | Disable or re-set the firewall and check CUBRID and CUBRD Manager using ports are all open. |
| 26 | PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/cubrid.so' - libcascci.so.8: cannot open shared object file: No such file or directory in Unknown on line 0 | I cannot load the PHP module successfully. | PHP | - | If you build PHP module, Linux user should be as same as CUBRID Installation user. |
See the tutorial how to build PHP module, it is easy to use PECL |
| 27 | NativeException: java.lang.ClassNotFoundException: cubrid/jdbc/driver/CUBRIDDriver | Class.forName("cubrid.jdbc.driver.CUBRIDDriver") cannot find a driver. | Java | CUBRID 2008 R2.2.3002 | See if JAVA class path is correctly configured. | $ CUBRID / jdbc / cubrid_jdbc.jar should be set to CLASSPATH. See the manual. |
| 28 | PHP Warning: Unknown(): Unable to load dynamic library './cubird.so' - ./cubird.so: cannot open shared object file: No such file or directory in Unknown on line 0 | Doesn't work with CUBRID PHP driver. | PHP | CUBRID 2008 | 1. See if extension_dir is correctly configured in the php.ini. 2. CUBRID php module should link with libcascci.so (CCI driver). Your PHP cannot find CCI in the system |
1. extension_dir should address "cubrid.so" file. 2. cubrid.so refers to libcascci.so. See if cubrid.so links with libcascci.so by "ldd cubrid.so" command |
| 29 | main.c:(.text+0x69): undefined reference to `cci_connect_3_0' | When building the source, error occurs. | CCI | CUBRID 2008 R3.1 | The option for CCI driver can be added | Use the option, -L$CUBRID/lib-lcascci |
| 30 | /usr/bin/ld: cannot find -lcascci | When running $ gcc -L$CUBRID/lib-lcascci a.c -o a, cannot find CCI library | CCI | CUBRID 2008 R3.1 | Error occurs since the library was not found. | 1) Check $CUBRID/lib directory if libcascci.so exists. 2) Check if CUBRID environment variables are correctly configured. |
| 31 | Attempt to access a closed ResultSet(PreparedStatement) | To keep using a ResultSet in the following queries, error occurs. | Engine | CUBRID 2008 | ResultSet to fetch has been already closed. | The prior ResultSet was closed because cutoCommit is true. If you re-use the 1st ResultSet, change the setting to "False" and add Commit/Rollback in the end for each transaction. |
| 32 | PHP Startup: Unable to load dynamic library | I have already set php.ini, but I cannot execute queries. | PHP | CUBRID 2008 R4.0 | *.dll file cannot be loaded. | Check your PHP version and OS version. In the directory, only a right version of PHP driver should exist. http://ftp.cubrid.org/CUBRID_Drivers/PHP_Driver/ |
| 33 | Backup is already running. Backup cannot be run by two processes. | When trying DB backup in CURBID Manager, error occurs. | Windows 2008 | CUBRID 2008 R2.2 | While DB bakcup is already running, you cannot perform backup at the same time. | 1. Check if other DBA or automated script has already run DB backup. 2. If not, kill a prior backup process. |
| 34 | Cannot create enough threads for 'max_clients=100'. | In cubrid.conf, I configured java_stored_procedure=yes to use Java stored procedure. Then, error occurs. | CentOS | CUBRID 2008 R4.0 | In the 32bit server, it can possibly limit due to lack of memory. | 1. Change the server to 64bit 2. Run a command to limit memory stack size: ulmit -s 5120 3. Set max_clients in cubrid.conf to lower value. |
| 35 | mktemp: invalid option -- p Usage: mktemp -d -q -u template tar: ../CUBRID-product.tar: Cannot open: tar: Error is not recoverable: exiting now | During CUBRID DB server installation, error occurs. | Linux | CUBRID 2008 R4.1 | In your system, there is no mktemp library. | Check if the library is installed in your system with a command: pm -qa | grep mktemp If not exists, add or upgrade your OS. |
| 36 | configure: error: /home/cubrid/CUBRID/lib/libcascci.so Please set CUBRID base install dir with --with-cubrid=DIR | During CUBRID PHP driver installation, error occurs. | CentOS | CUBRID 2008 R4.1 | OS bit, CUBRID bit, PHP bit mismatches. | Chekc if the bit of OS / CUBRID / PHP is all same. http://ftp.cubrid.org/ |
Page info
viewed 1207 times
![[Level:0]](http://www.cubrid.org/modules/point/icons/default/0.gif "Rank: 0/30, reputation score 1 (16% completed for the next level)"){kind=icon}
leejogun
![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 21 (3% completed for the next level)"){kind=icon}
Esen Sagynov
Share this article