pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

SIMPLE-ERROR: not supported type SYB-MSUDT

Open TooComplex opened this issue 3 years ago • 1 comments

  • [x] pgloader --version

    pgloader version "3.6.9"
    compiled with SBCL 2.0.1.debian
    
    
  • [x] did you test a fresh compile from the source tree?

    Yes, I've tested, but still not working

  • [x] did you search for other similar issues?

    Yes, I searched a lot, but not found any error like this

  • [x] how can I reproduce the bug?

    Just download the free MS SQL database from Microsoft: AdventureWorks2019, restore it, and try migrate it from a MS SQL server. https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms


LOAD DATABASE
FROM mssql://***:***@***:1433/AdventureWorks2019
INTO postgresql://***:***@***:5432/***

WITH include drop, create tables, no truncate,
      create indexes, reset sequences, foreign keys

CAST type udt to text drop default drop not null

before load do $$ drop schema if exists dbo cascade; $$
;

  • [x] pgloader output you obtain
......

SIMPLE-ERROR: not supported type SYB-MSUDT
An unhandled error condition has been signalled: not supported type SYB-MSUDT




What I am doing here?

not supported type SYB-MSUDT

pgloader: mem.c:1202: tds_free_connection: Assertion `conn->in_net_tds == NULL' failed.
fatal error encountered in SBCL pid 3117709(tid 0x7efc9d84f700):
SIGABRT received.

Welcome to LDB, a low-level debugger for the Lisp runtime environment.
ldb>


  • [x] data that is being loaded, if relevant
  No data loaded
  • [ ] How the data is different from what you expected, if relevant

TooComplex avatar Nov 06 '22 04:11 TooComplex

HI @TooComplex.

Have you found a solution for this?

PeaceDeveloper avatar Aug 13 '24 13:08 PeaceDeveloper