Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Error Messages and Troubleshooting


Noerror messagestatecomponentversioncause(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\\backup\_backup_lv0 is a backup of database created on Mon Apr 11 15:41:49 2011 instead of given database C:\CUBRID\DATABA~1\\ created on Wed Apr 20 16:13:47 2011 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

http://www.cubrid.org/wiki_apis/entry/php_api_build_guide 

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/

 

comments powered by Disqus
Page info
viewed 1961 times
translations en
Author
posted 2 years ago by
leejogun
Contributors
updated last year by
View revisions
Share this article