Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork9.7k
Closed
Description
Symfony version(s) affected: 4.3
Description
In AbstractOracleDriver.php line 57:
An exception occurred while executing 'SELECT a.* FROM (SELECT m.* FROM messenger_messages m WHERE (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) AND (m.queue_name = ?) ORDER BY available_at ASC) a WHERE ROWNUM <= 1 FOR UPDATE' with params ["2019-09-26 10:26:28", "2019-09-26 11:26:28", "default"]: ORA-02014: FOR UPDATE kann nicht auf View mit DISTINCT, GROUP BY usw. augewandt werdenIn OCI8Exception.php line 16:
ORA-02014: FOR UPDATE kann nicht auf View mit DISTINCT, GROUP BY usw. augewandt werdenHow to reproduce
Use oracle12 with symfony 4.3 and messenger
Was affected with this issue too:#32427
Fixed it by removing the "T" from that dateformat
I think the query must be rewritten, so that the rownum filter is not on the outer sql. Maybe like this?https://stackoverflow.com/a/6337356/1953421
Could not try, because i do not know where to change the sql for the messenger select.