https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
j

Jiyuan Zheng

01/05/2022, 11:21 PM
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

[DEPRECATED] Marcos Marx

01/05/2022, 11:58 PM
@Jiyuan Zheng can you share the complete logs from the airbyte-server?
j

Jiyuan Zheng

01/06/2022, 12:50 AM
@[DEPRECATED] Marcos Marx here is the log - I removed our actual config as it contains some sensitive information
u

[DEPRECATED] Marcos Marx

01/06/2022, 9:33 PM
Do you have enough space in disk and permissions to write folders and files inside the instance using Airbyte?
m

Mohammad Safari

01/07/2022, 1:03 AM
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

[DEPRECATED] Marcos Marx

01/07/2022, 4:38 PM
@Mohammad Safari weird because the patch-1 would handle in smaller batches to made the upgrade!
m

Mohammad Safari

01/07/2022, 4:38 PM
this is 0.29.12
u

[DEPRECATED] Marcos Marx

01/07/2022, 4:40 PM
yep, but youโ€™re upgrading to the 0.32.0-patch right?
10 Views