 |
I'm unable to reproduce this issue. Please provide more details and ideally specific steps to reproduce. Until then, this issue will be considered "on hold pending user data". |
 |
a GET request (while logged into MantisBT) to http://f.q.d.n/racktables/index.php?page=ipv4net&id=3 is the URI I used to trigger the the exception. Short of a full database dump, I really don't know what more I can offer you. We're about to replace this particular MySQL 5.7 instance with a Percona 5.6 instance. In the mean time, maybe try your unit test suite against MySQL 5.7, if you haven't? |
|
|
Full query:SELECT
tag_id,
TagStorage.user AS tag_user,
UNIX_TIMESTAMP(TagStorage.date) AS tag_time,
RackObject.id,
RackObject.name,
RackObject.label,
RackObject.asset_no,
RackObject.objtype_id,
(SELECT
MIN(rack_id)
FROM
RackSpace
WHERE
object_id = RackObject.id) AS rack_id,
(SELECT
MIN(parent_entity_id)
FROM
EntityLink
WHERE
child_entity_type = 'object'
AND child_entity_id = RackObject.id
AND parent_entity_type = 'rack') AS rack_id_2,
(SELECT
MIN(parent_entity_id)
FROM
EntityLink
WHERE
child_entity_type = 'object'
AND child_entity_id = RackObject.id
AND parent_entity_type = 'object') AS container_id,
(SELECT
name
FROM
RackObject
WHERE
id = container_id) AS container_name,
(SELECT
objtype_id
FROM
RackObject
WHERE
id = container_id) AS container_objtype_id,
RackObject.has_problems,
RackObject.comment,
(SELECT
COUNT(*)
FROM
Port
WHERE
object_id = RackObject.id) AS nports,
(SELECT
domain_id
FROM
VLANSwitch
WHERE
object_id = id
LIMIT 1) AS 8021q_domain_id,
(SELECT
template_id
FROM
VLANSwitch
WHERE
object_id = id
LIMIT 1) AS 8021q_template_id
FROM
RackObject
LEFT JOIN
TagStorage ON entity_realm = 'object'
AND entity_id = RackObject.id
WHERE
RackObject.id = '7'
ORDER BY tag_idWhen run against Percona 5.6, this works fine. When run against MySQL 5.7 with the same dataset, this fails. |
 |
I can confirm, that this mistake is appeared only in MySQL 5.7.X |
 |
This probably has to do with MySQL SQL mode changes in versions 5.7.x. |
 |
No issues so far with MySQL 5.7.12. I just removed "NO_ZERO_DATE" from 5.7 default modes, so RT install works file my.cnf [mysqld] sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" |
|
|
If you try to click a row one of the queries will fail because of ONLY_FULL_GROUP_BY. I would like to avoid managing the MySQL server if possible. |
|
|
I clicked some rows but all looks fine. I also can execute the full query in mysql without errors. (Empty Set of course) If i change RackObject.id i get some rows. |
|
|
A user on the mailing list has experienced the issue I meant. |
|
|
The solution to bug 1635 may have worked around this bug too, it would be great if anybody could check and update. I have not seen this bug reproducing. |
|
|
Could anybody test if the original issue still reproduces with the change mentioned in the previous comment applied? Thank you. |
|
|
This query does not fail on my MySQL server version 5.7.12. To work on this bug it is necessary to see how to reproduce it. |
|
|
If anybody can provide exact instructions how to reproduce this issue, please reopen. |
- Anonymous
