Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

We are currently experiencing issues with dbremote running on remote databases. Replication has been running for months without issue but now we are getting the database locking up and dbremote failing to run. Dbremote seems to lose connection while processing files: 

I. 2013-11-11 17:43:29. UPDATE shipclip.NIIN
                           SET FSC=NULL,
                               COG=NULL,
                               DESCR=NULL,
                               UNIT_PRICE=224.08,
                               BRF=NULL,
                               UOM=NULL,
                               AAC=NULL,
                               SLC=NULL,
                               SLAC=NULL,
                               NET_PRICE=NULL
                        VERIFY (FSC,COG,DESCR,UNIT_PRICE,BRF,UOM,AAC,SLC,SLAC,NET_PRICE)
                        VALUES ('4820','9B','SEAT,VALVE',222.21,.25,'EA','Z','0','00',0)
                         WHERE NIIN='012090384'


E. 2013-11-11 18:02:07. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. SQL statement failed: (-832) Connection error: Shared memory connection to server timed out
E. 2013-11-11 18:04:08. Error connecting to database
E. 2013-11-11 18:04:08. SQL statement failed: (-101) Not connected to a database
E. 2013-11-11 18:04:08. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. Communication error (-85)
E. 2013-11-11 18:04:08. SQL statement failed: (-85) Communication error
E. 2013-11-11 18:04:08. Communication error (-85)
E. 2013-11-11 18:04:08. SQL statement failed: (-101) Not connected to a database
I. 2013-11-11 18:04:08. Shutdown by request
I. 2013-11-11 18:04:08. Execution completed
I. 2013-11-11 19:02:43. SQL Remote Message Agent Version 12.0.1.3750

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
VolkerBarth
Contributor
‎2013 Nov 12 6:03 AM
0 Likes

You may try to add the LOG=filename connection parameter to DBREMOTE's connection string to get debug information on connection issues.

You also might use sa_conn_info() and sa_locks() in a DBISQL session to try to find out whether the operations from SQL Remote are blocked by concurrent OLAP transactions...

If this is a blocking issue, have you set individual values for the BLOCKING and BLOCKING_TIMEOUT options, or are they used with their default values (ON and 0, meaning infinite waiting on blocks to be released)?

regdomaratzki
Product and Topic Expert
Product and Topic Expert
‎2013 Nov 12 8:17 AM
0 Likes

Does the database engine log have any entries from around the same time to indicate what might have happened?

Former Member
‎2013 Nov 12 10:39 AM
0 Likes

Are you modifying the SUBSCRIBE BY values for an article when this happens?

View Entire Topic
Former Member
‎2013 Nov 12 11:29 AM
0 Likes

No the subscribe by value is not being modified.

No mini dump file.

Tue Nov 12 2013 11:31:03 11:31:03 Attempting to connect using: UID=rep_dbo;PWD=*;DBN=SHIPCLIP;ServerName=SMISDBS12;LOG=C:smis_appShipCLIPLogsSHIPCLIP_agent_error.log 11:31:03 Attempting to connect to a running server... 11:31:03 Trying to start SharedMemory link ... 11:31:03 SharedMemory link started successfully 11:31:03 Attempting SharedMemory connection (no sasrv.ini cached address) 11:31:03 Connected to server over SharedMemory 11:31:03 Connected to SQL Anywhere Server version 12.0.1.3817 11:31:03 Application information: 11:31:03 IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 11:31:03 Connected to the server, attempting to connect to a running database... 11:31:03 [ 1] Connected to database successfully 11:31:03 Attempting to connect using: UID=rep_dbo;PWD=*;DBN=SHIPCLIP;ServerName=SMISDBS12;CON=get_remote_option;LOG=C:smis_appShipCLIPLogsSHIPCLIP_agent_error.log 11:31:03 Attempting to connect to a running server... 11:31:03 Attempting SharedMemory connection (no sasrv.ini cached address) 11:31:03 Connected to server over SharedMemory 11:31:03 Connected to SQL Anywhere Server version 12.0.1.3817 11:31:03 Application information: 11:31:03 IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 11:31:03 Connected to the server, attempting to connect to a running database... 11:31:03 [ 2] Connected to database successfully 11:31:03 Attempting to connect using: UID=rep_dbo;PWD=*;DBN=SHIPCLIP;ServerName=SMISDBS12;CON=Worker0;LOG=C:smis_appShipCLIPLogsSHIPCLIP_agent_error.log 11:31:03 Attempting to connect to a running server... 11:31:03 Attempting SharedMemory connection (no sasrv.ini cached address) 11:31:03 Connected to server over SharedMemory 11:31:03 Connected to SQL Anywhere Server version 12.0.1.3817 11:31:03 Application information: 11:31:03 IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 11:31:03 Connected to the server, attempting to connect to a running database... 11:31:03 [ 3] Connected to database successfully 11:31:03 Attempting to connect using: UID=rep_dbo;PWD=*;DBN=SHIPCLIP;ServerName=SMISDBS12;CON=SYNCH;LOG=C:smis_appShipCLIPLogsSHIPCLIP_agent_error.log 11:31:03 Attempting to connect to a running server... 11:31:03 Attempting SharedMemory connection (no sasrv.ini cached address) 11:31:03 Connected to server over SharedMemory 11:31:03 Connected to SQL Anywhere Server version 12.0.1.3817 11:31:03 Application information: 11:31:03 IP=10.24.20.96;HOST=bth497286a;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:Program FilesSQL Anywhere 12Bin32dbremote.exe';PID=0x7100;THREAD=0xa14;VERSION=12.0.1.3817;API=DBLIB;TIMEZONEADJUSTMENT=-300 11:31:03 Connected to the server, attempting to connect to a running database... 11:31:03 [ 4] Connected to database successfully 11:31:04 [ 3] Disconnecting shared memory client, process id not found 11:31:04 [ 3] Communication function i_cs_HandleSQLPresError code 4 11:31:04 [ 3] Communication function StrmGetInd code 7 11:31:04 Attempting to connect using: UID=rep_dbo;PWD=**;DBN=SHIPCLIP;ServerName=SMISDBS12;CON=ERROR;LOG=C:smis_appShipCLIPLogsSHIPCLIP_agent_error.log 11:31:04 Attempting to connect to a running server... 11:31:04 Attempting SharedMemory connection (no sasrv.ini cached address) 11:31:04 Failed to connect over SharedMemory 11:31:04 Cannot connect to server 11:31:04 [ 2] Disconnecting shared memory client, process id not found 11:31:04 [ 2] Communication function i_cs_HandleSQLPresError code 4 11:31:04 [ 2] Communication function StrmGetInd code 7 11:31:04 [ 4] Disconnecting shared memory client, process id not found 11:31:04 [ 4] Communication function i_cs_HandleSQLPresError code 4 11:31:04 [ 4] Communication function StrmGetInd code 7 11:31:05 [ 1] Disconnecting shared memory client, process id not found 11:31:05 [ 1] Communication function i_cs_HandleSQLPresError code 4 11:31:05 [ 1] Communication function StrmGetInd code 7

Show replies
Show replies
regdomaratzki
Product and Topic Expert
Product and Topic Expert
‎2013 Nov 12 11:45 AM
0 Likes

That's the log generated on the client side as a result of adding "log=" into the connection string. It tells us the database engine isn't running anymore.

What about the database engine log? We need to figure out why the database engine shut down.

Ask a Question