#Issues updating Self hosted from 1.4.13 to 1.6.2

15 messages · Page 1 of 1 (latest)

dull maple
#

I am upgrading my selfhosted environment from 1.4.13 to 1.6.2, I got all the containers running, when I run migrate I get

Migrating Collection authenticators:
Failed to update project ("MySpoons") version with error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._1_' doesn't exist

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._1_' doesn't exist in @swoole/library/core/Database/PDOStatementProxy.php:49
Stack trace:
#0 @swoole/library/core/Database/PDOStatementProxy.php(49): PDOStatement->execute()
#1 /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php(1926): Swoole\Database\PDOStatementProxy->__call('execute', Array)
#2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(5952): Utopia\Database\Adapter\MariaDB->count('', Array, NULL)
#3 /usr/src/code/vendor/utopia-php/database/src/Database/Validator/Authorization.php(166): Utopia\Database\Database->Utopia\Database\{closure}()
#4 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(5953): Utopia\Database\Validator\Authorization::skip(Object(Closure))
#5 /usr/src/code/src/Appwrite/Migration/Migration.php(215): Utopia\Database\Database->count(Object(Utopia\Database\Document))
#6 /usr/src/code/src/Appwrite/Migration/Migration.php(180): Appwrite\Migration\Migration->documentsIterator('authenticators')
#7 /usr/src/code/src/Appwrite/Migration/Version/V21.php(43): Appwrite\Migration\Migration->forEachDocument(Array)
#8 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(125): Appwrite\Migration\Version\V21->execute()
#9 /usr/src/code/src/Appwrite/Platform/Tasks/Migrate.php(38): Appwrite\Platform\Tasks\Migrate->action('1.6.2', Object(Utopia\Database\Database), Object(Closure), Object(Utopia\Registry\Registry))
#10 [internal function]: Appwrite\Platform\Tasks\Migrate->Appwrite\Platform\Tasks\{closure}()
#11 {main}
  thrown in @swoole/library/core/Database/PDOStatementProxy.php on line 49
#

Issues updating Self hosted from 1.4.13 to 1.6.2

#

Oh, might be because i jumped too far? I didn't step it through, i jumped straight to latest

dull maple
#

I think that is the issue, now the question is, how can i fix this without a restore?

verbal osprey
#

i think you should go to 1.5.0 then i guess its 1.5.11 then 1.6.0 then 1.6.2 with migration in each version.

#

comfirm with github what are major updates

frozen hearth
frozen hearth
verbal osprey
dull maple
#

Okay, so i restored my backup, ran the upgrade to 1.5.0
and now Traefik & worker-usage are failing to start

Error response from daemon: failed to create task for container: failed to create shim task: OCI runtime create failed: runc create failed: unable to start container process: exec: "usage": executable file not found in $PATH: unknown
dull maple
#

looks like it is working with 1.5.1

coarse ivy
dull maple
#

Updated from 1.5.11 (after migrate) to 1.6.2 and migrate is still failing

Migrating Collection deployments:
Failed to update project ("ejds") version with error: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
coarse ivy
dull maple
#

yes I did, and i stepped it through, 1.4.13 > 1.5.1 > 1.5.11 > 1.6.2