Почему мой сервер 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 ответов

А пока вам нужно бежатьsetup-tables.cmdвручную в Windows.

После ввода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
Другие вопросы по тегам