Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.3 |  CUBRID 9.0.0 | 

CUBRID SHARD Log

There are four types of logs that relate to starting the shard: access, proxy, error and SQL logs. Changing the directory of each log is available through LOG_DIR, ERROR_LOG_DIR, and PROXY_LOG_FILE parameter of the shard configuration file (shard.conf).

SHARD PROXY Log
Access Log
  • Parameter: ACCESS_LOG
  • Description: Log the client access (the existing broker logs at the cas).
  • Default directory: $CUBRID/log/broker/
  • File name: <broker_name>_<proxy_index>.access
  • Log type: All strings, except the access log and the cas_index at the cas, are identical

10.24.18.67 - - 1340243427.828 1340243427.828 2012/06/21 10:50:27 ~ 2012/06/21 10:50:27 23377 - -1 shard1     shard1

10.24.18.67 - - 1340243427.858 1340243427.858 2012/06/21 10:50:27 ~ 2012/06/21 10:50:27 23377 - -1 shard1     shard1

10.24.18.67 - - 1340243446.791 1340243446.791 2012/06/21 10:50:46 ~ 2012/06/21 10:50:46 23377 - -1 shard1     shard1

10.24.18.67 - - 1340243446.821 1340243446.821 2012/06/21 10:50:46 ~ 2012/06/21 10:50:46 23377 - -1 shard1     shard1

Proxy Log Level
  • Parameter: PROXY_LOG
  • Proxy log level policy: When the upper level is set, all logs of the lower level will be left.
    • Ex) Set SCHEDULE and then all ERROR | TIMEOUT | NOTICE | SHARD | SCHEDULE logs will be left.
  • Proxy Log Levell Item
    • NONE or OFF: No log is left.
    • ERROR (default): An internal error occurs and logging is not successfully processed
    • TIMEOUT: Timeout such as session timeout or query timeout
    • NOTICE: When the error is not a query without hint or other errors
    • SHARD: Scheduling that shows which shard and which cas the client request have sent to and whether the request has responded to the client or not
    • SCHEDULE: Shard processing such as getting the shard key ID through parsing the hit or hashing
    • ALL: All logs
SHARD CAS Log
SQL Log
  • Parameter: SQL_LOG
  • Description: Log queries such as prepare/execute/fetch and other cas information.
  • Default directory: $CUBRID/log/broker/sql_log
  • File name: %broker_name%_%proxy_index%_%shard_index%_%as_index%.sql.log

06/21 10:13:00.005 (0) STATE idle

06/21 10:13:01.035 (0) CAS TERMINATED pid 31595

06/21 10:14:20.198 (0) CAS STARTED pid 23378

06/21 10:14:21.227 (0) connect db shard1@HostA user dba url shard1 session id 3

06/21 10:14:21.227 (0) DEFAULT isolation_level 3, lock_timeout -1

06/21 10:50:28.259 (1) prepare srv_h_id 1

06/21 10:50:28.259 (0) auto_rollback

06/21 10:50:28.259 (0) auto_rollback 0

Error log
  • Parameter: ERROR_LOG_DIR
  • Description: For CUBRID, the cs library logs EID and error strings to the corresponding file. For cas4o/m, the cas logs errors to the corresponding file.
  • Default directory: $CUBRID/log/broker/error_log
  • File name: %broker_name%_%proxy_index%_%shard_index%_%cas_index%.err

Time: 06/21/12 10:50:27.776 - DEBUG *** file ../../src/transaction/boot_cl.c, line 1409

trying to connect 'shard1@localhost'

Time: 06/21/12 10:50:27.776 - DEBUG *** file ../../src/transaction/boot_cl.c, line 1418

ping server with handshake

Time: 06/21/12 10:50:27.777 - DEBUG *** file ../../src/transaction/boot_cl.c, line 966

boot_restart_client: register client { type 4 db shard1 user dba password (null) program cubrid_cub_cas_1 login cubrid_user host HostA pid 23270 }