Debian při aktualizacích: chyba s MySQL

Debian při aktualizacích: chyba s MySQL
« kdy: 25. 03. 2012, 10:02:50 »
toto mi ukazuje pri instalaci cacti:


Citace
mysql-5.1 (5.1.61-1) stable-security; urgency=high

   Due to the non-disclosure of security patch information from Oracle,
   we are forced to ship this upstream version update of MySQL 5.1 into
   all releases that carry MySQL 5.1. There are several known incompatible
   changes, which are listed below, taken from dev.mysql.com's changelogs,
   available here: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html

   5.1.51:
    Incompatible Change: Previously, if you flushed the logs using FLUSH
    LOGS or mysqladmin flush-logs and mysqld was writing the error log to
    a file (for example, if it was started with the --log-error option),
    it renamed the current log file with the suffix -old, then created a
    new empty log file. This had the problem that a second log-flushing
    operation thus caused the original error log file to be lost unless
    you saved it under a different name. For example, you could use the
    following commands to save the file:
    .
    shell> mysqladmin flush-logs
    shell> mv host_name.err-old backup-directory
    .
    To avoid the preceding file-loss problem, renaming no longer
    occurs. The server merely closes and reopens the log file. To rename

 logs reopens a new file with the original file name. For example, you
    can rename the file and create a new one using the following commands:
    .
    shell> mv host_name.err host_name.err-old
    shell> mysqladmin flush-logs
    shell> mv host_name.err-old backup-directory
    .
    (Bug #29751)
    .
    References: See also Bug #56821.

   5.1.55:
    Incompatible Change: When auto_increment_increment is greater than
    one, values generated by a bulk insert that reaches the maximum
    column value could wrap around rather producing an overflow error.
    .
    As a consequence of the fix, it is no longer possible for an
    auto-generated value to be equal to the maximum BIGINT UNSIGNED
    value. It is still possible to store that value manually, if the
    column can accept it. (Bug #39828, Bug #11749800)

 5.1.59:
    Incompatible Change: Handling of a date-related assertion was
    modified.
    .
    However, a consequence of this change is that several functions
    become more strict when passed a DATE() function value as their
    argument and reject incomplete dates with a day part of zero. These
    functions are affected: CONVERT_TZ(), DATE_ADD(), DATE_SUB(),
    DAYOFYEAR(), LAST_DAY(), TIMESTAMPDIFF(), TO_DAYS(), TO_SECONDS(),
    WEEK(), WEEKDAY(), WEEKOFYEAR(), YEARWEEK(). Because this changes
    date-handling behavior in General Availability-status series (MySQL
    5.1 and 5.5), it was reverted in 5.1.62 and 5.5.21. The change is
    retained in MySQL 5.6.
    .
    References: See also Bug #13458237.

 -- Clint Byrum <clint@ubuntu.com>  Thu, 01 Mar 2012 23:25:34 -0800


mam debian squueze, nemam ani paru co to znamena a co s tym robit. Viete poradit ako to vyriesit? dakujem
« Poslední změna: 25. 03. 2012, 20:31:10 od Petr Krčmář »


DarkKnight

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #1 kdy: 25. 03. 2012, 10:40:34 »
aktualizuj mysql

Kód: [Vybrat]
apt-get install mysql-5.1

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #2 kdy: 25. 03. 2012, 13:15:52 »
sudo apt-get -f install mysql-server-5.1

mi ukaze tu istu chybu....

Lol Phirae

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #3 kdy: 25. 03. 2012, 13:36:16 »
OMG. Už jsi zkusil někdy
Kód: [Vybrat]
sudo apt-get upgrade nebo zásadně nikdy neaktualizuješ?  ::)

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #4 kdy: 25. 03. 2012, 14:00:25 »
skusal som aj update, upgrade....vzdy to vyhodi textovy dokument s danym textom ktory je v prvom prikaze, ide ho len posuvat dole a nasledne vypnut. NIc viac....


Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #5 kdy: 25. 03. 2012, 14:02:48 »
po vypnuti oznamenia pomocou ctrl+c ukaze:

Fetched 238 kB in 0s (536 kB/s)   
Reading changelogs... Done
 a tam to aj zastane...
musim vypnut terminal a otvorit novy. Nasledne ked dam nieco instalovat, alebo upgrade to iste....proste nejde nic instalova, upgradovat....

Lol Phirae

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #6 kdy: 25. 03. 2012, 14:13:18 »
Ještě máš krabici od toho počítače?  :D

P.S. Co kdybys sem aspoň konečně napsal, jaký příkaz používáš, a jaké zdroje máš nastaveny?!

Kód: [Vybrat]
$ apt-cache policy mysql-server-5.1
mysql-server-5.1:
  Instalovaná verze: (žádná)
  Kandidát:          5.1.61-2
  Tabulka verzí:
     5.1.61-2 0
        600 http://ftp.debian.org/debian/ testing/main amd64 Packages
        600 http://ftp.debian.org/debian/ unstable/main amd64 Packages
     5.1.58-1 0
        600 http://debian.linuxmint.com/latest/ testing/main amd64 Packages

vi input mode

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #7 kdy: 25. 03. 2012, 15:52:03 »
po vypnuti oznamenia pomocou ctrl+c ukaze:

Fetched 238 kB in 0s (536 kB/s)   
Reading changelogs... Done
 a tam to aj zastane...
musim vypnut terminal a otvorit novy. Nasledne ked dam nieco instalovat, alebo upgrade to iste....proste nejde nic instalova, upgradovat....

no keď to killneš, tak nečakaj, že niečo vyriešiš... predpokladám, že sa z toho "oznámenia, v ktorom sa dá len posúvať" (:D:D) dostaneš pomocou klávesy q

Re:mysql-5.1 (5.1.61-1) stable-security; urgency=high
« Odpověď #8 kdy: 25. 03. 2012, 16:17:30 »
vdaka vi input mode, stacilo dat len: q