Error mysql 76 fell through ecase expression

Содержание

1. ECASE error for utf8mb4_0900_xx #913
2. Comments
3. FATAL error: 76 fell through ECASE expression. #1211
4. Comments
5. Fatal error from latest docker with: pgloader SOURCE TARGET #760
6. Comments
7. pgloader 10 fell through ECASE expression #1183
8. Comments
9. ERROR :WAITING-FOR-NEXT fell through ECASE expression #313
10. Comments

I think I can make part of the log available here.

2019-05-26T15:24:27.313000Z SQL MySQL: sending query: SELECT `id`, `name` FROM `auth_group`
2019-05-26T15:24:27.363000Z ERROR A thread failed with error: 255 fell through ECASE expression.
                            Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21
                                           23 27 28 30 31 32 33 35 41 42 45 46
                                           47 48 49 50 51 52 54 55 56 60 61 62
                                           63 64 65 69 72 76 77 78 79 82 83 87
                                           90 92 93 94 95 96 97 98 101 102 103
                                           104 105 106 107 108 109 110 111 112
                                           113 114 115 116 117 118 119 120 121
                                           122 123 124 128 129 130 131 132 133
                                           134 135 136 137 138 139 140 141 142
                                           143 144 145 146 147 148 149 150 151
                                           159 160 161 162 163 164 165 166 167
                                           168 169 170 171 172 173 174 175 176
                                           177 178 179 180 181 182 183 192 193
                                           194 195 196 197 198 199 200 201 202
                                           203 204 205 206 207 208 209 210 211
                                           212 213 214 215 223 224 225 226 227
                                           228 229 230 231 232 233 234 235 236
                                           237 238 239 240 241 242 243 244 245
                                           246 247 254).
2019-05-26T15:24:27.373000Z DEBUG SET application_name TO 'pgloader'
2019-05-26T15:24:27.387000Z ERROR Date/time: 2019-05-26-15:24An unhandled error condition has been signalled:
                              255 fell through ECASE expression.
                              Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21
                                             23 27 28 30 31 32 33 35 41 42 45
                                             46 47 48 49 50 51 52 54 55 56 60
                                             61 62 63 64 65 69 72 76 77 78 79
                                             82 83 87 90 92 93 94 95 96 97 98
                                             101 102 103 104 105 106 107 108
                                             109 110 111 112 113 114 115 116
                                             117 118 119 120 121 122 123 124
                                             128 129 130 131 132 133 134 135
                                             136 137 138 139 140 141 142 143
                                             144 145 146 147 148 149 150 151
                                             159 160 161 162 163 164 165 166
                                             167 168 169 170 171 172 173 174
                                             175 176 177 178 179 180 181 182
                                             183 192 193 194 195 196 197 198
                                             199 200 201 202 203 204 205 206
                                             207 208 209 210 211 212 213 214
                                             215 223 224 225 226 227 228 229
                                             230 231 232 233 234 235 236 237
                                             238 239 240 241 242 243 244 245
                                             246 247 254).


Backtrace for: #<SB-THREAD:THREAD "lparallel" RUNNING {1007041E63}>
0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {10066D3963}>)
1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<SB-KERNEL:CASE-FAILURE expected-type: "(MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..)"datum: 255> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL)
2: ((LAMBDA (CONDITION) :IN PGLOADER.LOAD:COPY-FROM) #<SB-KERNEL:CASE-FAILURE expected-type: "(MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..)"datum: 255>)
3: (LPARALLEL.KERNEL::CONDITION-HANDLER #<SB-KERNEL:CASE-FAILURE expected-type: "(MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..)"datum: 255>)
4: (SIGNAL #<SB-KERNEL:CASE-FAILURE expected-type: "(MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..)"datum: 255>)
5: (ERROR SB-KERNEL:CASE-FAILURE :NAME ECASE :DATUM 255 :EXPECTED-TYPE (MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64 65 69 72 76 77 78 79 82 83 87 90 92 93 94 95 96 97 98 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 254) :POSSIBILITIES (2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64 65 69 72 76 77 78 79 82 83 87 90 92 93 94 95 96 97 98 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 254))
6: (QMYND-IMPL::MYSQL-CS-COLL-TO-CHARACTER-ENCODING 255)
7: (QMYND-IMPL::PARSE-TEXT-PROTOCOL-RESULT-COLUMN-AS-TEXT #() #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "nickname" :ORG-NAME "nickname" :CS-COLL 255 :COLUMN-LENGTH 1020 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL))
8: (QMYND-IMPL::PARSE-RESULTSET-ROW-AS-TEXT-VECTOR #<unavailable argument> #<unavailable argument>)
9: (QMYND-IMPL::MAP-RESULTSET-ROWS #<CLOSURE (LAMBDA (PGLOADER.LOAD::ROW) :IN PGLOADER.LOAD:QUEUE-RAW-DATA) {1009370BAB}> 5 #(#S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "id" :ORG-NAME "id" :CS-COLL 63 :COLUMN-LENGTH 11 :TYPE 3 :FLAGS 16899 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "nickname" :ORG-NAME "nickname" :CS-COLL 255 :COLUMN-LENGTH 1020 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "company" :ORG-NAME "company" :CS-COLL 255 :COLUMN-LENGTH 1020 :TYPE 253 :FLAGS 4097 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "dob" :ORG-NAME "dob" :CS-COLL 63 :COLUMN-LENGTH 10 :TYPE 10 :FLAGS 128 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "user_id" :ORG-NAME "user_id" :CS-COLL 63 :COLUMN-LENGTH 11 :TYPE 3 :FLAGS 20485 :DECIMALS 0 :DEFAULT-VALUE NIL)) :AS-TEXT T :RESULT-TYPE VECTOR)
10: (QMYND-IMPL:SEND-COMMAND-QUERY "SELECT `id`, `nickname`, `company`, `dob`, `user_id` FROM `account_profile`" :ROW-FN #<CLOSURE (LAMBDA (PGLOADER.LOAD::ROW) :IN PGLOADER.LOAD:QUEUE-RAW-DATA) {1009370BAB}> :AS-TEXT T :RESULT-TYPE VECTOR)
11: (QMYND:MYSQL-QUERY #<QMYND-IMPL::MYSQL-INET-CONNECTION {100623BA93}> "SELECT `id`, `nickname`, `company`, `dob`, `user_id` FROM `account_profile`" :ROW-FN #<CLOSURE (LAMBDA (PGLOADER.LOAD::ROW) :IN PGLOADER.LOAD:QUEUE-RAW-DATA) {1009370BAB}> :AS-TEXT T :RESULT-TYPE VECTOR)
12: (PGLOADER.SOURCE.MYSQL::CALL-WITH-ENCODING-HANDLER #<PGLOADER.SOURCE.MYSQL:COPY-MYSQL {100911ECD3}> "account_profile" #<CLOSURE (LAMBDA NIL :IN PGLOADER.SOURCES:MAP-ROWS) {10066CDF4B}>)
13: ((:METHOD PGLOADER.SOURCES:MAP-ROWS (PGLOADER.SOURCE.MYSQL:COPY-MYSQL)) #<PGLOADER.SOURCE.MYSQL:COPY-MYSQL {100911ECD3}> :PROCESS-ROW-FN #<CLOSURE (LAMBDA (PGLOADER.LOAD::ROW) :IN PGLOADER.LOAD:QUEUE-RAW-DATA) {1009370BAB}>) [fast-method]
14: ((:METHOD PGLOADER.LOAD:QUEUE-RAW-DATA (PGLOADER.SOURCES:COPY T T)) #<PGLOADER.SOURCE.MYSQL:COPY-MYSQL {100911ECD3}> #S(LPARALLEL.VECTOR-QUEUE:VECTOR-QUEUE :IMPL #S(LPARALLEL.VECTOR-QUEUE::RAW-QUEUE :DATA #(0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0... *I REMOVED A FREAKING BUNCH OF 0s*) :START 0 :COUNT 0) :LOCK #<SB-THREAD:MUTEX "Anonymous lock" (free)> :NOTIFY-PUSH NIL :NOTIFY-POP NIL) 1) [fast-method]
15: ((FLET #:BODY-FN584 :IN LPARALLEL.KERNEL::MAKE-CHANNELED-TASK) #<unavailable lambda list>)
16: ((LAMBDA NIL :IN LPARALLEL.KERNEL::MAKE-CHANNELED-TASK) #<unavailable lambda list>)
17: (LPARALLEL.KERNEL::EXEC-TASK/WORKER #<unavailable lambda list>)
18: (LPARALLEL.KERNEL::WORKER-LOOP #<unavailable lambda list>)
19: (LPARALLEL.KERNEL::%CALL-WITH-TASK-HANDLER #<unavailable lambda list>)
20: ((LAMBDA NIL :IN LPARALLEL.KERNEL::CALL-WITH-WORKER-CONTEXT))
21: (LPARALLEL.KERNEL::CALL-WITH-WORKER-CONTEXT #<CLOSURE (LAMBDA NIL :IN LPARALLEL.KERNEL::ENTER-WORKER-LOOP) {1006E86CEB}> #<FUNCTION FUNCALL> #<LPARALLEL.KERNEL:KERNEL :NAME "lparallel" :WORKER-COUNT 4 :USE-CALLER NIL :ALIVE T :SPIN-COUNT 2000 {1007040983}> #S(LPARALLEL.KERNEL::WORKER :HANDSHAKE/FROM-WORKER #S(LPARALLEL.CONS-QUEUE:CONS-QUEUE :IMPL #S(LPARALLEL.RAW-QUEUE:RAW-QUEUE :HEAD NIL :TAIL NIL) :LOCK #<SB-THREAD:MUTEX #1="Anonymous lock" (free)> :CVAR #<SB-THREAD:WAITQUEUE #2=Anonymous condition variable {100950D303}>) :HANDSHAKE/TO-WORKER #S(LPARALLEL.CONS-QUEUE:CONS-QUEUE :IMPL #S(LPARALLEL.RAW-QUEUE:RAW-QUEUE :HEAD NIL :TAIL NIL) :LOCK #<SB-THREAD:MUTEX #1# (free)> :CVAR #<SB-THREAD:WAITQUEUE #2# {100950D363}>) :EXIT-NOTIFICATION #S(LPARALLEL.CONS-QUEUE:CONS-QUEUE :IMPL #S(LPARALLEL.RAW-QUEUE:RAW-QUEUE :HEAD NIL :TAIL NIL) :LOCK #<SB-THREAD:MUTEX #1# (free)> :CVAR NIL) :THREAD #<SB-THREAD:THREAD "lparallel" RUNNING {1007041E63}> :RUNNING-CATEGORY :DEFAULT :INDEX 3 :TASKS #S(LPARALLEL.SPIN-QUEUE:SPIN-QUEUE :HEAD (LPARALLEL.SPIN-QUEUE::DUMMY (#<CLOSURE #3=(LAMBDA NIL :IN LPARALLEL.KERNEL::MAKE-CHANNELED-TASK) {1006240CCB}> . :DEFAULT) (#<CLOSURE #3# {10062421CB}> . :DEFAULT) (#<CLOSURE #3# {100624368B}> . :DEFAULT) (#<CLOSURE #3# {1006244B7B}> . :DEFAULT) (#<CLOSURE #3# {100624601B}> . :DEFAULT) (#<CLOSURE #3# {10062475CB}> . :DEFAULT) (#<CLOSURE #3# {100667861B}> . :DEFAULT) (#<CLOSURE #3# {1006679BDB}> . :DEFAULT) . #4=((#<CLOSURE #3# {100667B11B}> . :DEFAULT))) :TAIL #4#)))
22: ((LAMBDA NIL :IN LPARALLEL.KERNEL::MAKE-WORKER-THREAD))
23: ((LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS))
24: ((FLET #:WITHOUT-INTERRUPTS-BODY-1139 :IN SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE))
25: ((FLET SB-THREAD::WITH-MUTEX-THUNK :IN SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE))
26: ((FLET #:WITHOUT-INTERRUPTS-BODY-359 :IN SB-THREAD::CALL-WITH-MUTEX))
27: (SB-THREAD::CALL-WITH-MUTEX #<CLOSURE (FLET SB-THREAD::WITH-MUTEX-THUNK :IN SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE) {7F8623DAED6B}> #<SB-THREAD:MUTEX "thread result lock" owner: #<SB-THREAD:THREAD "lparallel" RUNNING {1007041E63}>> NIL T NIL)
28: (SB-THREAD::INITIAL-THREAD-FUNCTION-TRAMPOLINE #<SB-THREAD:THREAD "lparallel" RUNNING {1007041E63}> NIL #<CLOSURE (LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS) {1007041E0B}> (#<SB-THREAD:THREAD #1="lparallel" RUNNING {1007041E63}> #<SB-THREAD:THREAD #1# RUNNING {1007041913}> #<SB-THREAD:THREAD #1# RUNNING {10070413C3}> #<SB-THREAD:THREAD #1# RUNNING {1007040E73}> #<SB-THREAD:THREAD #1# RUNNING {100616C393}> #<SB-THREAD:THREAD "main thread" RUNNING {1006115F63}>) NIL NIL NIL NIL)
29: ("foreign function: call_into_lisp")
30: ("foreign function: new_thread_trampoline")

The line of interest in the backtrace is the following, where we learn that the MySQL driver used by pgloader doesn’t know about the encoding of your database:

6: (QMYND-IMPL::MYSQL-CS-COLL-TO-CHARACTER-ENCODING 255)

See https://github.com/qitab/qmynd/blob/master/src/common/charsets.lisp for a list of the encodings that are supported. We have an open PR for the driver that fixes this problem: https://github.com/qitab/qmynd/pull/11. Can you build pgloader with this branch of the driver to test that it’s all ok?

By doing the following, you should have a pgloader binary to play with that includes a fix to this issue, and once you’ve confirmed that the encoding specification is ok, I will be able to merge the PR for the qmynd driver!

$ cd /path/to/pgloader/sources
$ cd build/quicklisp/local-projects/
$ rm -rf qmynd
$ git clone https://github.com/cristianbica/qmynd
$ cd /path/to/pgloader/sources
$ make save

I will try this although I’ve moved the data using Django’s dump and load data. Will let you know once I have a result. Thanks. Btw I guess I know nothing about lisp haha the log looks like cipher text to me

In the previous comment, I mentioned I can build from source, that was built from the bundle provided in Github release page… But now I’m trying to build from
git clone https://github.com/dimitri/pgloader.git. It seems that I can’t successfully build in Ubuntu 18.04 nor Debian 9…

The following error message is obtained from the building process in Debian 9.

Sorry, I don’t know how to copy from the terminal in Debian… I just installed it in VM…

Oops, right click is the trick…

[package nibbles].................................
[package ironclad]................................
[package ironclad-vm]...................
debugger invoked on a SB-INT:SIMPLE-PROGRAM-ERROR in thread
#<THREAD "main thread" RUNNING {1001E06FA3}>:
  invalid number of arguments: 5

Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

restarts (invokable by number or by possibly-abbreviated name):
  0: [RETRY                        ] Retry
                                     compiling #<IRONCLAD-SOURCE-FILE "ironclad" "src" "common">.
  1: [ACCEPT                       ] Continue, treating
                                     compiling #<IRONCLAD-SOURCE-FILE "ironclad" "src" "common">
                                     as having been successful.
  2:                                 Retry ASDF operation.
  3: [CLEAR-CONFIGURATION-AND-RETRY] Retry ASDF operation after resetting the
                                     configuration.
  4: [ABORT                        ] Give up on "pgloader"
  5: [CONTINUE                     ] Ignore runtime option --eval "(ql:quickload "pgloader")".
  6:                                 Skip rest of --eval and --load options.
  7:                                 Skip to toplevel READ/EVAL/PRINT loop.
  8: [EXIT                         ] Exit SBCL (calling #'EXIT, killing the process).

(SB-X86-64-ASM::|movzx| #<SB-ASSEM:SEGMENT :TYPE :REGULAR> #<SB-C::VOP :INFO UB32REF/LE :ARGS #<SB-C:TN-REF :TN #<SB-C:TN INPUT-BLOCK1!1[RDI]> :WRITE-P NIL :VOP UB32REF/LE> :RESULTS #<SB-C:TN-REF :TN #<SB-C:TN t2[RDX]> :WRITE-P T :VOP UB32REF/LE>> (:DWORD :QWORD) #<SB-C:TN t2[RDX]> #<SB-X86-64-ASM::EA :DWORD base=#<SB-C:TN INPUT-BLOCK1!1[RDI]> index=#<SB-C:TN t3[RDX]> disp=1>) [tl,external]
0] 

I don’t see useful information in the build log(maybe I can’t get it, I know nothing about lisp)

If you need more debug info, let me know

It’s a well known error so I think we have enough information for me to recognise it: your SBCL is too old, please grab a more recent version.

Yes, I’ve confirmed replacing qmynd solves the problem. I can copy the whole DB using the new built binary. Thanks.

Thanks! now can you compare several data fields in both source and target database and make sure that the encoding conversion makes sense and didn’t damage your data? IOW, it is the same text in MySQL and in Postgres after pgloader’s migration is done?

@dimitri
Are you able to tell which table was causing the problem from the full log that I’ve sent you via email? So that I can carefully check that particular table.

From the following entry in the backtrace I appears to be column nickname from table account_profile that did target the error first. I would suppose that it’s just the first text column that pgloader has to work on in your case though?

(QMYND-IMPL::PARSE-TEXT-PROTOCOL-RESULT-COLUMN-AS-TEXT #() #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "crm" :TABLE "account_profile" :ORG-TABLE "account_profile" :NAME "nickname" :ORG-NAME "nickname" :CS-COLL 255 :COLUMN-LENGTH 1020 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL))

For nickname in account_profile
Both the source and dest table have empty values which are correct.

For other tables, the content looks the same too.
I’ve specifically checked some columns with Chinese characters, they are all good.

Source

Destination

Thanks a lot @Meowzz95 for extended testing, I have now merged https://github.com/qitab/qmynd/pull/11. It means the next normal build of pgloader will embed the fix here (after a make clean for people who already had a pgloader source and dependencies installed).

pgloader version «3.5.2»

pgloader --debug --verbose mysql://root:password@localhost/acorn-db postgresql:///acornt

The outcome:

sb-impl::*default-external-format* :UTF-8
tmpdir: #P"/var/folders/bh/86p1yw5d4zj0m547x5m3swcc0000gn/T/"
2018-12-15T02:59:11.016000Z NOTICE Starting pgloader, log system is ready.
2018-12-15T02:59:11.023000Z INFO Starting monitor
2018-12-15T02:59:11.062000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://pavelkrotov@UNIX:5432/acornt {1005754E93}>
2018-12-15T02:59:11.062000Z DEBUG SET client_encoding TO 'utf8'
2018-12-15T02:59:11.062000Z DEBUG SET application_name TO 'pgloader'
2018-12-15T02:59:11.068000Z LOG Migrating from #<MYSQL-CONNECTION mysql://root@localhost:3306/acorn-db {1005611A83}>
2018-12-15T02:59:11.068000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://pavelkrotov@UNIX:5432/acornt {1005754E93}>
KABOOM!
FATAL error: 76 fell through ECASE expression.
             Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31
                            32 33 35 41 42 45 46 47 48 49 50 51 52 54 55 56 60
                            61 62 63 64 65 69 72 77 78 79 82 83 87 90 92 93 94
                            95 96 97 98 101 102 103 104 105 106 107 108 109 110
                            111 112 113 114 115 116 117 118 119 120 121 122 123
                            124 128 129 130 131 132 133 134 135 136 137 138 139
                            140 141 142 143 144 145 146 147 148 149 150 151 159
                            160 161 162 163 164 165 166 167 168 169 170 171 172
                            173 174 175 176 177 178 179 180 181 182 183 192 193
                            194 195 196 197 198 199 200 201 202 203 204 205 206
                            207 208 209 210 211 212 213 214 215 223 224 225 226
                            227 228 229 230 231 232 233 234 235 236 237 238 239
                            240 241 242 243 244 245 246 247 254).
Date/time: 2018-12-14-21:59An unhandled error condition has been signalled:
                              76 fell through ECASE expression.
                              Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21
                                             23 27 28 30 31 32 33 35 41 42 45
                                             46 47 48 49 50 51 52 54 55 56 60
                                             61 62 63 64 65 69 72 77 78 79 82
                                             83 87 90 92 93 94 95 96 97 98 101
                                             102 103 104 105 106 107 108 109
                                             110 111 112 113 114 115 116 117
                                             118 119 120 121 122 123 124 128
                                             129 130 131 132 133 134 135 136
                                             137 138 139 140 141 142 143 144
                                             145 146 147 148 149 150 151 159
                                             160 161 162 163 164 165 166 167
                                             168 169 170 171 172 173 174 175
                                             176 177 178 179 180 181 182 183
                                             192 193 194 195 196 197 198 199
                                             200 201 202 203 204 205 206 207
                                             208 209 210 211 212 213 214 215
                                             223 224 225 226 227 228 229 230
                                             231 232 233 234 235 236 237 238
                                             239 240 241 242 243 244 245 246
                                             247 254).


Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {10005905B3}>
0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SB-IMPL::STRING-OUTPUT-STREAM {1006FA5FC3}>)
1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<SB-KERNEL:CASE-FAILURE expected-type: (MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..) datum: 76> :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE NIL)
2: ((FLET "H0" :IN PGLOADER::MAIN) #<SB-KERNEL:CASE-FAILURE expected-type: (MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..) datum: 76>)
3: (SB-KERNEL::%SIGNAL #<SB-KERNEL:CASE-FAILURE expected-type: (MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 ..) datum: 76>)
4: (ERROR SB-KERNEL:CASE-FAILURE :NAME ECASE :DATUM 76 :EXPECTED-TYPE (MEMBER 2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64 65 69 72 77 78 79 82 83 87 90 92 93 94 95 96 97 98 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 254) :POSSIBILITIES (2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42 45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64 65 69 72 77 78 79 82 83 87 90 92 93 94 95 96 97 98 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 254))
5: (QMYND-IMPL::MYSQL-CS-COLL-TO-CHARACTER-ENCODING 76)
6: (QMYND-IMPL::PARSE-TEXT-PROTOCOL-RESULT-COLUMN-AS-TEXT #(65 117 100 105 116 84 114 97 105 108) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "TABLE_NAME" :ORG-NAME "TABLE_NAME" :CS-COLL 76 :COLUMN-LENGTH 192 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL))
7: (QMYND-IMPL::PARSE-RESULTSET-ROW-AS-TEXT-LIST 9 #<unavailable argument>)
8: (QMYND-IMPL:PARSE-RESULTSET-ROWS 9 #(#S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "TABLE_NAME" :ORG-NAME "TABLE_NAME" :CS-COLL 76 :COLUMN-LENGTH 192 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "t" :ORG-TABLE "" :NAME "TABLE_COMMENT" :ORG-NAME "TABLE_COMMENT" :CS-COLL 33 :COLUMN-LENGTH 768 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "COLUMN_NAME" :ORG-NAME "COLUMN_NAME" :CS-COLL 76 :COLUMN-LENGTH 192 :TYPE 253 :FLAGS 0 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "COLUMN_COMMENT" :ORG-NAME "COLUMN_COMMENT" :CS-COLL 83 :COLUMN-LENGTH 6144 :TYPE 252 :FLAGS 145 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "DATA_TYPE" :ORG-NAME "DATA_TYPE" :CS-COLL 83 :COLUMN-LENGTH 50331645 :TYPE 252 :FLAGS 144 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "mysql" :TABLE "c" :ORG-TABLE "columns" :NAME "COLUMN_TYPE" :ORG-NAME "COLUMN_TYPE" :CS-COLL 83 :COLUMN-LENGTH 16777215 :TYPE 252 :FLAGS 4241 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "mysql" :TABLE "c" :ORG-TABLE "columns" :NAME "COLUMN_DEFAULT" :ORG-NAME "COLUMN_DEFAULT" :CS-COLL 83 :COLUMN-LENGTH 65535 :TYPE 252 :FLAGS 144 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "IS_NULLABLE" :ORG-NAME "IS_NULLABLE" :CS-COLL 33 :COLUMN-LENGTH 9 :TYPE 253 :FLAGS 1 :DECIMALS 0 :DEFAULT-VALUE NIL) #S(QMYND-IMPL::COLUMN-DEFINITION-V41-PACKET :CATALOG "def" :SCHEMA "" :TABLE "c" :ORG-TABLE "" :NAME "EXTRA" :ORG-NAME "EXTRA" :CS-COLL 83 :COLUMN-LENGTH 180 :TYPE 253 :FLAGS 128 :DECIMALS 0 :DEFAULT-VALUE NIL)) :AS-TEXT T :RESULT-TYPE LIST)
9: (QMYND-IMPL:SEND-COMMAND-QUERY #<(SIMPLE-BASE-STRING 650) -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-... {1006EA2CFF}> :ROW-FN NIL :AS-TEXT T :RESULT-TYPE LIST)
10: (QMYND:MYSQL-QUERY #<QMYND-IMPL::MYSQL-INET-CONNECTION {10069354F3}> #<(SIMPLE-BASE-STRING 650) -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-... {1006EA2CFF}> :ROW-FN NIL :AS-TEXT T :RESULT-TYPE LIST)
11: (PGLOADER.SOURCE.MYSQL::LIST-ALL-COLUMNS #1=#S(PGLOADER.CATALOG:SCHEMA :SOURCE-NAME #2="acorn-db" :NAME ""acorn-db"" :CATALOG #S(PGLOADER.CATALOG:CATALOG :NAME #2# :SCHEMA-LIST (#1#) :TYPES-WITHOUT-BTREE NIL) :TABLE-LIST NIL :VIEW-LIST NIL :IN-SEARCH-PATH T) :TABLE-TYPE :TABLE :ONLY-TABLES NIL :INCLUDING NIL :EXCLUDING NIL)
12: ((:METHOD PGLOADER.SOURCES:FETCH-METADATA (PGLOADER.SOURCE.MYSQL:COPY-MYSQL PGLOADER.CATALOG:CATALOG)) #<PGLOADER.SOURCE.MYSQL:COPY-MYSQL {100615E843}> #1=#S(PGLOADER.CATALOG:CATALOG :NAME #2="acorn-db" :SCHEMA-LIST (#S(PGLOADER.CATALOG:SCHEMA :SOURCE-NAME #2# :NAME ""acorn-db"" :CATALOG #1# :TABLE-LIST NIL :VIEW-LIST NIL :IN-SEARCH-PATH T)) :TYPES-WITHOUT-BTREE NIL) :MATERIALIZE-VIEWS NIL :ONLY-TABLES NIL :CREATE-INDEXES T :FOREIGN-KEYS T :INCLUDING NIL :EXCLUDING NIL) [fast-method]
13: ((:METHOD PGLOADER.LOAD:COPY-DATABASE (PGLOADER.SOURCES:DB-COPY)) #<PGLOADER.SOURCE.MYSQL:COPY-MYSQL {100615E843}> :ON-ERROR-STOP T :WORKER-COUNT 4 :CONCURRENCY 1 :MULTIPLE-READERS NIL :MAX-PARALLEL-CREATE-INDEX NIL :TRUNCATE NIL :DISABLE-TRIGGERS NIL :DATA-ONLY NIL :SCHEMA-ONLY NIL :CREATE-SCHEMAS T :CREATE-TABLES T :INCLUDE-DROP T :DROP-SCHEMA NIL :CREATE-INDEXES T :INDEX-NAMES :UNIQUIFY :RESET-SEQUENCES T :FOREIGN-KEYS T :REINDEX NIL :ONLY-TABLES NIL :INCLUDING NIL :EXCLUDING NIL :SET-TABLE-OIDS T :ALTER-TABLE NIL :ALTER-SCHEMA NIL :MATERIALIZE-VIEWS NIL) [fast-method]
14: ((LAMBDA ()))
15: (PGLOADER:RUN-COMMANDS (LAMBDA NIL (LET* ((PGLOADER.SOURCES:*DEFAULT-CAST-RULES* (QUOTE ((:SOURCE (:TYPE #1="int" :AUTO-INCREMENT T :TYPEMOD (< PGLOADER.TRANSFORMS:PRECISION 10)) :TARGET (:TYPE #2="serial")) (:SOURCE (:TYPE #1# :AUTO-INCREMENT T :TYPEMOD (<= 10 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #3="bigserial")) (:SOURCE (:TYPE #1# :AUTO-INCREMENT NIL :TYPEMOD (< PGLOADER.TRANSFORMS:PRECISION 10)) :TARGET (:TYPE #1#)) (:SOURCE (:TYPE #1# :AUTO-INCREMENT NIL :TYPEMOD (<= 10 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #4="bigint")) (:SOURCE (:TYPE #5="tinyint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #6="smallint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #7="mediumint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #4# :AUTO-INCREMENT T) :TARGET (:TYPE #3#)) (:SOURCE (:TYPE #5# :TYPEMOD (= 1 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #8="boolean" :DROP-TYPEMOD T) :USING PGLOADER.TRANSFORMS::TINYINT-TO-BOOLEAN) (:SOURCE (:TYPE "bit" :TYPEMOD (= 1 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #8# :DROP-TYPEMOD T) :USING PGLOADER.TRANSFORMS::BITS-TO-BOOLEAN) (:SOURCE (:TYPE #4# :TYPEMOD (< 19 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #9="numeric" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #5# :UNSIGNED T) :TARGET (:TYPE #6# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #6# :UNSIGNED T) :TARGET (:TYPE #10="integer" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #7# :UNSIGNED T) :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #10# :UNSIGNED T) :TARGET (:TYPE #4# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #5#) :TARGET (:TYPE #6# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #6#) :TARGET (:TYPE #6# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #7#) :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #10#) :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #11="float") :TARGET (:TYPE #11# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #4#) :TARGET (:TYPE #4# :DROP-TYPEMOD T)) (:SOURCE (:TYPE "double") :TARGET (:TYPE "double precision" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #9#) :TARGET (:TYPE #9# :DROP-TYPEMOD NIL)) (:SOURCE (:TYPE #12="decimal") :TARGET (:TYPE #12# :DROP-TYPEMOD NIL)) (:SOURCE (:TYPE "tinytext") :TARGET (:TYPE #13="text") :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE #13#) :TARGET (:TYPE #13#) :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE "mediumtext") :TARGET (:TYPE #13#) :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE "longtext") :TARGET (:TYPE #13#) :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE #14="varchar") :TARGET (:TYPE #14# :DROP-TYPEMOD NIL) :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE #15="char") :TARGET (:TYPE #15# :DROP-TYPEMOD NIL) :USING PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS) (:SOURCE (:TYPE "binary") :TARGET (:TYPE #16="bytea") :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "varbinary") :TARGET (:TYPE #16#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "tinyblob") :TARGET (:TYPE #16#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "blob") :TARGET (:TYPE #16#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "mediumblob") :TARGET (:TYPE #16#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "longblob") :TARGET (:TYPE #16#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE #17="datetime" :DEFAULT #18="0000-00-00 00:00:00" :NOT-NULL T) :TARGET (:TYPE #19="timestamptz" :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #17# :DEFAULT #18#) :TARGET (:TYPE #19# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #17# :ON-UPDATE-CURRENT-TIMESTAMP T :NOT-NULL T) :TARGET (:TYPE #19# :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20="timestamp" :DEFAULT #18# :NOT-NULL T) :TARGET (:TYPE #19# :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20# :DEFAULT #18#) :TARGET (:TYPE #19# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20# :ON-UPDATE-CURRENT-TIMESTAMP T :NOT-NULL T) :TARGET (:TYPE #19# :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #21="date" :DEFAULT "0000-00-00") :TARGET (:TYPE #21# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #21#) :TARGET (:TYPE #21#)) (:SOURCE (:TYPE "year") :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #17#) :TARGET (:TYPE #19#) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20#) :TARGET (:TYPE #19#) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE "enum") :TARGET (:TYPE #22=#<FUNCTION PGLOADER.SOURCE.MYSQL::ENUM-OR-SET-NAME>)) (:SOURCE (:TYPE "set") :TARGET (:TYPE #22#) :USING PGLOADER.TRANSFORMS::SET-TO-ENUM-ARRAY) (:SOURCE (:TYPE "geometry") :TARGET (:TYPE #23="point") :USING PGLOADER.TRANSFORMS::CONVERT-MYSQL-POINT) (:SOURCE (:TYPE #23#) :TARGET (:TYPE #23#) :USING PGLOADER.TRANSFORMS::CONVERT-MYSQL-POINT) (:SOURCE (:TYPE "linestring") :TARGET (:TYPE "path") :USING PGLOADER.TRANSFORMS::CONVERT-MYSQL-LINESTRING)))) (PGLOADER.SOURCES:*CAST-RULES* (QUOTE NIL)) (PGLOADER.SOURCE.MYSQL:*DECODING-AS* (QUOTE NIL)) (PGLOADER.PARAMS:*MYSQL-SETTINGS* (QUOTE NIL)) (PGLOADER.PARAMS:ON-ERROR-STOP (GETF (QUOTE NIL) :ON-ERROR-STOP T)) (PGLOADER.PARAMS:*PG-SETTINGS* (PGLOADER.PGSQL:SANITIZE-USER-GUCS (QUOTE NIL))) (PGLOADER.PARAMS:*PGSQL-RESERVED-KEYWORDS* (PGLOADER.PGSQL:LIST-RESERVED-KEYWORDS #24=#<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://pavelkrotov@UNIX:5432/acornt {1005754E93}>)) (PGLOADER.PARAMS:*COPY-BATCH-ROWS* (OR NIL PGLOADER.PARAMS:*COPY-BATCH-ROWS*)) (PGLOADER.PARAMS:*COPY-BATCH-SIZE* (OR NIL PGLOADER.PARAMS:*COPY-BATCH-SIZE*)) (PGLOADER.PARAMS:*PREFETCH-ROWS* (OR NIL PGLOADER.PARAMS:*PREFETCH-ROWS*)) (PGLOADER.PARAMS:*ROWS-PER-RANGE* (OR NIL PGLOADER.PARAMS:*ROWS-PER-RANGE*)) (PGLOADER.PARAMS:*IDENTIFIER-CASE* (OR NIL PGLOADER.PARAMS:*IDENTIFIER-CASE*)) (PGLOADER.PARSER::SOURCE (MAKE-INSTANCE (QUOTE PGLOADER.SOURCE.MYSQL:COPY-MYSQL) :TARGET-DB #24# :SOURCE-DB #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://root@localhost:3306/acorn-db {1005611A83}>))) NIL (PGLOADER.LOAD:COPY-DATABASE PGLOADER.PARSER::SOURCE :INCLUDING (QUOTE NIL) :EXCLUDING (QUOTE NIL) :MATERIALIZE-VIEWS (QUOTE NIL) :ALTER-TABLE (QUOTE NIL) :ALTER-SCHEMA (QUOTE NIL) :SET-TABLE-OIDS T :ON-ERROR-STOP PGLOADER.PARAMS:ON-ERROR-STOP) NIL)) :START-LOGGER NIL :FLUSH-SUMMARY T :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL)
16: (PGLOADER:LOAD-DATA :FROM #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://root@localhost:3306/acorn-db {1005611A83}> :INTO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://pavelkrotov@UNIX:5432/acornt {1005754E93}> :ENCODING :UTF-8 :FIELDS NIL :TARGET-TABLE-NAME NIL :OPTIONS NIL :GUCS NIL :CASTS NIL :BEFORE NIL :AFTER NIL :START-LOGGER NIL :FLUSH-SUMMARY T)
17: (PGLOADER.MONITOR::CALL-WITH-MONITOR #<CLOSURE (LAMBDA NIL :IN PGLOADER::MAIN) {10053069DB}>)
18: (PGLOADER::MAIN ("pgloader" "--debug" "--verbose" "mysql://root:password@localhost/acorn-db" "postgresql:///acornt"))
19: ((LAMBDA NIL :IN "/private/tmp/pgloader-20180705-16956-54q8li/pgloader-3.5.2/dumper-2SKVI5f7.lisp"))
20: ((FLET SB-UNIX::BODY :IN SAVE-LISP-AND-DIE))
21: ((FLET "WITHOUT-INTERRUPTS-BODY-36" :IN SAVE-LISP-AND-DIE))
22: ((LABELS SB-IMPL::RESTART-LISP :IN SAVE-LISP-AND-DIE))



2018-12-15T02:59:11.150000Z DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://root@localhost:3306/acorn-db {1005611A83}>
2018-12-15T02:59:11.150000Z SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
  select c.table_name, t.table_comment,
         c.column_name, c.column_comment,
         c.data_type, c.column_type, c.column_default,
         c.is_nullable, c.extra
    from information_schema.columns c
         join information_schema.tables t using(table_schema, table_name)
   where c.table_schema = 'acorn-db' and t.table_type = 'BASE TABLE'



order by table_name, ordinal_position;
2018-12-15T02:59:11.150000Z INFO Stopping monitor

What I am doing here?

76 fell through ECASE expression.
Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33 35 41 42
               45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64 65 69 72 77 78
               79 82 83 87 90 92 93 94 95 96 97 98 101 102 103 104 105 106 107
               108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
               124 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142
               143 144 145 146 147 148 149 150 151 159 160 161 162 163 164 165
               166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181
               182 183 192 193 194 195 196 197 198 199 200 201 202 203 204 205
               206 207 208 209 210 211 212 213 214 215 223 224 225 226 227 228
               229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244
               245 246 247 254).

If I had to bet… which I have to here… well I would say that the number 76 here refers to a MySQL charset that is not implemented in the Qmynd driver:

https://github.com/qitab/qmynd/blob/master/src/common/charsets.lisp#L97

Can you find which charset your MySQL database is using, and if 76 find some documentation as to what is this charset is expected to be?

CHARSET=utf8
Thank you very much, Dimitry, for the reply. I looked into one of the tables in the mySql database and that what might be related to the charset and possible problesm in conversion, or not?

ENGINE=InnoDB AUTOINCREMENT=10080 DEFAULT CHARSET=utf8 PACKKEYS=0

Sent fromMail Pilot(https://mailpilothq.com/)

Please try to use the DECODE AS clause in your pgloader command. Can you find authoritative documentation about charset 76 in MySQL being UTF-8 so that I might add that to the MySQL driver?

..I cannot see 76 in charset of the mysql db. yet, I got the charset for the entire db

"armscii8"  "ARMSCII-8 Armenian"    "armscii8_general_ci"   1
"ascii" "US ASCII"  "ascii_general_ci"  1
"big5"  "Big5 Traditional Chinese"  "big5_chinese_ci"   2
"binary"    "Binary pseudo charset" "binary"    1
"cp1250"    "Windows Central European"  "cp1250_general_ci" 1
"cp1251"    "Windows Cyrillic"  "cp1251_general_ci" 1
"cp1256"    "Windows Arabic"    "cp1256_general_ci" 1
"cp1257"    "Windows Baltic"    "cp1257_general_ci" 1
"cp850" "DOS West European" "cp850_general_ci"  1
"cp852" "DOS Central European"  "cp852_general_ci"  1
"cp866" "DOS Russian"   "cp866_general_ci"  1
"cp932" "SJIS for Windows Japanese" "cp932_japanese_ci" 2
"dec8"  "DEC West European" "dec8_swedish_ci"   1
"eucjpms"   "UJIS for Windows Japanese" "eucjpms_japanese_ci"   3
"euckr" "EUC-KR Korean" "euckr_korean_ci"   2
"gb18030"   "China National Standard GB18030"   "gb18030_chinese_ci"    4
"gb2312"    "GB2312 Simplified Chinese" "gb2312_chinese_ci" 2
"gbk"   "GBK Simplified Chinese"    "gbk_chinese_ci"    2
"geostd8"   "GEOSTD8 Georgian"  "geostd8_general_ci"    1
"greek" "ISO 8859-7 Greek"  "greek_general_ci"  1
"hebrew"    "ISO 8859-8 Hebrew" "hebrew_general_ci" 1
"hp8"   "HP West European"  "hp8_english_ci"    1
"keybcs2"   "DOS Kamenicky Czech-Slovak"    "keybcs2_general_ci"    1
"koi8r" "KOI8-R Relcom Russian" "koi8r_general_ci"  1
"koi8u" "KOI8-U Ukrainian"  "koi8u_general_ci"  1
"latin1"    "cp1252 West European"  "latin1_swedish_ci" 1
"latin2"    "ISO 8859-2 Central European"   "latin2_general_ci" 1
"latin5"    "ISO 8859-9 Turkish"    "latin5_turkish_ci" 1
"latin7"    "ISO 8859-13 Baltic"    "latin7_general_ci" 1
"macce" "Mac Central European"  "macce_general_ci"  1
"macroman"  "Mac West European" "macroman_general_ci"   1
"sjis"  "Shift-JIS Japanese"    "sjis_japanese_ci"  2
"swe7"  "7bit Swedish"  "swe7_swedish_ci"   1
"tis620"    "TIS620 Thai"   "tis620_thai_ci"    1
"ucs2"  "UCS-2 Unicode" "ucs2_general_ci"   2
"ujis"  "EUC-JP Japanese"   "ujis_japanese_ci"  3
"utf16" "UTF-16 Unicode"    "utf16_general_ci"  4
"utf16le"   "UTF-16LE Unicode"  "utf16le_general_ci"    4
"utf32" "UTF-32 Unicode"    "utf32_general_ci"  4
"utf8"  "UTF-8 Unicode" "utf8_general_ci"   3
"utf8mb4"   "UTF-8 Unicode" "utf8mb4_0900_ai_ci"    4

How to include the DECODE AS clause in the command line as this

~ $ pgloader --debug --verbose mysql://root:password@localhost/acorn-db  postgresql:///acornt

..I have zero initial knowledge how to use — read the docs several times, does not help; took a while to figure out that the file with .load should be created as a alternative to the command line — > the same outcome. finally, tried do migrations just tables — the same ‘kaboom’. that is the .load file

LOAD DATABASE
     FROM      mysql://root:password@localhost/acorn-db
     INTO postgresql:///pagila
     WITH include drop, create tables, create indexes, reset sequences,
      workers = 8, concurrency = 1,
      multiple readers per thread, rows per range = 50000

  SET PostgreSQL PARAMETERS
      maintenance_work_mem to '128MB',
      work_mem to '12MB',
      search_path to 'sakila, public, "$user"'

  SET MySQL PARAMETERS
      net_read_timeout  = '120',
      net_write_timeout = '120'

 CAST type bigint when (= precision 20) to bigserial drop typemod,
      type date drop not null drop default using zero-dates-to-null,
      -- including only table names matching ~/Formats/,
      -- decoding table names matching ~/*/, ~/encoding/ AS utf8,
      -- type tinyint to boolean using tinyint-to-boolean,
      type year to integer;

2020-10-12T15:37:31.347000Z ERROR mysql: 76 fell through ECASE expression.
       Wanted one of (2 3 4 5 6 8 9 10 11 14 15 17 20 21 23 27 28 30 31 32 33
                      35 41 42 45 46 47 48 49 50 51 52 54 55 56 60 61 62 63 64
                      65 69 72 77 78 79 82 83 87 90 92 93 94 95 96 97 98 101
                      102 103 104 105 106 107 108 109 110 111 112 113 114 115
                      116 117 118 119 120 121 122 123 124 128 129 130 131 132
                      133 134 135 136 137 138 139 140 141 142 143 144 145 146
                      147 148 149 150 151 159 160 161 162 163 164 165 166 167
                      168 169 170 171 172 173 174 175 176 177 178 179 180 181
                      182 183 192 193 194 195 196 197 198 199 200 201 202 203
                      204 205 206 207 208 209 210 211 212 213 214 215 223 224
                      225 226 227 228 229 230 231 232 233 234 235 236 237 238
                      239 240 241 242 243 244 245 246 247 254).
2020-10-12T15:37:31.348000Z LOG report summary reset
       table name     errors       read   imported      bytes      total time       read      write
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
  fetch meta data          0          0          0                     0.000s    
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
-----------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
2020-10-12T15:37:31.393000Z INFO Stopping monitor
got these error in mysql 8.0.21 and pgloader version "3.6.2"

  - [ ] pgloader output you obtain