Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Peter Parker on July 17, 2017, 08:36:38 AM
-
Hi guys,
I have been setting Configuration Server Backup 8.5 for my lab, then to test HA, I stop Config Server Primary, but after I stop it, I can't login to GA by IP address of Config Server Backup, from my opinions while viewing log, I see that it is failed to switch over from Config Server Backup to Config Server Primary.
Is there anyone who can help me give me a few ideas to fix this?
Thank everyone very much!
[code]15:13:13.492 cfg_refresh DB server connection established
15:13:13.492 SERVER STATE: Generated refresh value is 61219184
15:13:13.492 Std 04503 Connected to Database 'configdb' at host 'hcmcomdb', port -1
15:13:13.492 Trc 24400 Trying to open database [configdb] ,SQL server [hcmcomdb]
15:13:13.492 Std 07001 Database 'configdb' opened
15:13:13.492 Main DBServer connection restored, waiting for notify validation to complete
15:13:13.492 notifying core on context loading completion
Collision check is initiated ...
SERVER STATE: fire on_loadcompleted on objectset level, dbserver source context is fully loaded
15:13:13.492 SERVER STATE: server controller apply loaded:read-only state on unconfirmed dataset
SERVER STATE: cease future attempts to connect to peer
REventChangeAppRunMode from LCA...
15:13:26.171 Std 22502 LCA signal [switch to the primary mode] is received
Disable all transactions, because switchover backup->primary has happened.
ERROR: switchover/upgrade alredy in progress and db_context level
run Mode changed ...
REventChangeAppRunMode from LCA...
15:13:27.450 Std 22502 LCA signal [switch to the primary mode] is received
Disable all transactions, because switchover backup->primary has happened.
ERROR: switchover/upgrade alredy in progress and db_context level
run Mode changed ...
ODBC: id='25.1' req='228' odbcerr: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
ODBC: id='25.1' req='229' odbcerr: [Microsoft][ODBC SQL Server Driver]Communication link failure
15:13:49.444 Trc 04524 Client 'DbServerThread_app' disconnected
15:13:49.476 Std 05023 Process './dbclient_msql' stopped
/./dbclient_msql
pid = 3416
id = 24
expiration_time = 2017-07-17T15:14:19
client copy = 0
DbClient name = MS SQL: 25.1
15:13:49.507 dbserver_manager with alias dbcontroller_alias is about to unregister form socket 25, reference counter 3 (reason - exception)
15:13:49.507 cfg_refresh DB server connection exception
15:13:49.507 SERVER STATE: Initiating closure of main DB connection because of exception on cfg_refresh
15:13:49.507 dbserver_manager with alias main-dbserver is about to unregister form socket 26, reference counter 3 (reason - exception)
15:13:49.507 Std 04504 Connection to Database 'configdb' at host 'hcmcomdb', port -1 lost
15:13:49.522 Trc 04524 Client 'DbServerThread_app' disconnected
15:13:49.591 Std 05023 Process './dbclient_msql' stopped
/./dbclient_msql
pid = 1892
id = 25
expiration_time = 2017-07-17T15:14:19
client copy = 0
DbClient name = MS SQL: 26.1
15:13:59.512 dbserver_manager with alias dbcontroller_alias has being registered for the socket 27, reference counter 3
15:13:59.512 cfg_refresh DB server connection connecting
15:13:59.512 dbserver_manager with alias main-dbserver has being registered for the socket 28, reference counter 3
15:13:59.512 Trc 04500 Connecting to Database 'configdb' at host 'hcmcomdb', port -1
15:13:59.528 Std 05022 Process './dbclient_msql' started
15:13:59.528 Std 05022 Process './dbclient_msql' started
'./dbclient_msql' registered; protocol version '1.4' id '27.1'
'./dbclient_msql' registered; protocol version '1.4' id '28.1'
ODBC: id='27.1' req='-1'
DBClient ODBC, Copyright (c) 1997-2016 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 8.5.100.25
DB Common part version: 8.5.100.25
Vendor supported versions: "ODBC"
Process ID: 1628
Build on 'i686-winnt-vs8-64'
+0015 Connection to multiserver created, host 'localhost', port '59478', socket '328'
ODBC: id='27.1' req='1' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004'
+0000 Database Access Point in TKVList:
+0000 section "default":
+0000 "dbengine" = "mssql"
+0000 "dbserver" = "hcmcomdb"
+0000 "dbname" = "configdb"
+0000 "username" = "sa"
+0000 "password" = "***"
+0000 section "dbclient":
+0000 "max-binding-memory" = 250
+0000 "utf8-ucs2" = "false"
+0000 000000000116B9E0,hDBC=4222624,4222624
+0000 Could not connect to SQL Server using SQL Native Client driver. Attemting default MS SQL Server driver...
+0000 Connected to MSSQL with SQL Server driver.
ODBC: id='28.1' req='-1'
DBClient ODBC, Copyright (c) 1997-2016 Genesys Telecommunications Labs, Inc.
All Rights Reserved
Db Client version: 8.5.100.25
DB Common part version: 8.5.100.25
Vendor supported versions: "ODBC"
Process ID: 3716
Build on 'i686-winnt-vs8-64'
+0015 Connection to multiserver created, host 'localhost', port '59479', socket '320'
ODBC: id='28.1' req='1' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004'
+0000 Database Access Point in TKVList:
+0000 section "default":
+0000 "dbengine" = "mssql"
+0000 "dbserver" = "hcmcomdb"
+0000 "dbname" = "configdb"
+0000 "username" = "sa"
+0000 "password" = "***"
+0000 section "dbclient":
+0000 "max-binding-memory" = 250
+0000 "utf8-ucs2" = "false"
+0000 000000000111B9E0,hDBC=5205664,5205664
+0000 Could not connect to SQL Server using SQL Native Client driver. Attemting default MS SQL Server driver...
+0000 Connected to MSSQL with SQL Server driver.
15:13:59.668 cfg_refresh DB server connection established
15:13:59.668 SERVER STATE: Generated refresh value is 61551216
15:13:59.668 Std 04503 Connected to Database 'configdb' at host 'hcmcomdb', port -1
15:13:59.668 Trc 24400 Trying to open database [configdb] ,SQL server [hcmcomdb]
15:13:59.668 Std 07001 Database 'configdb' opened
15:13:59.668 Main DBServer connection restored, waiting for notify validation to complete
15:13:59.668 notifying core on context loading completion
Collision check is initiated ...
SERVER STATE: fire on_loadcompleted on objectset level, dbserver source context is fully loaded
15:13:59.668 SERVER STATE: server controller apply loaded:read-only state on unconfirmed dataset
SERVER STATE: cease future attempts to connect to peer
REventChangeAppRunMode from LCA...
15:14:03.886 Std 22502 LCA signal [switch to the primary mode] is received
Disable all transactions, because switchover backup->primary has happened.
ERROR: switchover/upgrade alredy in progress and db_context level
run Mode changed ...
REventChangeAppRunMode from LCA...
15:14:14.982 Std 22502 LCA signal [switch to the primary mode] is received
Disable all transactions, because switchover backup->primary has happened.
ERROR: switchover/upgrade alredy in progress and db_context level
run Mode changed ...
[/code]
-
What say primary and backup confserv logs arround the issue timestamp? What is your HA configuration for CFG layer? Is the embedded DBClient used or not?
-
Hi Kubig,
Can you please check my configuration of Config Server Primary & Backup as below?
Config Server Primary:
[code][confserv]
port =2020
management-port =2021
server = dbserver
encryption = false
encoding = utf-8
langid = 1033
[log]
verbose = standard
all = stderr
[dbserver]
dbengine =mssql
dbserver =hcmcomdb
dbname =configdb
username =sa
password =1pcc@cb
response-timeout = 600
[/code]
Config Server Backup:
[code][log]
verbose = standard
all = stderr
[dbserver]
dbengine =mssql
dbserver =hcmcomdb
dbname =configdb
username =sa
password =1pcc@cb
response-timeout = 600
[authentication]
library =gauth_ldap
[gauth_ldap]
ldap-url =ldap://172.24.104.6:389/dc=ansv,dc=vn??sub?givenName=X
[confserv_b]
port=2020
management-port=2021
server=dbserver
encryption=false
encoding=utf-8
langid=1033
[/code]
Is there any the problem do with my configuration of Primary & Backup?
-
I cannot see confserv configuration part within your confserv.cfg for backup instance - try to amend the config file and start it again. To ensure all is working just try to start the backup instance with primary role - you will see if it is working or not.