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

embulk-output-mysql (0.8.7) TimeZone(Unknown Source) #308

Open
lucleba opened this issue Jul 1, 2022 · 0 comments
Open

embulk-output-mysql (0.8.7) TimeZone(Unknown Source) #308

lucleba opened this issue Jul 1, 2022 · 0 comments

Comments

@lucleba
Copy link

lucleba commented Jul 1, 2022

Hi All,
I'm using:
● MySQL: 5.7.14
● embulk: 0.9.23
● embulk-output-mysql: 0.8.7

below is my config
in:
type: http
url: https://xxxx
parser:
type: xml2
root: aaa/bbb
schema:
- {name: tsr_id, type: long}
- {name: date, type: timestamp, format: '%Y/%m/%d'}}
method: get
read_timeout: 300000
out:
type: mysql
host: xxx.xxx.xxx.xxx
user: user
password: *******
database: db
table: table_xxx
options: {useLegacyDatetimeCode: false, serverTimezone: UTC}
mode: insert
column_options:
date: {type: 'DATETIME'}

however, sometimes i get error about time zone
below is the log I got

java.io.IOException: Stream closed at java.util.zip.InflaterInputStream.ensureOpen(InflaterInputStream.java:67) at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:121) at java.io.FilterInputStream.read(FilterInputStream.java:83) at java.io.DataInputStream.readUnsignedByte(DataInputStream.java:288) at org.joda.time.tz.DateTimeZoneBuilder.readMillis(DateTimeZoneBuilder.java:183) at org.joda.time.tz.DateTimeZoneBuilder$PrecalculatedZone.readFrom(DateTimeZoneBuilder.java:1359) at org.joda.time.tz.DateTimeZoneBuilder.readFrom(DateTimeZoneBuilder.java:119) at org.joda.time.tz.DateTimeZoneBuilder.readFrom(DateTimeZoneBuilder.java:98) at org.joda.time.tz.ZoneInfoProvider.loadZoneData(ZoneInfoProvider.java:226) at org.joda.time.tz.ZoneInfoProvider.getZone(ZoneInfoProvider.java:160) at org.joda.time.DateTimeZone.forID(DateTimeZone.java:216) at org.joda.time.DateTimeUtils.put(DateTimeUtils.java:451) at org.joda.time.DateTimeUtils.buildDefaultTimeZoneNames(DateTimeUtils.java:441) at org.joda.time.DateTimeUtils.getDefaultTimeZoneNames(DateTimeUtils.java:412) at org.joda.time.format.DateTimeFormatterBuilder$TimeZoneName.parseInto(DateTimeFormatterBuilder.java:2294) at org.joda.time.format.DateTimeParserBucket.doParseMillis(DateTimeParserBucket.java:179) at org.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:780) at org.embulk.spi.time.TimeZoneIds.parseJodaDateTimeZone(TimeZoneIds.java:142) at org.embulk.spi.time.TimestampFormatter$TimestampColumnOption.getTimeZone(TimestampFormatter.java:130) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) at org.embulk.config.TaskInvocationHandler.invoke(TaskInvocationHandler.java:165) at org.embulk.output.jdbc.setter.$Proxy53.getTimeZone(Unknown Source) at org.embulk.spi.time.TimestampFormatter.<init>(TimestampFormatter.java:29) at org.embulk.output.jdbc.setter.ColumnSetterFactory.newTimestampFormatter(ColumnSetterFactory.java:92) at org.embulk.output.jdbc.setter.ColumnSetterFactory.newCoalesceColumnSetter(ColumnSetterFactory.java:143) at org.embulk.output.jdbc.setter.ColumnSetterFactory.newColumnSetter(ColumnSetterFactory.java:42) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.newColumnSetters(AbstractJdbcOutputPlugin.java:787) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.doBegin(AbstractJdbcOutputPlugin.java:595) at org.embulk.output.MySQLOutputPlugin.doBegin(MySQLOutputPlugin.java:164) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$2.run(AbstractJdbcOutputPlugin.java:452) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1284) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1272) at org.embulk.spi.util.RetryExecutor.run(RetryExecutor.java:81) at org.embulk.spi.util.RetryExecutor.runInterruptible(RetryExecutor.java:62) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1257) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1249) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.begin(AbstractJdbcOutputPlugin.java:446) at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.transaction(AbstractJdbcOutputPlugin.java:422) at org.embulk.exec.BulkLoader$4$1$1.transaction(BulkLoader.java:521) at org.embulk.exec.LocalExecutorPlugin.transaction(LocalExecutorPlugin.java:50) at org.embulk.exec.BulkLoader$4$1.run(BulkLoader.java:516) at org.embulk.spi.util.Filters$RecursiveControl.transaction(Filters.java:84) at org.embulk.spi.util.Filters.transaction(Filters.java:42) at org.embulk.exec.BulkLoader$4.run(BulkLoader.java:511) at org.embulk.input.jdbc.AbstractJdbcInputPlugin.transaction(AbstractJdbcInputPlugin.java:225) at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:507) at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:35) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:353) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:350) at org.embulk.spi.Exec.doWith(Exec.java:22) at org.embulk.exec.BulkLoader.run(BulkLoader.java:350) at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:242) at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:291) at org.embulk.EmbulkRunner.run(EmbulkRunner.java:155) at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:431) at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:90) at org.embulk.cli.Main.main(Main.java:64)

Can someone help me solve this problem? thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant