Got MySQL warnings when upgraded from 6.3 to 7.0

server

#1

I upgraded from 6.3 to 7.0 and got the following errors. Any idea why this happens?

[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.TotalStorageStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.FileOpsStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.FileOpsStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
[WARNING] Failed to execute sql: (1146, "Table 'seahub-db.UserActivityStat' doesn't exist")
[WARNING] Failed to execute sql: (1051, "Unknown table 'seahub-db.UserTrafficStat'")
[WARNING] Failed to execute sql: (1091, "Can't DROP 'profile_profile_contact_email_0975e4bf_uniq'; check that column/key exists")

Seafile pro edition 7.0.2 beta is ready for testing!
#2

I can confirm these warnings, except for the last line.
A quick grep through the seahub and seafile-server sources does not show any mentions of the UserActivityStat table earlier than in the 6.3->7.0 migration, making it unlikely that this issue is due to me having missed out on a database migration in the past.

I’m using the community edition btw.


#3

Same problem:

Updating seafile/seahub database …

[INFO] You are using MySQL
[INFO] updating ccnet database…
[INFO] updating seafile database…
[INFO] updating seahub database…
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.FileOpsStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.FileOpsStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seafile_seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1051, “Unknown table ‘seafile_seahub-db.UserTrafficStat’”)
[WARNING] Failed to execute sql: (1091, “Can’t DROP ‘profile_profile_contact_email_0975e4bf_uniq’; check that column/key exists”)
Done


#4

Same Problem here when upgrading 6.3.4 to 7.0.2 (which is not marked beta :wink: )


This script would upgrade your seafile server from 6.3 to 7.0
Press [ENTER] to contiune

Updating seafile/seahub database …

[INFO] You are using MySQL
[INFO] updating ccnet database…
[INFO] updating seafile database…
[INFO] updating seahub database…
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.TotalStorageStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.FileOpsStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.FileOpsStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1146, “Table ‘seahub-db.UserActivityStat’ doesn’t exist”)
[WARNING] Failed to execute sql: (1051, “Unknown table ‘seahub-db.UserTrafficStat’”)
[WARNING] Failed to execute sql: (1091, “Can’t DROP ‘profile_profile_contact_email_0975e4bf_uniq’; check that column/key exists”)
Done

Is this anything to be concerned about?


Seafile server 7.0 is ready! (Including the CE and PRO edition)
#5

Just updated from 6.3.4 to 7.0.2 and I have the same messages, but everything seems to be working fine…


#6

got the same warnings…

everything seems to be working though