Jump to content
PMXSD

Refreshing cache for table 'ca_contact'

Recommended Posts

Hello Everybody,

I have an issue with Service Desk in 12.7 and I asked if someone can help to understand what´s going on. In the middle of the day, our CA Service Desk start to go slow for everything (Login, Change a rol, Save a Change). Making a research in the logs I found thousand lines saying:


05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows C1C6F456A3892841A0B2C6B3829768FB
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows F151E7D14F80474ABE177F39B2CE45AB
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows DA5FC743F4F772489FA9960E8955ED5E
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows 85071B859CB6AC44ADA69CBBC565C4AB
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows 4473733CCAE3954B99F00068630FE24A
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows F8B8BD6F97DB9A4495DA38FBA6C7DC49
05/21 10:26:51.80 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows 6A7EE01F0D166E46A1E73A5927B60915
05/21 10:26:51.82 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows D812F7849AC07A43AD887AA58980138E
05/21 10:26:51.82 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows 982DBD8C703375459023D2652DFB7591
05/21 10:26:51.82 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows 9A2891C2E023B8419D25EACA4DCCBF23
05/21 10:26:51.84 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows E796A29FB543804390FFC07BBDCC9ED8
05/21 10:26:51.84 G500603SV0SS   bpvirtdb_srvr       31896 SIGNIFICANT  vdbsql.c              1433  refreshing cache for table 'ca_contact' rows EBE75EA2AC1B7B4F95EEEFBD1C931B1E

I found a document to stop this using the dbmonitor_nxd -c stop -t ca_contact but I don't why this action happens. At this point, the monitor for this table is stopped but I don´t either what it will happen with the application if it continues stopped. The document about dbmonitor_nxd says the following:

The main function of dbmonitor_nxd is to generate CHANGE notifications for changes in specified tables that did not occur through CA SDM. In order to perform this function, the monitor periodically queries the database, determines what was changed externally and then sends CHANGE notifications to the bpvirtdb_nxd server. The bpvirtdb_nxd server notifies all domsrvr servers of the change, which causes each domsrvr to update its cache of specific database objects and then notify all other processes that subscribe for changes in the specified tables.

Here, I don´t know where is the bpvirtdb_nxd server to see the changes that the document says.

This issue happened 2 times in a week and I don´t know why.

Please, someone has any idea about this problem?

Thank you very much!

Edited by PMXSD

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...