Intermittent error related to analytics plugin in the logs

Open
#178 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
java, sql
Domain
data, databases

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

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from killbill/killbill-analytics-plugin

All issues in killbill/killbill-analytics-plugin

Similar issues

More Java issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.