panic: strconv.ParseUint: parsing "9999999999999999999999999999": value out of range
Hi Team,
I have issued with inspect
09:13:27 DEBUG Read project. status=initialized path=/opt/pg_migrate-v1.0.0-beta.2/erp driver=oracle online=true 09:13:27 DEBUG Cache miss. name=Source 09:13:27 DEBUG Cache miss. name=Target 09:13:27 INFO Opening database connection pool. key=source driver=oracle dsn=or:erp@10.168.38.64/erp 09:13:27 INFO Connecting to database. key=source count=1 09:13:27 DEBUG Released database connexion. key=source usage=0/1 09:13:27 INFO Inspecting source database. driver=oracle 09:13:27 INFO This may take some time. 09:13:27 DEBUG Reusing connection to database. key=source idle=1 09:13:27 DEBUG Querying schemas. 09:13:27 DEBUG Inspected schemas. count=14 duration=676.657µs 09:13:27 INFO Connecting to database. key=source count=2 09:13:27 DEBUG Released database connexion. key=source usage=1/2 09:13:27 DEBUG Reusing connection to database. key=source idle=1 09:13:27 DEBUG Querying views. 09:13:27 INFO Connecting to database. key=source count=3 09:13:27 DEBUG Querying nls-database. 09:13:27 DEBUG Inspected nls-database. count=20 duration=1.420763ms 09:13:27 DEBUG Querying nls-session. 09:13:27 DEBUG Inspected nls-session. count=17 duration=453.646µs 09:13:27 DEBUG Querying v-parameters. 09:13:27 DEBUG Inspected v-parameters. count=343 duration=21.181572ms 09:13:27 INFO Inspected metadada. software="Oracle Database 19c Enterprise Edition " 09:13:27 DEBUG Querying routines. 09:13:27 INFO Connecting to database. key=source count=4 09:13:27 DEBUG Querying tables. 09:13:27 DEBUG Querying roles. 09:13:27 DEBUG Inspected roles. count=15 duration=5.006653ms 09:13:27 INFO Found roles. count=15 09:13:27 DEBUG Querying sequences. 09:13:27 DEBUG Inspected views. count=136 duration=456.37959ms 09:13:27 INFO Found views. count=136 09:13:27 DEBUG Querying materialized-views. 09:13:27 DEBUG Inspected materialized-views. count=0 duration=2.209089ms 09:13:27 DEBUG Done inspecting views. 09:13:27 DEBUG Released database connexion. key=source usage=3/4 09:13:28 DEBUG Inspected tables. count=9004 duration=1.10424394s 09:13:28 INFO Found tables. count=9004 09:13:28 DEBUG Reusing connection to database. key=source idle=1 09:13:28 DEBUG Querying partitions. 09:13:28 INFO Connecting to database. key=source count=5 09:13:28 DEBUG Querying columns. 09:13:28 DEBUG Querying tables-indexes. 09:13:28 INFO Connecting to database. key=source count=6 09:13:28 DEBUG Querying keys. 09:13:29 DEBUG Inspected partitions. count=2777 duration=238.335714ms 09:13:29 INFO Found table partitions. count=2777 09:13:29 DEBUG Querying subpartitions. 09:13:29 DEBUG Inspected keys. count=4319 duration=461.774962ms 09:13:29 INFO Found tables keys. count=4319 09:13:29 DEBUG Querying foreign-keys. 09:13:29 DEBUG Inspected foreign-keys. count=136 duration=19.580712ms 09:13:29 INFO Found foreign keys. count=136 09:13:29 DEBUG Querying checks. 09:13:29 DEBUG Inspected subpartitions. count=6037 duration=286.254361ms 09:13:29 INFO Found table subpartitions. count=6037 09:13:29 DEBUG Released database connexion. key=source usage=5/6 09:13:30 DEBUG Inspected checks. count=28 duration=646.157191ms 09:13:30 INFO Found tables checks. count=28 09:13:30 DEBUG Released database connexion. key=source usage=4/6 09:13:30 DEBUG Inspected sequences. count=287705 duration=407.617618ms 09:13:30 INFO Found sequences. count=287705 09:13:30 DEBUG Querying types. 09:13:30 DEBUG Inspected types. count=21 duration=71.577839ms 09:13:30 INFO Found user types. count=21 09:13:30 DEBUG Querying dblinks. 09:13:30 DEBUG Inspected dblinks. count=0 duration=585.635µs 09:13:30 DEBUG Querying synonyms. 09:13:30 DEBUG Inspected synonyms. count=0 duration=26.048858ms 09:13:30 DEBUG Querying jobs. 09:13:30 DEBUG Inspected jobs. count=0 duration=735.033µs 09:13:30 DEBUG Querying scheduler. 09:13:30 DEBUG Inspected scheduler. count=0 duration=1.367909ms 09:13:30 DEBUG Done inspecting objects. 09:13:30 DEBUG Released database connexion. key=source usage=3/6 09:13:31
DEBUG Inspected tables-indexes. count=2949 duration=2.450326577s 09:13:31 DEBUG Querying tables-indexes-columns. 09:13:33
DEBUG Inspected tables-indexes-columns. count=3588 duration=1.709415441s 09:13:33 INFO Found tables indexes. count=2949 09:13:33
DEBUG Released database connexion. key=source usage=2/6 09:13:34 DEBUG Inspected columns. count=114290 duration=4.508562997s 09:13:34
DEBUG Querying identities. 09:13:34 DEBUG Inspected identities. count=230 duration=231.684632ms 09:13:34 DEBUG Done inspecting tables. 09:13:34 DEBUG Released database connexion. key=source usage=1/6 09:13:52
DEBUG Inspected routines. count=28366 duration=15.096844423s 09:13:54 INFO Extracted package functions. package="PACKAGE ENCRYPT_CONVERT" count=2 09:13:55 DEBUG Disambiguate DECLARE followed by new line as nested block. source= pos=+3:2 09:13:55 DEBUG Remove new line after DECLARE to consider it as a variable declaration. 09:13:56 DEBUG Disambiguate DECLARE followed by new line as nested block. source= pos=+6:0 09:13:56 DEBUG Remove new line after DECLARE to consider it as a variable declaration. 09:13:56 DEBUG Disambiguate DECLARE followed by new line as nested block. source= pos=+150:0 09:13:56 DEBUG Remove new line after DECLARE to consider it as a variable declaration. routines: processing... 50 % ████████████████████████████████████████████▓░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ 24s panic: strconv.ParseUint: parsing "9999999999999999999999999999": value out of range
goroutine 29 \[running\]: gitlab.com/dalibo/transqlate/lexer.(\*Token).Normalize(0xc0115fd470)
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/lexer/token.go:171 +0x42d
gitlab.com/dalibo/transqlate/parser.(\*state).lexAll(0xc022e35a00)
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/parser/state.go:38 +0xe9
gitlab.com/dalibo/transqlate/parser.(\*state).parse(0xc022e35a00)
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/parser/state.go:26 +0x18
gitlab.com/dalibo/transqlate/parser.Parse(...)
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/parser/parser.go:12
gitlab.com/dalibo/transqlate/oracle.parse({0xf15548, 0x9}, {0xc0380c0000, 0x152f4c})
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/oracle/translate.go:146 +0xea
gitlab.com/dalibo/transqlate/rewrite.Engine.Parse(...)
/root/go/pkg/mod/gitlab.com/dalibo/transqlate@v0.6.5/rewrite/engine.go:106
gitlab.com/dalibo/pg_migrate/internal/oracle.parseSignature({0xd9cea0, 0xc027203e70})
/opt/pg_migrate-v1.0.0-beta.2/internal/oracle/routines.go:213 +0xed
gitlab.com/dalibo/pg_migrate/internal/oracle.(\*model).inspectRoutines(0xc000270c88, {0x108f6f0?, 0xc00013c140?})
/opt/pg_migrate-v1.0.0-beta.2/internal/oracle/routines.go:66 +0xe45
gitlab.com/dalibo/pg_migrate/internal/oracle.(\*model).Inspect.func3({0x108f6f0?, 0xc00013c140?}, 0x0?)
/opt/pg_migrate-v1.0.0-beta.2/internal/oracle/inspect.go:64 +0x33 github.com/arunsworld/nursery.runJobsUntilAllDone.func1(0x0?)
/root/go/pkg/mod/github.com/arunsworld/nursery@v0.6.0/nursery.go:149 +0x2e created by github.com/arunsworld/nursery.runJobsUntilAllDone in goroutine 23
/root/go/pkg/mod/github.com/arunsworld/nursery@v0.6.0/nursery.go:148 +0x4f
Regards,
Son
Edited by Étienne BERSAC