Strange 'ORA-01002: fetch out of sequence' issue

[stevefan1999-personal]

I tried to use the latest oracledb driver for Directus, but there is some problem during migration. It seems like the fetch cursor was invalidated, indicating something somewhere we have a concurrency problem.

Check this out
directus/directus#19067 (comment)

[sharadraju]

Thanks @stevefan1999-personal for testing our thin mode. What is the Oracle DB version that you are using?

I can see that Knex framework is used. Are you able to isolate the exact the SQL statement that causes this ORA-01002 error.
An isolated test case will help us immensely!

[sharadraju]

@stevefan1999-personal Were you able to run the Knex connection with a connection pool of maxSize 1?
Also do let us know, if you can isolate this issue and provide a simple, runnable test case. That would be extremely helpful.

[stevefan1999-personal]

@stevefan1999-personal Were you able to run the Knex connection with a connection pool of maxSize 1?
Also do let us know, if you can isolate this issue and provide a simple, runnable test case. That would be extremely helpful.

Let me check this weekend

[hinogi]

typeorm/typeorm#10285 seems to have the same problem with thin

[stevefan1999-personal]

Seems like there is indeed a concurrency issue

[sharadraju]

Closing this discussion as it has been fixed