1616// under the License.
1717
1818import com.mysql.cj.jdbc.StatementImpl
19+ import org.codehaus.groovy.runtime.IOGroovyMethods
1920
2021suite(" insert_group_commit_into" ) {
2122 def dbName = " regression_test_insert_p0"
@@ -65,6 +66,7 @@ suite("insert_group_commit_into") {
6566 // assertEquals(result, expected_row_count)
6667 assertTrue (serverInfo. contains(" 'status':'PREPARE'" ))
6768 assertTrue (serverInfo. contains(" 'label':'group_commit_" ))
69+ return serverInfo
6870 }
6971
7072 def none_group_commit_insert = { sql , expected_row_count ->
@@ -211,6 +213,55 @@ suite("insert_group_commit_into") {
211213 // try_sql("DROP TABLE ${table}")
212214 }
213215
216+ // test connect to observer fe
217+ try {
218+ def fes = sql_return_maparray " show frontends"
219+ logger. info(" frontends: ${ fes} " )
220+ if (fes. size() > 1 ) {
221+ def observer_fe = null
222+ for (def fe : fes) {
223+ if (fe.IsMaster == " false" ) {
224+ observer_fe = fe
225+ break
226+ }
227+ }
228+ if (observer_fe != null ) {
229+ def url = " jdbc:mysql://${ observer_fe.Host} :${ observer_fe.QueryPort} /"
230+ logger. info(" observer url: " + url)
231+ connect(user = context. config. jdbcUser, password = context. config. jdbcPassword, url = url) {
232+ sql """ set enable_insert_group_commit = true; """
233+ sql """ set enable_nereids_dml = false; """
234+ sql """ set enable_profile= true; """
235+
236+ // 1. insert into
237+ def server_info = group_commit_insert """ insert into ${ table} (name, id) values('c', 3); """ , 1
238+ assertTrue (server_info. contains(' query_id' ))
239+ // get query_id, such as 43f87963586a482a-b0496bcf9e2b5555
240+ def query_id_index = server_info. indexOf(" 'query_id':'" ) + " 'query_id':'" . length()
241+ def query_id = server_info. substring(query_id_index, query_id_index + 33 )
242+ logger. info(" query_id: " + query_id)
243+ // 2. check profile
244+ StringBuilder sb = new StringBuilder ();
245+ sb. append(" curl -X GET -u ${ context.config.jdbcUser} :${ context.config.jdbcPassword} http://${ observer_fe.Host} :${ observer_fe.HttpPort} " )
246+ sb. append(" /api/profile?query_id=" ). append(query_id)
247+ String command = sb. toString()
248+ logger. info(command)
249+ def process = command. execute()
250+ def code = process. waitFor()
251+ def err = IOGroovyMethods . getText(new BufferedReader (new InputStreamReader (process. getErrorStream())));
252+ def out = process. getText()
253+ logger. info(" Get profile: code=" + code + " , out=" + out + " , err=" + err)
254+ assertEquals (code, 0 )
255+ def json = parseJson(out)
256+ assertEquals (" success" , json. msg. toLowerCase())
257+ }
258+ }
259+ } else {
260+ logger. info(" only one fe, skip test connect to observer fe" )
261+ }
262+ } finally {
263+ }
264+
214265 // table with array type
215266 tableName = " insert_group_commit_into_duplicate_array"
216267 table = dbName + " ." + tableName
@@ -266,4 +317,4 @@ suite("insert_group_commit_into") {
266317 // try_sql("DROP TABLE ${table}")
267318 }
268319 }
269- }
320+ }
0 commit comments