Comments (4)
could you check your indexes with indextool to make sure these indexes are valid ?
from manticoresearch.
$ sudo indextool -c /etc/manticoresearch/manticore.conf --check la8_items_upcaft
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)
using config file '/etc/manticoresearch/manticore.conf'...
checking table 'la8_items_upcaft'...
WARNING: failed to load RAM chunks, checking only 3 disk chunks
checking schema...
checking disk chunk, extension 0, 0(3)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking kill-list...
checking dead row map...
checking doc-id lookup...
check passed, 9.2 sec elapsed
checking disk chunk, extension 1, 1(3)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking kill-list...
checking dead row map...
checking doc-id lookup...
check passed, 9.6 sec elapsed
checking disk chunk, extension 2, 2(3)...
checking schema...
checking dictionary...
checking data...
checking rows...
checking attribute blocks index...
checking kill-list...
checking dead row map...
checking doc-id lookup...
check passed, 10.5 sec elapsed
check passed, 10.5 sec elapsed
and the files:
$ ll /var/lib/manticore/la8_items_upcaft -h
total 658M
drwxrwxrwx 2 manticore manticore 4.0K Apr 10 01:53 .
drwxrwxrwx 5 manticore manticore 4.0K Apr 10 05:20 ..
-rw------- 1 manticore manticore 120M Apr 10 02:45 la8_items_upcaft.0.spa
-rw------- 1 manticore manticore 91M Apr 9 12:32 la8_items_upcaft.0.spb
-rw------- 1 manticore manticore 187M Apr 9 12:32 la8_items_upcaft.0.spd
-rw------- 1 manticore manticore 5.3M Apr 9 12:32 la8_items_upcaft.0.spe
-rw------- 1 manticore manticore 2.6K Apr 9 12:32 la8_items_upcaft.0.sph
-rw------- 1 manticore manticore 174K Apr 9 12:32 la8_items_upcaft.0.sphi
-rw------- 1 manticore manticore 7.8M Apr 9 12:32 la8_items_upcaft.0.spi
-rw------- 1 manticore manticore 103M Apr 9 12:32 la8_items_upcaft.0.spidx
-rw------- 1 manticore manticore 158K Apr 10 07:46 la8_items_upcaft.0.spm
-rw------- 1 manticore manticore 78M Apr 9 12:32 la8_items_upcaft.0.spp
-rw------- 1 manticore manticore 6.5M Apr 9 12:32 la8_items_upcaft.0.spt
-rw------- 1 manticore manticore 4.8M Apr 10 02:26 la8_items_upcaft.1.spa
-rw------- 1 manticore manticore 3.8M Apr 9 17:10 la8_items_upcaft.1.spb
-rw------- 1 manticore manticore 7.3M Apr 9 17:10 la8_items_upcaft.1.spd
-rw------- 1 manticore manticore 178K Apr 9 17:10 la8_items_upcaft.1.spe
-rw------- 1 manticore manticore 2.6K Apr 9 17:10 la8_items_upcaft.1.sph
-rw------- 1 manticore manticore 131K Apr 9 17:10 la8_items_upcaft.1.sphi
-rw------- 1 manticore manticore 998K Apr 9 17:10 la8_items_upcaft.1.spi
-rw------- 1 manticore manticore 4.4M Apr 9 17:10 la8_items_upcaft.1.spidx
-rw------- 1 manticore manticore 6.3K Apr 10 06:16 la8_items_upcaft.1.spm
-rw------- 1 manticore manticore 3.1M Apr 9 17:10 la8_items_upcaft.1.spp
-rw------- 1 manticore manticore 266K Apr 9 17:10 la8_items_upcaft.1.spt
-rw------- 1 manticore manticore 7.3M Apr 10 02:27 la8_items_upcaft.2.spa
-rw------- 1 manticore manticore 5.6M Apr 10 01:27 la8_items_upcaft.2.spb
-rw------- 1 manticore manticore 12M Apr 10 01:27 la8_items_upcaft.2.spd
-rw------- 1 manticore manticore 282K Apr 10 01:27 la8_items_upcaft.2.spe
-rw------- 1 manticore manticore 2.6K Apr 10 01:27 la8_items_upcaft.2.sph
-rw------- 1 manticore manticore 139K Apr 10 01:27 la8_items_upcaft.2.sphi
-rw------- 1 manticore manticore 1.3M Apr 10 01:27 la8_items_upcaft.2.spi
-rw------- 1 manticore manticore 6.5M Apr 10 01:27 la8_items_upcaft.2.spidx
-rw------- 1 manticore manticore 9.6K Apr 10 07:46 la8_items_upcaft.2.spm
-rw------- 1 manticore manticore 4.9M Apr 10 01:27 la8_items_upcaft.2.spp
-rw------- 1 manticore manticore 403K Apr 10 01:27 la8_items_upcaft.2.spt
-rwxrwxrwx 1 manticore manticore 0 Apr 10 05:20 la8_items_upcaft.lock
-rw------- 1 manticore manticore 2.6K Apr 10 01:53 la8_items_upcaft.meta
-rw------- 1 manticore manticore 28 Apr 10 01:53 la8_items_upcaft.ram
-rw------- 1 manticore manticore 31 Apr 10 01:53 la8_items_upcaft.settings
A thought: I don't think OPTIMIZE items_all
index is related to the breaking of the items_upcaft
index. Because since my OP i observed the same behavior simply by manually doing:
FLUSH RTINDEX la8_items_upcaft;
FLUSH RAMCHUNK la8_items_upcaft;
from manticoresearch.
could you provide your index as described in the manual Uploading-your-data ?
I'd like to issue FLUSH
statement as you described and investigate the issue.
from manticoresearch.
Its a production server, so I had to delete and rebuild the index from scratch, so I don't have it anymore. Next time it happens i will attach the index too.
from manticoresearch.
Related Issues (20)
- Filtering by string range returns unexpected result HOT 1
- Optimize chunks merging/compression algorithm HOT 3
- POC: integrate Rust ML library with Manticore Search C++ code HOT 7
- count(distinct ...) against multiple tables with different field order returns wrong value HOT 1
- Hybrid search
- Failed to start on windows HOT 13
- 'alter' doesn't work if datadir path located on a symlink HOT 2
- Mysqldump, wrong wordforms directory HOT 4
- Expand keywords after normalization
- Dropping a replicated distributed table should fail HOT 1
- INSERT via mysql fails with "Malformed packet" HOT 3
- Duplicated ids in a real-time table HOT 4
- Add support for Ubuntu Noble 24.04 HOT 2
- META total_found is wrong for a SQL query with HAVING HOT 2
- Ability to support using index fields as ranking factor HOT 3
- OPTIMIZE fails, then it says no such table (rt index) HOT 10
- `range` filter produced random order results even with `order by` condition HOT 1
- `sort` is not respected by manticoresearch
- Improve RELOAD ... switchover=1
- Protected tables in replication of Galera
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 manticoresearch.