Skip to content

[Messenger] Fix Oracle errors 'ORA-00955: Name is already used by an existing object' with Doctrine transport #60211

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

Open
wants to merge 3 commits into
base: 7.2
Choose a base branch
from

Conversation

atgitwk
Copy link

@atgitwk atgitwk commented Apr 13, 2025

Q A
Branch? 7.2
Bug fix? yes
New feature? no
Deprecations? no
Issues Fix #59903
License MIT

Initialization of MESSENGER objects causes an Oracle error when using messenger:setup-transports.
For more explanation, please see issue #59903

@carsonbot carsonbot added this to the 7.2 milestone Apr 13, 2025
@nicolas-grekas nicolas-grekas changed the title [Messenger] Fix Oracle errors 'ORA-00955: Name is already used by an … [Messenger] Fix Oracle errors 'ORA-00955: Name is already used by an existing object' with Doctrine transport Jun 27, 2025
@symfony symfony deleted a comment from carsonbot Jun 27, 2025
@symfony symfony deleted a comment from carsonbot Jun 27, 2025
@nicolas-grekas
Copy link
Member

Can you please have a look at the test failures? They're related for the component.

$serverVersion = $this->driverConnection->executeQuery("SELECT version FROM product_component_version WHERE product LIKE 'Oracle Database%'")->fetchOne();
if (version_compare($serverVersion, '12.1.0', '>=')) {
$idColumn->setAutoincrement(false); // disable the creation of SEQUENCE and TRIGGER
// The line below is taken into account only if Oracle version is >= 12.1.0
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I think this clear by the version compare, right? So do we need this comment?

Copy link
Author

@atgitwk atgitwk Jun 30, 2025

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yes, you're right, I can remove it.

Sorry, I'm new to GitHub and PR stuff. And I still have a few tests with errors :(
fabbot.io tells me that I should have done a “rebase” instead of a “merge” when i synchronize upstream/7.2 with my fix branch. And I don't understand why I have to write -\strlen() instead of -strlen()...

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

There is a few functions in PHP which benefit from a special compilation into OPCodes (making their execution faster), but those optimization require the call to be fully qualified instead of using the global function fallback. strlen is one of those functions, which is why our CI enforces qualifying calls so that we benefit from the optimizations.

Copy link
Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

-strlen() has already been there for a long time thru several versions , so may I fix it?

@atgitwk
Copy link
Author

atgitwk commented Jul 1, 2025

Still have some failing checks, may anyone help ?

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

Successfully merging this pull request may close these issues.

5 participants