google / google/grr

Launch binaries failed with "Error 1406: Data too long for column 'data_value' at row 1"

Open
#981 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
5.1k
Forks
796
PR merge metrics
No merged PRs in 30d

Description

**Environment**
- GRR installed from DEB
- tested on both 3.4.5.1 and 3.4.6.0
- server is Ubuntu 18.04
- clients are Windows 10 and Ubuntu 18.04

**Describe the issue**
When starting a flow "LaunchBinary (3.4.51)" or "execute binary hack (3.4.6.0)", the flow is stopped before even being picked up by the client and fails with, after a long while, the error given below.

Same result on linux clients with a relatively simple binary (cp), and on windows clients with a cli binary that works perfectly when launched manually. Note that this is a fresh install of GRR, not an upgrade.

**Error logs**
```
<_InactiveRpcError of RPC that terminated with:
status = StatusCode.UNKNOWN
details = "Error 1406: Data too long for column 'data_value' at row 1"
debug_error_string = "{"created":"@1654186737.047671253","description":"Error received from peer ipv4:172.17.84.36:4444","file":"src/core/lib/surface/call.cc","file_line":952,"grpc_message":"Error 1406: Data too long for column 'data_value' at row 1","grpc_status":2}"
> (from http://lucxu20.int.excellium.lu/api/v2/clients/C.0ea9ee0871fa3889/flows)
```

**Additional context**
Modifying the tables broadcasts and pending_messages as shown below fixes the issue, but since I'm not sure of the root cause, that might really not be the best course of action:

```
alter table pending_messages
modify column data_value longblob;
alter table broadcasts
modify column data_value longblob;
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.