upgrade from 7.46 to 7.5.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tayling
    Member
    • Apr 2023
    • 45

    upgrade from 7.46 to 7.5.5

    Hi - I have successfully upgraded a few times in the last 6 months using the gui. Today I am tryin to upgrade fomr 7.4.6 and it is failing.with error 500.
    My log file as follows - if anyone can see an obvoius issue I would be grateful.
    Thanks
    Regards
    Tony

    [2023-07-17 03:51:25] ERROR: (1040) SQLSTATE[HY000] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:51:25] ERROR: (1040) SQLSTATE[HY000] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:51:35] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:51:40] ERROR: (1040) SQLSTATE[HY000] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:51:45] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:56:23] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; POST /Admin/action/runUpgrade; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:57:03] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 03:59:24] ERROR: Database rebuild failure, details: Could not create PDOFactory..
    [2023-07-17 03:59:43] ERROR: (500) Error occurred while EspoCRM rebuild. Please see the log for more detail.; POST /Admin/action/runUpgrade; line: 285, file: /home/collectionconsul/public_html/espo/application/Espo/Core/Upgrades/Actions/Base.php​
  • tayling
    Member
    • Apr 2023
    • 45

    #2
    UPDATE
    on going into phpmyadmin on the server I also got too many connections error - on refresh it continued to load. My webhost pushed a graceful restart. On retrying the udate - I got the same issue, with the same log entries
    [2023-07-17 04:16:05] ERROR: (1040) SQLSTATE[HY000] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:16:05] ERROR: (1040) SQLSTATE[HY000] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:17:05] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:17:05] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:30:01] ERROR: Uncaught Exception PDOException: "SQLSTATE[08004] [1040] Too many connections" at /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php line 73 {"exception":"[object] (PDOException(code: 1040): SQLSTATE[08004] [1040] Too many connections at /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php:73)"}
    [2023-07-17 04:31:05] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:31:05] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:32:06] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:41:05] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /Notification/action/notReadCount; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php
    [2023-07-17 04:46:52] ERROR: (1040) SQLSTATE[08004] [1040] Too many connections; GET /PopupNotification/action/grouped; line: 73, file: /home/collectionconsul/public_html/espo/application/Espo/ORM/PDO/MysqlPDOFactory.php​

    Thanks Tony

    Comment

    • lazovic
      Super Moderator
      • Jan 2022
      • 809

      #3
      Hi tayling,

      These post and comments may be useful for you: https://stackoverflow.com/questions/...any-connection.

      Comment

      • esforim
        Active Community Member
        • Jan 2020
        • 2204

        #4
        You getting that because your server can't handle the "process of upgrading", I know cause I use Shared Server and we are limited and I get this error often.

        You need to use the CLI upgrade method to reduce this problem. GUI won't work and I pretty much stop using GUI upgrade nowadays.

        Comment

        • abidoss
          Senior Member
          • Mar 2023
          • 228

          #5
          What is the version of PHP? ?

          Comment

          • tayling
            Member
            • Apr 2023
            • 45

            #6
            Thanks eveybody - it was because on moving the PHP version was wrong - set to 8 all worked fine
            Cheers
            Tony

            Comment

            Working...