Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error migrate from ms sql to postgres #1512

Closed
dimkadv2 opened this issue Jul 24, 2023 · 1 comment
Closed

error migrate from ms sql to postgres #1512

dimkadv2 opened this issue Jul 24, 2023 · 1 comment

Comments

@dimkadv2
Copy link

dimkadv2 commented Jul 24, 2023

Hi, Dmitriy!

i am trying to convert from MS SQL to Postgres, and I get the following errors:

22: ((LAMBDA NIL :IN LPARALLEL.KERNEL::MAKE-WORKER-THREAD))
23: ((LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS))
24: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
25: ((FLET "WITHOUT-INTERRUPTS-BODY-11" :IN SB-THREAD::RUN))
26: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
27: ((FLET "WITHOUT-INTERRUPTS-BODY-4" :IN SB-THREAD::RUN))
28: (SB-THREAD::RUN)
29: ("foreign function: call_into_lisp_")
30: ("foreign function: funcall1")

2023-07-24T10:38:40.259393Z NOTICE COPY adress.settlement_type with 0 rows estimated [3/4]
2023-07-24T10:38:40.259660Z DEBUG Reader started for adress.settlement_type
2023-07-24T10:38:40.260177Z DEBUG start adress.settlement_type   15569096
2023-07-24T10:38:40.260311Z INFO Stopping monitor

What I am doing here?

The value
  #.(SB-SYS:INT-SAP #X7F4FF801C898)
is not of type
  VECTOR

Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN
Max connections reached, increase value of TDS_MAX_CONN

the error always happens on the table Adress.SettlementType (what is remarkable - this table contains only 9 rows)

my config file:

LOAD DATABASE
    FROM mssql://***
    INTO pgsql://***

WITH snake_case identifiers, create tables, create indexes, create schemas, include drop, foreign keys, reset sequences, batch rows = 500

SET work_mem to '256MB', maintenance_work_mem to '512 MB'

BEFORE LOAD DO
    $$ CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; $$
;

my freedts config file:


[global]
	tds version = 7.4
	client charset = UTF-8

full log:
pgloader.zip

what am I doing wrong?

@dimkadv2
Copy link
Author

it turned out that the problem is in my ignorance of the Unix device of similar systems, I created my driver file along the path "~/"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant