z309 export failing with 'Segmentation Fault (core dumped)
- Article Type: General
- Product: Aleph
- Product Version: 21
Problem Symptoms:
* When using Export Database Tables (file-03) to export Circulation logger table (z309), the job fails with error:
$alephe_scratch/xxx50_p_file_03.nnnnn
in_fl: /exlibris/aleph/u20_1/xxx50/files/z309.seqaa.DLM out_fl: /exlibris/aleph/u20_1/xxx50/files/z309.seqaa
Segmentation Fault (core dumped)
* The tables has more than 13 Mio records
Cause:
The file is larger than 2 GB (file size limit in Unix)
Resolution:
Split the files using a lower amount of records per file, thus avoiding the file size limit of 2 GB per Unix files.
Additional Information
See also information in the 'Export Database Tables (file-03) service help file:
No. of Records per File
This field defines the number of records that will be included in each sequential file. To be used in case the size of one sequential file exceeds 2 GB. When used, the data will be split into several sequential files. If the field is left blank, then the program performs the split according to the number of records in the table.
The sequential files are named <table>.seq[a-z][a-z]. For example, for z02 the files will be z02.seqaa, z02.seqab ... z02.seqba, z02.seqbb.
You may then use the Import Database Tables - Without Checks (file-04) service to load the sequential files produced by this service. The Import Database Tables procedure will import all related files.
Category: Background processing (500)
- Article last edited: 10/8/2013