Import in 1.2-alpha.20171204


(Alma) #21

Hi @mjibson,
I am running v2.1.3 and I am seeing this error too.

I am trying to load a single table, 29Gb sql dump file from nodelocal. I tried twice. The job progresses to about 20% and both times I got the exact same message:
Error: pq: IO error: While open a file for appending: /export/data/cockroachdb/cockroach-tmp/cockroach-temp024783182/000006.log: No such file or directory
Failed running “sql”

In the log file on the node I was executing the statement on, I see:
E190208 15:23:31.486491 143216679 storage/engine/disk_map.go:273 [n2,import-distsql] unable to clear range with prefix [140]: IO error: While open a file for appending: /export/data/cockroachdb/cockroach-tmp/cockroach-temp024783182/000006.log: No such file or directory

The path /export/data/cockroachdb/cockroach-tmp/cockroach-temp024783182/ does not exist on any of the nodes. The nodes did not get restarted and nobody else was doing anything on the cluster during the load (no other users except me). I managed to successfully load smaller tables.
I run on 3 bare metal hosts. I abused them with tpc-c and they seemed to be stable.

Let me know what other info would be useful.
Thanks!


(Matt Jibson) #22

What mount type is /export/data? Is it just a normal directory on a local disk, or NFS or some other network storage?


(Alma) #23

/export/data is local disk;
/export/data/cockroachdb/cockroach-data/extern is a symlink to NFS;