1 2 Previous Next 15 Replies Latest reply on Nov 20, 2014 12:37 PM by AlexT_Intel

    add mysql on edison

    wumf

      hello everyone,

       

               I want to add mysql on edison ,but after i compile successful, when the edison set up ,there is a problem :

       

      Starting kernel ...

       

      [    0.773556] pca953x 1-0020: failed reading register

      [    0.773971] pca953x 1-0021: failed reading register

      [    0.783161] pca953x 1-0022: failed reading register

      [    0.783515] pca953x 1-0023: failed reading register

      [    1.628989] pmic_ccsm pmic_ccsm: Error reading battery profile from battid frmwrk

      [    1.637698] pmic_ccsm pmic_ccsm: Battery Over heat exception

      [    1.716128] VFS: Unable to mount root fs on unknown-block(179,8)

      [    1.716212] User configuration error - no valid root filesystem found

      [    1.716288] Kernel panic - not syncing: Invalid configuration from end user prevents continuing

      [    1.716366] CPU: 0 PID: 1 Comm: swapper/0 Not tainted 3.10.17-poky-edison+ #20

      [    1.716426] Hardware name: Intel Corporation Merrifield/BODEGA BAY, BIOS 466 2014.06.23:19.20.05

      [    1.716494]  f6c89ed8 f6c89ed8 f6c89e8c c18a95d0 f6c89eac c18a4e93 c1a753a0 c1cb53c0

      [    1.716610]  00000000 f6c89ed8 00008001 f5c35005 f6c89f04 c1c01f0e c1a64d50 f6c89ed8

      [    1.716721]  f5c35000 00008001 00000000 0b300008 ffffff9c f7ac66a0 c1a646fc 6e6b6e75

      [    1.716833] Call Trace:

      [    1.716884]  [<c18a95d0>] dump_stack+0x16/0x18

      [    1.716940]  [<c18a4e93>] panic+0x87/0x181

      [    1.716994]  [<c1c01f0e>] mount_block_root+0x23a/0x23a

      [    1.717059]  [<c1328b6d>] ? SyS_mknod+0x2d/0x30

      [    1.717111]  [<c1c02068>] mount_root+0x5b/0x61

      [    1.717164]  [<c1c021b7>] prepare_namespace+0x149/0x18d

      [    1.717223]  [<c1319a85>] ? SyS_access+0x25/0x30

      [    1.717281]  [<c1c01c00>] kernel_init_freeable+0x1ef/0x1fc

      [    1.717342]  [<c1c014e0>] ? do_early_param+0x78/0x78

      [    1.717401]  [<c1896040>] kernel_init+0x10/0x140

      [    1.717458]  [<c18b46f7>] ret_from_kernel_thread+0x1b/0x28

      [    1.717516]  [<c1896030>] ? rest_init+0x80/0x80

      [    1.717659] emmc_ipanic: panic notified

      [    1.717697] emmc_ipanic: Crash partition in use!

      [    1.717779] ------------[ cut here ]------------

      [    1.717841] WARNING: at /work/Edison/ww42/edison-src/build/tmp/work/edison-poky-linux/linux-yocto/3.10.17+gitAUTOINC+6ad20f049a_c03195ed6e-)

      [    1.717974] Modules linked in:

      [    1.718020] CPU: 0 PID: 1 Comm: swapper/0 Not tainted 3.10.17-poky-edison+ #20

      [    1.718079] Hardware name: Intel Corporation Merrifield/BODEGA BAY, BIOS 466 2014.06.23:19.20.05

      [    1.718147]  00000000 00000000 f6c89cf4 c18a95d0 f6c89d1c c123e79e c1a7f7b5 c1a6e9e0

      [    1.718262]  0000007b c121f29b c121f29b 00000001 f73fda40 f73efa40 f6c89d2c c123e862

      [    1.718376]  00000009 00000000 f6c89d34 c121f29b f6c89d50 c12791d7 ffff8b74 00000000

      [    1.718490] Call Trace:

      [    1.718533]  [<c18a95d0>] dump_stack+0x16/0x18

      [    1.718592]  [<c123e79e>] warn_slowpath_common+0x5e/0x80

      [    1.718651]  [<c121f29b>] ? native_smp_send_reschedule+0x4b/0x50

      [    1.718713]  [<c121f29b>] ? native_smp_send_reschedule+0x4b/0x50

      [    1.718778]  [<c123e862>] warn_slowpath_null+0x22/0x30

      [    1.718835]  [<c121f29b>] native_smp_send_reschedule+0x4b/0x50

      [    1.718899]  [<c12791d7>] trigger_load_balance+0x137/0x1c0

      [    1.718962]  [<c126d41d>] scheduler_tick+0xdd/0x110

      [    1.719021]  [<c124eee7>] update_process_times+0x57/0x70

      [    1.719081]  [<c128e116>] tick_sched_handle.isra.12+0x26/0x60

      [    1.719141]  [<c128e187>] tick_sched_timer+0x37/0x70

      [    1.719199]  [<c1263198>] ? __remove_hrtimer+0x38/0x90

      [    1.719258]  [<c126360b>] __run_hrtimer+0x7b/0x220

      [    1.719313]  [<c128e150>] ? tick_sched_handle.isra.12+0x60/0x60

      [    1.719378]  [<c1264318>] hrtimer_interrupt+0x1f8/0x2b0

      [    1.719445]  [<c18b4e54>] smp_apic_timer_interrupt+0x54/0x89

      [    1.719508]  [<c14b5584>] ? trace_hardirqs_off_thunk+0xc/0x18

      [    1.719570]  [<c18afa7a>] apic_timer_interrupt+0x32/0x38

      [    1.719635]  [<c12400d8>] ? __add_preferred_console.constprop.11+0x8/0xa0

      [    1.719703]  [<c18a4f56>] ? panic+0x14a/0x181

      [    1.719757]  [<c1c01f0e>] mount_block_root+0x23a/0x23a

      [    1.719820]  [<c1328b6d>] ? SyS_mknod+0x2d/0x30

      [    1.719873]  [<c1c02068>] mount_root+0x5b/0x61

      [    1.719927]  [<c1c021b7>] prepare_namespace+0x149/0x18d

      [    1.719985]  [<c1319a85>] ? SyS_access+0x25/0x30

      [    1.720043]  [<c1c01c00>] kernel_init_freeable+0x1ef/0x1fc

      [    1.720104]  [<c1c014e0>] ? do_early_param+0x78/0x78

      [    1.720163]  [<c1896040>] kernel_init+0x10/0x140

      [    1.720220]  [<c18b46f7>] ret_from_kernel_thread+0x1b/0x28

      [    1.720278]  [<c1896030>] ? rest_init+0x80/0x80

      [    1.720326] ---[ end trace 249ab3a60b68dd36 ]---

       

      The edison stop here , after a few miuntes , the ediso reboot!

       

      I add the mysql  :

      add :

      IMAGE_INSTALL += "mysql5"

      IMAGE_INSTALL += "mysql-python"

       

      Why?  

        • 1. Re: add mysql on edison
          mhahn

          [    1.637698] pmic_ccsm pmic_ccsm: Battery Over heat exception

          [    1.716128] VFS: Unable to mount root fs on unknown-block(179,8)

          [    1.716212] User configuration error - no valid root filesystem found

           

          looks pretty weird ...

          • 2. Re: add mysql on edison
            Intel_Peter

            Hello wunf,

             

            I found some posts talking about related subjects; maybe you can find them helpful.

             

            Not able to start mysql prompt

            cannot enter into mysqld

            running mysql script from command line and send it to server in linux

             

            However if you are able to make it work I invite you to post your results in the community.

            If you have any more doubts don't hesitate to ask.

             

            Regards,

                        Peter

            1 of 1 people found this helpful
            • 3. Re: add mysql on edison
              wumf

              Hi peter ,

               

                    The first , thank you for your help ! Now I don't have some ways to solute the question ! And I add  "postgresql", there is the same problem ,too.

                    I want to install SQL ,but I add "mysql" and "postgresql" unsuccessfully!

               

              [    0.773556] pca953x 1-0020: failed reading register

              [    0.773971] pca953x 1-0021: failed reading register

              [    0.783161] pca953x 1-0022: failed reading register

              [    0.783515] pca953x 1-0023: failed reading register

              [    1.628989] pmic_ccsm pmic_ccsm: Error reading battery profile from battid frmwrk

              [    1.637698] pmic_ccsm pmic_ccsm: Battery Over heat exception

               

               

              Regards,

              wumf

              • 4. Re: add mysql on edison
                deium

                I get the same initial 6 lines of readings on my Edison mini breakout board.  I don't have a battery to overheat as I am powered over USB on J16.

                I have not experienced anything bad as a result.

                 

                key to me in your errors are:

                [    1.716128] VFS: Unable to mount root fs on unknown-block(179,8)

                [    1.716212] User configuration error - no valid root filesystem found

                 

                I'd reset Edison by flashing it again, and my advise is to examine where you are trying to install mysqld to.  The root fs / does not have much space in the partition most of which gets chewed up by journal logs.  the /home partition is where most of your space resides.  do a diskfree with the command df to see your space remaining and realize that anything not in one of the folders and subfolders of a partition is going to end up being part of the root / partition.

                 

                /

                /boot

                /dev

                /dev/shm

                /etc/machine-id

                /factory

                /home

                /run

                /sys/fs/cgroup

                /tmp

                /var/volatile

                1 of 1 people found this helpful
                • 5. Re: add mysql on edison
                  Intel_Peter

                  Hello wunf,

                   

                  I've been researching and testing a little, I've been following this guide and I managed to install mySQL on the Edison, but I haven't tested it yet.. Why don't you try it and let us know your results?

                   

                  Regards,

                              Peter

                  • 6. Re: add mysql on edison
                    wumf

                    Hi deium,

                     

                         Thank you for your help !  The rootfs partition does not have much space lead to the problem ! And do you know how to adjust the rootfs partition's space on edison?

                    • 7. Re: add mysql on edison
                      deium

                      I don't have an answer to adjust the root partition on the yocto supported image, but I did find that the edison_config.service is chewing 6400 blocks in 3:08 hours.  If you have finished configuring, you can run

                      • systemctl disable edison_config.service
                      • rm -rf /var/log/journal/*
                      • reboot

                      it will save a bit of your root partition being eaten away.  Some journal / log housekeeping will have to be done to keep the root clean.

                      • 8. Re: add mysql on edison
                        wumf

                        Hi peter,

                         

                                Maybe The rootfs partition does not have much space lead to the problem ! And do you know  how to adjust the partition's space on edison?



                        Regard,


                        wumf

                        • 9. Re: add mysql on edison
                          mhahn

                          If you don't mind a Toto rebuild you can use the method described elsewhere in this forum. I do have 2G roots size with that...

                          • 10. Re: add mysql on edison
                            mhahn

                            Toto -> Yocto

                            • 11. Re: add mysql on edison
                              wumf

                              Hi  mhahn,

                               

                                    Can you tell me how to do it ? Thank you!

                               

                               

                              Regards,

                               

                              wumf

                              • 12. Re: add mysql on edison
                                wumf

                                Hi mhahn,

                                 

                                      Thank you very much ! I know how to do it ! Increasing the Root Partition Size

                                 

                                wumf

                                • 13. Re: add mysql on edison
                                  mhahn

                                  there are probably easier ways - but I went the Yocto build one. Is helpful to have a Yocto build environment anyways to build own packages

                                  • 14. Re: add mysql on edison
                                    wumf

                                    Hi deium,

                                     

                                           If you want to increase the roof partition size ,you can try to do it according to Increasing the Root Partition Size

                                     

                                     

                                    wumf

                                    1 2 Previous Next