Open mfiume opened 10 years ago
Reported by Martine.
On pro server
This statement fails: SELECT upload_id, file_id, variant_id, dna_id, chrom, position, dbsnp_id, ref, alt, qual, filter, variant_type, zygosity, gt, custom_info INTO OUTFILE "/localhd/medsavant/server/medsavant-server-zip-1.1-rc-2/tmp/2013_11_22_8_27_1_952/dump/z_variant_proj1_ref3_update2.dump" FIELDS TERMINATED BY '\t' ENCLOSED BY '"' ESCAPED BY '\' FROM z_variant_proj1_ref3_update2
upload_id
file_id
variant_id
dna_id
chrom
position
dbsnp_id
ref
alt
qual
filter
variant_type
zygosity
gt
custom_info
As a temporary fix, I had to manually chmod the dump directory:
sudo chmod -R 777 /localhd/medsavant/server/medsavant-server-zip-1.1-rc-2/
This is a completely open setting for now, until we find out what the proper setting should be and how to automate it.
Reported by Martine.
On pro server
This statement fails: SELECT
upload_id,file_id,variant_id,dna_id,chrom,position,dbsnp_id,ref,alt,qual,filter,variant_type,zygosity,gt,custom_infoINTO OUTFILE "/localhd/medsavant/server/medsavant-server-zip-1.1-rc-2/tmp/2013_11_22_8_27_1_952/dump/z_variant_proj1_ref3_update2.dump" FIELDS TERMINATED BY '\t' ENCLOSED BY '"' ESCAPED BY '\' FROM z_variant_proj1_ref3_update2As a temporary fix, I had to manually chmod the dump directory:
sudo chmod -R 777 /localhd/medsavant/server/medsavant-server-zip-1.1-rc-2/
This is a completely open setting for now, until we find out what the proper setting should be and how to automate it.