Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4745

Cannot access data on NTFS drive.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5.31
    • None
    • None
    • None
    • Linux Mint 15. SSD boot drive ext4 with ide data drive NTFS. Intel Dual Core 2.7Mhz. 4Gb Ram.

    Description

      Can only access data on the boot drive. My thoughts could be linked to permissions as mounted drives are owned by ROOT account no MySql account. Possibly MariaDb is starting before the drive is mounted after a reboot. Reproduce as detailed below:
      1. Stop server.
      2. Copy data from ssd ext4 boot drive to ide ntfs mounted drive
      3. Restart server.
      4. Test access with MySql Workbench and custom apps. All works fine.
      5. Reboot computer. MariaDb starts ok.
      6. Run custom app. Logs on ok but try to read records and get error:
      "java.sql.SQLSyntaxErrorException: Table 'pword.app' doesn't exist"
      7. Open MySql Workbench. All schemas listed correctly in tree view.
      8. Attempt to expand "Tables". Tables listed correctly.
      9. Attempt to expand a table. Workbench shuts down.
      10. Stop server.
      11. Reset datadir back to boot partition as original.
      12. Restart server.
      13. Everything works fine.
      14. Reboot computer. MariaDb works fine.

      Attachments

        1. axel.log
          10 kB
        2. elena_tests.txt
          12 kB
        3. global_variables.csv
          11 kB
        4. mariadb.log
          10 kB
        5. my.cnf
          5 kB
        6. my.cnf.wba.bak
          5 kB
        7. start_bad.log
          38 kB
        8. start_good.log
          1 kB

        Issue Links

          links to

          Web Link Changing location of database

          Activity

            People

              axel Axel Schwenke
              mdavies5 Michael Davies
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.