mysql probléma :S

Kezdőlap › Fórumok › Debiannal kapcsolatos kérdések › mysql probléma :S

10 bejegyzés megtekintése - 61-70 / 79
1 2 3 … 6 7 8
  • Szerző
    Bejegyzés
  • 2008-09-13-20:36 #2172520
    mesti
    Felhasználó

      failed mint szokás szerint…
      egyik csávó azt mondta lehet hogy a partíció sérült:S

      zoltan22 wrote:
      Eredmeny = hibauzenet? Ha nincs, akkor minden rendben 🙂
      2008-09-13-20:36 #2172521
      mesti
      Felhasználó

        failed mint szokás szerint…
        egyik csávó azt mondta lehet hogy a partíció sérült:S

        zoltan22 wrote:
        Eredmeny = hibauzenet? Ha nincs, akkor minden rendben 🙂
        2008-09-13-20:38 #2172522
        mesti
        Felhasználó

          ja a log: http://kt-t.hu/log/daemon.log

          10. étöl kezdödött a probléma de nem birom kibogozni a logbol h mi a baj:S

          2008-09-13-20:38 #2172523
          mesti
          Felhasználó

            ja a log: http://kt-t.hu/log/daemon.log

            10. étöl kezdödött a probléma de nem birom kibogozni a logbol h mi a baj:S

            2008-09-13-21:00 #2172524
            zoltan22
            Felhasználó

              Ide masolom a relevans reszeket, hatha valaki tud ezzel mit kezdeni:

              elso hiba:

              Code:
              Sep 12 15:00:01 Andro proftpd[5967]: localhost (localhost[::ffff:127.0.0.1]) – FTP session closed.
              Sep 12 15:02:45 Andro mysqld_safe[6091]: started
              Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45  InnoDB: Started; log sequence number 0 813659
              Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/host.frm’
              Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/host.frm’
              Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/host.frm’
              Sep 12 15:02:45 Andro mysqld_safe[6105]: ended
              Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ resulted in
              Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
              Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
              Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
              Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]:
              Sep 12 15:06:39 Andro proftpd[6336]: 87.229.24.126 (::ffff:87.229.6.72[::ffff:87.229.6.72]) – error setting IPV6_V6ONLY: Protocol not available

              gondolom a visszamasolas utan:

              Code:
              Sep 13 22:00:01 Andro proftpd[23279]: localhost (localhost[::ffff:127.0.0.1]) – FTP session closed.
              Sep 13 22:03:38 Andro mysqld_safe[23425]: started
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Database was not shut down normally!
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Starting crash recovery.
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Reading tablespace information from the .ibd files…
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Restoring possible half-written data pages from the doublewrite
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: buffer…
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Starting log scan based on checkpoint at
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: log sequence number 0 36808.
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Doing recovery: scanned up to log sequence number 0 43655
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Starting an apply batch of log records to the database…
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
              Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Apply batch completed
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Started; log sequence number 0 43655
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Starting crash recovery…
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Crash recovery finished.
              Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
              Sep 13 22:03:38 Andro mysqld_safe[23439]: ended
              Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ resulted in
              Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
              Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
              Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
              Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]:
              Sep 13 22:30:01 Andro proftpd[23983]: localhost (localhost[::ffff:127.0.0.1]) – error setting IPV6_V6ONLY: Protocol not available
              2008-09-13-21:00 #2172525
              zoltan22
              Felhasználó

                Ide masolom a relevans reszeket, hatha valaki tud ezzel mit kezdeni:

                elso hiba:

                Code:
                Sep 12 15:00:01 Andro proftpd[5967]: localhost (localhost[::ffff:127.0.0.1]) – FTP session closed.
                Sep 12 15:02:45 Andro mysqld_safe[6091]: started
                Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45  InnoDB: Started; log sequence number 0 813659
                Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/host.frm’
                Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] /usr/sbin/mysqld: Incorrect information in file: ‘./mysql/host.frm’
                Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/host.frm’
                Sep 12 15:02:45 Andro mysqld_safe[6105]: ended
                Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ resulted in
                Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
                Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
                Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
                Sep 12 15:02:59 Andro /etc/init.d/mysql[6245]:
                Sep 12 15:06:39 Andro proftpd[6336]: 87.229.24.126 (::ffff:87.229.6.72[::ffff:87.229.6.72]) – error setting IPV6_V6ONLY: Protocol not available

                gondolom a visszamasolas utan:

                Code:
                Sep 13 22:00:01 Andro proftpd[23279]: localhost (localhost[::ffff:127.0.0.1]) – FTP session closed.
                Sep 13 22:03:38 Andro mysqld_safe[23425]: started
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Database was not shut down normally!
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Starting crash recovery.
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Reading tablespace information from the .ibd files…
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Restoring possible half-written data pages from the doublewrite
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: buffer…
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Starting log scan based on checkpoint at
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: log sequence number 0 36808.
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Doing recovery: scanned up to log sequence number 0 43655
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Starting an apply batch of log records to the database…
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
                Sep 13 22:03:38 Andro mysqld[23428]: InnoDB: Apply batch completed
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38  InnoDB: Started; log sequence number 0 43655
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Starting crash recovery…
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [Note] Crash recovery finished.
                Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
                Sep 13 22:03:38 Andro mysqld_safe[23439]: ended
                Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ resulted in
                Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
                Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
                Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
                Sep 13 22:03:52 Andro /etc/init.d/mysql[23576]:
                Sep 13 22:30:01 Andro proftpd[23983]: localhost (localhost[::ffff:127.0.0.1]) – error setting IPV6_V6ONLY: Protocol not available
                2008-09-13-22:06 #2172526
                admin
                Adminisztrátor
                  mesti wrote:
                  failed mint szokás szerint…
                  egyik csávó azt mondta lehet hogy a partíció sérült:S

                  adatbázis userek jogai?
                  létezenk azok az userek, amelyeket a bemásolással oda nyomsz?
                  mysql(mysql_root) user jogai?
                  Ez nem a system root!

                  2008-09-13-22:06 #2172527
                  admin
                  Adminisztrátor
                    mesti wrote:
                    failed mint szokás szerint…
                    egyik csávó azt mondta lehet hogy a partíció sérült:S

                    adatbázis userek jogai?
                    létezenk azok az userek, amelyeket a bemásolással oda nyomsz?
                    mysql(mysql_root) user jogai?
                    Ez nem a system root!

                    2008-09-14-05:55 #2172528
                    admin
                    Adminisztrátor

                      Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/host.frm’

                      Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

                      Ezeket szerinted miért írogatja ?

                      2008-09-14-05:55 #2172529
                      admin
                      Adminisztrátor

                        Sep 12 15:02:45 Andro mysqld[6094]: 080912 15:02:45 [ERROR] Fatal error: Can’t open and lock privilege tables: Incorrect information in file: ‘./mysql/host.frm’

                        Sep 13 22:03:38 Andro mysqld[23428]: 080913 22:03:38 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

                        Ezeket szerinted miért írogatja ?

                      • Szerző
                        Bejegyzés
                      10 bejegyzés megtekintése - 61-70 / 79
                      1 2 3 … 6 7 8
                      • Be kell jelentkezni a hozzászóláshoz.