https://linen.dev logo
Join Slack
Powered by
Hi Airbyte team, my previous attempt to do an upgr...
# ask-community-for-troubleshooting
j
Hi Airbyte team, my previous attempt to do an upgrade from 0.29.19-alpha to 0.32.0-alpha-patch-1 failed and I would like to revert everything but importing my backup is not working 😞 Does anyone know why? Error logs are added to the thread.
👀 1
Copy code
was aborted: An I/O error occurred while sending to the backend.  Call getNextException to see other errors in the batch.
	at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:526) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:870) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:893) ~[postgresql-42.2.18.jar:42.2.18]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:113) ~[jooq-3.13.4.jar:?]
	... 74 more
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:527) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:870) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:893) ~[postgresql-42.2.18.jar:42.2.18]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:113) ~[jooq-3.13.4.jar:?]
	... 74 more
Caused by: java.io.EOFException
	at org.postgresql.core.PGStream.receiveChar(PGStream.java:443) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2057) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:521) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:870) ~[postgresql-42.2.18.jar:42.2.18]
	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:893) ~[postgresql-42.2.18.jar:42.2.18]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[commons-dbcp2-2.7.0.jar:2.7.0]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:112) ~[jooq-3.13.4.jar:?]
	at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:113) ~[jooq-3.13.4.jar:?]
	... 74 more
Publish operation is approaching monitor period. Increase period or risk compromising fixed rate.
I also see
Copy code
2022-01-05 23:48:43 INFO o.j.t.JooqLogger(info):312 - {cloud_workspace_app_root=/workspace/server/logs} - Single batch             : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
2022-01-05 23:48:50 INFO o.j.t.JooqLogger(info):312 - {cloud_workspace_app_root=/workspace/server/logs} - Single batch             : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
2022-01-05 23:48:51 INFO i.a.s.RequestLogger(filter):109 - {cloud_workspace_app_root=/workspace/server/logs} - REQ 172.20.58.87 GET 200 /api/v1/health
2022-01-05 23:48:57 WARN i.a.s.ConfigDumpImporter(importDatabaseFromArchive):258 - {cloud_workspace_app_root=/workspace/server/logs} - Postgres database version upgrade failed, reverting to state previous to migration.
2022-01-05 23:48:57 ERROR i.a.s.h.ArchiveHandler(importInternal):151 - {cloud_workspace_app_root=/workspace/server/logs} - Import failed
u
@Jiyuan Zheng can you share the complete logs from the airbyte-server?
j
@[DEPRECATED] Marcos Marx here is the log - I removed our actual config as it contains some sensitive information
u
Do you have enough space in disk and permissions to write folders and files inside the instance using Airbyte?
m
so this was a deadlock on DB side. I scaled down scheduler and let server do the initial config load and then scaled up scheduler. all good now
👍 2
u
@Mohammad Safari weird because the patch-1 would handle in smaller batches to made the upgrade!
m
this is 0.29.12
u
yep, but you’re upgrading to the 0.32.0-patch right?
10 Views
Open in Slack
PreviousNext
Powered by