Intermittent error related to analytics plugin in the logs
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
Research direction
Start with Metadata.getTable in Metadata.java, particularly the calls shown at lines 87, 140, and 234, and trace how jOOQ reads column defaults while caching report_accounts_summary metadata. Investigate why the default expression 0000-00-00 00:00:00 triggers the parser error; done looks like the reported log error is addressed.
Written by the indexing model from the issue text.
Description
The KB logs some time show the following error related to the analytics plugin:
2025-10-15T01:27:40,810+0000 lvl='INFO', log='MetaImpl', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Cannot parse default expression: 0000-00-00 00:00:00
org.jooq.impl.ParserException: Unexpected content after end of field input: [1:12] 0000-00-00 [*]00:00:00
at org.jooq.impl.DefaultParseContext.exception(ParserImpl.java:13544)
at org.jooq.impl.DefaultParseContext.done(ParserImpl.java:13704)
at org.jooq.impl.DefaultParseContext.parseField0(ParserImpl.java:563)
at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:428)
at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:423)
at org.jooq.impl.MetaImpl$MetaTable.initColumns(MetaImpl.java:1084)
at org.jooq.impl.MetaImpl$MetaTable.<init>(MetaImpl.java:679)
at org.jooq.impl.MetaImpl$MetaSchema.lambda$getTables$2(MetaImpl.java:425)
at org.jooq.impl.Tools.map(Tools.java:2020)
at org.jooq.impl.MetaImpl$MetaSchema.getTables(MetaImpl.java:397)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:140)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:87)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata$3.run(Metadata.java:234)
2025-10-15T01:27:40,850+0000 lvl='INFO', log='MetaImpl', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Cannot parse default expression: 0000-00-00 00:00:00
org.jooq.impl.ParserException: Unexpected content after end of field input: [1:12] 0000-00-00 [*]00:00:00
at org.jooq.impl.DefaultParseContext.exception(ParserImpl.java:13544)
at org.jooq.impl.DefaultParseContext.done(ParserImpl.java:13704)
at org.jooq.impl.DefaultParseContext.parseField0(ParserImpl.java:563)
at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:428)
at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:423)
at org.jooq.impl.MetaImpl$MetaTable.initColumns(MetaImpl.java:1084)
at org.jooq.impl.MetaImpl$MetaTable.<init>(MetaImpl.java:679)
at org.jooq.impl.MetaImpl$MetaSchema.lambda$getTables$2(MetaImpl.java:425)
at org.jooq.impl.Tools.map(Tools.java:2020)
at org.jooq.impl.MetaImpl$MetaSchema.getTables(MetaImpl.java:397)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:140)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:87)
at org.killbill.billing.plugin.analytics.reports.sql.Metadata$3.run(Metadata.java:234)
2025-10-15T01:27:40,852+0000 lvl='INFO', log='Metadata', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Caching metadata for table report_accounts_summary
This needs to be investigated and addressed.
- Dominant language
- Java
- Stars
- 13
- Forks
- 33
- PR merge metrics
- No merged PRs in 30d
Getting set up
- No Dockerfile or Docker Compose file
- No pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from killbill/killbill-analytics-plugin
-
Difficulty 2/5 1-3 hours Newbie friendliness 45/100
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
-
Automation analysisOpen
Difficulty 5/5 Over a week Newbie friendliness 20/100
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
killbill/killbill-analytics-plugin#163 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 30/100
killbill/killbill-analytics-plugin#152 · 3 comments ·
All issues in killbill/killbill-analytics-plugin
Similar issues
-
component/data-layer
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 77/100
-
RegistryExceptionHandler uses self-referencing basePackageClasses instead of a controller classOpenbug finsim-registry good-first-issue
Difficulty 1/5 Under an hour Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
? - Needs Triage bug
Difficulty 2/5 1-3 hours Newbie friendliness 66/100
NVIDIA/cudf-spark#17063 ·
Maintainers usually reply within 2 days
-
status:pending type:bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100