Working with win11 pro education.
After running my dockor container, docker-compose up –build –detach.
I tried and had the below
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>
Expected: SERVERPOD version: 1.x.x, mode: development, time: 2022-09-12 17:22:02.825468Z Insights listening on port 8081 Server default listening on port 8080 Webserver listening on port 8082
The expected message comes followed by some bunch of messages.
3
Answers
For now, you have to run
setup-tables.cmd
manually on Windows.Follow these steps accurately ,projects run successfully.
In windows you should manualy create database tables as in step 2
See this video describe it clearly: https://youtu.be/BQ6JQbp2Xy0
Run this command in your server project:
then