Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Upgrade from 3.4 to 3.7.3 hangs with mysql connect


  • I have upgraded all modules from 3.4 to 3.7.4.
    Loading system hangs at "Initializing pooled connection manager"

    INFO  2019-12-10T11:01:47,493 (com.serotonin.m2m2.Main.loadModules:650) - Loading module 'internal', v3.7.0 by Infinite Automation Systems Inc. 
    INFO  2019-12-10T11:01:50,104 (com.serotonin.m2m2.Lifecycle.loadLic:583) - Checking license... 
    INFO  2019-12-10T11:01:50,252 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
    

    mySQL only gets one hit from mango:

    2019-12-10T03:01:50.888382Z         8 Connect   root@localhost on mango using SSL/TLS
    

    When I comment-out all mysql enteries in overrides/properties env.properties and remove the h2 comments, systems loads OK (with obliviously very old settings before we moved to mysql.)

    Ubuntu 19:10
    mysql 8:0.18


  • @Balistar that isn't enough information to go on. Can you review your logs from the upgrade and see if anything went wrong? Each time Mango starts it should create a new log file so I would start by reviewing the log from the time you started and did the upgrade. Also check the com.serotonin.m2m2.db.upgrade.UpgradeXX.logs to see if any SQL commands failed that were not logged in the normal log file.

    Thanks.