Ça va être du sport

ceca:/# apt-get update ; apt-get -o APT::Get::Trivial-Only=true dist-upgrade ; df --si
Get:1 http://apt.auf.org wheezy Release.gpg [181 B]
Ign http://apt.auf.org/ wheezy/auf Translation-en
Ign http://apt.auf.org/ wheezy/auf Translation-fr
Get:2 http://apt.auf.org wheezy Release [5323 B]
Get:3 http://debian.ca.auf.org wheezy Release.gpg [2373 B]
Get:4 http://debian.ca.auf.org/debian/ wheezy/contrib Translation-en [34.8 kB]
Ign http://debian.ca.auf.org/debian/ wheezy/contrib Translation-fr
Get:5 http://debian.ca.auf.org/debian/ wheezy/main Translation-en [3846 kB]
Get:6 http://apt.auf.org wheezy/auf i386 Packages [10.2 kB]                                 
Get:7 http://debian.ca.auf.org/debian/ wheezy/main Translation-fr [751 kB]                            
Get:8 http://debian.ca.auf.org wheezy-updates Release.gpg [1554 B]
Get:9 http://debian.ca.auf.org/debian/ wheezy-updates/contrib Translation-en [14 B]
Ign http://debian.ca.auf.org/debian/ wheezy-updates/contrib Translation-fr
Get:10 http://debian.ca.auf.org/debian/ wheezy-updates/main Translation-en [3814 B]
Ign http://debian.ca.auf.org/debian/ wheezy-updates/main Translation-fr
Get:11 http://debian.ca.auf.org wheezy/updates Release.gpg [1554 B]
Get:12 http://debian.ca.auf.org/debian-security/ wheezy/updates/main Translation-en [195 kB]
Ign http://debian.ca.auf.org/debian-security/ wheezy/updates/main Translation-fr
Get:13 http://debian.ca.auf.org wheezy Release [191 kB]
Get:14 http://debian.ca.auf.org wheezy-updates Release [143 kB]
Get:15 http://debian.ca.auf.org wheezy/updates Release [102 kB]                     
Get:16 http://debian.ca.auf.org wheezy/main i386 Packages [5858 kB]                 
Get:17 http://debian.ca.auf.org wheezy/contrib i386 Packages [42.3 kB]                    
Get:18 http://debian.ca.auf.org wheezy-updates/main i386 Packages [5613 B]
Get:19 http://debian.ca.auf.org wheezy-updates/contrib i386 Packages [14 B]
Get:20 http://debian.ca.auf.org wheezy/updates/main i386 Packages [339 kB]
Fetched 11.5 MB in 4s (2518 kB/s)                           
Reading package lists... Done
W: There is no public key available for the following key IDs:
7638D0442B90D010
W: There is no public key available for the following key IDs:
7638D0442B90D010
W: There is no public key available for the following key IDs:
9D6D8F6BC857C906
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Calculating upgrade... Failed
The following packages have unmet dependencies:
 initscripts : Breaks: nfs-common (< 1:1.2.5-3) but 1:1.2.2-4squeeze3 is to be installed
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
Filesystem             Size   Used  Avail Use% Mounted on
/dev/vda1              8.5G   7.0G   1.1G  88% /
tmpfs                  526M      0   526M   0% /lib/init/rw
udev                   522M   140k   521M   1% /dev
tmpfs                  526M      0   526M   0% /dev/shm
ceca:/#



ceca:/# apt-get upgrade && apt-get clean
...
...
Setting up insserv (1.14.0-5) ...
Installing new version of config file /etc/insserv.conf ...
(Reading database ... 55666 files and directories currently installed.)
Preparing to replace sysv-rc 2.88dsf-13.1+squeeze1 (using .../sysv-rc_2.88dsf-41+deb7u1_all.deb) ...
Unpacking replacement sysv-rc ...
Processing triggers for man-db ...
Setting up sysv-rc (2.88dsf-41+deb7u1) ...
info: Reordering boot system, log to /var/lib/insserv/run-20160224T1214.log
error: Something failed while migrating.

error: Unable to migrate to dependency based boot sequencing.

See http://wiki.debian.org/LSBInitScripts/DependencyBasedBoot for
more information about dependency based boot sequencing. To
reattempt the migration process run 'dpkg --configure sysv-rc'.

dpkg: error processing sysv-rc (--configure):
 subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
                                      Errors were encountered while processing:
 sysv-rc
E: Sub-process /usr/bin/dpkg returned an error code (1)
ceca:/# dpkg --configure sysv-rc
ceca:/# apt-get upgrade && apt-get clean
....
147 upgraded, 0 newly installed, 0 to remove and 331 not upgraded.

...
insserv: warning: script 'K02epindexer' missing LSB tags and overrides
insserv: warning: script is corrupt or invalid: /etc/init.d/../rc6.d/K00vzreboot
insserv: warning: current stop runlevel(s) (1) of script `cron' overrides LSB defaults (empty).
insserv: warning: script 'epindexer' missing LSB tags and overrides
insserv: There is a loop at service epindexer if started
insserv: There is a loop between service munin-node and mountnfs if started
insserv:  loop involving service mountnfs at depth 8
insserv:  loop involving service nfs-common at depth 7
insserv: There is a loop between service munin-node and checkroot if started
insserv:  loop involving service checkroot at depth 5
insserv:  loop involving service hostname at depth 4


insserv: Max recursions depth 99 reached
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv:  loop involving service mountnfs-bootclean at depth 10
insserv:  loop involving service networking at depth 8
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv:  loop involving service bootmisc at depth 12
insserv: There is a loop between service munin-node and mountall-bootclean if started
insserv:  loop involving service mountall-bootclean at depth 8
insserv:  loop involving service mountall at depth 7
insserv:  loop involving service checkfs at depth 6
insserv: There is a loop between service epindexer and ifupdown-clean if started
insserv:  loop involving service ifupdown-clean at depth 6
insserv: There is a loop between service epindexer and mountdevsubfs if started
insserv:  loop involving service mountdevsubfs at depth 2
insserv:  loop involving service udev at depth 1
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv:  loop involving service mountoverflowtmp at depth 10
insserv: There is a loop between service epindexer and mtab if started
insserv:  loop involving service mtab at depth 6
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: There is a loop at service munin-node if started
insserv: There is a loop between service munin-node and mountoverflowtmp if started
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: configured to not write apport reports
                                               Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv:  loop involving service pop-before-smtp at depth 13
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv:  loop involving service courier-authdaemon at depth 13
insserv:  loop involving service hwclock at depth 7
insserv:  loop involving service bootlogd at depth 4
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: Starting epindexer depends on munin-node and therefore on system facility `$all' which can not be true!
insserv: exiting now without changing boot order!
update-rc.d: error: insserv rejected the script header
dpkg: error processing spamassassin (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 cron
 console-common
 apticron
 logrotate
 at
 acpid
 acpi-support-base
 sudo
 auf-git-etc
 courier-authdaemon
 courier-base
 x11-common
 xfonts-encodings
 xfonts-utils
 gsfonts-x11
 hdparm
 openbsd-inetd
 smartmontools
 spamassassin
E: Sub-process /usr/bin/dpkg returned an error code (1)
ceca:/#

Après cette modif 

+++ b/etc/init.d/munin-node
@@ -4,8 +4,6 @@
 # Provides:          munin-node
 # Required-Start:    $local_fs $remote_fs
 # Required-Stop:     $local_fs $remote_fs
-# Should-Start:      $all
-# Should-Stop:       $all
 # Default-Start:     2 3 4 5
 # Default-Stop:      0 1 6
 # Short-Description: Start/stop Munin-Node

tout se passe bien.

ceca:/# apt-get install udev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libc6-dev : Breaks: gcc-4.4 (< 4.4.6-4) but 4.4.5-8 is to be installed
E: Broken packages
ceca:/# 

ceca:/# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Calculating upgrade... Failed
The following packages have unmet dependencies:
 initscripts : Breaks: nfs-common (< 1:1.2.5-3) but 1:1.2.2-4squeeze3 is to be installed
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
ceca:/# cat /etc/apt/sources.list
deb http://debian.ca.auf.org/debian wheezy main contrib
#deb http://debian.ca.auf.org/debian wheezy-lts main contrib non-free
deb http://debian.ca.auf.org/debian wheezy-updates main contrib

deb http://debian.ca.auf.org/debian-security wheezy/updates main

deb http://apt.auf.org wheezy auf
ceca:/# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/vda1             7.9G  6.7G  814M  90% /
tmpfs                 502M     0  502M   0% /lib/init/rw
udev                  497M  136K  497M   1% /dev
tmpfs                 502M     0  502M   0% /dev/shm
ceca:/# aptitude purge nfs-common
The following packages will be REMOVED:  
  nfs-common{p} 
0 packages upgraded, 0 newly installed, 1 to remove and 329 not upgraded.
Need to get 0 B of archives. After unpacking 618 kB will be freed.
Do you want to continue? [Y/n/?] 
(Reading database ... 59525 files and directories currently installed.)
Removing nfs-common ...
[ ok ] Stopping NFS common utilities: statd.
Purging configuration files for nfs-common ...
insserv: warning: script 'K01epindexer' missing LSB tags and overrides
insserv: warning: script is corrupt or invalid: /etc/init.d/../rc6.d/K00vzreboot
insserv: warning: script 'epindexer' missing LSB tags and overrides
dpkg-statoverride: warning: No override present.
Processing triggers for man-db ...
                                         
Current status: 329 updates [-1].
ceca:/# 

ceca:/# aptitude purge gcc-4.4
The following packages will be REMOVED:  
  gcc-4.4{p} 
0 packages upgraded, 0 newly installed, 1 to remove and 328 not upgraded.
Need to get 0 B of archives. After unpacking 4682 kB will be freed.
The following packages have unmet dependencies:
  g++-4.4: Depends: gcc-4.4 (= 4.4.5-8) but it is not going to be installed.
  g++: Depends: gcc-4.4 (>= 4.4.5-1~) but it is not going to be installed.
  gcc: Depends: gcc-4.4 (>= 4.4.5-1~) but it is not going to be installed.
The following actions will resolve these dependencies:

     Remove the following packages:              
1)     build-essential                           
2)     g++                                       
3)     g++-4.4                                   
4)     gcc                                       
5)     libstdc++6-4.4-dev                        

     Leave the following dependencies unresolved:
6)     spamassassin recommends gcc               
7)     dpkg-dev recommends build-essential       


Accept this solution? [Y/n/q/?] 
The following packages will be REMOVED:
  build-essential{a} dpkg-dev{u} g++{a} g++-4.4{a} gcc{a} gcc-4.4{p} libdpkg-perl{u} libstdc++6-4.4-dev{a} 
0 packages upgraded, 0 newly installed, 8 to remove and 324 not upgraded.
Need to get 0 B of archives. After unpacking 29.5 MB will be freed.
Do you want to continue? [Y/n/?] 
(Reading database ... 59482 files and directories currently installed.)
Removing build-essential ...
Removing dpkg-dev ...
Removing g++ ...
Removing gcc ...
Removing g++-4.4 ...
Removing libstdc++6-4.4-dev ...
Processing triggers for man-db ...
(Reading database ... 58483 files and directories currently installed.)
Removing gcc-4.4 ...
(Reading database ... 58416 files and directories currently installed.)
Removing libdpkg-perl ...
Processing triggers for man-db ...
                                         
Current status: 324 updates [-5].
ceca:/#

ceca:/# apt-get install udev sans soucis ...

==>apt-get clean ; aptitude search ~i\!~Odebian

Les paquets suivants seront ENLEVÉS : 
  cpp-4.3{p} dhcp3-client{p} dhcp3-common{p} diff{p} doc-linux-text{p} fam{a} gcc-4.3-base{p} gcj-4.2-base{p} 
  gs-common{p} libbind9-60{p} libboost-iostreams1.42.0{p} libdb4.6{p} libdb4.7{p} libdb4.8{p} libdns69{p} 
  libevent-1.4-2{p} libgcj8-1{p} libgcj8-1-awt{p} libgcj8-jar{p} libgmp3c2{p} libgraphviz4{p} libgs8{p} 
  libisc62{p} libisccc60{p} libisccfg62{p} libjpeg62{u} libkpathsea4{p} libkpathsea5{p} libltdl3{p} 
  liblwres60{p} liblzma2{p} libmagick10{p} libmagickcore3{p} libmagickwand3{p} libmpfr1ldbl{p} 
  libmysqlclient16{p} libpoppler5{p} libssl0.9.8{p} libtokyocabinet8{p} linux-image-2.6.32-5-amd64{p} 
  pop-before-smtp{p} portmap{p} python2.5{p} python2.5-minimal{p} xpdf-common{ap} xpdf-reader{p} xpdf-utils{p} 
0 paquets mis à jour, 0 nouvellement installés, 47 à enlever et 0 non mis à jour.
Il est nécessaire de télécharger 0 o d'archives. Après dépaquetage, 237 Mo seront libérés.

ceca:/# apt-get install eprints
###################################################################
##                                                               ##
##                    Welcome to EPrints 3                       ##
##                                                               ##
###################################################################
##                                                               ##
## For known issues please check:                                ##
##     http://wiki.eprints.org/w/Debian_Known_Issues             ##
##                                                               ##
## Getting Started:                                              ##
##        Before you can start using eprints you need to         ##
## configure your install, follow these simple steps:            ##
##                                                               ##
##  # su eprints                                                 ##
##        You have to logged in as the eprints user to operate   ##
##        with eprints                                           ##
##  # cd                                                         ##
##        To the eprints home directory (/usr/share/eprints3)    ##
##                                                               ##
##  # ./bin/epadmin create                                       ##
##        Follow the instruction to create your archive.         ##
##                                                               ##
##  # exit                                                       ##
##                                                               ##
##  # a2ensite eprints                                           ##
##                                                               ##
##  # apache2ctl restart                                         ##
##                                                               ##
##                         ##### DONE #####                      ##
##                                                               ##
##  For more documentation please see the eprints wiki:          ##
##           http://wiki.eprints.org/w/Documentation             ##
##                                                               ##
###################################################################
ceca:/# 

ceca:/# /etc/init.d/apache2 start
[....] Starting web server: apache2Action 'start' failed.
The Apache error log may have more information.
 failed!
ceca:/# less /var/log/apache2/error.log
....
[Fri Feb 26 13:23:43 2016] [error] Can't locate EPrints.pm in @INC (@INC contains: /opt/eprints3/perl_lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl . /etc/apache2) at /usr/share/eprints3/bin/startup.pl line 6.\nBEGIN failed--compilation aborted at /usr/share/eprints3/bin/startup.pl line 6.\nCompilation failed in require at (eval 2) line 1.\n
[Fri Feb 26 13:23:43 2016] [error] Can't load Perl file: /usr/share/eprints3/bin/startup.pl for server ceca.auf.org:0, exiting...

ceca:/usr/share/eprints3# su - eprints
(auto-config de GIT_AUTHOR_NAME GIT_AUTHOR_EMAIL GIT_COMMITTER_NAME GIT_COMMITTER_EMAIL)
eprints@ceca:~$ bin/generate_apacheconf --system --replace
Wrote /usr/share/eprints3/cfg/apache.conf.2016022601
Wrote /usr/share/eprints3/cfg/apache.conf
Wrote /usr/share/eprints3/cfg/apache_ssl.conf

You must restart apache for any changes to take effect!
eprints@ceca:~$ déconnexion

ceca:/usr/share/eprints3# /etc/init.d/apache2 start
[....] Starting web server: apache2[Fri Feb 26 13:49:53 2016] [warn] _default_ VirtualHost overlap on port 80, the first has precedence
[Fri Feb 26 13:49:53 2016] [warn] _default_ VirtualHost overlap on port 80, the first has precedence
. ok 
ceca:/usr/share/eprints3#

Apache2 :
ceca:/etc/apache2# ls -al sites-available/
total 28
drwxr-xr-x 2 root root 4096 fév 26 14:04 .
drwxr-xr-x 7 root root 4096 fév 26 14:06 ..
-rw-r--r-- 1 root root 1012 fév 26 14:01 default
-rw-r--r-- 1 root root 7251 avr  1  2012 default-ssl
-rw-r--r-- 1 root root 1011 mar  3  2011 elections.auf.org
-rw-r--r-- 1 root root  893 jun 20  2011 phpmyadmin
ceca:/etc/apache2# ls -al sites-enabled/
total 8
drwxr-xr-x 2 root root 4096 fév 26 14:01 .
drwxr-xr-x 7 root root 4096 fév 26 14:06 ..
ceca:/etc/apache2# ls -al conf.d/
total 28
drwxr-xr-x 2 root root 4096 fév 26 14:04 .
drwxr-xr-x 7 root root 4096 fév 26 14:06 ..
-rw-r--r-- 1 root root  268 mai  5  2009 charset
-rw-r--r-- 1 root root   44 avr 27  2009 eprints3.conf
-rw-r--r-- 1 root root 3296 avr  1  2012 localized-error-pages
-rw-r--r-- 1 root root  143 avr  1  2012 other-vhosts-access-log
lrwxrwxrwx 1 root root   28 mai  7  2009 phpmyadmin.conf -> ../../phpmyadmin/apache.conf
-rw-r--r-- 1 root root 2590 aoû 18  2015 security
ceca:/etc/apache2# cat conf.d/eprints3.conf 
Include /usr/share/eprints3/cfg/apache.conf
ceca:/etc/apache2# 
ceca:/etc/apache2# vi ports.conf
==> activer le NameVirtualHosts

http://ceca.auf.org/eprints/
Cette archive fonctionne sous la version EPrints 3.1.2.1

ceca:/etc/apache2# su - eprints
eprints@ceca:~$ bin/epadmin upgrade ceca
Stopping indexer ...
Upgrading 3.1.1 to 3.1.2
Set DB compatibility flag to '3.1.2'.
Upgrading 3.1.2 to 3.2.0
There are recommended configuration file updates:
        indexing.pl
        rdf_license.pl
Install updated configuration files? [yes/no] ? yes
Renaming /usr/share/eprints3/archives/ceca/cfg/cfg.d/indexing.pl to indexing.pl.old
Added dataset saved_search
Fixed saved_search__rindex.field collation
Added dataset document
Added placement to dataset document
Added mime_type to dataset document
Added relation to dataset document
Added media to dataset document
Fixed document__rindex.field collation
Added dataset file
Added dataset user
Added username to dataset user
Added newemail to dataset user
Added email to dataset user
Added roles to dataset user
Added preference to dataset user
Added name to dataset user
Fixed user__rindex.field collation
Added securecode to dataset loginticket
Added ip to dataset loginticket
Added time to dataset loginticket
Added dataset eprint
Added files to dataset eprint
Added contact_email to dataset eprint
Added item_issues to dataset eprint
Added edit_lock to dataset eprint
Added creators to dataset eprint
Added contributors to dataset eprint
Added editors to dataset eprint
Added exhibitors to dataset eprint
Added producers to dataset eprint
Added conductors to dataset eprint
Added lyricists to dataset eprint
Fixed eprint__rindex.field collation
Added dataset request
Added requester_email to dataset request
Added expiry_date to dataset request
Added code to dataset request
Fixed request__rindex.field collation
Added datasetid to dataset history
Added dataset upload_progress
DBD::mysql::db do failed: Ne peut créer la table 'ceca.#sql-1790_29a' (Errcode: 150) at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3052, <STDIN> line 1.
SQL ERROR (do): ALTER TABLE `subject_name_sortvalue` ADD CONSTRAINT `subject_name_sortvalue_fk` FOREIGN KEY(`subjectid`) REFERENCES `subject`(`subjectid`) ON DELETE CASCADE
SQL ERROR (do): Ne peut créer la table 'ceca.#sql-1790_29a' (Errcode: 150) (#1005)
Failed adding dataset subject
Added name to dataset subject
Added parents to dataset subject
Added ancestors to dataset subject
Added sortvalue to dataset subject
Added last_run to dataset import
Added last_success to dataset import
Added dataset event_queue
Added dataset triple
Added parent to dataset metafield
Added provenance to dataset metafield
Added sql_counter to dataset metafield
Added default_value to dataset metafield
9 datasets added
38 fields added
Added counter fileid
Added counter tripleid
Added counter metafieldid
3 counters were added
CREATE(_utf8_test):  collation is latin1_swedish_ci:  [ OK ]
Converting database tables to UTF-8
Upgrading dataset saved_search
Upgrading `saved_search` by insertion
Upgrading `saved_search__ordervalues_fr` by insertion
Upgrading rindex and grep tables for saved_search
Upgrading dataset document
Upgrading `document` by insertion
Upgrading `document_relation_type` by insertion
Upgrading `document_relation_uri` by insertion
Upgrading `document__ordervalues_fr` by insertion
Upgrading rindex and grep tables for document
Upgrading dataset file
Upgrading `file` by insertion
DBD::mysql::db do failed: Impossible de supprimer un enregistrement père : une constrainte externe l'empèche at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3052, <STDIN> line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_file`
SQL ERROR (do): Impossible de supprimer un enregistrement père : une constrainte externe l'empèche (#1217)
Upgrading `file_copies_pluginid` by insertion
Upgrading `file_copies_sourceid` by insertion
Upgrading `file__ordervalues_fr` by insertion
Upgrading dataset user
Upgrading `user` by insertion
Upgrading `user_editperms` by insertion
Upgrading `user_roles` by insertion
Upgrading `user_items_fields` by insertion
Upgrading `user__ordervalues_fr` by insertion
Upgrading rindex and grep tables for user
Upgrading dataset loginticket
Upgrading `loginticket` by insertion
Upgrading `loginticket__ordervalues_fr` by insertion
Upgrading dataset eprint
Upgrading `eprint` by insertion
Upgrading `eprint_relation_type` by insertion
Upgrading `eprint_relation_uri` by insertion
Upgrading `eprint_item_issues_id` by insertion
Upgrading `eprint_item_issues_type` by insertion
Upgrading `eprint_item_issues_description` by insertion
Upgrading `eprint_item_issues_timestamp` by insertion
Upgrading `eprint_item_issues_status` by insertion
Upgrading `eprint_item_issues_reported_by` by insertion
Upgrading `eprint_item_issues_resolved_by` by insertion
Upgrading `eprint_item_issues_comment` by insertion
Upgrading `eprint_creators_name` by insertion
Upgrading `eprint_creators_id` by insertion
Upgrading `eprint_contributors_type` by insertion
Upgrading `eprint_contributors_name` by insertion
Upgrading `eprint_contributors_id` by insertion
Upgrading `eprint_corp_creators` by insertion
Upgrading `eprint_subjects` by insertion
Upgrading `eprint_divisions` by insertion
Upgrading `eprint_editors_name` by insertion
Upgrading `eprint_editors_id` by insertion
Upgrading `eprint_related_url_url` by insertion
Upgrading `eprint_related_url_type` by insertion
Upgrading `eprint_funders` by insertion
Upgrading `eprint_projects` by insertion
Upgrading `eprint_exhibitors_name` by insertion
Upgrading `eprint_exhibitors_id` by insertion
Upgrading `eprint_producers_name` by insertion
Upgrading `eprint_producers_id` by insertion
Upgrading `eprint_conductors_name` by insertion
Upgrading `eprint_conductors_id` by insertion
Upgrading `eprint_lyricists_name` by insertion
Upgrading `eprint_lyricists_id` by insertion
Upgrading `eprint_accompaniment` by insertion
Upgrading `eprint_skill_areas` by insertion
Upgrading `eprint_copyright_holders` by insertion
Upgrading `eprint__ordervalues_fr` by insertion
Upgrading rindex and grep tables for eprint
Upgrading dataset request
Upgrading `request` by insertion
Upgrading `request__ordervalues_fr` by insertion
Upgrading rindex and grep tables for request
Upgrading dataset history
Upgrading `history` by insertion
Upgrading `history__ordervalues_fr` by insertion
Upgrading dataset upload_progress
Upgrading `upload_progress` by insertion
DBD::mysql::db do failed: Impossible de supprimer un enregistrement père : une constrainte externe l'empèche at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3052, <STDIN> line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_upload_progress`
SQL ERROR (do): Impossible de supprimer un enregistrement père : une constrainte externe l'empèche (#1217)
Upgrading `upload_progress__ordervalues_fr` by insertion
Upgrading dataset access
Upgrading `access` by insertion
Upgrading `access__ordervalues_fr` by insertion
Upgrading dataset subject
Upgrading `subject` by insertion
Upgrading `subject_name_name` by insertion
Upgrading `subject_name_sortvalue` by insertion
Upgrading `subject_name_lang` by insertion
Upgrading `subject_parents` by insertion
Upgrading `subject_ancestors` by insertion
Upgrading `subject_sortvalue_sortvalue` by insertion
Upgrading `subject_sortvalue_lang` by insertion
Upgrading `subject__ordervalues_fr` by insertion
Upgrading rindex and grep tables for subject
DBD::mysql::st execute failed: La table 'ceca.subject__rindex' n'existe pas at /usr/share/eprints3/perl_lib/EPrints/Database/mysql.pm line 422, <STDIN> line 1.
DBD::mysql::st fetch failed: fetch() without execute() at /usr/share/eprints3/perl_lib/EPrints/Database/mysql.pm line 425, <STDIN> line 1.
DBD::mysql::st execute failed: La table 'ceca.subject__rindex' n'existe pas at bin/epadmin line 2769, <STDIN> line 1.
DBD::mysql::st fetch failed: fetch() without execute() at bin/epadmin line 2770, <STDIN> line 1.
DBD::mysql::db do failed: La table 'ceca.subject__rindex' n'existe pas at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3052, <STDIN> line 1.
SQL ERROR (do): ALTER IGNORE TABLE subject__rindex MODIFY field VARCHAR(64) CHARACTER SET UTF8, MODIFY word VARCHAR(128) CHARACTER SET UTF8, DEFAULT CHARACTER SET UTF8, ADD PRIMARY KEY(field,word,`subjectid`)
SQL ERROR (do): La table 'ceca.subject__rindex' n'existe pas (#1146)
Upgrading dataset message
Upgrading dataset import
Upgrading dataset event_queue
Upgrading dataset cachemap
Upgrading dataset triple
Upgrading dataset metafield

------------------------------------------------------------------
---------------- EPrints System Error ----------------------------
------------------------------------------------------------------
An unexpected error occurred while attempting to convert tables to UTF-8.

------------------------------------------------------------------
EPrints System Error inducing stack dump
 at /usr/share/eprints3/bin/../perl_lib/EPrints.pm line 147
        EPrints::abort() called at bin/epadmin line 2753
        main::upgrade_mysql_charset('EPrints::Repository=HASH(0x9c8d284)', 'EPrints::Database::mysql=HASH(0xb8a35b8)') called at bin/epadmin line 3008
        main::upgrade_3_1_2_to_3_2_0('EPrints::Repository=HASH(0x9c8d284)', 'EPrints::Database::mysql=HASH(0xb8a35b8)') called at bin/epadmin line 2887
        main::upgrade('ceca') called at bin/epadmin line 320
eprints@ceca:~$ 


==> relancer plusieurs fois l'upgrade, ça finit par aller jusqu'où bout malgré les erreurs

CONCLUSION : on laisse tomber. Ce serveur restera en l'état !

ZA/Montréal/MigrationJessie/Ceca (dernière édition le 2016-03-08 21:19:57 par MoussaNombre)