Downloading Flow Results - SQL syntax Error
- Dominant language
- Python
- Stars
- 5.1k
- Forks
- 796
- PR merge metrics
- No merged PRs in 30d
Description
Collected ~700 files, when I go to export through the UI (Results tab, then generate archive) we get the following error:
> Archive generation failed for flow 90051C2E on client C.2adaf967040ba9e9: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")
The web UI has the following error in the log:
> ERROR:2019-09-03 20:38:39,443 1093 MainProcess 140060590860032 Thread-68406 http_api:593] Error while processing /api/clients/C.2adaf967040ba9e9/flows/90051C2E/results/files-archive (GET) with ApiGetFlowFilesArchiveHandler: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")
Traceback (most recent call last):
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/gui/http_api.py", line 532, in HandleRequest
binary_stream, method_name=method_metadata.name)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/gui/http_api.py", line 407, in _BuildStreamingResponse
peek = next(content)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/gui/api_call_handler_base.py", line 53, in GenerateContent
for chunk in self.content_generator:
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/gui/api_plugins/flow.py", line 634, in _WrapContentGenerator
for item in generator.Generate(flow_results):
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/gui/archive_generator.py", line 171, in Generate
for chunk in file_store.StreamFilesChunks(client_paths):
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/file_store.py", line 497, in StreamFilesChunks
hash_ids_by_cp.values())
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/db.py", line 3456, in ReadHashBlobReferences
return self.delegate.ReadHashBlobReferences(hashes)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/db_utils.py", line 53, in Decorator
result = f(*args, **kwargs)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql_utils.py", line 259, in Decorated
return self._RunInTransaction(Closure, readonly)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql.py", line 557, in _RunInTransaction
result = function(connection)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql_utils.py", line 257, in Closure
return func(self, *args, **new_kw)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql_blobs.py", line 155, in ReadHashBlobReferences
cursor.execute(query, [hash_id.AsBytes() for hash_id in hashes])
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql_pool.py", line 197, in execute
return self._forward(self.cursor.execute, query, args=args)
File "/usr/share/grr-server/local/lib/python2.7/site-packages/grr_response_server/databases/mysql_pool.py", line 166, in _forward
return method(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
Currently running 3.3.0post6. If you need additional details let me know!
Contributor guide
Assessment
This issue has not been assessed yet.