on 2017 Nov 22 3:55 AM
Hello,
We have a few agents running 24/7. Several customers are having the same setup, but slightly different machines / OS or even SQL Anywhere (not prior to version 12).
At this site every night the agents loose the connection to the DataBase. But i cannot figure out whether this is a caused by the DataBase the Application. It seems to me the application looses the connection, but i am not sure.
Can you point me in the right direction. Googling gives me too much info:-)
Regards,
Marc
from database console --------------------- I. 11/22 00:26:04. Cache size adjusted to 4251432K I. 11/22 00:26:55. Connection ID 24034: connection "usr" terminated abnormally; client socket shut down I. 11/22 00:26:55. Connection ID 24034: Disconnected TCPIP client's AppInfo is IP=192.168.96.38;HOST=BG-NLEDI;OSUSER=perry.myname;OS='Windows 2012R2 Build 9200 ';EXE=C:\\apps\\B2BServerCDW\\b2bHandleCDW.exe;PID=0x404;THREAD=0xa40;VERSION=17.0.0.1062;API=ODBC;TIMEZONEADJUSTMENT=60 I. 11/22 00:26:55. Connection ID 24034: "usr" disconnected from database "MYDB" I. 11/22 00:26:55. Connection ID 24034: Client disconnected I. 11/22 00:27:04. Cache size adjusted to 4251324K I. 11/22 00:27:30. Connection ID 25979: connection "reportserver" terminated abnormally; client socket shut down I. 11/22 00:27:30. Connection ID 25979: Disconnected TCPIP client's AppInfo is IP=192.168.96.25;HOST=BG-NLRP1;OSUSER=BGAS2SA;OS='Windows 2012R2 Build 9200 ';EXE=C:\\apps\\CDWReportServer\\CDWReportServer.exe;PID=0x6c4;THREAD=0xf3c;VERSION=17.0.0.1062;API=ODBC;TIMEZONEADJUSTMENT=60 I. 11/22 00:27:30. Connection ID 25979: "reportserver" disconnected from database "MYDB" I. 11/22 00:27:30. Connection ID 25979: Client disconnected I. 11/22 00:28:04. Cache size adjusted to 4251208K I. 11/22 00:29:04. Cache size adjusted to 4251176K I. 11/22 00:30:00. Starting checkpoint of "MYDB" (MYDB.db) at Wed Nov 22 2017 00:30 ================================================================== SQL Anywhere Network Server Version 17.0.0.1062 Workgroup Edition Copyright © 2015 SAP SE or an SAP affiliate company. All rights reserved. Use of this software is governed by the SAP Software Use Rights Agreement. Refer to http://global.sap.com/corporate-en/our-company/agreements/index.epx. Processors detected: 4 logical processor(s) on 4 core(s) on 4 physical processor(s) Processor license restriction (Workgroup Edition): all logical processors on all cores on up to 2 physical processors Processor license restriction (licensed processors): all logical processors on all cores on up to 2 physical processors This server is licensed to use: all logical processors on all cores on up to 2 physical processors Processors in use by server: 2 logical processor(s) on 2 core(s) on 2 physical processor(s) This server is licensed to: Administrator MyCompany Running Windows 2012R2 Build 9600 on X86_64 Server built for X86_64 processor architecture 4231168K of memory used for caching Minimum cache size: 4231168K, maximum cache size: 15095340K Using a maximum page size of 4096 bytes Starting database "MYDB" (E:\\MYDB\\MYDB.db) at Thu Nov 02 2017 22:36 Transaction log: F:\\MYDB\\MYDB.log Database "MYDB" (MYDB.db) started at Thu Nov 02 2017 22:36 Database server started at Thu Nov 02 2017 22:36 HTTP listener starting on port 9091 Now accepting requests ====== startup parameters: ------------------ -x tcpip(PORT=4002) -xs http(port=9091) -ti 0 -c 4G
Request clarification before answering.
User | Count |
---|---|
87 | |
9 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.