1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

#[TRANSAKSI 1 : Start]

--- 2008-05-12 20:20:41.046000 +07:00
 (5160)   [4;36;1mSQL (0.000000)[0m   [0;1mSET SQL_AUTO_IS_NULL=0[0m
--- 2008-05-12 20:20:41.046000 +07:00
 (5160)   [4;35;1mSQL (0.000000)[0m   [0mBEGIN[0m

--- 2008-05-12 20:20:41.140000 +07:00
 (5160)   [4;36;1mPenerbangan Columns (0.015000)[0m   [0;1mSHOW FIELDS FROM
 penerbangans[0m

--- 2008-05-12 20:20:41.156000 +07:00
 (5160)   [4;35;1mPenerbangan Load (0.016000)[0m   [0mSELECT * FROM penerbangans
 WHERE (penerbangans.`id` = 70) [0m

#[TRANSAKSI 1 : granted exclusive key]

--- 2008-05-12 20:20:41.203000 +07:00
 (5160)   [4;36;1mBarangTerpesan Load (0.000000)[0m   [0;1mSELECT * FROM
 barang_terpesans WHERE (barang_id = '70BO-243' AND hari_h ='2008-07-01' AND
 hari_out IS NULL) FOR UPDATE[0m

--- 2008-05-12 20:20:41.265000 +07:00
 (5160)   [4;35;1mPemesanan Columns (0.015000)[0m   [0mSHOW FIELDS FROM
 pemesanans[0m

--- 2008-05-12 20:20:41.281000 +07:00
 (5160)   [4;36;1mSQL (0.000000)[0m   [0;1mSELECT sum(jumlah_pesanan) AS 
sum_jumlah_pesanan FROM pemesanans WHERE (penerbangan_id =70 AND hari_out > 
'2008-07-01' AND hari_h <= NULL) [0m

#[TRANSAKSI 1 SLEEPS at 20:20:41.281000 ]

#[TRANSAKSI 2 : start]
--- 2008-05-12 20:20:42.171000 +07:00
 (5384)   [4;36;1mSQL (0.000000)[0m   [0;1mSET SQL_AUTO_IS_NULL=0[0m

--- 2008-05-12 20:20:42.171000 +07:00
 (5384)   [4;35;1mSQL (0.000000)[0m   [0mBEGIN[0m

--- 2008-05-12 20:20:42.234000 +07:00
 (5384)   [4;36;1mPenerbangan Columns (0.016000)[0m   [0;1mSHOW FIELDS FROM 
penerbangans[0m

--- 2008-05-12 20:20:42.234000 +07:00
 (5384)   [4;35;1mPenerbangan Load (0.000000)[0m   [0mSELECT * FROM penerbangans
 WHERE (penerbangans.`id` = 70) [0m


#[TRANSAKSI 2 : granted key]

--- 2008-05-12 20:20:42.265000 +07:00
 (5384)   [4;36;1mBarangTerpesan Load (0.000000)[0m   [0;1mSELECT * FROM 
barang_terpesans WHERE (barang_id = '70BO-243' AND hari_h ='2008-07-01' AND 
hari_out IS NULL) FOR UPDATE[0m

--- 2008-05-12 20:20:42.312000 +07:00
 (5384)   [4;35;1mPemesanan Columns (0.016000)[0m   [0mSHOW FIELDS FROM 
pemesanans[0m

--- 2008-05-12 20:20:42.328000 +07:00
 (5384)   [4;36;1mSQL (0.016000)[0m   [0;1mSELECT sum(jumlah_pesanan) AS
 sum_jumlah_pesanan FROM pemesanans WHERE (penerbangan_id =70 AND hari_out > 
'2008-07-01' AND hari_h <= NULL) [0m


#[TRANSAKSI 1 : weak up at  20:21:11.296000]


--- 2008-05-12 20:21:11.296000 +07:00
 (5160)   [4;35;1mBarangTerpesan Columns (0.015000)[0m   [0mSHOW FIELDS FROM 
barang_terpesans[0m

--- 2008-05-12 20:21:12.343000 +07:00
 (5384)   [4;35;1mBarangTerpesan Columns (0.015000)[0m   [0mSHOW FIELDS FROM 
barang_terpesans[0m

--- 2008-05-12 20:21:12.359000 +07:00
 (5160)   [4;36;1mSQL (1.047000)[0m   [0;1mINSERT INTO barang_terpesans 
(`updated_at`, `hari_out`, `session_id`, `jumlah`, `hari_h`, `barang_id`) 
VALUES('2008-05-12 20:21:11', NULL, 'w2hx12w3w', 3, '2008-07-01', '70BO-243')[0m

#[TRANSAKSI 2 DEAD LOCK]

--- 2008-05-12 20:21:12.359000 +07:00
 (5384)   [4;36;1mSQL (0.000000)[0m   [0;1mMysql::Error: Deadlock found when trying
 to get lock; try restarting transaction: INSERT INTO barang_terpesans 
(`updated_at`, `hari_out`, `session_id`, `jumlah`, `hari_h`, `barang_id`) 
VALUES('2008-05-12 20:21:12', NULL, 'j4pnc10mg', 3, '2008-07-01', '70BO-243')[0m

#[TRANSAKSI 1 : Released Key] 
#[TRANSAKSI 1:  Finish]

--- 2008-05-12 20:21:12.359000 +07:00
 (5160)   [4;35;1mSQL (0.000000)[0m   [0mCOMMIT[0m


#[TRANSAKSI 2 : Roll Back]

--- 2008-05-12 20:21:12.359000 +07:00
 (5384)   [4;35;1mSQL (0.000000)[0m   [0mROLLBACK[0m