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 }