Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error: canceling statement due to statement timeout #108

Open
bradley-varol opened this issue May 3, 2023 · 0 comments
Open

error: canceling statement due to statement timeout #108

bradley-varol opened this issue May 3, 2023 · 0 comments

Comments

@bradley-varol
Copy link

bradley-varol commented May 3, 2023

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant