pt-upgrade fails on SELECT ... INTO queries

Bug #1421781 reported by Frank Cizmich on 2015-02-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Fix Released
Medium
Frank Cizmich

Bug Description

pt-upgrade fails when a query is of the form SELECT ... INTO

e.g: SELECT 1 INTO @foo

error:
DBD::mysql::st fetchall_arrayref failed: fetch() without execute()

It seems the tool expects the fetchall_array command to succeed (expects 0 or more rows), but the DBI module considers the whole procedure complete, since it's not a "true" SELECT.

PT 2.2.13
DBI version 1.663 (latest as of writing)

Related branches

Changed in percona-toolkit:
status: New → In Progress
milestone: none → 2.2.14
importance: Undecided → Medium
assignee: nobody → Frank Cizmich (frank-cizmich)
tags: added: pt-upgrade
Changed in percona-toolkit:
status: In Progress → Fix Committed
Frank Cizmich (frank-cizmich) wrote :

Fixed by filtering out SELECT...INTO queries

Changed in percona-toolkit:
status: Fix Committed → Fix Released

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-675

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers