Upgrading to version 5.0 fails

[arnonm]

Describe the bug
DB migration fails:
aused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Script V95__add_source_points_table.sql failed
reitti-1 | ----------------------------------------------
reitti-1 | SQL State : 23505
reitti-1 | Error Code : 0
reitti-1 | Message : ERROR: could not create unique index "idx_raw_source_upsert_target"
reitti-1 | Detail: Key (user_id, "timestamp", device_id)=(2, 2026-05-06 21:33:31+00, null) is duplicated.
reitti-1 | Location : db/migration/V95__add_source_points_table.sql (/app/nested:/app/app.jar/!BOOT-INF/classes/!/db/migration/V95__add_source_points_table.sql)
reitti-1 | Line : 17
reitti-1 | Statement : Run Flyway with -X option to see the actual statement causing the problem
reitti-1 |
reitti-1 | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:256) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:217) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:137) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:75) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:66) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:31) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:65) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:391) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | ... 102 common frames omitted
reitti-1 | Caused by: org.postgresql.util.PSQLException: ERROR: could not create unique index "idx_raw_source_upsert_target"
reitti-1 | Detail: Key (user_id, "timestamp", device_id)=(2, 2026-05-06 21:33:31+00, null) is duplicated.
reitti-1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2904) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2589) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:431) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:534) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:437) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:359) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:344) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:320) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:315) ~[postgresql-42.7.11.jar!/:42.7.11]
reitti-1 | at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-6.3.3.jar!/:na]
reitti-1 | at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-6.3.3.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:215) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:88) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:212) ~[flyway-core-11.7.2.jar!/:na]
reitti-1 | ... 108 common frames omitted
reitti-1 |
reitti-1 | DATA_DIR (/data) is already writable. Skipping chown.

To Reproduce
Steps to reproduce the behavior:
Follow instructions on migrating from 4 to 5
Update tags from :next to 5
run sql command
pull and start containers

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):
Linux reitti 6.17.9-1-pve #1 SMP PREEMPT_DYNAMIC PMX 6.17.9-1 (2026-01-12T16:25Z) x86_64 GNU/Linux

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

[dgraf-gh]

Crazy, since raw_location_points should never have allowed this I am a little bit baffled how this can happen. Lets try to fix this manually:

Execute the following sql statements, this will simulate the V95 Migrations script and brings your db to V95. A later restart of reitti should hopefully go through.

First we should run

SELECT user_id, device_id, timestamp, COUNT(*)
FROM raw_source_points
GROUP BY user_id, device_id, timestamp
HAVING COUNT(*) > 1;

This should you give an estimate how many rows are affected.

If that does looks ok, executing:

DELETE FROM raw_source_points
WHERE id NOT IN (
    SELECT MAX(id)
    FROM raw_source_points
    GROUP BY user_id, device_id, timestamp
);

will cleanup the db.

Now we need to execute the rest of the migration script:

-- 3. Add the Partial Indices (The secret to performance)
CREATE INDEX idx_raw_source_main_device
    ON raw_source_points (user_id, timestamp)
    WHERE device_id IS NULL;

CREATE INDEX idx_raw_source_external_devices
    ON raw_source_points (device_id, timestamp)
    WHERE device_id IS NOT NULL;


CREATE TABLE raw_location_points_new AS
SELECT rlp.id,
       rlp.accuracy_meters,
       rlp.timestamp,
       rlp.user_id,
       rlp.geom,
       rlp.processed,
       rlp.version,
       rlp.elevation_meters,
       rlp.synthetic,
       rlp.ignored,
       rlp.invalid,
       CASE
           WHEN rlp.synthetic = FALSE THEN rsp.id
           ELSE NULL
           END AS source_point_id
FROM raw_location_points rlp
         LEFT JOIN raw_source_points rsp
                   ON rlp.user_id = rsp.user_id
                       AND rlp.timestamp = rsp.timestamp;
-- 2. Drop the slow table and rename the new one
DROP TABLE raw_location_points CASCADE;
ALTER TABLE raw_location_points_new
    RENAME TO raw_location_points;

-- 1. Explicitly set the column to NOT NULL
ALTER TABLE raw_location_points
    ALTER COLUMN id SET NOT NULL;

-- 2. Now add the identity property
ALTER TABLE raw_location_points
    ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY;

-- 3. Sync the sequence so the next ID starts after your current max
SELECT setval(
               pg_get_serial_sequence('raw_location_points', 'id'),
               (SELECT MAX(id) FROM raw_location_points)
       );

-- 3. Re-apply the DDL (Primary Key, Indices, Owner)
ALTER TABLE raw_location_points
    ADD PRIMARY KEY (id);
ALTER TABLE public.raw_location_points
    ALTER COLUMN invalid SET DEFAULT false,
    ALTER COLUMN invalid SET NOT NULL,
    ALTER COLUMN synthetic SET DEFAULT false,
    ALTER COLUMN synthetic SET NOT NULL,
    ALTER COLUMN ignored SET DEFAULT false,
    ALTER COLUMN ignored SET NOT NULL;

CREATE INDEX idx_raw_location_points_user_time_synthetic
    ON raw_location_points (user_id, timestamp, synthetic);

CREATE INDEX raw_location_points_processed
    ON raw_location_points (processed);

CREATE UNIQUE INDEX raw_location_points_user_id_timestamp_uindex
    ON raw_location_points (user_id, timestamp);

CREATE INDEX idx_covering_user_time
    ON raw_location_points (user_id, timestamp) INCLUDE (geom);

CREATE INDEX idx_raw_locations_user_timestamp_valid
    ON raw_location_points (user_id, invalid, ignored, timestamp)
    WHERE ((invalid = FALSE) AND (ignored = FALSE));

CREATE INDEX raw_location_points_user_id_processed_invalid_index
    ON raw_location_points (user_id, processed, invalid) INCLUDE (id, timestamp);

CREATE EXTENSION IF NOT EXISTS btree_gist;

-- add time line override table
CREATE TABLE timeline_overrides
(
    id         bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    user_id    bigint                      NOT NULL REFERENCES users (id),
    device_id  bigint                      NOT NULL REFERENCES devices (id),
    start_time timestamp(6) with time zone NOT NULL,
    end_time   timestamp(6) with time zone NOT NULL,
    created_at timestamp with time zone DEFAULT NOW(),
    CONSTRAINT no_timeline_overlap EXCLUDE USING gist (
        user_id WITH =,
        TSTZRANGE(start_time, end_time) WITH &&
        )
);


CREATE OR REPLACE VIEW v_source_stream AS
WITH current_overrides AS (
    SELECT user_id, device_id, start_time, end_time
    FROM timeline_overrides
)
-- PART A: Points from specific overridden devices
SELECT
    rsp.id AS source_point_id, -- <--- Crucial back-link
    rsp.accuracy_meters,
    rsp.timestamp,
    rsp.user_id,
    rsp.geom,
    rsp.elevation_meters,
    rsp.device_id
FROM raw_source_points rsp
         JOIN current_overrides ov ON rsp.user_id = ov.user_id
    AND rsp.device_id = ov.device_id
    AND rsp.timestamp >= ov.start_time
    AND rsp.timestamp <= ov.end_time

UNION ALL

-- PART B: Points from the "Main" device (where no override exists)
SELECT
    rsp.id AS source_point_id, -- <--- Crucial back-link
    rsp.accuracy_meters,
    rsp.timestamp,
    rsp.user_id,
    rsp.geom,
    rsp.elevation_meters,
    rsp.device_id
FROM raw_source_points rsp
WHERE rsp.device_id IS NULL  -- This is our "Main" device convention
  AND NOT EXISTS (
    -- Only take the main point if there is NO override for this specific second
    SELECT 1
    FROM current_overrides ov
    WHERE ov.user_id = rsp.user_id
      AND rsp.timestamp >= ov.start_time
      AND rsp.timestamp <= ov.end_time
);

and finally tell the app that we executed it:

UPDATE flyway_schema_history SET success = true WHERE installed_rank = 95;

I hope this helps

[husainihisan]

Hi, mine also failed.. do i need to open new ticket?

Attaching to postgis-1, redis-1, reitti-1, tile-cache-1 redis-1 | 1:C 08 Jul 2026 01:14:47.688 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect. redis-1 | 1:C 08 Jul 2026 01:14:47.688 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo redis-1 | 1:C 08 Jul 2026 01:14:47.688 * Redis version=7.4.9, bits=64, commit=00000000, modified=0, pid=1, just started redis-1 | 1:C 08 Jul 2026 01:14:47.688 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf redis-1 | 1:M 08 Jul 2026 01:14:47.688 * Increased maximum number of open files to 10032 (it was originally set to 1024). redis-1 | 1:M 08 Jul 2026 01:14:47.689 * monotonic clock: POSIX clock_gettime redis-1 | 1:M 08 Jul 2026 01:14:47.690 * Running mode=standalone, port=6379. redis-1 | 1:M 08 Jul 2026 01:14:47.690 * Server initialized redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Loading RDB produced by version 7.4.9 redis-1 | 1:M 08 Jul 2026 01:14:47.691 * RDB age 12 seconds redis-1 | 1:M 08 Jul 2026 01:14:47.691 * RDB memory usage when created 0.95 Mb redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Done loading RDB, keys loaded: 32, keys expired: 0. redis-1 | 1:M 08 Jul 2026 01:14:47.691 * DB loaded from disk: 0.000 seconds redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Ready to accept connections tcp tile-cache-1 | Using resolver IP: 127.0.0.11 postgis-1 | postgis-1 | PostgreSQL Database directory appears to contain a database; Skipping initialization postgis-1 | postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: starting PostgreSQL 17.10 on x86_64-pc-linux-musl, compiled by gcc (Alpine 15.2.0) 15.2.0, 64-bit postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgis-1 | 2026-07-08 01:14:47.794 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgis-1 | 2026-07-08 01:14:47.802 UTC [29] LOG: database system was shut down at 2026-07-08 01:14:35 UTC postgis-1 | 2026-07-08 01:14:47.813 UTC [1] LOG: database system is ready to accept connections tile-cache-1 | 127.0.0.1 - - [08/Jul/2026:09:14:52 +0800] "GET /custom/planet/latest/0/0/0.pbf HTTP/1.1" 200 79432 "-" "curl/8.14.1" "-" "https://tiles.dedicatedcode.com" cache:HIT reitti-1 | DATA_DIR (/data) is already writable. Skipping chown. reitti-1 |
reitti-1 | . ____ _ __ _ _
reitti-1 | /\ / ' __ _ () __ __ _ \ \ \
reitti-1 | ( ( )__ | '_ | '| | ' / _ | \ \ \ \ reitti-1 | \\/ ___)| |_)| | | | | || (_| | ) ) ) ) reitti-1 | ' |____| .__|_| |_|_| |_\__, | / / / / reitti-1 | =========|_|==============|___/=/_/_/_/ reitti-1 | reitti-1 | :: Spring Boot :: (v3.5.16) reitti-1 | reitti-1 | 2026-07-08T01:15:00.707Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : Starting ReittiApplication v0.0.1-SNAPSHOT using Java 25.0.3 with PID 1 (/app/app.jar started by reitti in /app) reitti-1 | 2026-07-08T01:15:00.711Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : The following 1 profile is active: "docker" tile-cache-1 | 127.0.0.1 - - [08/Jul/2026:09:15:02 +0800] "GET /custom/planet/latest/0/0/0.pbf HTTP/1.1" 200 79432 "-" "curl/8.14.1" "-" "https://tiles.dedicatedcode.com" cache:HIT reitti-1 | 2026-07-08T01:15:03.951Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode reitti-1 | 2026-07-08T01:15:03.957Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode. reitti-1 | 2026-07-08T01:15:04.050Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 54 ms. Found 0 Redis repository interfaces. reitti-1 | 2026-07-08T01:15:05.806Z INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http) reitti-1 | 2026-07-08T01:15:05.837Z INFO 1 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] reitti-1 | 2026-07-08T01:15:05.838Z INFO 1 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.55] reitti-1 | 2026-07-08T01:15:05.895Z INFO 1 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext reitti-1 | 2026-07-08T01:15:05.896Z INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 5061 ms reitti-1 | 2026-07-08T01:15:06.662Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... reitti-1 | 2026-07-08T01:15:07.001Z INFO 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@211da640 reitti-1 | 2026-07-08T01:15:07.005Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. reitti-1 | 2026-07-08T01:15:07.068Z INFO 1 --- [ main] org.flywaydb.core.FlywayExecutor : Database: jdbc:postgresql://postgis:5432/reittidb (PostgreSQL 17.10) reitti-1 | 2026-07-08T01:15:07.357Z ERROR 1 --- [ main] o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'setupFilter' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/config/SetupFilter.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | 2026-07-08T01:15:07.409Z INFO 1 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] reitti-1 | 2026-07-08T01:15:07.417Z WARN 1 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [HikariPool-1:housekeeper] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: reitti-1 | java.base/jdk.internal.misc.Unsafe.park(Native Method) reitti-1 | java.base/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source) reitti-1 | java.base/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source) reitti-1 | java.base/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) reitti-1 | java.base/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) reitti-1 | java.base/java.lang.Thread.run(Unknown Source) reitti-1 | 2026-07-08T01:15:07.420Z WARN 1 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [HikariPool-1:connection-adder] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: reitti-1 | java.base/java.lang.Thread.sleepNanos0(Native Method) reitti-1 | java.base/java.lang.Thread.sleepNanos(Unknown Source) reitti-1 | java.base/java.lang.Thread.sleep(Unknown Source) reitti-1 | com.zaxxer.hikari.util.UtilityElf.quietlySleep(UtilityElf.java:71) reitti-1 | com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:757) reitti-1 | com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:731) reitti-1 | java.base/java.util.concurrent.FutureTask.run(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) reitti-1 | java.base/java.lang.Thread.run(Unknown Source) reitti-1 | 2026-07-08T01:15:07.427Z WARN 1 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server reitti-1 | 2026-07-08T01:15:07.429Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... reitti-1 | 2026-07-08T01:15:07.444Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. reitti-1 | 2026-07-08T01:15:07.505Z INFO 1 --- [ main] .s.b.a.l.ConditionEvaluationReportLogger : reitti-1 | reitti-1 | Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. reitti-1 | 2026-07-08T01:15:07.565Z ERROR 1 --- [ main] o.s.boot.SpringApplication : Application run failed reitti-1 | reitti-1 | org.springframework.context.ApplicationContextException: Unable to start web server reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:170) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:622) ~[spring-context-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:318) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at com.dedicatedcode.reitti.ReittiApplication.main(ReittiApplication.java:16) ~[!/:0.0.1-SNAPSHOT] reitti-1 | at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na] reitti-1 | at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na] reitti-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:106) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:147) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:107) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:517) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:219) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:193) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:167) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | ... 11 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'setupFilter' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/config/SetupFilter.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1393) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1230) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:230) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:184) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:179) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAdaptableBeans(ServletContextInitializerBeans.java:164) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:96) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:271) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:245) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4456) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1191) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source) ~[na:na] reitti-1 | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:81) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[na:na] reitti-1 | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:747) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:783) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1191) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source) ~[na:na] reitti-1 | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:81) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[na:na] reitti-1 | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:747) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:410) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:868) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:436) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:128) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | ... 16 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1393) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1230) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1777) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1660) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 57 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1824) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1715) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1660) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 71 common frames omitted reitti-1 | Caused by: org.flywaydb.core.api.exception.FlywayValidateException: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.flywaydb.core.Flyway.lambda$migrate$1(Flyway.java:201) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:210) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.flywaydb.core.Flyway.migrate(Flyway.java:188) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1871) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1820) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 83 common frames omitted reitti-1 | reitti-1 exited with code 1

[arnonm]

Daniel, first command failed so I stopped: ***@***.***:/opt/reitti# sudo docker compose exec postgis psql -U reitti -d reittidb --command "SELECT user_id, device_id, timestamp, COUNT(*) FROM raw_source_points GROUP BY user_id, device_id, timestamp HAVING COUNT(*) > 1;" ERROR: relation "raw_source_points" does not exist LINE 2: FROM raw_source_points

…

On Wed, Jul 8, 2026 at 4:21 AM husaini ***@***.***> wrote: *husainihisan* left a comment (dedicatedcode/reitti#1089) <#1089 (comment)> Hi, mine also failed.. do i need to open new ticket? Attaching to postgis-1, redis-1, reitti-1, tile-cache-1 redis-1 | 1:C 08 Jul 2026 01:14:47.688 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see jemalloc/jemalloc#1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect. redis-1 | 1:C 08 Jul 2026 01:14:47.688 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo redis-1 | 1:C 08 Jul 2026 01:14:47.688 * Redis version=7.4.9, bits=64, commit=00000000, modified=0, pid=1, just started redis-1 | 1:C 08 Jul 2026 01:14:47.688 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf redis-1 | 1:M 08 Jul 2026 01:14:47.688 * Increased maximum number of open files to 10032 (it was originally set to 1024). redis-1 | 1:M 08 Jul 2026 01:14:47.689 * monotonic clock: POSIX clock_gettime redis-1 | 1:M 08 Jul 2026 01:14:47.690 * Running mode=standalone, port=6379. redis-1 | 1:M 08 Jul 2026 01:14:47.690 * Server initialized redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Loading RDB produced by version 7.4.9 redis-1 | 1:M 08 Jul 2026 01:14:47.691 * RDB age 12 seconds redis-1 | 1:M 08 Jul 2026 01:14:47.691 * RDB memory usage when created 0.95 Mb redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Done loading RDB, keys loaded: 32, keys expired: 0. redis-1 | 1:M 08 Jul 2026 01:14:47.691 * DB loaded from disk: 0.000 seconds redis-1 | 1:M 08 Jul 2026 01:14:47.691 * Ready to accept connections tcp tile-cache-1 | Using resolver IP: 127.0.0.11 postgis-1 | postgis-1 | PostgreSQL Database directory appears to contain a database; Skipping initialization postgis-1 | postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: starting PostgreSQL 17.10 on x86_64-pc-linux-musl, compiled by gcc (Alpine 15.2.0) 15.2.0, 64-bit postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgis-1 | 2026-07-08 01:14:47.790 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgis-1 | 2026-07-08 01:14:47.794 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgis-1 | 2026-07-08 01:14:47.802 UTC [29] LOG: database system was shut down at 2026-07-08 01:14:35 UTC postgis-1 | 2026-07-08 01:14:47.813 UTC [1] LOG: database system is ready to accept connections tile-cache-1 | 127.0.0.1 - - [08/Jul/2026:09:14:52 +0800] "GET /custom/planet/latest/0/0/0.pbf HTTP/1.1" 200 79432 "-" "curl/8.14.1" "-" "https://tiles.dedicatedcode.com" cache:HIT reitti-1 | DATA_DIR (/data) is already writable. Skipping chown. reitti-1 | reitti-1 | . ____ _ __ _ _ reitti-1 | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ reitti-1 | ( ( )\___ | '_ | '_| | '_ \/ _ | \ \ \ reitti-1 | \/ *)| |)| | | | | || (| | ) ) ) ) reitti-1 | ' |**| .__|| ||*| |*_*, | / / / / reitti-1 | =========|*|==============|**/=//*/_/ reitti-1 | reitti-1 | :: Spring Boot :: (v3.5.16) reitti-1 | reitti-1 | 2026-07-08T01:15:00.707Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : Starting ReittiApplication v0.0.1-SNAPSHOT using Java 25.0.3 with PID 1 (/app/app.jar started by reitti in /app) reitti-1 | 2026-07-08T01:15:00.711Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : The following 1 profile is active: "docker" tile-cache-1 | 127.0.0.1 - - [08/Jul/2026:09:15:02 +0800] "GET /custom/planet/latest/0/0/0.pbf HTTP/1.1" 200 79432 "-" "curl/8.14.1" "-" " https://tiles.dedicatedcode.com" cache:HIT reitti-1 | 2026-07-08T01:15:03.951Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode reitti-1 | 2026-07-08T01:15:03.957Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode. reitti-1 | 2026-07-08T01:15:04.050Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 54 ms. Found 0 Redis repository interfaces. reitti-1 | 2026-07-08T01:15:05.806Z INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http) reitti-1 | 2026-07-08T01:15:05.837Z INFO 1 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] reitti-1 | 2026-07-08T01:15:05.838Z INFO 1 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.55] reitti-1 | 2026-07-08T01:15:05.895Z INFO 1 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext reitti-1 | 2026-07-08T01:15:05.896Z INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 5061 ms reitti-1 | 2026-07-08T01:15:06.662Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... reitti-1 | 2026-07-08T01:15:07.001Z INFO 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection ***@***.*** reitti-1 | 2026-07-08T01:15:07.005Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. reitti-1 | 2026-07-08T01:15:07.068Z INFO 1 --- [ main] org.flywaydb.core.FlywayExecutor : Database: jdbc:postgresql://postgis:5432/reittidb (PostgreSQL 17.10) reitti-1 | 2026-07-08T01:15:07.357Z ERROR 1 --- [ main] o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name 'setupFilter' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/config/SetupFilter.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | 2026-07-08T01:15:07.409Z INFO 1 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat] reitti-1 | 2026-07-08T01:15:07.417Z WARN 1 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [HikariPool-1:housekeeper] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: reitti-1 | java.base/jdk.internal.misc.Unsafe.park(Native Method) reitti-1 | java.base/java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source) reitti-1 | java.base/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source) reitti-1 | java.base/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) reitti-1 | java.base/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) reitti-1 | java.base/java.lang.Thread.run(Unknown Source) reitti-1 | 2026-07-08T01:15:07.420Z WARN 1 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [HikariPool-1:connection-adder] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: reitti-1 | java.base/java.lang.Thread.sleepNanos0(Native Method) reitti-1 | java.base/java.lang.Thread.sleepNanos(Unknown Source) reitti-1 | java.base/java.lang.Thread.sleep(Unknown Source) reitti-1 | com.zaxxer.hikari.util.UtilityElf.quietlySleep(UtilityElf.java:71) reitti-1 | com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:757) reitti-1 | com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:731) reitti-1 | java.base/java.util.concurrent.FutureTask.run(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) reitti-1 | java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) reitti-1 | java.base/java.lang.Thread.run(Unknown Source) reitti-1 | 2026-07-08T01:15:07.427Z WARN 1 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server reitti-1 | 2026-07-08T01:15:07.429Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... reitti-1 | 2026-07-08T01:15:07.444Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. reitti-1 | 2026-07-08T01:15:07.505Z INFO 1 --- [ main] .s.b.a.l.ConditionEvaluationReportLogger : reitti-1 | reitti-1 | Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. reitti-1 | 2026-07-08T01:15:07.565Z ERROR 1 --- [ main] o.s.boot.SpringApplication : Application run failed reitti-1 | reitti-1 | org.springframework.context.ApplicationContextException: Unable to start web server reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:170) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:622) ~[spring-context-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:318) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at com.dedicatedcode.reitti.ReittiApplication.main(ReittiApplication.java:16) ~[!/:0.0.1-SNAPSHOT] reitti-1 | at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) ~[na:na] reitti-1 | at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na] reitti-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:106) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40) ~[app.jar:0.0.1-SNAPSHOT] reitti-1 | Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:147) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.(TomcatWebServer.java:107) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:517) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:219) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:193) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:167) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | ... 11 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'setupFilter' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/config/SetupFilter.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1393) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1230) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:230) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:184) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:179) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAdaptableBeans(ServletContextInitializerBeans.java:164) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.ServletContextInitializerBeans.(ServletContextInitializerBeans.java:96) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:271) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:245) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:52) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4456) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1191) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source) ~[na:na] reitti-1 | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:81) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[na:na] reitti-1 | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:747) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:783) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1191) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source) ~[na:na] reitti-1 | at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:81) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[na:na] reitti-1 | at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:747) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:201) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardService.startInternal(StandardService.java:410) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:868) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.apache.catalina.startup.Tomcat.start(Tomcat.java:436) ~[tomcat-embed-core-10.1.55.jar!/:na] reitti-1 | at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:128) ~[spring-boot-3.5.16.jar!/:3.5.16] reitti-1 | ... 16 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userJdbcService' defined in URL [jar:nested:/app/app.jar/!BOOT-INF/classes/!/com/dedicatedcode/reitti/repository/UserJdbcService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:804) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1393) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1230) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1777) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1660) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 57 common frames omitted reitti-1 | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1824) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1715) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1660) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 71 common frames omitted reitti-1 | Caused by: org.flywaydb.core.api.exception.FlywayValidateException: Validate failed: Migrations have failed validation reitti-1 | Migration checksum mismatch for migration version 95 reitti-1 | -> Applied to database : -423745809 reitti-1 | -> Resolved locally : 1631103717 reitti-1 | Either revert the changes to the migration, or run repair to update the schema history. reitti-1 | Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE reitti-1 | at org.flywaydb.core.Flyway.lambda$migrate$1(Flyway.java:201) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:210) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.flywaydb.core.Flyway.migrate(Flyway.java:188) ~[flyway-core-11.7.2.jar!/:na] reitti-1 | at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-3.5.16.jar!/:3.5.16] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1871) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1820) ~[spring-beans-6.2.19.jar!/:6.2.19] reitti-1 | ... 83 common frames omitted reitti-1 | reitti-1 exited with code 1` — Reply to this email directly, view it on GitHub <#1089?email_source=notifications&email_token=AA5BWKLQHGNTHAIEE26LOG35DWOYNA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJRGA2TCNZVG44KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KYZTPN52GK4S7MNWGSY3L#issuecomment-4910517578>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA5BWKPYUEDXAWNTFMBB5OL5DWOYNAVCNFSNUABFKJSXA33TNF2G64TZHM4TQOJZGM4TCNZTHNEXG43VMU5TIOBRGMZTCNRYGE4KC5QC> . Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS <https://github.com/notifications/mobile/ios/AA5BWKNLY3TI7QDCBG3QPAT5DWOYNA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJRGA2TCNZVG44KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KUZTPN52GK4S7NFXXG> and Android <https://github.com/notifications/mobile/android/AA5BWKO2O7IPQYV5L6TXLFT5DWOYNA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJRGA2TCNZVG44KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2K4ZTPN52GK4S7MFXGI4TPNFSA>. Download it today! You are receiving this because you authored the thread.Message ID: ***@***.***>

[dgraf-gh]

Ok, I see it did not create the table. Then try to executed:

SELECT user_id, timestamp, COUNT(*)
FROM raw_location_points
GROUP BY user_id,  timestamp
HAVING COUNT(*) > 1;

If this returns some points, we need to clean them out in the table.

DELETE FROM raw_location_points
WHERE id NOT IN (
  SELECT MAX(id)
FROM raw_location_points
GROUP BY user_id, timestamp
);

After that, we reset flyway:

DELETE FROM flyway_schema_history WHERE installed_rank = 95;

and try to restart reitti.

[arnonm]

ok, the performance on that quer was awful, this was much faster: DELETE FROM raw_location_points r USING ( SELECT user_id, timestamp, MAX(id) as max_id FROM raw_location_points GROUP BY user_id, timestamp ) keep WHERE r.user_id = keep.user_id AND r.timestamp = keep.timestamp AND r.id < keep.max_id; I still had problems. Eventually I realized I didn't have enough disk space although there was 3GB free for the container. The migration to version 96 increased the disk usage by 8-10 GB during the migration. It then reclaimed some of it back reitti-1 | DATA_DIR (/data) is not writable by reitti. Adjusting permissions... reitti-1 | reitti-1 | . ____ _ __ _ _ reitti-1 | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ reitti-1 | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ reitti-1 | \\/ ___)| |_)| | | | | || (_| | ) ) ) ) reitti-1 | ' |____| .__|_| |_|_| |_\__, | / / / / reitti-1 | =========|_|==============|___/=/_/_/_/ reitti-1 | reitti-1 | :: Spring Boot :: (v3.5.16) reitti-1 | reitti-1 | 2026-07-09T18:03:04.937Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : Starting ReittiApplication v0.0.1-SNAPSHOT using Java 25.0.3 with PID 1 (/app/app.jar started by reitti in /app) reitti-1 | 2026-07-09T18:03:04.940Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : The following 1 profile is active: "docker" reitti-1 | 2026-07-09T18:03:06.547Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode reitti-1 | 2026-07-09T18:03:06.549Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode. reitti-1 | 2026-07-09T18:03:06.604Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 28 ms. Found 0 Redis repository interfaces. reitti-1 | 2026-07-09T18:03:07.463Z INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http) reitti-1 | 2026-07-09T18:03:07.480Z INFO 1 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] reitti-1 | 2026-07-09T18:03:07.480Z INFO 1 --- [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.55] reitti-1 | 2026-07-09T18:03:07.508Z INFO 1 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext reitti-1 | 2026-07-09T18:03:07.508Z INFO 1 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2501 ms reitti-1 | 2026-07-09T18:03:07.899Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... reitti-1 | 2026-07-09T18:03:08.095Z INFO 1 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection ***@***.*** reitti-1 | 2026-07-09T18:03:08.096Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. reitti-1 | 2026-07-09T18:03:08.129Z INFO 1 --- [ main] org.flywaydb.core.FlywayExecutor : Database: jdbc:postgresql://postgis:5432/reittidb (PostgreSQL 17.10) reitti-1 | 2026-07-09T18:03:08.236Z INFO 1 --- [ main] o.f.core.internal.command.DbValidate : Successfully validated 112 migrations (execution time 00:00.080s) reitti-1 | 2026-07-09T18:03:08.263Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Current version of schema "public": 94 reitti-1 | 2026-07-09T18:03:08.291Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "95 - add source points table" reitti-1 | 2026-07-09T18:05:12.788Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: drop cascades to materialized view location_daily_summary reitti-1 | 2026-07-09T18:05:16.412Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : +----------+ reitti-1 | | setval | reitti-1 | +----------+ reitti-1 | | 35157787 | reitti-1 | +----------+ reitti-1 | reitti-1 | 2026-07-09T18:06:29.520Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "96 - add task name to job meta data" reitti-1 | 2026-07-09T18:06:29.598Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "97 - update location point status" reitti-1 | 2026-07-09T18:06:34.064Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "98 - update location daily sumary" reitti-1 | 2026-07-09T18:06:34.067Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: materialized view "location_daily_sumary" does not exist, skipping reitti-1 | 2026-07-09T18:06:44.506Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "99 - add metadata tables" reitti-1 | 2026-07-09T18:06:45.025Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "100 - add user map styles" reitti-1 | 2026-07-09T18:06:46.965Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "101 - add default styles to database" reitti-1 | 2026-07-09T18:06:47.052Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "102 - adjust column types for user map styles" reitti-1 | 2026-07-09T18:06:47.179Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "103 - update default reitti map styles" reitti-1 | 2026-07-09T18:06:47.230Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "104 - add default device" reitti-1 | 2026-07-09T18:10:06.748Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "105 - add missing api keys for devices" reitti-1 | 2026-07-09T18:10:06.802Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "106 - unlink reitti styles from users" reitti-1 | 2026-07-09T18:10:06.819Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "107 - add device avatar table" reitti-1 | 2026-07-09T18:10:06.849Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "108 - add show avatar to device table" reitti-1 | 2026-07-09T18:10:06.864Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "109 - fix nominatim default geocoder" reitti-1 | 2026-07-09T18:10:06.883Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "110 - add index to raw location points" reitti-1 | 2026-07-09T18:10:09.491Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "111 - update source view" reitti-1 | 2026-07-09T18:10:24.231Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version "112 - add quarz tables" reitti-1 | 2026-07-09T18:10:24.236Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_fired_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.237Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_paused_trigger_grps" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.238Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_scheduler_state" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.239Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_locks" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.239Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_simple_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.240Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_cron_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.240Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_simprop_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.241Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_blob_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.241Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_triggers" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.242Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_job_details" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.243Z INFO 1 --- [ main] o.f.c.i.s.DefaultSqlScriptExecutor : DB: table "qrtz_calendars" does not exist, skipping reitti-1 | 2026-07-09T18:10:24.578Z INFO 1 --- [ main] o.f.core.internal.command.DbMigrate : Successfully applied 18 migrations to schema "public", now at version v112 (execution time 07:12.611s) reitti-1 | WARNING: A terminally deprecated method in sun.misc.Unsafe has been called reitti-1 | WARNING: sun.misc.Unsafe::allocateMemory has been called by io.netty.util.internal.PlatformDependent0$2 (jar:nested:/app/app.jar/!BOOT-INF/lib/netty-common-4.1.135.Final.jar!/) reitti-1 | WARNING: Please consider reporting this to the maintainers of class io.netty.util.internal.PlatformDependent0$2 reitti-1 | WARNING: sun.misc.Unsafe::allocateMemory will be removed in a future release reitti-1 | 2026-07-09T18:10:29.599Z INFO 1 --- [ main] c.d.reitti.service.VersionService : git.properties loaded successfully. reitti-1 | 2026-07-09T18:10:29.719Z INFO 1 --- [ main] org.quartz.impl.StdSchedulerFactory : Using default implementation for ThreadExecutor reitti-1 | 2026-07-09T18:10:29.729Z INFO 1 --- [ main] org.quartz.core.SchedulerSignalerImpl : Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl reitti-1 | 2026-07-09T18:10:29.730Z INFO 1 --- [ main] org.quartz.core.QuartzScheduler : Quartz Scheduler v2.5.2 created. reitti-1 | 2026-07-09T18:10:29.739Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Using db table-based data access locking (synchronization). reitti-1 | 2026-07-09T18:10:29.741Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : JobStoreCMT initialized. reitti-1 | 2026-07-09T18:10:29.741Z INFO 1 --- [ main] org.quartz.core.QuartzScheduler : Scheduler meta-data: Quartz Scheduler (v2.5.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' reitti-1 | Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. reitti-1 | NOT STARTED. reitti-1 | Currently in standby mode. reitti-1 | Number of jobs executed: 0 reitti-1 | Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 5 threads. reitti-1 | Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is not clustered. reitti-1 | reitti-1 | 2026-07-09T18:10:29.742Z INFO 1 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. reitti-1 | 2026-07-09T18:10:29.742Z INFO 1 --- [ main] org.quartz.impl.StdSchedulerFactory : Quartz scheduler version: 2.5.2 reitti-1 | 2026-07-09T18:10:29.742Z INFO 1 --- [ main] org.quartz.core.QuartzScheduler : JobFactory set to: ***@***.*** reitti-1 | WARNING: A restricted method in java.lang.System has been called reitti-1 | WARNING: java.lang.System::load has been called by com.github.luben.zstd.util.Native$2 in an unnamed module (jar:nested:/app/app.jar/!BOOT-INF/lib/zstd-jni-1.5.5-11.jar!/) reitti-1 | WARNING: Use --enable-native-access=ALL-UNNAMED to avoid a warning for callers in this module reitti-1 | WARNING: Restricted methods will be blocked in a future release unless native access is enabled reitti-1 | reitti-1 | 2026-07-09T18:10:29.934Z INFO 1 --- [ main] net.iakovlev.timeshape.TimeZoneEngine : Initializing with bounding box: -90.0, -180.0, 90.0, 180.0 reitti-1 | 2026-07-09T18:10:32.019Z INFO 1 --- [ main] net.iakovlev.timeshape.Index : Initialized index with 1319 time zones reitti-1 | 2026-07-09T18:10:32.067Z INFO 1 --- [ main] c.d.r.s.GeoLocationTimezoneService : Searching for SignificantPlaces without Timezone data. Found [0] reitti-1 | 2026-07-09T18:10:32.573Z INFO 1 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index reitti-1 | 2026-07-09T18:10:32.969Z INFO 1 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 1 endpoint beneath base path '/actuator' reitti-1 | 2026-07-09T18:10:33.019Z INFO 1 --- [ main] r$InitializeUserDetailsManagerConfigurer : Global AuthenticationManager configured with UserDetailsService bean with name userDetailsServiceImpl reitti-1 | 2026-07-09T18:10:33.805Z INFO 1 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '/' reitti-1 | 2026-07-09T18:10:33.808Z INFO 1 --- [ main] o.s.s.quartz.SchedulerFactoryBean : Starting Quartz Scheduler now reitti-1 | 2026-07-09T18:10:33.815Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Freed 0 triggers from 'acquired' / 'blocked' state. reitti-1 | 2026-07-09T18:10:33.825Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Recovering 0 jobs that were in-progress at the time of the last shut-down. reitti-1 | 2026-07-09T18:10:33.825Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Recovery complete. reitti-1 | 2026-07-09T18:10:33.826Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Removed 0 'complete' triggers. reitti-1 | 2026-07-09T18:10:33.828Z INFO 1 --- [ main] o.s.s.quartz.LocalDataSourceJobStore : Removed 0 stale fired job entries. reitti-1 | 2026-07-09T18:10:33.834Z INFO 1 --- [ main] org.quartz.core.QuartzScheduler : Scheduler quartzScheduler_$_NON_CLUSTERED started. reitti-1 | 2026-07-09T18:10:33.861Z INFO 1 --- [ main] c.d.reitti.ReittiApplication : Started ReittiApplication in 449.448 seconds (process running for 450.169) reitti-1 | 2026-07-09T18:10:38.824Z INFO 1 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' reitti-1 | 2026-07-09T18:10:38.825Z INFO 1 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' reitti-1 | 2026-07-09T18:10:38.826Z INFO 1 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms reitti-1 | 2026-07-09T18:10:56.120Z INFO 1 --- [eduler_Worker-3] c.d.r.s.p.AnomalyProcessingService : Marked 0 points as invalid for user arnon reitti-1 | 2026-07-09T18:10:58.475Z INFO 1 --- [eduler_Worker-5] d.r.s.p.UnifiedLocationProcessingService : Processing location data for user [arnon], mode: LIVE reitti-1 | 2026-07-09T18:10:58.614Z INFO 1 --- [eduler_Worker-5] d.r.s.p.UnifiedLocationProcessingService : Completed processing for user [arnon] in 139ms: 0 visits → 0 processed visits → 0 trips reitti-1 | 2026-07-09T18:11:33.031Z INFO 1 --- [eduler_Worker-4] c.d.r.s.p.AnomalyProcessingService : Marked 0 points as invalid for user arnon reitti-1 | 2026-07-09T18:11:33.577Z INFO 1 --- [eduler_Worker-1] d.r.s.p.UnifiedLocationProcessingService : Processing location data for user [arnon], mode: LIVE reitti-1 | 2026-07-09T18:11:33.598Z INFO 1 --- [eduler_Worker-1] d.r.s.p.UnifiedLocationProcessingService : Completed processing for user [arnon] in 21ms: 0 visits → 0 processed visits → 0 trips ***@***.***:/opt/reitti#

…

On Thu, Jul 9, 2026 at 6:39 AM Daniel Graf ***@***.***> wrote: *dgraf-gh* left a comment (dedicatedcode/reitti#1089) <#1089 (comment)> Ok, I see it did not create the table. Then try to executed: SELECT user_id, timestamp, COUNT(*) FROM raw_location_points GROUP BY user_id, timestamp HAVING COUNT(*) > 1; If this returns some points, we need to clean them out in the table. DELETE FROM raw_location_points WHERE id NOT IN ( SELECT MAX(id) FROM raw_location_points GROUP BY user_id, timestamp ); After that, we reset flyway: DELETE FROM flyway_schema_history WHERE installed_rank = 95; and try to restart reitti. — Reply to this email directly, view it on GitHub <#1089?email_source=notifications&email_token=AA5BWKLMUMN5NL4VV7ULMIT5D4HWTA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSGEZTINRSGMZKM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KYZTPN52GK4S7MNWGSY3L#issuecomment-4921346232>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA5BWKNPZTI3N7UCJLYJLKL5D4HWTAVCNFSNUABFKJSXA33TNF2G64TZHM4TQOJZGM4TCNZTHNEXG43VMU5TIOBRGMZTCNRYGE4KC5QC> . Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS <https://github.com/notifications/mobile/ios/AA5BWKJE3PV6EUOCIUK3AAL5D4HWTA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSGEZTINRSGMZKM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KUZTPN52GK4S7NFXXG> and Android <https://github.com/notifications/mobile/android/AA5BWKIFCQN26LPDYLZJBQL5D4HWTA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSGEZTINRSGMZKM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2K4ZTPN52GK4S7MFXGI4TPNFSA>. Download it today! You are receiving this because you authored the thread.Message ID: ***@***.***>

[dgraf-gh]

Oh, I never considered that ...
Yes, it temporary copies the raw_location_points into the raw_source_table.

I will add this information also into the upgrade guide.

[arnonm]

Glad to be able to contribute, thanks for the help.

…

On Thu, Jul 9, 2026 at 9:16 PM Daniel Graf ***@***.***> wrote: *dgraf-gh* left a comment (dedicatedcode/reitti#1089) <#1089 (comment)> Oh, I never considered that ... Yes, it temporary copies the raw_location_points into the raw_source_table. I will add this information also into the upgrade guide. — Reply to this email directly, view it on GitHub <#1089?email_source=notifications&email_token=AA5BWKK7N4HZOTW4TJEHJ4T5D7OPLA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSHAZDAMBXHA4KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KYZTPN52GK4S7MNWGSY3L#issuecomment-4928200788>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA5BWKO4S4USVBVPJSF3NIT5D7OPLAVCNFSNUABFKJSXA33TNF2G64TZHM4TQOJZGM4TCNZTHNEXG43VMU5TIOBRGMZTCNRYGE4KC5QC> . Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS <https://github.com/notifications/mobile/ios/AA5BWKJHN5RV4JKER7UIZGT5D7OPLA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSHAZDAMBXHA4KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2KUZTPN52GK4S7NFXXG> and Android <https://github.com/notifications/mobile/android/AA5BWKMBZ4XRE4B5GZIBG4D5D7OPLA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIOJSHAZDAMBXHA4KM4TFMFZW63VGMF2XI2DPOKSWK5TFNZ2K4ZTPN52GK4S7MFXGI4TPNFSA>. Download it today! You are receiving this because you authored the thread.Message ID: ***@***.***>