## mark a section (Learn more)

#[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

This paste will be private.