October 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HSEARCH-4678) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID

by Yasin Koyuncu (JIRA)

Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiMzA... ) Re: select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiMzA... ) Yes, I already saw those configurations, however it is limited and does not allow me to change this sequence configuration. But maybe this solution using UUID s could be the solution without polluting configuration options. ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4678) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNWF... ) Re: select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNWF... ) > > > > we can use the jpa annotations > > That’s not an option, as Hibernate Search needs to be able to add that entity to the Hibernate ORM mapping conditionally depending on settings. Believe me, we’re not using XML mapping because we like it 😑 It’s just the only solution for dynamic mapping (yes, it’s dynamic). Also, I don’t really want to expose these entity types as API, because that will get in the way of future evolutions. There’s a middle ground to be found between flexibility for Hibernate Search users and flexibility for Hibernate Search developers. You can already change the XML mapping yourself if you want, through configuration properties. Though that’s completely unsupported and could break at any time: see org.hibernate.search.mapper.orm.coordination.outboxpolling.cfg.spi.HibernateOrmMapperOutboxPollingSpiSettings#OUTBOXEVENT_ENTITY_MAPPING. ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4678) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID

by Yasin Koyuncu (JIRA)

Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *commented* on HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNGU... ) Re: select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNGU... ) I think maybe instead of using this hardcoded entity mapping, we can use the jpa annotations on the entity and if someone wants to override them they can use xml configuration for it for their own needs? ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15598) Remove unused legacy SPIs: InstrumentedClassLoader, ByteCodeHelper

by Sanne Grinovero (JIRA)

Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-15598 ( https://hibernate.atlassian.net/browse/HHH-15598?atlOrigin=eyJpIjoiZmFlMj... ) Re: Remove unused legacy SPIs: InstrumentedClassLoader, ByteCodeHelper ( https://hibernate.atlassian.net/browse/HHH-15598?atlOrigin=eyJpIjoiZmFlMj... ) Sent a draft: https://github.com/hibernate/hibernate-orm/pull/5406 ( https://github.com/hibernate/hibernate-orm/pull/5406 ) ( https://hibernate.atlassian.net/browse/HHH-15598#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15598#add-comment?atlOrigin=ey... ) 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4716) JDBC Batch performance affected by outbox event sequence generator

by Yoann Rodière (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4716) JDBC Batch performance affected by outbox event sequence generator

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4716 ( https://hibernate.atlassian.net/browse/HSEARCH-4716?atlOrigin=eyJpIjoiMTQ... ) Re: JDBC Batch performance affected by outbox event sequence generator ( https://hibernate.atlassian.net/browse/HSEARCH-4716?atlOrigin=eyJpIjoiMTQ... ) Thanks for reporting. This looks like an alternative solution to the same problem as https://hibernate.atlassian.net/browse/HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678 ). Maybe you’ll want to chime in there? ( https://hibernate.atlassian.net/browse/HSEARCH-4716#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4716#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4678) select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HSEARCH-4678 ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNTU... ) Re: select nextval ('hsearch_outbox_event_generator ') performs very slowly on CockroachDB，why not use UUID ( https://hibernate.atlassian.net/browse/HSEARCH-4678?atlOrigin=eyJpIjoiNTU... ) Someone proposed an alternative solution on https://hibernate.atlassian.net/browse/HSEARCH-4716 ( https://hibernate.atlassian.net/browse/HSEARCH-4716 ). I suppose we could do both (allow UUIDs or sequences with a large increment size), but I’d like to avoid an explosion of the amount of setups in the wild, which would cause us much trouble when testing. So I’d really like to find one solutions that satisfies everyone, if possible… ( https://hibernate.atlassian.net/browse/HSEARCH-4678#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4678#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HHH-15598) Remove unused legacy SPIs: InstrumentedClassLoader, ByteCodeHelper

by Sanne Grinovero (JIRA)

Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMmUzOWRmZWY4... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15598?atlOrigin=eyJpIjoiMmUzOW... ) HHH-15598 ( https://hibernate.atlassian.net/browse/HHH-15598?atlOrigin=eyJpIjoiMmUzOW... ) Remove unused legacy SPIs: InstrumentedClassLoader, ByteCodeHelper ( https://hibernate.atlassian.net/browse/HHH-15598?atlOrigin=eyJpIjoiMmUzOW... ) Issue Type: Improvement Assignee: Unassigned Created: 12/Oct/2022 01:12 AM Fix Versions: 6.2.0 Priority: Major Reporter: Sanne Grinovero ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The org.hibernate.bytecode.spi.InstrumentedClassLoader is a little utility we don't use ourselves anymore. It's simple enough that anyone needing such a thing could re-implement it themselves so I suggest we remove it. Same for org.hibernate.bytecode.spi.ByteCodeHelper : it has no use within our own runtime code, but it's used by tests - so I'd move it to the testing utilities. Since these are SPIs I’m proposing the change for 6.2, without need for a deprecation cycle. I’ll send a draft to check if this is agreeable. ( https://hibernate.atlassian.net/browse/HHH-15598#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15598#add-comment?atlOrigin=ey... ) 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4716) JDBC Batch performance affected by outbox event sequence generator

by Yasin Koyuncu (JIRA)

2 years, 3 months

1
0
0 / 0

[JIRA] (HSEARCH-4716) JDBC Batch performance affected by event box sequence generator

by Yasin Koyuncu (JIRA)

Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiNmVlNzE4... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-4716?atlOrigin=eyJpIjoiNmV... ) HSEARCH-4716 ( https://hibernate.atlassian.net/browse/HSEARCH-4716?atlOrigin=eyJpIjoiNmV... ) JDBC Batch performance affected by event box sequence generator ( https://hibernate.atlassian.net/browse/HSEARCH-4716?atlOrigin=eyJpIjoiNmV... ) Issue Type: Improvement Affects Versions: 6.1.6.Final Assignee: Unassigned Components: mapper-orm-coordination-outbox-polling Created: 12/Oct/2022 01:01 AM Priority: Minor Reporter: Yasin Koyuncu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=70121%3... ) We are using jdbc batching and I noticed the bottleneck was these queries which were executed too often: select nextval ('hsearch_outbox_event_generator') Then I’ve looked a bit in the code and found this entity mapping: in org.hibernate.search.mapper.orm.coordination.outboxpolling.event.impl. OutboxPollingOutboxEventAdditionalJaxbMappingProducer public static final String ENTITY_DEFINITION = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" + "<hibernate-mapping>\n" + " <class name=\"" + CLASS_NAME + "\" entity-name=\"" + ENTITY_NAME + "\" table=\"" + TABLE_NAME + "\">\n" + " <id name=\"id\" type=\"long\">\n" + " <generator class=\"org.hibernate.id.enhanced.SequenceStyleGenerator\">\n" + " <param name=\"sequence_name\">" + TABLE_NAME + "_GENERATOR</param>\n" + " <param name=\"table_name\">" + TABLE_NAME + "_GENERATOR</param>\n" + " <param name=\"initial_value\">1</param>\n" + " <param name=\"increment_size\">1</param>\n" + " </generator>\n" + " </id>\n" + " <property name=\"entityName\" type=\"string\" length=\"256\" nullable=\"false\" />\n" + " <property name=\"entityId\" type=\"string\" length=\"256\" nullable=\"false\" />\n" + " <property name=\"entityIdHash\" type=\"integer\" index=\"entityIdHash\" nullable=\"false\" />\n" + " <property name=\"payload\" type=\"materialized_blob\" nullable=\"false\" />\n" + " <property name=\"retries\" type=\"integer\" nullable=\"false\" />\n" + " <property name=\"processAfter\" type=\"Instant\" index=\"processAfter\" nullable=\"true\" />\n" + " <property name=\"status\" index=\"status\" nullable=\"false\">\n" + " <type name=\"org.hibernate.type.EnumType\">\n" + " <param name=\"enumClass\">" + OutboxEvent.Status.class.getName() + "</param>\n" + " </type>\n" + " </property>\n" + " </class>\n" + "</hibernate-mapping>\n"; In order to make less calls we can increase the following value: {{ <param name=\"increment_size\">1</param>\n"}} Is it possible to make this configurable? Thx in advance, Yasin ( https://hibernate.atlassian.net/browse/HSEARCH-4716#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-4716#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100208- sha1:399748d )

2 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2022