Bug #11090 Segmentation fault using 'source' command
Submitted: 3 Jun 2005 22:55 Modified: 4 Jul 2005 15:12
Reporter: Robert Sheets Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.0.6-beta OS:Linux (Debian linux (testing))
Assigned to: CPU Architecture:Any

[3 Jun 2005 22:55] Robert Sheets 
Description:
In upgrading from MySQL 5.0.4 to 5.0.6, I dumped my databases to a file with mysqldump.  Upon installing 5.0.6, I attempted to restore the databases using the 'source' command in the MySQL client.  After many syntax (1064) and packet size (1153) errors, the client segfaulted.  The end result was the partial restoration of the databases.

How to repeat:
I'm not sure what exactly in my dump file is causing the segfault, but repeating the 'source' again causes the exact same set of errors and it segfaults at the same point.  The error immediately before the segfault is:

ERROR 1064 (42000): 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 '',0),(45,NULL,'Hagerty Hall','171',11,1,'HH171','1','1','1','HH','J18B-3',6,24,0' at line 1

The next line after the line with the error is simply "UNLOCK TABLES;"
[4 Jun 2005 15:12] Jorge del Conde 
Hi,

I wasn't able to get strange results using the source command.  Can you please upload your dump file ?

Thanks
[4 Jul 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".