A few smaller tables succeeded but then:
drop table if exists history;
import TABLE history (
itemid bigint NOT NULL,
clock integer NOT NULL,
value numeric(20,4) NOT NULL,
ns integer NOT NULL
csv data (‘nodelocal:///home/cockroach/csv/crdb/data/history.csv’)
with temp=‘nodelocal:///home/cockroach/csv/crdb/tmp’, nullif = ‘\N’;
pq: result is ambiguous (job lease expired)
Error: pq: result is ambiguous (job lease expired)
Failed running “sql”
nodelocal:///home/cockroach/csv is on a nfs share that is mounted on all nodes.
all nodes are marked dead in the gui
the input is about 500M and contains 15730985 rows.
Good thing is that the nodes do rejoin the cluster after about 10 minutes but the import still fails on me,
any tips on this?