Comments (3)
Hi, sorry for issue without a repro. I've found the condition that had this problem:
local result, err = server.net_box:call('crud.select', {'person_cross_ref', {{ '=', 'PartyUId', partyUId }}, {first = 1000} })
log.info("CRUD RESULT rows " .. #result.rows ) -- ..", " .. utils.dump(result.rows))
result, err = server.net_box:eval('return box.space.person_cross_ref:select()')
log.info("SPACE RESULT rows = " .. #result)
Output:
CRUD RESULT rows 100
SPACE RESULT rows = 116
Space definition:
return {
---
--- This migration creates cross-reference storage space 'person_cross_ref'.
---
--- For each person there is a set of cross-reference records:
--- {
--- partyUId = 'P123',
--- crossRefData = {{externalId, systemNumber, endDate}, ...}
--- }
---
up = function()
local utils = require('migrator.utils')
local s = box.schema.create_space('person_cross_ref', { if_not_exists = true })
s:format({
-- vshard bucket id
{ name = 'bucket_id', type = 'unsigned', is_nullable = false },
-- global record ID in Customer HUB
{ name = 'partyUId', type = 'string', is_nullable = false },
-- cross-reference array of objects
-- {
-- externalId -- string, person id in external system
-- systemNumber -- string, the id of external system
-- endDate, -- number, cross-ref validity unix-time (ms)
-- }
{ name = 'crossRefData', type = 'array', is_nullable = true },
})
s:create_index('person_cross_ref_pk', {
parts = { 'partyUId' },
unique = true,
if_not_exists = true,
type = 'TREE'
})
s:create_index('bucket_id', {
parts = { 'bucket_id' },
unique = false,
if_not_exists = true,
type = 'TREE'
})
utils.register_sharding_key('person_cross_ref', { 'bucket_id' })
return true
end
}
This reproduced on outdated version of crud. Need to retest on new versions..
Reproduced on these versions:
'cartridge == 2.3.0-1',
'crud == 0.4.0-1',
from crud.
local result, err = server.net_box:call('crud.select', {'person_cross_ref', {{ '=', 'PartyUId', partyUId }}, {first = 1000} })
Your space does not contain PartyUId
field, but contains partyUId
field. Anyway, if we make the same request with partyUId
field with crud 0.8.0, no problems arise.
from crud.
I think we can close it, thanks
from crud.
Related Issues (20)
- Borders fails to process bad fields
- operation_data usability
- Update operation convert is broken for splice HOT 2
- Replace/insert errors `operation_data` should always contain tuple that was not inserted
- [BUG] Calling `crud.get` causes a bunch of `fiber leak` errors HOT 1
- crud doesn't build key from conditions HOT 1
- Support vshard's `identification_mode` = `name_as_key` HOT 2
- Сan't initialize storage/router if no UUIDs
- support vshard `master: auto` HOT 1
- `box.info.ro` can be true in `init_storage()` on all instances in replicaset HOT 1
- It seems that crud is doing two selects in one `crud.get` HOT 3
- Add a role for tarantool 3.0 HOT 1
- After upgrade CRUD from 0.10.0 to 1.4.2 we got errors for different operations for old spaces. HOT 15
- Проблема с crud.count HOT 3
- Consider reworking batch operations info HOT 2
- Handle 'wrong symbol )' exception in case of comparision field with nil or {} on nonindexed column
- Bad error handling
- Vshard cluster does not start in tests
- `_many` operations fail to work with bucket specified
- Storage can't be initialized on tarantool 3.x with 2.x snapshot before an upgrade
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from crud.