[pgpool-general-jp: 188] Re: 大量のINSERTを行うとデッドロックする

[Yoshiyuki Asaba]

浅羽です。

From: Yoshiyuki Asaba <y-asaba ＠ sraoss.co.jp>
Subject: [pgpool-general-jp: 187] Re: 大量のINSERTを行うとデッドロックする
Date: Thu, 05 Jul 2007 11:19:41 +0900 (JST)


> 添付のパッチを適用していただければ、常に SELECT をレプリケーションさせ
> ます。

パッチが正しくありませんでした…。

--
Yoshiyuki Asaba
y-asaba ＠ sraoss.co.jp
-------------- next part --------------
Index: pool_process_query.c
===================================================================
RCS file: /cvsroot/pgpool/pgpool/pool_process_query.c,v
retrieving revision 1.49
diff -c -r1.49 pool_process_query.c
*** pool_process_query.c	2 Jun 2007 00:51:54 -0000	1.49
--- pool_process_query.c	5 Jul 2007 02:24:23 -0000
***************
*** 679,684 ****
--- 679,685 ----
  		MASTER_SLAVE = 0;
  		master_slave_dml = 1;
  	}
+ #if 0
  	else if (REPLICATION && is_select_query(string1) && !is_sequence_query(string1))
  	{
  		int i;
***************
*** 694,699 ****
--- 695,701 ----
  		in_load_balance = 1;
  		select_in_transaction = 1;
  	}
+ #endif
  
  	/*
  	 * judge if we need to lock the table
***************
*** 813,818 ****
--- 815,821 ----
  		MASTER_SLAVE = 0;
  		master_slave_dml = 1;
  	}
+ #if 0
  	else if (REPLICATION && is_select_query(stmt->prepared_string) && !is_sequence_query(stmt->prepared_string))
  	{
  		int i;
***************
*** 829,834 ****
--- 832,838 ----
  		in_load_balance = 1;
  		select_in_transaction = 1;
  	}
+ #endif
  
  	for (i = 0;i < backend->num;i++)
  	{
***************
*** 2974,2980 ****
  	}
  
  	return (!strncasecmp(sql, "SELECT", 6));
- 
  }
  
  /*
--- 2978,2983 ----