Announcement

Collapse
No announcement yet.

Error Encountered: Upgrade Process Stuck

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    - How long does the process shown in your screenshot take? Does it terminate with some kind of error or are you just stopping the process yourself? Since the size of your database is extremely large, depending on the capacity of your server, the Rebuild process may take a very long time.
    - Are there any errors in the EspoCRM logs other than the one you started the thread with?
    - When the terminal window stuck, open another terminal window > login to the database > run:
    Code:
    show processlist;
    - Send a screenshot to the forum, like:​

    Click image for larger version  Name:	image.png Views:	0 Size:	127.5 KB ID:	105384
    Last edited by victor; 04-25-2024, 10:10 AM.

    Comment


    • #17
      victor
      Click image for larger version

Name:	image.png
Views:	90
Size:	56.4 KB
ID:	105411
      Please check this

      Comment


      • #18
        Click image for larger version

Name:	image.png
Views:	93
Size:	45.4 KB
ID:	105414​Please check this

        Comment


        • #19
          Click image for larger version

Name:	image.png
Views:	93
Size:	25.9 KB
ID:	105416​create index IDX is taking a lot of time

          Comment


          • #20
            [2024-04-26 04:18:57] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TYPE'
            [2024-04-26 04:18:57] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TYPE'
            [2024-04-26 04:22:34] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TARGET_TYPE'
            [2024-04-26 04:22:34] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TARGET_TYPE'
            [2024-04-26 04:26:40] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_PARENT_ID'
            [2024-04-26 04:26:40] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_PARENT_ID'
            [2024-04-26 04:26:40] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 136, file: /home/abc.com/public_html/application/Espo/Core/DataManager.php
            [2024-04-26 04:26:40] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 136, file: /home/abc.com/public_html/application/Espo/Core/DataManager.php


            Log

            Comment


            • #21
              - Try to uninstall and remove unofficial extensions and make Hard Rebuild: https://docs.espocrm.com/administrat.../#hard-rebuild.
              - If Hard Rebuild is successfull, then try to upgrade your instance (without installing any extension before the upgrade).
              Last edited by victor; 04-26-2024, 10:26 AM.

              Comment

              Working...
              X