Hopefully Apple will fix this soon but in the meantime we have a workaround for both Jaikoz and SongKong with only a minor side effect: However it only works if OSX preferred language is set to English otherwise the menubar does not work. On Sunday 25th September High Sierra was officially released and the problem appeared to be resolved.
Jaikoz or songkong update#
Update Nov 15th 2017, Apple have eventually fixed this with the OSX 13.1 release, and we have reverted the now unnecessary fix in SongKong 4.13, we will do the same thing with the next Jaikoz release.
I added testWhileIdle="true" to my context.xml and removed the autoreconnect=true hoping this will remove connections from pool before mysql just gives up on them.In August we reported that Apples beta version of their High Sierra operating system was broken for all Java applications because it did not display the menubar properly. Speaking to someone else since it is only connections from the Store web application that is failing and that only does anything when a purchase is made which is currently only a few times a day it sounds like the connection is being timed out by MySql itself without telling the jdbc pool, so when try to use the connection via the pool we get the error. Maybe shoud not be so many Jaikoz processes ?
| 145211 | paul | localhost | jaikoz | Query | 0 | NULL | show processlist | | Id | User | Host | db | Command | Time | State | Info | Ran Show Process List as suggested and got the following: mysql> show processlist The errors say I could use AutorReconnect=true, but I am already doing that. I wonder if having two database connections is breaking things or having two applications define the same connection is breaking things since I don't think i had such a problem when I only the jaikoz application. I had to introduce 'store' since payment provider required a single url to send all successful payments (be it from songkong or jaikoz)
Mysql contains two db instances and in my web.xml file I have Īnd in context.xml (I have changed username and password) I have Īlso this configuration is from my Store web application, I also a have a jaikoz and a songkong web application both of these define one of the connections. The server configured values for client timeouts, or using theĬonnector/J connection property 'autoReconnect=true' to avoid thisīut I dont think MySql is down since I have never ever had a problem connecting to it, the errors occur randomly about 5% of the time. Testing connection validity before use in your application, increasing You should consider either expiring and/or The last packet sent successfully to the server wasĤ4,533,707 milliseconds ago. The last packet successfully received from the server was 44,533,707
Jaikoz or songkong license#
When a user makes a purchase, its processed by Paypal and then they contact our server and we create the license and store it in the database, but unfortunately it doesn't always work giving errors such as: I have a Tomcat and Mysql installed on the same machine, its not been recently updated so we are using Tomcat 7.0.31 and MySql 5.0.95 on Linux.