8000 On execution of FULLTEXT search / AQL query db is restarting · Issue #4185 · arangodb/arangodb · GitHub
[go: up one dir, main page]
Skip to content

On execution of FULLTEXT search / AQL query db is restarting #4185

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
6 of 29 tasks
swapniltx opened this issue Dec 30, 2017 · 5 comments
Closed
6 of 29 tasks

On execution of FULLTEXT search / AQL query db is restarting #4185

swapniltx opened this issue Dec 30, 2017 · 5 comments
Assignees
@jsteemann
Labels
1 Bug 2 Fixed Resolution 3 AQL Query language related 3 Index
Milestone
3.3

Comments

@swapniltx
Copy link
swapniltx commented Dec 30, 2017 •
edited
Loading

my environment running ArangoDB

I'm using the latest ArangoDB of the respective release series:

  • 2.8
  • 3.0
  • 3.1
  • 3.2
  • 3.3
  • self-compiled devel branch

Mode:

  • Cluster
  • Single-Server

Storage-Engine:

  • mmfiles
  • rocksdb

On this operating system:

  • DCOS on
    • AWS
    • Azure
    • own infrastructure
    • GCP
  • Linux
    • Debian .deb
    • Ubuntu .deb (16.04)
    • SUSE .rpm
    • RedHat .rpm
    • Fedora .rpm
    • Gentoo
    • docker - official docker library
    • other:
  • Windows, version:
  • MacOS, version:

this is an AQL-related issue:

[ ] I'm using graph features

I'm issuing AQL via:

  • web interface with this browser: running on this OS:
  • arangosh
  • this Driver: NodeJS

I've run db._explain("<my aql query>") and it didn't shed more light on this.
The AQL query in question is:

The issue can be reproduced using this dataset:

log

2017/12/30 07:55:42 single has terminated, quickly, in 24.861013999s (recent failures: 1)
2017/12/30 07:55:42 restarting single
2017/12/30 07:55:42 Looking for a running instance of single on port 8529
2017/12/30 07:55:42 Starting single on port 8529
2017-12-30T07:55:42Z [20746] INFO ArangoDB 3.3.1 [linux] 64bit, using jemalloc, VPack 0.1.30, RocksDB 5.6.0, ICU 58.1, V8 5.7.492.77, OpenSSL 1.0.2g 1 Mar 2016
2017-12-30T07:55:42Z [20746] INFO detected operating system: Linux version 4.13.0-1002-gcp (buildd@lgw01-amd64-060) (gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ub
untu1~16.04.5)) #5-Ubuntu SMP Tue Dec 5 13:20:17 UTC 2017
@swapniltx
Copy link
Author

arangodb 3.2 setup is working fine with same configuration

@jsteemann
Copy link
Contributor

@xbirdblack : could you please provide some basic information about the AQL query you are executing? It would help if you could post the query string here and the list of indexes for the collection in question. Thanks!

@maxkernbach maxkernbach added the 3 AQL Query language related label Jan 2, 2018
@swapniltx
Copy link
Author

Query from node js driver
FOR d IN FULLTEXT('users', 'name', ${search}, 3) RETURN { name: d.name, id: d._id }
collection users
{ name: 'pipare', email: 'pipare@example.com' }
index - FULLTEXT
field - name
min - 3

@jsteemann jsteemann added the 1 Bug label Jan 5, 2018
jsteemann added a commit that referenced this issue Jan 5, 2018
@jsteemann
fixed issue #4185: On execution of FULLTEXT search / AQL query db is …
03ae15a 
…restarting
jsteemann added a commit that referenced this issue Jan 5, 2018
@jsteemann
fixed issue #4185: On execution of FULLTEXT search / AQL query db is …
0183813 
…restarting
@jsteemann
Copy link
Contributor

A potential fix for the issue is contained in this pull request: #4239
I have to discuss this fix next week, as it will turn the optimization off in some cases, and this may be improved still.

@jsteemann jsteemann self-assigned this Jan 5, 2018
jsteemann added a commit that referenced this issue Jan 15, 2018
@jsteemann
fixed issue #4185: On execution of FULLTEXT search / AQL query db is … (
f31734a 
#4239)
jsteemann added a commit that referenced this issue Jan 15, 2018
@jsteemann
fixed issue #4185: On execution of FULLTEXT search / AQL query db is … (
653f95f 
#4238)
@maxkernbach maxkernbach added the 2 Fixed Resolution label Jan 31, 2018
@maxkernbach maxkernbach added this to the 3.3 milestone Jan 31, 2018
@maxkernbach
Copy link
Contributor

Hi @xbirdblack,

thanks for reporting the bug. Version 3.3.3 including the fix for FULLTEXT search is released.
Please reopen this issue if the problem still occurs.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jsteemann jsteemann

Labels
1 Bug 2 Fixed Resolution 3 AQL Query language related 3 Index
Projects
None yet
Milestone
3.3
Development

No branches or pull requests
5 participants
@jsteemann @dothebart @swapniltx @Simran-B @maxkernbach
0