aqueduct db upgrade gives range error : Invalid value: Not in inclusive range 0..1114111: -1

[91priyansh]

**** Stacktrace

• #0 StringBuffer.writeCharCode (dart:core-patch/string_buffer_patch.dart:74:9)
• Build authentication adapter #1 PostgreSQLFormat.substitute (package:postgres/src/substituter.dart:83:29)
• Ensure application startup completes across isolates #2 Query.sendExtended (package:postgres/src/query.dart:61:38)
• Documentation for application, controllers, router #3 _PostgreSQLConnectionStateIdle.processQuery (package:postgres/src/connection_fsm.dart:182:9)
• Allow resource controller endpoints to take query params as optional arguments #4 _PostgreSQLConnectionStateIdle.awake (package:postgres/src/connection_fsm.dart:168:14)
• Ensure that path parameters from the router are parsed into the type the handler expects #5 _PostgreSQLExecutionContextMixin._enqueue (package:postgres/src/connection.dart:399:67)
• Create API documentation intermediate file format #6 _PostgreSQLExecutionContextMixin.query (package:postgres/src/connection.dart:318:12)
• Integrate code coverage tool for tests #7 PostgreSQLPersistentStore.execute (package:aqueduct/src/db/postgresql/postgresql_persistent_store.dart:153:37)
• Create Postman file from intermediate documentation #8 PostgreSQLPersistentStore.schemaVersion (package:aqueduct/src/db/postgresql/postgresql_persistent_store.dart:216:26)
• Create Swagger API specification generated from intermediate format #9 CLIDatabaseUpgrade.handle (package:aqueduct/src/cli/commands/db_upgrade.dart:28:52)
• Write guide for monadart  #10 CLICommand.process (package:aqueduct/src/cli/command.dart:159:20)
• Allow closures or find better way to add context to REsourceRequests in ApplicationPipeline #11 CLICommand.process (package:aqueduct/src/cli/command.dart:135:12)
• Allow HttpController methods to parse path better #12 CLICommand.process (package:aqueduct/src/cli/command.dart:135:12)
• Add RouteMatch class to encapsulate information from a Router match #13 main (file:///C:/Users/DELL/AppData/Roaming/Pub/Cache/hosted/pub.dartlang.org/aqueduct-3.3.0+1/bin/aqueduct.dart:9:27)
• A big cleanup #14 _startIsolate. (dart:isolate-patch/isolate_patch.dart:299:32)
• Fixed null pipelineOptions bug #15 _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:168:12)

---

Dart version is 2.10.5 (stable)

[maulaniad]

#844 (comment)

this worked for me

[ali-thowfeek]

#844 (comment)

this worked for me

That is:
dart pub run aqueduct db upgrade

For some reason i cant generate more than one migration file, so i had to delete the old one and generate new migration file each time. Also had to reset the whole database before running the upgrade command. I hope this benefits you.