Background Image

FORUM

조회 수 413 추천 수 0 댓글 6
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
OS
Linux 64bit centOS 6.5
CUBRID Ver.
 9.2.21.0005
CUBRID TOOL Ver.
 10.1.0.002
응용 환경(API)
 php

* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
에러 내용 및 재현 방법 재현 가능한 Source와 SQL
관련 테이블(인덱스, 키정보 포함) 정보 CUBRID 홈 디렉토리 아래 log 디렉토리 압축


-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
저희가 테스트 서버와 운영서버를 돌리고 있는데요

system parameter 확인결과 별반 차이를 찾아보지 못 했습니다.

그래서 문의 드립니다.


경우는 이렇습니다.


1. 트랜잭션을 사용하여 A라는 테이블에 insert 하였습니다. 그리고 sleep을 걸어 트랜잭션 걸리는 시간을 인위적으로 늘려


2. 트랜잭션이 걸린 상태에서 A라는 테이블에 update를 하였습니다.


테스트 서버의 경우에는 

1번 행동이 완료된 후에 update를 동시에 완료하였고


운영서버의 경우에는

1번 행동과는 무관하게 update를 먼저 완료하였습니다.


왜 이런 현상이 있는 지 확인이 가능한지요...


지금 운영서버에서 LOCK걸린 테이블에 update 혹은 insert 과정에서 LOCK에러가 계속 발생하여

연동문제가 계속적으로 발생하고 있습니다.


성수기라 데이터가 급증하고 있는데 이와같은 현상이 점점 늘어나고 있는 해결책이 보이지 않네요


답변 부탁드립니다.





  • ?
    정훈 2017.08.03 01:15

    안녕하세요

    운영서버와 개발서버의 cubrid.conf 파일을 비교해서 파라미터 값을 확인해보면 좋을 것 같습니다.


    추가적으로 운영 서버에서 LOCK이 발생했을 때의 트랜잭션에 대한 것을 확인해보면 좋습니다.

    $> cubrid lockdb [db_name]
    유틸리티로 확인하여 LOCK 종류와 잠금 상태를 확인해주세요.


  • ?
    봉보로봉봉 2017.08.03 02:33

    *** Lock Table Dump ***
     Lock Escalation at = 100000, Run Deadlock interval =  1.00

    Transaction (index  0, (unknown), (unknown)@(unknown)|-1)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  1, applylogdb, DBA@db02|44028)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_UNACTIVE_COMMITTED
    Timeout_period : Infinite wait

    Transaction (index  2, broker2_cub_cas_1, DBA@db01|62090)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  3, copylogdb, DBA@db01|36351)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  4, broker2_cub_cas_2, DBA@db01|62716)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  5, broker2_cub_cas_4, DBA@db01|62093)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  6, broker2_cub_cas_6, DBA@db01|62095)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  7, broker2_cub_cas_7, DBA@db01|62096)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  8, broker2_cub_cas_8, DBA@db01|62097)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  9, broker2_cub_cas_9, DBA@db01|62098)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 10, broker2_cub_cas_3, DBA@db01|62092)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 11, broker2_cub_cas_5, DBA@db01|62094)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 12, broker2_cub_cas_11, DBA@db01|62100)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 13, broker2_cub_cas_10, DBA@db01|62099)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 14, broker2_cub_cas_15, DBA@db01|62104)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 15, broker2_cub_cas_13, DBA@db01|62102)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 16, broker2_cub_cas_12, DBA@db01|62101)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 17, broker2_cub_cas_14, DBA@db01|62103)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 18, broker2_cub_cas_16, DBA@db01|62105)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 19, broker2_cub_cas_17, DBA@db01|62106)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 20, broker2_cub_cas_18, DBA@db01|62107)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 21, broker2_cub_cas_19, DBA@db01|62108)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 22, broker2_cub_cas_20, DBA@db01|62109)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 23, broker2_cub_cas_21, DBA@db01|62110)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 24, broker2_cub_cas_2, DBA@db02|496)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 25, broker2_cub_cas_3, DBA@db02|19880)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 26, broker2_cub_cas_25, DBA@db02|9075)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 27, broker2_cub_cas_7, DBA@db02|51989)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 28, broker2_cub_cas_22, DBA@db01|62111)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 29, broker2_cub_cas_23, DBA@db01|62112)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 30, broker2_cub_cas_25, DBA@db01|62114)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 31, broker2_cub_cas_24, DBA@db01|62113)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 32, broker2_cub_cas_26, DBA@db01|62115)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 33, broker2_cub_cas_27, DBA@db01|62116)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 34, broker2_cub_cas_28, DBA@db01|62117)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 35, broker2_cub_cas_29, DBA@db01|62118)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 36, broker2_cub_cas_15, DBA@db02|9109)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 37, broker2_cub_cas_1, DBA@db02|498)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 38, broker2_cub_cas_13, DBA@db02|969)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 39, broker2_cub_cas_14, DBA@db02|9120)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 40, broker2_cub_cas_16, DBA@db02|991)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 41, broker2_cub_cas_17, DBA@db02|9105)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 42, broker2_cub_cas_22, DBA@db02|9083)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 43, broker2_cub_cas_33, DBA@db02|1014)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 44, broker2_cub_cas_26, DBA@db02|460)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 45, broker2_cub_cas_35, DBA@db02|473)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 46, broker2_cub_cas_30, DBA@db01|62119)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 47, broker2_cub_cas_80, DBA@db02|477)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 48, broker2_cub_cas_117, DBA@db02|488)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 49, broker2_cub_cas_119, DBA@db02|497)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 50, broker2_cub_cas_121, DBA@db02|501)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 51, broker2_cub_cas_122, DBA@db02|519)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 52, broker2_cub_cas_123, DBA@db02|528)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 53, broker2_cub_cas_124, DBA@db02|532)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 54, broker2_cub_cas_125, DBA@db02|542)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 55, broker2_cub_cas_127, DBA@db02|550)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 56, broker2_cub_cas_126, DBA@db02|546)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 57, broker2_cub_cas_130, DBA@db02|567)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 58, broker2_cub_cas_128, DBA@db02|559)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 59, broker2_cub_cas_129, DBA@db02|563)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 60, broker2_cub_cas_131, DBA@db02|577)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 61, broker2_cub_cas_133, DBA@db02|585)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 62, broker2_cub_cas_132, DBA@db02|581)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 63, broker2_cub_cas_134, DBA@db02|596)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 64, broker2_cub_cas_135, DBA@db02|601)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 65, broker2_cub_cas_136, DBA@db02|609)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 66, broker2_cub_cas_137, DBA@db02|613)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 67, broker2_cub_cas_138, DBA@db02|622)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 68, broker2_cub_cas_140, DBA@db02|63399)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 69, broker2_cub_cas_141, DBA@db02|63432)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 70, broker2_cub_cas_139, DBA@db02|63391)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 71, broker2_cub_cas_142, DBA@db02|330)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 72, broker2_cub_cas_145, DBA@db02|63455)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 73, broker2_cub_cas_143, DBA@db02|63441)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 74, broker2_cub_cas_144, DBA@db02|63450)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 75, broker2_cub_cas_146, DBA@db02|63468)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 76, broker2_cub_cas_147, DBA@db02|63469)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 77, broker2_cub_cas_31, DBA@db01|62120)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 78, broker2_cub_cas_32, DBA@db01|62121)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 79, broker2_cub_cas_10, DBA@db02|8364)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 80, broker2_cub_cas_5, DBA@db02|18218)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 81, broker2_cub_cas_33, DBA@db01|62122)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 82, broker2_cub_cas_148, DBA@db02|63478)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 83, broker2_cub_cas_149, DBA@db02|63481)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 84, broker2_cub_cas_150, DBA@db02|63523)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 85, broker2_cub_cas_151, DBA@db02|65504)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 86, broker2_cub_cas_152, DBA@db02|65495)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 87, broker2_cub_cas_153, DBA@db02|65490)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 88, broker2_cub_cas_154, DBA@db02|65478)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 89, broker2_cub_cas_159, DBA@db02|65464)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 90, broker2_cub_cas_157, DBA@db02|65474)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 91, broker2_cub_cas_155, DBA@db02|63545)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 92, broker2_cub_cas_156, DBA@db02|63561)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 93, broker2_cub_cas_160, DBA@db02|65460)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 94, broker2_cub_cas_4, DBA@db02|48141)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 95, broker2_cub_cas_158, DBA@db02|63571)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 96, broker2_cub_cas_161, DBA@db02|65452)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 97, broker2_cub_cas_27, DBA@db02|9070)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 98, broker2_cub_cas_162, DBA@db02|63614)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 99, broker2_cub_cas_8, DBA@db02|42506)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 100, broker2_cub_cas_34, DBA@db01|62123)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 101, broker2_cub_cas_35, DBA@db01|62124)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 102, broker2_cub_cas_36, DBA@db01|62125)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 103, broker2_cub_cas_37, DBA@db01|62126)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 104, broker2_cub_cas_38, DBA@db01|62127)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 105, broker2_cub_cas_39, DBA@db01|62128)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 106, broker2_cub_cas_40, DBA@db01|62129)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 107, broker2_cub_cas_45, DBA@db01|62134)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 108, broker2_cub_cas_46, DBA@db01|62135)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 109, broker2_cub_cas_42, DBA@db01|62131)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 110, broker2_cub_cas_41, DBA@db01|62130)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 111, broker2_cub_cas_43, DBA@db01|62132)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 112, broker2_cub_cas_48, DBA@db01|62137)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 113, broker2_cub_cas_50, DBA@db01|62139)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 114, broker2_cub_cas_47, DBA@db01|62136)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 115, broker2_cub_cas_49, DBA@db01|62138)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 116, broker2_cub_cas_44, DBA@db01|62133)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 117, broker2_cub_cas_20, DBA@db02|9087)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 118, broker2_cub_cas_19, DBA@db02|9096)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 119, broker2_cub_cas_12, DBA@db02|16003)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 120, broker2_cub_cas_11, DBA@db02|3318)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 121, broker2_cub_cas_9, DBA@db02|64762)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 122, broker2_cub_cas_6, DBA@db02|63161)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 123, broker2_cub_cas_42, DBA@db02|8877)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 124, broker2_cub_cas_43, DBA@db02|8872)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 125, broker2_cub_cas_44, DBA@db02|8863)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 126, broker2_cub_cas_45, DBA@db02|8859)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 127, broker2_cub_cas_46, DBA@db02|8850)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 128, broker2_cub_cas_50, DBA@db02|8759)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 129, lockdb, DBA@db02|36811)
    Isolation READ COMMITTED CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : No wait

    Transaction (index 157, broker2_cub_cas_18, DBA@db02|40260)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 160, broker2_cub_cas_21, DBA@db02|40277)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 161, broker2_cub_cas_23, DBA@db02|40278)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 162, broker2_cub_cas_24, DBA@db02|40279)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 165, broker2_cub_cas_28, DBA@db02|40282)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 166, broker2_cub_cas_29, DBA@db02|40283)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 167, broker2_cub_cas_30, DBA@db02|40295)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 168, broker2_cub_cas_31, DBA@db02|40296)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 169, broker2_cub_cas_32, DBA@db02|40297)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 170, broker2_cub_cas_34, DBA@db02|40315)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 171, broker2_cub_cas_36, DBA@db02|40317)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 172, broker2_cub_cas_37, DBA@db02|40318)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 173, broker2_cub_cas_38, DBA@db02|40319)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 174, broker2_cub_cas_39, DBA@db02|40320)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 175, broker2_cub_cas_40, DBA@db02|40321)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 176, broker2_cub_cas_41, DBA@db02|40322)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 182, broker2_cub_cas_47, DBA@db02|40330)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 183, broker2_cub_cas_48, DBA@db02|40332)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 184, broker2_cub_cas_49, DBA@db02|40333)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 186, broker2_cub_cas_51, DBA@db02|40335)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 187, broker2_cub_cas_52, DBA@db02|40336)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 188, broker2_cub_cas_53, DBA@db02|40337)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 189, broker2_cub_cas_54, DBA@db02|40338)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 190, broker2_cub_cas_55, DBA@db02|40340)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Object Lock Table:
            Current number of objects which are locked    = 2
            Maximum number of objects which can be locked = 10000


    위가 확인 내용입니다.

    이걸로 무엇을 확인할 수 있는지요..

    cubrid.conf는 설치할때 초기값이라고 보면 되요

    db이름이나 브로커 정보만 수정하고 다른건 ... 당시에는 손댈줄도 몰랐으니..ㅡㅡ..
  • ?
    정훈 2017.08.03 03:23

    현재는 lock 존재하지 않는 것으로 보입니다. lock 발생 시에 확인해주세요. 
    (참고 : http://www.cubrid.com/zbxe/3540951)

  • ?
    봉보로봉봉 2017.08.03 07:31

    그러면 LOCK 걸릴때까지 실시간으로 체크해야되는건가요?


    영업시간 9시부터 18시까지 20건 정보 발생하는 것을 체크해서 LOCK걸리는 3~4초의 시간을 캐치하라는 말씀인가요?


    이게 가능한지 모르겠네요..ㅡㅡ.. 해결불가라는 얘기인가요?


    그리고 링크는 홈으로 가는데..ㅡㅡ..

  • ?
    정훈 2017.08.03 19:57

    큐브리드 cd $CUBRID/log/server 에 ~.event 라는 파일로 어떤 LOCK이 발생했는지 확인할 수 있습니다. 

    어떤 종류의 lock 인지, 해당 트랜잭션은 무엇인지를 확인해야 명확하게 해결할 수 있습니다.

    다음 메뉴얼을 참조해 주세요.

    (시스템 설정 - http://www.cubrid.org/manual/ko/9.3.0/admin/config.html#lock-parameters )

    (트랜잭션과 잠금 - http://www.cubrid.org/manual/ko/9.3.0/sql/transaction.html#id1 )

  • ?
    봉보로봉봉 2017.08.04 01:55
    파라미터 이름타입기본값최소값최대값
    deadlock_detection_interval_in_secsfloat1.00.1 
    isolation_levelint316
    lock_escalationint100,0005 
    lock_timeoutmsec-1(무제한)0(대기안함)INT_MAX
    rollback_on_lock_escalationboolno 

     

    위 내용 값은 전부 기본값인것을 확인하였습니다.




    해당 파일에 Log 입니다.



    08/03/17 00:30:51.228 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(42674)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 00:30:51.433 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   IX_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 00:30:51.546 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 02:17:56.079 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 02:17:56.194 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:43.381 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:44.282 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:49.205 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 08:21:28.335 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   NS_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    08/03/17 09:20:47.995 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NX_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    08/03/17 09:45:58.849 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_7(33135)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 09:46:09.889 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 09:46:12.163 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 09:46:53.845 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 10:06:14.417 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_9(4130)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '32000007461775'

      bind: 'D32765-32000011245222'

      bind: '3'

      bind: '1501722370'


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 10:45:19.712 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(27945)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:01:46.340 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_6(34580)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2470279

      bind: '5021096776270290'

      bind: '3'

      bind: '1501725701'


    blocker:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:30:12.196 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_7(33135)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 11:30:12.797 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_6(34580)

      lock:   NS_LOCK (oid=-9992|310|-16127, table=ha_use, index=i_ha_use_us_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-9992|310|-16127, table=ha_use, index=i_ha_use_us_cond)

      sql: ***EMPTY***


    08/03/17 11:35:14.872 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2470614

      bind: '5022140776270555'

      bind: '3'

      bind: '1501727714'


    blocker:

      client: DBA@db02|broker1_cub_cas_1(34214)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:42:46.253 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(52593)

      lock:   NX_LOCK (oid=-17062|19561|-32199, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8770350.00000000

      bind: 8770351.00000000

      bind: 8770352.00000000

      bind: 8770353.00000000

      bind: 2471406


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-17062|19561|-32199, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 12:21:10.552 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-17062|19575|-32250, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:1  where [ha_use].[us_no]= ?:0 

      bind: 8771902

      bind: 2471782


    blocker:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   NS_LOCK (oid=-17062|19575|-32250, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 12:33:22.490 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(34214)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 13:24:54.521 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 13:35:04.239 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NX_LOCK (oid=-17062|19599|-32187, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:3  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ))

      bind: 8774719.00000000

      bind: 8774720.00000000

      bind: 8774721.00000000

      bind: 2472483


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NS_LOCK (oid=-17062|19599|-32187, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 13:45:16.118 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 13:45:16.419 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NX_LOCK (oid=-17062|19613|-32235, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8775125.00000000

      bind: 8775126.00000000

      bind: 8775127.00000000

      bind: 8775128.00000000

      bind: 2472571


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NS_LOCK (oid=-17062|19613|-32235, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 13:57:07.130 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-17062|19617|-32156, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:2  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ))

      bind: 8775663.00000000

      bind: 8775664.00000000

      bind: 2472696


    blocker:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-17062|19617|-32156, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 14:26:21.755 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 14:45:01.186 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 14:45:02.593 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 15:00:25.739 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2472684

      bind: '5022140776272761'

      bind: '3'

      bind: '1501740025'


    blocker:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 15:00:27.160 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NX_LOCK (oid=-17062|19652|-32232, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8778449.00000000

      bind: 8778450.00000000

      bind: 8778451.00000000

      bind: 8778452.00000000

      bind: 2473254


    blocker:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NS_LOCK (oid=-17062|19652|-32232, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 15:20:41.166 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:    U_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:    U_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


      client: DBA@db02|broker1_cub_cas_10(59578)

      lock: NULL_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: '008451-22000008944307'

      bind: '3'

      bind: '1501741241'


      client: DBA@db02|broker1_cub_cas_6(50548)

      lock: NULL_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: '008451-22000008944307'

      bind: '3'

      bind: '1501741241'


    08/03/17 15:20:41.575 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_11(27980)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '5000006241440'

      bind: '5A4D1F-5000008929089'

      bind: '3'

      bind: '1501741241'


    08/03/17 15:21:47.089 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_13(65041)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2446200

      bind: '5021096776988184'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_9(4130)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


      client: DBA@db02|broker1_cub_cas_1(51100)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.191 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_9(4130)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_1(51100)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.192 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.300 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_12(33353)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.300 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:    U_LOCK (oid=31|27851|51, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:    U_LOCK (oid=31|27851|51, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:43:57.597 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(55097)

      lock:   NX_LOCK (oid=-17062|19664|-32174, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:3  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ))

      bind: 8779883.00000000

      bind: 8779884.00000000

      bind: 8779885.00000000

      bind: 2473550


    blocker:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-17062|19664|-32174, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 16:01:05.884 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2379459

      bind: '5022094776970344'

      bind: '3'

      bind: '1501743664'


    blocker:

      client: DBA@db02|broker1_cub_cas_7(51278)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_3(55097)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2085373

      bind: '5022094776349447'

      bind: '3'

      bind: '1501743665'


    08/03/17 16:01:06.184 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(55097)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2085373

      bind: '5022094776349447'

      bind: '3'

      bind: '1501743665'


    blocker:

      client: DBA@db02|broker1_cub_cas_7(51278)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 16:13:32.876 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NS_LOCK (oid=-22172|310|16641, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-22172|310|16641, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 16:35:18.202 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2468007

      bind: '5021096776277555'

      bind: '3'

      bind: '1501745716'


    blocker:

      client: DBA@db02|broker1_cub_cas_4(58260)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 16:35:19.839 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_4(58260)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***



List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4256
3876 GRANT SELECT 후 SELECT 쿼리 실행 오류 문의 1 바보똥개 2023.07.25 86
3875 auto commit 이 되어있어서 잘못 update 처리한 데이터가 commit 되었을 때 대처법 부탁드립니다 1 rollback 2023.07.21 85
3874 운영db 접근이 되지 않아 문의 드립니다 1 file 찬이 2023.07.20 97
3873 홈경로 databases.txt 질문드립니다 1 큐브리드드 2023.07.17 83
3872 Cubrid admin 접속 제한 문의드립니다. 2 데굴v 2023.07.13 110
3871 특정단어 삭제 6 ddmmdd 2023.07.13 158
3870 error while loading shared libraries: libncurses.so.5 에러 문의 드립니다. 3 kikiki767 2023.07.10 1333
3869 다운로드페이지에 CUBRIDManager 11.x windows-x64.exe 는 없는데 .. 다운로드 할 수 있을까요? 2 최라이거 2023.07.05 92
3868 db_class에서 테이블 목록 조회시 2 cncn 2023.07.03 262
3867 조회쿼리 시간단축 1 leeee 2023.06.30 92
3866 CUBRID 8.4.4 -> 11.0.3 로 업그레이드 시 발생할 문제가 있을까요? 1 SDDC사업개발자 2023.06.29 88
3865 CUBRID to Tibero DBLink지원 가능한지 알고싶습니다. 1 공공기관에서사용중1 2023.06.28 126
3864 ELO타입이 무엇인가요? 1 sobubble 2023.06.27 109
3863 백업파일 받았는데 복구하는 방법을 모르겠습니다. 4 Ggyak 2023.06.20 154
3862 UTF8 한글이 깨짐 4 file yonggi 2023.06.19 250
3861 저장 프로스저에 있는 함수 상세보기 문의입니다. 1 대출인생30년 2023.06.12 78
3860 MERGE INTO 속도 개선 문의 1 leeee 2023.06.12 120
3859 NX_transcation 1 yoo 2023.06.12 77
3858 cubrid cursor.close() 에러 관련질문 3 힘내자화이팅 2023.06.08 175
3857 merge 쿼리 속도개선 2 leeee 2023.06.08 105
Board Pagination Prev 1 2 3 4 5 6 7 8 9 10 ... 199 Next
/ 199

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales