Incomplete record transfer between 2 buckets

SQL++
1

Hi,

Has anyone ever experienced a scenario where when you insert/upsert from one bucket to another, not all the records are getting created and found a cause/solution? The number of records from the source is less than the number of records in the destination.

Below is the query we are using

insert into `B` (key _k, value _v) select meta().id _k, _v from `A` _v

CB Ver: Enterprise Edition 6.6.5 build 10080

Thank you in advance.

2

It should work. Check query.log any errors.
If bucke has many entires you should consider eventing Examples: Using the Eventing Service | Couchbase Docs

or XDCR

1 Like