Hi there!

You don’t need the triggers. It was there just to cover the time, when there were running instances with multiple different versions. Feel free to submit PR disabling this migration for CockroachDB.

Neat :D I was assuming it is still needed because of the query that is being executed: https://github.com/tolgee/tolgee-platform/blob/main/backend/data/src/main/resources/db/changelog/hideApiKeyMigration.sql

can you point me in some direction to disable certain migrations?

:/ ok found another error: org.postgresql.util.PSQLException: ERROR: unknown signature: to_char(timestamp, string)

Hopefully would be added with cockroachdb/cockroach#3781 (but no clue when)

https://github.com/tolgee/tolgee-platform/blob/main/backend/data/src/main/kotlin/io/tolgee/repository/activity/ActivityRevisionRepository.kt#L64 here is the query with the function.

Would it be possible to change it to (not sure how to add the typecast in that query)

select 
  count(ar.id) as count,
  ar.timestamp::date as date
from 
  activity_revision ar
where 
  ar.project_id = 1
group by date
order by date

# Now:
# select count(ar.id) as count, function('to_char', ar.timestamp, 'yyyy-MM-dd') as date

# New? (::date would also format it in iso so the output would be identical if this works)
# select count(ar.id) as count, ar.timestamp::date as date

 can you point me in some direction to disable certain migrations?

You can specify dbms in the schema.xml file by setting dbms attribute for sql statement. See db/changelog/schema.xml:1482. But I don't think this will be sufficient for you. However, there is other way. It seems like you can send some parameters to the liquibase chengelog and use them.

You can provide these params when the liquibase bean is created:

io.tolgee.configuration.LiquibaseConfiguration#liquibase

To actually disable the statements, you can use precondidions:
https://docs.liquibase.com/concepts/changelogs/preconditions.html

I actually never done this. So I am just guessing.

Would it be possible to change it to (not sure how to add the typecast in that query)

I don't really remember why it's there. Let me check... 😆

Seems like you would be able to create same result, by using different methods supported by CockroachDB.

extract(element: string, input: date) → float

Extracts element from input.Compatible elements: millennium, century, decade, year, isoyear, quarter, month, week, dayofweek, isodow, dayofyear, julian, hour, minute, second, millisecond, microsecond, epoch

select count(ar.id) as count, ar.timestamp::date as date

I've tested this and it doesn't work, But this works:

select count(ar.id) as count, cast(cast(ar.timestamp as date) as text) as date

with select count(ar.id) as count, cast(cast(ar.timestamp as date) as text) as date it would work for CRDB as well! :D if that is a possible change for you it would be great

I've created a PR. Let's se what the test result shows, but it looks like we will have to wait for CRDB 22.2.

@JanCizmar is there a way for me to get a dockerimage with the modifications? Then I could also run this and see if something else pops up

You can clone the repo and run ./gradlew docker It generates tolgee/tolgee image, which you can use as you wish. Let me know if it worked. :)

:/ was a bit tricky to get the correct image but I managed it.

Sadly there is an error popping up:

ERROR: unimplemented: the configuration setting "join_collapse_limit" is not supported

coming from:

The simple way of commenting the line seems to work - but the comment indicates to me that it is important for postgres....

Update: using the correct branch should help - rebuilding right now

Update 2: yes! it works!

 Update: using the correct branch should help - rebuilding right now

Yeah, it's fixed here https://github.com/tolgee/tolgee-platform/pull/1405/files#diff-b7d4751a11611455d0032b401f73be0b04084e153680caabdeecfdb0c33673d0R346

This issue is stale because it has been open for 30 days with no activity.