[MXS-661] Log fills with 'Length (0) is 0 or query string allocation failed' Created: 2016-04-04 Updated: 2018-01-15 Resolved: 2016-04-05 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | schemarouter |
| Affects Version/s: | 1.4.1 |
| Fix Version/s: | 1.4.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Stefan Schüller | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u4 x86_64 GNU/Linux |
||
| Issue Links: |
|
||||||||
| Description |
|
/var/log/maxscale/maxscale1.log fills up with the following:
Current config:
|
| Comments |
| Comment by Johan Wikman [ 2016-04-04 ] |
|
Would you be able to figure out what the query is? |
| Comment by Stefan Schüller [ 2016-04-04 ] |
|
I added a query log but it's empty. However I did notice that these errors come in bursts of 6 every 10 seconds. In my config the monitor_interval is also 10 seconds. EDIT: Changing monitor_interval to 20 seconds had no effect. The error is still every 10 seconds. There is a php loop script running that I think establishes a connection every 10 seconds but the query log is empty. EDIT2: The Issues is triggered by using mysql_ping 'http://php.net/manual/en/function.mysql-ping.php' . The script example will trigger the error. However mysql ping is deprecated and I believe Maxscale does not support 'Automatic reconnection' which is disabled by default in MySQL >= 5.0.3. |
| Comment by markus makela [ 2016-04-04 ] |
|
This is most likely caused by trying to parse a non-COM_QUERY packet. |
| Comment by markus makela [ 2016-04-05 ] |
|
Fixed in commit f834b4f5224ce482f697d6b337d65ea7efd3f47b. The cause was the parsing of non-COM_QUERY packets. |
| Comment by Timofey Turenko [ 2016-04-20 ] |
|
test added to 'sharding' test (added calls of 'mysql_ping() and checking logs for errors) |