SQL errors when upgrading from 5.0.4 to 8.0.5

I managed to migrate a 5.0.4 deployment’s data in a 8.0.5 deployment that is facilitated with Docker (all Community Edition). So far everything seems to work as expected. But starting from the 6.1 to 6.2 upgrade scripts there were a variety of SQL errors logged.

I’d appreciate if someone of the developers could have a look at it (search for Failed to execute sql) and share his assessment whether these are serious errors.

Attaching to seafile_seafile_1
*** Running /etc/my_init.d/01_create_data_links.sh...
*** Booting runit daemon...
*** Runit started as PID 22
*** Running /scripts/start.py...
waiting for mysql server to be ready: %s (2003, "Can't connect to MySQL server on 'db' ([Errno 111] Connection refused)")
[06/16/2021 12:14:10][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_5.0_5.1.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 5.0 to 5.1
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating seafile database...
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:12][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_5.1_6.0.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 5.1 to 6.0
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:14][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_6.0_6.1.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 6.0 to 6.1
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:15][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_6.1_6.2.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 6.1 to 6.2
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
*** Running /etc/my_init.d/01_create_data_links.sh...
*** Booting runit daemon...
*** Runit started as PID 22
*** Running /scripts/start.py...
[06/16/2021 12:14:18][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_6.1_6.2.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 6.1 to 6.2
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating ccnet database...
e[1;32m[WARNING] e[mFailed to execute sql: (1060, "Duplicate column name 'reference_id'")
e[1;32m[WARNING] e[mFailed to execute sql: (1060, "Duplicate column name 'reference_id'")
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:21][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_6.2_6.3.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 6.2 to 6.3
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating ccnet database...
e[1;32m[WARNING] e[mFailed to execute sql: (1091, "Can't DROP INDEX `PRIMARY`; check that it exists")
e[1;32m[INFO] e[mupdating seafile database...
e[1;32m[WARNING] e[mFailed to execute sql: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
e[1;32m[WARNING] e[mFailed to execute sql: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:44][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_6.3_7.0.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 6.3 to 7.0
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating ccnet database...
e[1;32m[INFO] e[mupdating seafile database...
e[1;32m[INFO] e[mupdating seahub database...
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.FileOpsStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.FileOpsStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
e[1;32m[WARNING] e[mFailed to execute sql: (1051, "Unknown table 'seahub-db.UserTrafficStat'")
e[1;32m[WARNING] e[mFailed to execute sql: (1091, "Can't DROP INDEX `profile_profile_contact_email_0975e4bf_uniq`; check that it exists")
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:47][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_7.0_7.1.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 7.0 to 7.1
Press [ENTER] to contiune
-------------------------------------------------------------
renaming the gunicorn.conf to gunicorn.conf.py ...
Done
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating seahub database...
e[1;32m[WARNING] e[mFailed to execute sql: (1091, "Can't DROP INDEX `drafts_draft_origin_file_uuid_7c003c98_uniq`; check that it exists")
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
[06/16/2021 12:14:48][upgrade]: Running script /opt/seafile/seafile-server-8.0.5/upgrade/upgrade_7.1_8.0.sh
-------------------------------------------------------------
This script would upgrade your seafile server from 7.1 to 8.0
Press [ENTER] to contiune
-------------------------------------------------------------
Updating seafile/seahub database ...
e[1;32m[INFO] e[mYou are using MySQL
e[1;32m[INFO] e[mupdating seahub database...
Done
migrating avatars ...
Done
updating e[33m/opt/seafile/seafile-server-lateste[m symbolic link to e[33m/opt/seafile/seafile-server-8.0.5e[m ...
-----------------------------------------------------------------
Upgraded your seafile server successfully.
-----------------------------------------------------------------
Starting seafile server, please wait ...
** Message: 12:14:49.118: seafile-controller.c(536): No seafevents.
Seafile server started
Done.
Starting seahub at port 8000 ...
Seahub is started
Done.