Skip to content
  • Categories
  • Recent
  • Popular
Collapse
Brand Logo
  1. Home
  2. Categories
  3. Sujets Techniques
  4. error in compose of gofast community

error in compose of gofast community

Scheduled Pinned Locked Moved Sujets Techniques
16 Posts 5 Posters 759 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    imanez01
    wrote on last edited by
    #6

    Bonjour @jlemangarin

    Voici les logs de drupal (ça reste comme ça pendant des heures):

    image.png

    Voici les logs de mysql:

    image.png

    1 Reply Last reply
    0
    • J Offline
      J Offline
      jc1204
      wrote on last edited by
      #7

      Bonjour,
      voici quelques informations sur le déploiement de compose.yml :

      image.png

      fichier log de gofast-ng-mysql : (les deux adresses ip sont celles de gofast-ng-drupal et gofast-ng-alfresco) :
      tail -f /var/log/mysql/mysqld.log

      image.png

      Nous avons fait plusieurs tests pour vérifier la connectivité entre les differents containers. Le dernier a été de tester la connexion à mysql qui semble fonctionner depuis un autre container :

      image.png

      Je reste à votre disposition pour effectuer d'autres tests

      1 Reply Last reply
      0
      • jlemangarinJ Offline
        jlemangarinJ Offline
        jlemangarin
        ADMIN SUPPORT-PROD DEV
        wrote on last edited by jlemangarin
        #8

        Bonjour @imanez01 @jc1204

        Pourriez-vous essayer de passer les commandes suivantes pour ré initialiser le container MySQL ?

        podman-compose down gofast-ng-mysql
        podman container rm gofast-ng-mysql
        

        Trouver le volume MySQL :

        podman volume ls
        

        Puis le supprimer :

        podman volume rm xxx_compose_gofast-ng-mysql_data
        

        Et enfin le relancer :

        podman-compose up -d
        

        On voit que l'initialisation du container MySQL a échoué, je vais essayer de comprendre pourquoi mais c'est étrange car le service réponds bien.

        Merci d'avance !

        LEMAN-GARIN Jérôme - CEO-Vision IT
        jerome.leman@ceo-vision.com
        Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
        +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
        https://www.ceo-vision.com

        1 Reply Last reply
        0
        • J Offline
          J Offline
          jc1204
          wrote on last edited by
          #9

          Je viens de supprimer le volume en question et relancer podman-compose up -d. Il y a toujours le même message d'erreur :

          image.png

          par contre la connexion depuis drupal vers mysql fonctionne bien en ligne de commande :

          image.png

          1 Reply Last reply
          0
          • jlemangarinJ Offline
            jlemangarinJ Offline
            jlemangarin
            ADMIN SUPPORT-PROD DEV
            wrote on last edited by
            #10

            @jc1204 Je vous propose d'essayer une dernière fois de réinitialiser complètement l'initialisation pour être certain :

            podman-compose down
            podman container rm -af
            podman volume rm -af
            podman-compose pull
            podman-compose up -d
            

            Puis de vérifier la sortie de démarrage de MySQL :

            podman logs -f gofast-ng-mysql
            

            Si cela ne fonctionne toujours pas, pourriez vous m'extraire complètement le fichier /var/log/mysql/mysqld.log pour analyse ?

            Merci d'avance pour votre aide !

            LEMAN-GARIN Jérôme - CEO-Vision IT
            jerome.leman@ceo-vision.com
            Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
            +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
            https://www.ceo-vision.com

            1 Reply Last reply
            0
            • J Offline
              J Offline
              jc1204
              wrote on last edited by cpotter
              #11

              ci-joint le contenu du fichier log après réinitialisation :

              2023-08-17T15:54:29.248118Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
              2023-08-17T15:54:29.248135Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.30) initializing of server in progress as process 58
              2023-08-17T15:54:32.681425Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
              2023-08-17T15:55:18.270144Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
              2023-08-17T15:56:53.129035Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
              2023-08-17T15:59:40.461037Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
              2023-08-17T15:59:40.461059Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.30) starting as process 110
              2023-08-17T15:59:40.577130Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
              2023-08-17T15:59:41.597710Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
              2023-08-17T15:59:44.529643Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
              2023-08-17T15:59:44.529681Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
              2023-08-17T15:59:44.656676Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/lib/mysql/mysqlx.sock
              2023-08-17T15:59:44.656940Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.30'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution.
              2023-08-17T15:59:50.251802Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
              2023-08-17T16:00:48.193292Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.30)  Source distribution.
              2023-08-17T16:00:48.483448Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
              2023-08-17T16:00:48.483469Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.30) starting as process 178
              2023-08-17T16:00:48.489091Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
              2023-08-17T16:00:50.650405Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
              2023-08-17T16:00:56.769134Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
              2023-08-17T16:00:56.769194Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
              2023-08-17T16:00:56.971565Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
              2023-08-17T16:00:56.971623Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.30'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution.
              2023-08-17T16:00:56.971715Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.30).
              2023-08-17T16:00:58.526548Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
              2023-08-17T16:00:58.526577Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.30) starting as process 1
              2023-08-17T16:00:58.587453Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
              2023-08-17T16:00:58.745101Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
              2023-08-17T16:00:59.745263Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
              2023-08-17T16:01:00.745451Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
              2023-08-17T16:01:01.745765Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
              2023-08-17T16:01:02.746001Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 11
              2023-08-17T16:01:03.746641Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./#ib_16384_0.dblwr error: 11
              2023-08-17T16:01:03.963704Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.30)  Source distribution.
              2023-08-17T16:01:07.567761Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
              2023-08-17T16:01:11.179782Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
              2023-08-17T16:01:11.179827Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
              2023-08-17T16:01:11.352344Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
              2023-08-17T16:01:11.352439Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.30'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution.
              2023-08-17T16:01:13.531419Z 8 [Warning] [MY-010055] [Server] IP address '10.89.0.142' could not be resolved: Name or service not known
              2023-08-17T16:01:13.540196Z 8 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:13.567561Z 9 [Warning] [MY-010055] [Server] IP address '10.89.0.128' could not be resolved: Name or service not known
              2023-08-17T16:01:18.559038Z 10 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:23.577680Z 12 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:28.596760Z 14 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:33.615744Z 16 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:38.634577Z 18 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:43.653187Z 20 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:48.672560Z 22 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:53.691036Z 24 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:01:58.709598Z 26 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:02:03.734791Z 28 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:02:08.754423Z 30 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:02:13.775279Z 32 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              2023-08-17T16:02:18.793625Z 34 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
              
              1 Reply Last reply
              0
              • jlemangarinJ Offline
                jlemangarinJ Offline
                jlemangarin
                ADMIN SUPPORT-PROD DEV
                wrote on last edited by jlemangarin
                #12

                Bonjour @jc1204,

                Nous avons ce matin produit un patch qui nous espérons corrigera le problème, pourriez vous essayer la manipulation suivante :

                Dans le fichier compose.yaml ligne 23, changer :

                    image: "${REGISTRY}/gofast-ng-mysql:1.0.0-beta"
                

                Par

                    image: "${REGISTRY}/gofast-ng-mysql:1.0.1-beta"
                

                Puis réinitialiser et relancer GoFAST Community :

                podman-compose down
                podman container rm -af
                podman volume rm -af
                podman-compose pull
                podman-compose up -d
                

                Et vérifier la sortie de

                podman logs -f gofast-ng-mysql
                

                Normalement, la sortie devrait ressembler à cela :

                4aeffc8a-792d-404d-9974-1857ecc72608-image.png

                Merci d'avance et bonne journée !

                LEMAN-GARIN Jérôme - CEO-Vision IT
                jerome.leman@ceo-vision.com
                Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
                +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
                https://www.ceo-vision.com

                1 Reply Last reply
                0
                • J Offline
                  J Offline
                  jc1204
                  wrote on last edited by
                  #13

                  Bonjour @jlemangarin
                  L'installation a fonctionné mais cela a pris plus de deux heures.
                  Nous allons configurer une autre vm avec alma 8 (centos 9 requiert un type de processeur "host" sur proxmox, les lenteurs viennent peut-être de là).
                  Merci pour votre aide

                  1 Reply Last reply
                  1
                  • jlemangarinJ Offline
                    jlemangarinJ Offline
                    jlemangarin
                    ADMIN SUPPORT-PROD DEV
                    wrote on last edited by
                    #14

                    @jc1204 Merci beaucoup pour votre retour !

                    Oui c'est bizarre, même sur un poste de travail développeur cela ne prends normalement pas plus de 15 min.

                    C'est le téléchargement des images qui a pris du temps ou l'instanciation une fois la commande up lancée ?

                    On pourra également faire une visio si vous le souhaitez pour pouvoir analyser tout cela ensemble, il faudrait aussi que j'essaie sur un CentOS stream 9

                    Bonne journée !

                    LEMAN-GARIN Jérôme - CEO-Vision IT
                    jerome.leman@ceo-vision.com
                    Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
                    +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
                    https://www.ceo-vision.com

                    1 Reply Last reply
                    0
                    • J Offline
                      J Offline
                      jc1204
                      wrote on last edited by
                      #15

                      @jlemangarin c'est plutôt l'instanciation qui a pris beaucoup de temps. Là je suis en train de mettre en place une vm avec alma 9

                      1 Reply Last reply
                      0
                      • jlemangarinJ Offline
                        jlemangarinJ Offline
                        jlemangarin
                        ADMIN SUPPORT-PROD DEV
                        wrote on last edited by
                        #16

                        @jc1204 D'accord merci pour l'information, si vous effectuez un nouvel essai sur Alma 9 pourriez vous regarder les logs de gofast-ng-drupal et gofast-ng-alfresco pour essayer d'identifier ce qui prends autant de temps ?

                        Merci d'avance !

                        LEMAN-GARIN Jérôme - CEO-Vision IT
                        jerome.leman@ceo-vision.com
                        Alliance - Porte A, 178 rue des Frères Lumière 74160 Archamps Technopole, FRANCE
                        +33 (0) 811 693 111 et depuis l'étranger +33 (0) 972 236 057
                        https://www.ceo-vision.com

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Search
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Popular
                        • Search