AnatolyUss/nmig

error: canceling statement due to statement timeout

bradley-varol opened this issue · 0 comments

I am receiving this error when migrating a table containing ~6 million records. I also see the following error when migrating a table with ~40k records that contains a BLOB column.

Any obvious reason i'm seeing a timeout and the error below?

	--[NMIG loadData] Loading the data into "public"."waveforms" table...
	--[populateTableWorker] error: canceling statement due to statement timeout

	SQL: COPY "public"."waveforms" FROM STDIN DELIMITER ',' CSV;


	--[populateTableWorker] Error loading table data:
SELECT `id` AS `id`,`track_id` AS `track_id`,HEX(`array`) AS `array` FROM `waveforms`;
/Users/bradleyvarol/Desktop/nmig/node_modules/pg-copy-streams/copy-from.js:120
    this.connection.stream.write(lenBuffer)
                    ^

TypeError: Cannot read properties of null (reading 'stream')
    at CopyStreamQuery.flushChunk (/Users/bradleyvarol/Desktop/nmig/node_modules/pg-copy-streams/copy-from.js:120:21)
    at CopyStreamQuery.flush (/Users/bradleyvarol/Desktop/nmig/node_modules/pg-copy-streams/copy-from.js:101:17)
    at CopyStreamQuery._writev (/Users/bradleyvarol/Desktop/nmig/node_modules/pg-copy-streams/copy-from.js:57:19)
    at doWrite (node:internal/streams/writable:409:12)
    at clearBuffer (node:internal/streams/writable:564:5)
    at onwrite (node:internal/streams/writable:464:7)
    at Object.onceWrapper (node:events:627:28)
    at Socket.emit (node:events:513:28)
    at afterWrite (node:internal/streams/writable:495:12)
    at onwrite (node:internal/streams/writable:480:7)

Node.js v18.15.0

	--[NMIG runLoaderProcess] For now inserted: 0 rows
	--[NMIG runLoaderProcess] Total rows to insert into "public"."waveforms": 0