G
Gareth Vincent
Guest
I would just like to know if anyone has a details answer as to what these errors means in the DB log file. 19:15:08 BROKER 0: Server 4 has 1 unresolved pending connections(s). Please check port 5703. (12454) 19:15:08 BROKER 0: Clearing pending connections from server 4. (12455) We are currently experiencing an issue with batch jobs that run in the evening, they are failing with a "lock wait time out of 1800". We have multiple Customers running on our Data Centre running on version 9.1e that share one common DB that reports on dayend times. These batch jobs connect via client/server connection on our LAN At this point i'm not sure if it is a DB recourse, coding or network issue. I'm leaning towards some type of load issue as there are multiple cronjobs that kick in the evening to start these batch processes. They start from 19h00 and end at around 22h00. The first few batch runs go though then later in the evening we start getting the "lock wait time out error". Each batch job can run for aprox 10min to 2hours so there is definitely an overlap were multiple customers are connecting to the common DB at the same time.
Continue reading...
Continue reading...