Cockroach Compatibility problem on Connector Signin

michael.schramm

So far we are using fusionauth with cockroachdb as our database. PW Logins are working.

Right now the only remaining problem we see is with:

DELETE
      FROM user_registrations_application_roles USING user_registrations
      WHERE user_registrations_application_roles.user_registrations_id = user_registrations.id AND (...)
      ^
  Hint: You have attempted to use a feature that is not yet implemented.
See: https://go.crdb.dev/issue-v/40963/v20.2

I cannot see the remainder of the query, but would it be possible to remove the "USING"?

michael.schramm

Would it be possible to change the Query to something like:

DELETE FROM 
  user_registrations_application_roles 
WHERE 
  user_registrations_id IN 
    (
      SELECT 
        user_registrations.id
      FROM
        user_registrations
      WHERE
        user_registrations.id = user_registrations_application_roles.application_roles_id
        (...)
    )

joshua

Hi @michael-schramm,

If you could provide a bit more context to your issue, we could perhaps give a few pointers, but unfortunately, I believe this is outside of our accepted/documented use guidelines. FusionAuth is supported using MySQL and Postgres (documentation here).

Thanks,
Josh

dan

I would add to what @joshua said that this is definitely outside our supported scope. You definitely get kudos for being adventurous when it comes to pushing the bounds of FusionAuth, though!

What seems like it might be a minor SQL query change could have ramifications across different databases, including performance degradation. I'm sure you understand we'd need to test this change and incorporate it into our ongoing support matrix. Not trivial, unfortunately.

If this is an absolute requirement, you can definitely contact us about a professional services engagement/enterprise support contract and we could price out making these changes. Our queue is pretty full right now, so it might be a while until we could get to it, but always happy to chat. https://fusionauth.io/contact/

michael.schramm

no worries around it.

Cockroach itself provides great support to run within kubernetes / running in multiple availability zones with automated sharding. (not the average use case^^)

whenever it will be fixed on the cockroach side https://github.com/cockroachdb/cockroach/issues/40963?version=v20.2 then I will of course report here if it works.

So far we are using fusionauth with cockroachdb and this is the only error that has pooped up till now.

joshua

@michael-schramm,

Perfect! Do let us know if you get it fixed and up and running!

Thanks,
Josh

daniel.lohse

@michael-schramm can I reach you somewhere for a short discussion? Am also thinking about going for CockroachDB and have a couple questions.