Pgloader: ECASE error for utf8mb4_0900_xx
Seems does not support utf8mb4_0900_xx that comes with MySQL/8
MySQL Version: 8.0.15
PgLoader Version: 3.5.2-3.pgdg18.04+1
Ref: https://github.com/dimitri/pgloader/issues/877#issuecomment-447662546
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).
An 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).
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
k-gun
All 8 comments
Hi @k-gun ; I added support for that encoding over at https://github.com/qitab/qmynd/commit/f25b134f570efae37d3296de2742c9d69fe0299c ; so you should be able to use that. Please upgrade your copy of pgloader to either the current release version (3.6.1) or build from current's master branch.
dimitri
on 22 Feb 2019
had the very same issue today. got it fixed by converting tables:
alter table table_name convert to character set utf8 collate utf8_bin
it took a while for 250gb mysql db but then it worked just fine
randomnerd
on 22 Feb 2019
It seems like the latest version of official docker image (pgloader version 3.6.2~devel) does not include this fix.
JokerQyou
on 7 Apr 2019
I'll need to have a look at Quicklisp current version of qmynd and maybe there's something I need to do there about it. Other than that, you can compile pgloader from source and should then have the most recent version of qmynd included, fresh from git.
dimitri
on 14 Apr 2019
same issue:
Ubuntu 19.10
pgloader version "3.6.1"
compiled with SBCL 1.4.15.debian
yunixon
on 20 Feb 2020
fwiw, I built from main line in git and it worked.
blazespinnaker
on 26 Sep 2020
2020-10-08T18:53:54.263000Z ERROR mysql: 76 fell through ECASE expression.
i got these error when migrate mysql to psql
mysql version -->8.0.21
pgloader version -->pgloader version "3.6.2"
compiled with SBCL 1.3.1.debian
order by table_name, ordinal_position;
2020-10-08T18:53:54.263000Z 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-08T18:53:54.263000Z LOG report summary reset
ashwinshrivastava2897
on 8 Oct 2020
Still getting this same error on 3.6.1 - it doesn't seem to have been fixed. I even converted all the tables to UTF8 to be sure...
2021-01-08T00:15:27.008000Z LOG pgloader version "3.6.1"
2021-01-08T00:15:27.054000Z LOG Migrating from #<MYSQL-CONNECTION mysql://pgloader@localhost:3306/kpi_test_data {10068F7113}>
2021-01-08T00:15:27.054000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@localhost:5432/kpi_test_data {10068F8AD3}>
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).
An 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).
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).
From what I see this is an ongoing problem and it doesn't seem to be fixed in new versions from what @ashwinshrivastava2897 reports....
ckmaresca
on 8 Jan 2021
Related issues
nibty
路
4Comments
drouarb
路
6Comments
nenadalm
路
6Comments
richardkmichael
路
6Comments
0xbzho
路
3Comments
Most helpful comment
Hi @k-gun ; I added support for that encoding over at https://github.com/qitab/qmynd/commit/f25b134f570efae37d3296de2742c9d69fe0299c ; so you should be able to use that. Please upgrade your copy of pgloader to either the current release version (3.6.1) or build from current's master branch.