Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *created* an issue
Hibernate Search (
https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiZTJjZTk0...
) / Bug (
https://hibernate.atlassian.net/browse/HSEARCH-4727?atlOrigin=eyJpIjoiZTJ...
) HSEARCH-4727 (
https://hibernate.atlassian.net/browse/HSEARCH-4727?atlOrigin=eyJpIjoiZTJ...
) OutboxEvent "payload" column created as blob(255) with DB2 (
https://hibernate.atlassian.net/browse/HSEARCH-4727?atlOrigin=eyJpIjoiZTJ...
)
Issue Type: Bug Assignee: Unassigned Components: mapper-orm-coordination-outbox-polling
Created: 24/Oct/2022 02:31 AM Fix Versions: 6.2-backlog, 6.1.8.Final Priority: Major
Reporter: Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
)
For some reason, with DB2, we get the following schema for the outbox-polling tables:
create table HSEARCH_AGENT (
id bigint not null,
type integer,
name varchar(255),
expiration timestamp,
state integer,
totalShardCount integer,
assignedShardIndex integer,
payload blob(255),
primary key (id)
)
Hibernate:
create table HSEARCH_OUTBOX_EVENT (
id bigint not null,
entityName varchar(256),
entityId varchar(256),
entityIdHash integer,
payload blob(255),
retries integer,
processAfter timestamp,
status integer,
primary key (id)
)
blob(255) is way too small, and ideally we would need an unbounded data type.
(
https://hibernate.atlassian.net/browse/HSEARCH-4727#add-comment?atlOrigin...
) Add Comment (
https://hibernate.atlassian.net/browse/HSEARCH-4727#add-comment?atlOrigin...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100209- sha1:392b984 )