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 4255
2636 select 쿼리 case변경 문의 3 yodongky 2017.08.18 527
2635 아직도 잘 정리가 안되어 질문 올립니다. ㅠ 오라클 -> 큐브리드 전환시 타입 결정... 1 덴드로비움 2017.08.17 965
2634 PK 생성 질문드립니다. 유니크 인덱스 자동생성이 안되네요? 2 덴드로비움 2017.08.17 2424
2633 erwin 으로 데이터베이스 가져와서 erd 그리고 싶은데요. 4 팅팅탱탱 2017.08.17 1736
2632 테이블 한글명, 컬럼 한글명을 입력해주는 신텍스는 없나요?? 2 덴드로비움 2017.08.16 1056
2631 CMT로 전환시 컬럼 타입 변경 문의드립니다. 1 덴드로비움 2017.08.15 381
2630 실행 오류 : -495 Execute: System error 문의드립니다. 1 yodongky 2017.08.11 558
2629 반올림 문의 1 무지초이 2017.08.11 388
2628 HA 구성 질문 1 루치냥 2017.08.11 743
2627 select 쿼리 조회시 함수와 LEFT OUTER JOIN사용 문의 1 yodongky 2017.08.10 661
2626 admin입력을 해도 오류가 떠요ㅠㅠ 1 file 노도아 2017.08.10 269
2625 DBMS 에러코드 확인하려면 어디서 확인가능한가요? 1 봉보로봉봉 2017.08.09 973
2624 Error: DBMS, -72, Your transaction (index 46, DBA@db01|62150) has been unilaterally aborted by the system 5 봉보로봉봉 2017.08.08 509
2623 큐브리드 설정 관련 질문드립니다. secret 안산혀눙이 2017.08.08 10
2622 select쿼리 실행오류 문의드립니다. 2 yodongky 2017.08.03 424
» 트랜잭션 관련하여 질문드립니다. 6 봉보로봉봉 2017.08.02 413
2620 큐브리드 함수가 받는 파라미터에 관련하여 문의드립니다. 2 yodongky 2017.08.02 670
2619 system parameter 확인 시 에러메세지 1 봉보로봉봉 2017.08.02 243
2618 큐브리드 카탈로그 조회 너무 어렵습니다. 도웁좀 주세요 ㅠ 3 덴드로비움 2017.08.01 856
2617 DB의 콜레이션(문자진합)을 조회하는 쿼리(신텍스)가 있나요? 2 덴드로비움 2017.07.31 796
Board Pagination Prev 1 ... 63 64 65 66 67 68 69 70 71 72 ... 199 Next
/ 199

Contact Cubrid

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