Segmentation fault when importing data from a 7.4 databaseinstance into a 7.6 i

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	mysql openssl Question
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	Update one field with more fields from another table
•	Getting Identity after INSERT
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	mysql test 4 1 fails with the gis test
•	MySQL Cluster Software
•	Downgrade Mysql from 4 to 3 23
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Can 't access mysql after kernel upgrade
•	Executing MySQL Commands From Within C Program
•	Comparing and writing out BLOBS
•	Preventing Duplicate Entries
•	FULLTEXT query format question
•	Strange behavior, Table Level Permission
•	Does the binary log enabling affect the MySQL performances?
•	mysql:it 's a db not a dbms how it 's possible?!
•	mysql have same function mthod as Oracle decode()

Segmentation fault when importing data from a 7.4 databaseinstance into a 7.6 i

Segmentation fault when importing data from a 7.4 databaseinstance into a 7.6 i

2007-05-17 - By Johan Hallgren

Back
Hello list,

I am attempting to export the data and catalog for a user in a 7.4.03.27
instance and import them into a 7.6.00.34 instance. The procedure I
follow is this, using the database tools on the server running the 7.6
instance for all operations:

1. I have ensured that the 7.6 instance has COLUMNCOMPRESSION set to NO,
and that it is an ASCII instance, just like the source 7.4 instance.
2. I export the catalog and data for a user from the source instance
with this loader command:
EXPORT USER CATALOG OUTSTREAM '1altwebcat.txt' DATA OUTSTREAM
'1altweb.txt'
This seems to complete successfully.
3. I then import the catalog into the target instance with this command.
The catalog import works with no errors:
IMPORT USER CATALOG INSTREAM '1altwebcat.txt'
4. Using the sqlcli I then drop all foreign keys from the just imported
catalog, to remove the chance of integrity violations during data
import. This also works fine.
5. I then try and import the user data using this command:
IMPORT USER DATA INSTREAM '1altweb.txt' PAGES
This populates a few tables with data, but then stops with "Segmentation
fault" being displayed in the console, with not error code of any kind.
The loader log file simply contains these lines for the import:
IMPORT USER DATA INSTREAM '1altweb.txt' PAGES
// *
// M Import PACKAGE
x'01000000A3AD4C46EE230000D1F9FA1A04C4AC1200000000'
// *
// M Execute PACKAGE to transform DATA
// *
// M Number of TABLES to transform: 0
// *
There is no ending error or anything.

I have tried the same procedure for other users in the same instance,
and in those cases all data can be successfully imported. Further, in
checking the data in the source instance for the first table whose data
fails to be imported, nothing there looks out of the ordinary.

Any insight on what could possibly be wrong would be most appreciated!

Thanks,
Johan Hallgren

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)