Upgrade failed 6.0.6 > 6.3.2 or 6.2.5 On Raspberry Pi : sqlite3_exec failed: table EmailUser


#1

Hello All, After upgrade seafile 6.0.6 to 6.3.2 or 6.2.5. Seafile not running.

août 05 21:12:37 raspiserver seafile.sh[12540]: failed to run “ccnet-server -t”
août 05 21:12:37 raspiserver seafile.sh[12540]: [08/05/18 21:12:37] …/common/session.c(132): using config file /opt/seafile/conf/ccnet.conf
août 05 21:12:37 raspiserver seafile.sh[12540]: [08/05/18 21:12:37] …/common/ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS
août 05 21:12:37 raspiserver systemd[1]: seafile.service: main process exited, code=exited, status=1/FAILURE
août 05 21:12:37 raspiserver systemd[1]: Failed to start Seafile server.
– Subject: L’unité (unit) seafile.service a échoué
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– L’unité (unit) seafile.service a échoué, avec le résultat failed.
août 05 21:12:37 raspiserver systemd[1]: Unit seafile.service entered failed state.
août 05 21:12:37 raspiserver sudo[12534]: pam_unix(sudo:session): session closed for user root
août 05 21:12:50 raspiserver sudo[12576]: pi : TTY=pts/0 ; PWD=/opt/seafile ; USER=root ; COMMAND=/bin/journalctl -xn
août 05 21:12:50 raspiserver sudo[12576]: pam_unix(sudo:session): session opened for user root by pi(uid=0)

seafile@raspiserver:/opt/seafile/seafile-server-6.2.5 $ ./seafile.sh start
[08/05/18 21:17:50] …/common/session.c(132): using config file /opt/seafile/conf/ccnet.conf
[08/05/18 21:17:51] …/common/ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS reference_id_index on EmailUser (reference_id): sqlite3_exec failed: table EmailUser has no column named reference_id.
ccnet-db.c(142): Error exec query CREATE UNIQUE INDEX IF NOT EXISTS reference_id_index on EmailUser (reference_id): sqlite3_exec failed: table EmailUser has no column named reference_id.

Do you have a solution for this problem?

Thanks


#2

Did you try to upgrade to 6.1.x first and after this to 6.2.x and so on?

You have to upgrade each version step by step.


#3

I will do it in the next few days. I give you the status


#4

Upgrade to 6.1.2 with success. I’m testing few day after next upgrade to 6.2. Thanks


#5

Upgrade to 6.2.5 with success. My Android client 2.2.2 and next cant not upload file. The 2.2.1 version upload whith success. Please help me.

My nginx config


server {
listen 8001;
server_name localhost;
ssl on;
ssl_certificate /etc/nginx/ssl/seahub.crt;
ssl_certificate_key /etc/nginx/ssl/seahub.key;
ssl_session_timeout 5m;
ssl_protocols TLSv1.2;
ssl_ciphers ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+EXP;
ssl_prefer_server_ciphers on;
location / {
fastcgi_pass 127.0.0.1:8000;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $fastcgi_script_name;
fastcgi_param SERVER_PROTOCOL $server_protocol;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SERVER_ADDR $server_addr;
fastcgi_param SERVER_PORT $server_port;
fastcgi_param SERVER_NAME $server_name;
fastcgi_param HTTPS on;
fastcgi_param HTTP_SCHEME https;

        access_log      /var/log/nginx/access.log;
        error_log       /var/log/nginx/error.log;
    }
    location /seafhttp {
        rewrite ^/seafhttp(.*)$ $1 break;
        proxy_pass http://127.0.0.1:8082;
        client_max_body_size 0;
        proxy_connect_timeout  36000s;
        proxy_read_timeout  36000s;
    }
    location /media {
        root /opt/seafile/seafile-server-latest/seahub;
    }

}


#6

That’s a bug in version 2.2.2/3. Use either 2.2.1 or 2.2.4.


#7

I have a bug on 2.2.2 2.2.3 and 2.2.4. I’m wating a new version. Thanks