Почему мой сервер serverpod не работает должным образом
Работа с Win11 Pro Education.
После запуска моего док-контейнера выполните команду docker-compose up --build --detach.
Я попробовал и получил следующее
Kojo Mensah@DESKTOP-RJUJLBG MINGW64 /c/src/flutter projects/serverpod/e_commerce/e_commerce_server
$ dart bin/main.dart
SERVERPOD version: 1.0.1 mode: development time: 2023-03-21 20:01:14.906344Z
2023-03-21 20:01:17.667254Z Failed to connect to database.
PostgreSQLSeverity.error 42P01: relation "serverpod_runtime_settings" does not exist
package:postgres/src/connection.dart 514:18 _PostgreSQLExecutionContextMixin._query
package:postgres/src/connection.dart 475:7 _PostgreSQLExecutionContextMixin.query
package:postgres/src/connection.dart 543:22 _PostgreSQLExecutionContextMixin.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 820:23 _PgExecutionContextWrapper.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 746:27 _PgExecutionContextWrapper._run
package:postgres_pool/postgres_pool.dart 819:12 _PgExecutionContextWrapper.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 661:16 PgPool.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 352:22 PgPool.run.<fn>.<fn>
package:postgres_pool/postgres_pool.dart 451:27 PgPool._useOrCreate
package:postgres_pool/postgres_pool.dart 423:14 PgPool._withConnection.<fn>
package:executor/src/executor_impl.dart 61:19 _Executor.scheduleTask
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 171:20 DatabaseConnection.find
package:serverpod/src/database/database_connection.dart 199:18 DatabaseConnection.findSingleRow
package:serverpod/src/database/database.dart 86:12 Database.findSingleRow
package:serverpod/src/server/serverpod.dart 310:13 Serverpod.start.<fn>
package:serverpod/src/server/serverpod.dart 299:5 Serverpod.start
package:e_commerce_server/server.dart 33:3 run
===== asynchronous gap ===========================
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 171:20 DatabaseConnection.find
package:serverpod/src/database/database_connection.dart 199:18 DatabaseConnection.findSingleRow
package:serverpod/src/database/database.dart 86:12 Database.findSingleRow
package:serverpod/src/server/serverpod.dart 310:13 Serverpod.start.<fn>
package:serverpod/src/server/serverpod.dart 299:5 Serverpod.start
package:e_commerce_server/server.dart 33:3 run
2023-03-21 20:01:19.584865Z Internal server error. Failed to load method lookup.
PostgreSQLSeverity.error 42P01: relation "serverpod_method" does not exist
package:postgres/src/connection.dart 514:18 _PostgreSQLExecutionContextMixin._query
package:postgres/src/connection.dart 475:7 _PostgreSQLExecutionContextMixin.query
package:postgres/src/connection.dart 543:22 _PostgreSQLExecutionContextMixin.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 820:23 _PgExecutionContextWrapper.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 746:27 _PgExecutionContextWrapper._run
package:postgres_pool/postgres_pool.dart 819:12 _PgExecutionContextWrapper.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 661:16 PgPool.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 352:22 PgPool.run.<fn>.<fn>
package:postgres_pool/postgres_pool.dart 451:27 PgPool._useOrCreate
package:postgres_pool/postgres_pool.dart 423:14 PgPool._withConnection.<fn>
package:executor/src/executor_impl.dart 61:19 _Executor.scheduleTask
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 171:20 DatabaseConnection.find
package:serverpod/src/database/database_connection.dart 199:18 DatabaseConnection.findSingleRow
package:serverpod/src/database/database.dart 86:12 Database.findSingleRow
package:serverpod/src/server/method_lookup.dart 47:26 MethodLookup._attemptLoad
package:serverpod/src/server/method_lookup.dart 30:7 MethodLookup.load
package:serverpod/src/server/serverpod.dart 325:9 Serverpod.start.<fn>
package:serverpod/src/server/serverpod.dart 299:5 Serverpod.start
package:e_commerce_server/server.dart 33:3 run
===== asynchronous gap ===========================
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 171:20 DatabaseConnection.find
package:serverpod/src/database/database_connection.dart 199:18 DatabaseConnection.findSingleRow
package:serverpod/src/database/database.dart 86:12 Database.findSingleRow
package:serverpod/src/server/method_lookup.dart 47:26 MethodLookup._attemptLoad
package:serverpod/src/server/method_lookup.dart 30:7 MethodLookup.load
package:serverpod/src/server/serverpod.dart 325:9 Serverpod.start.<fn>
package:serverpod/src/server/serverpod.dart 299:5 Serverpod.start
package:e_commerce_server/server.dart 33:3 run
Insights listening on port 8081
Server default listening on port 8080
Webserver listening on port 8082
CPU and memory usage metrics are not supported on this platform.
2023-03-21 20:01:21.310528Z Internal server error. Failed to connect to database in future call manager.
PostgreSQLSeverity.error 42P01: relation "serverpod_future_call" does not exist
package:postgres/src/connection.dart 514:18 _PostgreSQLExecutionContextMixin._query
package:postgres/src/connection.dart 475:7 _PostgreSQLExecutionContextMixin.query
package:postgres/src/connection.dart 543:22 _PostgreSQLExecutionContextMixin.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 820:23 _PgExecutionContextWrapper.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 746:27 _PgExecutionContextWrapper._run
package:postgres_pool/postgres_pool.dart 819:12 _PgExecutionContextWrapper.mappedResultsQuery
package:postgres_pool/postgres_pool.dart 661:16 PgPool.mappedResultsQuery.<fn>
package:postgres_pool/postgres_pool.dart 352:22 PgPool.run.<fn>.<fn>
package:postgres_pool/postgres_pool.dart 451:27 PgPool._useOrCreate
package:postgres_pool/postgres_pool.dart 423:14 PgPool._withConnection.<fn>
package:executor/src/executor_impl.dart 61:19 _Executor.scheduleTask
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 443:20 DatabaseConnection.deleteAndReturn
package:serverpod/src/database/database.dart 166:12 Database.deleteAndReturn
package:serverpod/src/server/future_call_manager.dart 100:18 FutureCallManager._checkQueue
===== asynchronous gap ===========================
package:postgres_pool/postgres_pool.dart 351:18 PgPool.run.<fn>
package:retry/retry.dart 131:16 RetryOptions.retry
package:postgres_pool/postgres_pool.dart 349:14 PgPool.run
package:serverpod/src/database/database_connection.dart 443:20 DatabaseConnection.deleteAndReturn
package:serverpod/src/database/database.dart 166:12 Database.deleteAndReturn
package:serverpod/src/server/future_call_manager.dart 100:18 FutureCallManager._checkQueue
Local stacktrace:
#0 FutureCallManager._checkQueue (package:serverpod/src/server/future_call_manager.dart:136:36)
<asynchronous suspension>
Ожидается: версия SERVERPOD: 1.xx, режим: разработка, время: 2022-09-12 17:22:02.825468Z Insights прослушивает порт 8081. Сервер по умолчанию прослушивает порт 8080. Веб-сервер прослушивает порт 8082.
За ожидаемым сообщением следует несколько сообщений.
5 ответов
После вводаdocker-compose up --build --detach
в cmd вам просто нужно ввести следующую команду:.\setup-tables
.
Точно следуйте этим шагам, и проекты будут успешными. В Windows вам следует вручную создать таблицы базы данных, как в шаге 2. Посмотрите это видео, чтобы четко описать это: https://youtu.be/BQ6JQbp2Xy0 .
cd .\demoserverpod\demoserverpod_server\ (your server path)
.\setup-tables.cmd
docker compose up --build --detach
dart .\bin\main.dart
Запустите эту команду в своем серверном проекте:
.\setup-tables.cmd
затем
docker-compose up --build --detach
dart bin/main.dart
Запустите эти команды в следующем порядке:
serverpod create mypod
cd mypod/mypod_server
setup-tables.cmd
docker compose down -v
setup-tables.cmd
docker compose up --build --detach
dart bin/main.dart