# Upgrade from 4.2.6 to \>= 4.3.0 problem

**URL:** <https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741>\
**Category:** CrateDB\
**Created:** [July 7, 2021, 10:53am UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741 "2021-07-07T10:53:52Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rps-v](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/rps-v/32/342_2.png) [@rps-v](https://community.cratedb.com/u/rps-v)\
**Post date:** [July 7, 2021, 10:53am UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/1 "2021-07-07T10:53:52Z")

</div>

Hello,

We are trying to upgrade from Crate 4.2.6 to a newer version, for example 4.3.4, and keep getting errors regarding the tables: “ **unable to upgrade the mappings** ”.  
This seems to affect tables that were created on Crate \< 4.0 so we tried recreating them, but encountered the [COPY circuit breaking exception bug](https://crate.io/docs/crate/reference/en/4.5/appendices/release-notes/4.3.1.html#fixes) (fixed in 4.3.1).  
What options do we have to upgrade ?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/53a99fa66dad73029888118d89319874611bc2d6.png)

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [July 7, 2021, 11:25am UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/2 "2021-07-07T11:25:30Z")

</div>

Hi @rps-v

What does the following query return

```sql
SELECT table_name, version['upgraded'], version['created']
FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema','pg_catalog','sys')

```

Do you still have tables created before v3.x ?

---

<div class="post-metadata">

**Author:** ![rps-v](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/rps-v/32/342_2.png) [@rps-v](https://community.cratedb.com/u/rps-v)\
**Post date:** [July 7, 2021, 12:01pm UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/3 "2021-07-07T12:01:53Z")

</div>

The oldest tables were created on Crate v3.2.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/b6a4400febc9ba67d1fa271711f7413a3dbbcead.png)

---

<div class="post-metadata">

**Author:** ![jayeff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/jayeff/32/271_2.png) [@jayeff](https://community.cratedb.com/u/jayeff)\
**Post date:** [July 7, 2021, 12:16pm UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/4 "2021-07-07T12:16:18Z")

</div>

Hi @rps-v,

when re-creating the table I suppose you tried both `COPY TO` and `INSERT FROM QUERY`? Do both run into the circuit breaker issue?

Maybe it would be an option to circumvent this issue by splitting the data copy process into multiple smaller copy commands. For example for a partitioned table to move one partition after another.

Can you give this approach a try?

---

<div class="post-metadata">

**Author:** ![rps-v](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/rps-v/32/342_2.png) [@rps-v](https://community.cratedb.com/u/rps-v)\
**Post date:** [July 7, 2021, 12:36pm UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/5 "2021-07-07T12:36:23Z")

</div>

Only tried `INSERT FROM QUERY` so far and it seems that the circuit breaker exception is intermittent as the second time I ran the same query it worked fine.  
Will try `COPY TO` if it still fails somehow and keep you updated with the progress.  
Thanks for the suggestions !

---

<div class="post-metadata">

**Author:** ![proddata](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/proddata/32/1379_2.png) [@proddata](https://community.cratedb.com/u/proddata)\
**Post date:** [July 20, 2021, 7:09pm UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/6 "2021-07-20T19:09:03Z")

</div>

Did it work out in the end?

---

<div class="post-metadata">

**Author:** ![rps-v](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/rps-v/32/342_2.png) [@rps-v](https://community.cratedb.com/u/rps-v)\
**Post date:** [July 21, 2021, 6:25am UTC](https://community.cratedb.com/t/upgrade-from-4-2-6-to-4-3-0-problem/741/7 "2021-07-21T06:25:44Z")

</div>

We tested this on our smaller cluster and it worked using `COPY TO`. Haven’t gotten around to migrating the big cluster yet though… will keep you updated as soon as that happens.