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.
  • 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