Stirling-PDF icon indicating copy to clipboard operation
Stirling-PDF copied to clipboard
Published 16 hours ago • verified publisher icon Stirling-Tools

[Bug]: ERROR s.s.p.s.service.DatabaseService - Error during database import: Constraint "CONSTRAINT_4" already exists

Open BlastboomStrice opened this issue 3 months ago • 12 comments

Installation Method

Local Installation

The Problem

Stirling-pdf fails to run. I think it is a database issue. I'm using the nix package from the official nixpkgs repo. It started failing after they updated the app from 0.33.1 to 1.0.2 (as you will see in the logs).

Visiting the https://localhost:8080/ page with (firefox-beta) browser, I get this:

Unable to connect

Firefox can’t establish a connection to the server at localhost:8080.

    The site could be temporarily unavailable or too busy. Try again in a few moments.
    If you are unable to load any pages, check your computer’s network connection.
    If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the web.

I'm mentioning this issue here: https://github.com/NixOS/nixpkgs/issues/440379

Possibly the jump from 0.33.1 to 1.0.2 broke it and it might be solved if I somehow reset stirling configs (haven't tried it yet).

Version of Stirling-PDF

1.2.0

Last Working Version of Stirling-PDF

0.33.1

Page Where the Problem Occurred

http://localhost:8080/

Docker Configuration

Relevant Log Output

Last log of the service working properly:

$ sudo journalctl -u stirling-pdf.service

-- Boot 0afaeb7c121f40e3ad5a4bcf07dece84 --
Aug 07 12:47:38 nixos systemd[1]: Started stirling-pdf.service.
Aug 07 12:47:41 nixos Stirling-PDF[926]: Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
Aug 07 12:47:42 nixos Stirling-PDF[926]:  ____ _____ ___ ____  _     ___ _   _  ____       ____  ____  _____
Aug 07 12:47:42 nixos Stirling-PDF[926]: / ___|_   _|_ _|  _ \| |   |_ _| \ | |/ ___|     |  _ \|  _ \|  ___|
Aug 07 12:47:42 nixos Stirling-PDF[926]: \___ \ | |  | || |_) | |    | ||  \| | |  _ _____| |_) | | | | |_
Aug 07 12:47:42 nixos Stirling-PDF[926]:  ___) || |  | ||  _ <| |___ | || |\  | |_| |_____|  __/| |_| |  _|
Aug 07 12:47:42 nixos Stirling-PDF[926]: |____/ |_| |___|_| \_\_____|___|_| \_|\____|     |_|   |____/|_|
Aug 07 12:47:42 nixos Stirling-PDF[926]: Powered by Spring Boot 3.3.5
Aug 07 12:47:42 nixos Stirling-PDF[926]: 12:47:42.948 [main] INFO  s.software.SPDF.SPdfApplication - Starting SPdfApplication v0.33.1 using Java 21.0.7 with PID 926 (/nix/store/3r455abchqimpsjkj31yr7wr9yv8ksq0-stirling-pdf-0.33.1/share/stirling-pdf/Stirling-PDF.jar started by stirling-pdf in /var/lib/private/stirling-pdf)
Aug 07 12:47:42 nixos Stirling-PDF[926]: 12:47:42.982 [main] INFO  s.software.SPDF.SPdfApplication - The following 1 profile is active: "default"
Aug 07 12:47:51 nixos Stirling-PDF[926]: Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
Aug 07 12:48:00 nixos Stirling-PDF[926]: 12:48:00.080 [main] INFO  s.software.SPDF.SPdfApplication - Running configs ApplicationProperties(legal=ApplicationProperties.Legal(termsAndConditions=https://www.stirlingpdf.com/terms-and-conditions, privacyPolicy=https://www.stirlingpdf.com/privacy-policy, accessibilityStatement=, cookiePolicy=, impressum=), security=ApplicationProperties.Security(enableLogin=false, csrfDisabled=true, initialLogin=ApplicationProperties.Security.InitialLogin(username=), oauth2=ApplicationProperties.Security.OAUTH2(enabled=false, issuer=, clientId=, autoCreateUser=false, blockRegistration=false, useAsUsername=email, scopes=[openid, profile, email], provider=google, client=ApplicationProperties.Security.OAUTH2.Client(google=Google [clientId=, clientSecret=NULL, scopes=[https://www.googleapis.com/auth/userinfo.email, https://www.googleapis.com/auth/userinfo.profile], useAsUsername=email], github=GitHub [clientId=, clientSecret=NULL, scopes=[read:user], useAsUsername=login], keycloak=Keycloak [issuer=, clientId=, clientSecret=NULL, scopes=[openid, profile, email], useAsUsername=preferred_username])), saml2=stirling.software.SPDF.model.ApplicationProperties$Security$SAML2@104861ff, loginAttemptCount=5, loginResetTimeMinutes=120, loginMethod=all), system=ApplicationProperties.System(defaultLocale=en-US, googlevisibility=false, showUpdate=false, showUpdateOnlyAdmin=false, customHTMLFiles=false, tessdataDir=/usr/share/tessdata, enableAlphaFunctionality=false, enableAnalytics=false), ui=ApplicationProperties.Ui(appName=null, homeDescription=null, appNameNavbar=null), endpoints=ApplicationProperties.Endpoints(toRemove=[], groupsToRemove=[]), metrics=ApplicationProperties.Metrics(enabled=true), automaticallyGenerated=ApplicationProperties.AutomaticallyGenerated(UUID=2525cb46-2464-4ace-803c-002c92b152c4), enterpriseEdition=ApplicationProperties.EnterpriseEdition(enabled=false, maxUsers=0, customMetadata=ApplicationProperties.EnterpriseEdition.CustomMetadata(autoUpdateMetadata=false, author=username, creator=Stirling-PDF, producer=Stirling-PDF)), autoPipeline=ApplicationProperties.AutoPipeline(outputFolder=null), processExecutor=ApplicationProperties.ProcessExecutor(sessionLimit=ApplicationProperties.ProcessExecutor.SessionLimit(libreOfficeSessionLimit=1, pdfToHtmlSessionLimit=1, ocrMyPdfSessionLimit=2, pythonOpenCvSessionLimit=8, ghostScriptSessionLimit=16, weasyPrintSessionLimit=16, installAppSessionLimit=1, calibreSessionLimit=1), timeoutMinutes=ApplicationProperties.ProcessExecutor.TimeoutMinutes(libreOfficeTimeoutMinutes=30, pdfToHtmlTimeoutMinutes=20, ocrMyPdfTimeoutMinutes=30, pythonOpenCvTimeoutMinutes=30, ghostScriptTimeoutMinutes=30, weasyPrintTimeoutMinutes=30, installAppTimeoutMinutes=60, calibreTimeoutMinutes=30)))
Aug 07 12:48:01 nixos Stirling-PDF[926]: 12:48:01.297 [main] INFO  s.s.S.config.EndpointConfiguration - Total disabled endpoints: 2. Disabled endpoints: book-to-pdf, pdf-to-book
Aug 07 12:48:02 nixos Stirling-PDF[926]: 12:48:02.839 [main] INFO  s.s.S.c.s.d.DatabaseBackupHelper - Deleted oldest backup: backup_202507302221.sql
Aug 07 12:48:02 nixos Stirling-PDF[926]: 12:48:02.873 [main] INFO  s.s.S.c.s.d.DatabaseBackupHelper - Database export completed: configs/db/backup/backup_202508071248.sql
Aug 07 12:48:05 nixos Stirling-PDF[926]: 12:48:05.066 [main] WARN  o.s.s.c.a.a.c.InitializeUserDetailsBeanManagerConfigurer$InitializeUserDetailsManagerConfigurer - Global AuthenticationManager configured with an AuthenticationProvider bean. UserDetailsService beans will not be used for username/password login. Consider removing the AuthenticationProvider bean. Alternatively, consider using the UserDetailsService in a manually instantiated DaoAuthenticationProvider.
Aug 07 12:48:07 nixos Stirling-PDF[926]: 12:48:07.743 [main] INFO  s.software.SPDF.SPdfApplication - Started SPdfApplication in 26.205 seconds (process running for 29.639)
Aug 07 12:48:07 nixos Stirling-PDF[926]: 12:48:07.769 [scheduling-1] WARN  s.software.SPDF.utils.FileMonitor - not monitoring any directory, even the root directory itself: ./pipeline/watchedFolders
Aug 07 12:48:07 nixos Stirling-PDF[926]: 12:48:07.772 [main] INFO  s.software.SPDF.SPdfApplication - Stirling-PDF Started.
Aug 07 12:48:07 nixos Stirling-PDF[926]: 12:48:07.772 [main] INFO  s.software.SPDF.SPdfApplication - Navigate to http://localhost:8080
Aug 07 12:48:07 nixos Stirling-PDF[926]: 12:48:07.772 [scheduling-1] INFO  s.software.SPDF.utils.FileMonitor - Registered directory: ./pipeline/watchedFolders
Aug 07 13:47:20 nixos systemd[1]: Stopping stirling-pdf.service...
Aug 07 13:47:20 nixos systemd[1]: stirling-pdf.service: Deactivated successfully.
Aug 07 13:47:20 nixos systemd[1]: Stopped stirling-pdf.service.
Aug 07 13:47:20 nixos systemd[1]: stirling-pdf.service: Consumed 1min 9.945s CPU time, 634.8M memory peak, 187.3M read from disk, 44K written to disk.

The log lines right after the above, where stirling first appears failing to run:

Aug 07 13:47:25 nixos systemd[1]: Started stirling-pdf.service.
Aug 07 13:47:29 nixos Stirling-PDF[77540]: 13:47:29.205 [main] INFO  s.software.SPDF.SPDFApplication - Additional features in jar
Aug 07 13:47:29 nixos Stirling-PDF[77540]: 13:47:29.811 [main] INFO  s.s.c.c.ConfigInitializer - Settings file updated based on template changes.
Aug 07 13:47:29 nixos Stirling-PDF[77540]: 13:47:29.811 [main] INFO  s.software.SPDF.SPDFApplication - Settings file: ./configs/settings.yml
Aug 07 13:47:29 nixos Stirling-PDF[77540]: 13:47:29.815 [main] INFO  s.software.SPDF.SPDFApplication - Custom settings file: ./configs/custom_settings.yml
Aug 07 13:47:31 nixos Stirling-PDF[77540]:  ____ _____ ___ ____  _     ___ _   _  ____       ____  ____  _____
Aug 07 13:47:31 nixos Stirling-PDF[77540]: / ___|_   _|_ _|  _ \| |   |_ _| \ | |/ ___|     |  _ \|  _ \|  ___|
Aug 07 13:47:31 nixos Stirling-PDF[77540]: \___ \ | |  | || |_) | |    | ||  \| | |  _ _____| |_) | | | | |_
Aug 07 13:47:31 nixos Stirling-PDF[77540]:  ___) || |  | ||  _ <| |___ | || |\  | |_| |_____|  __/| |_| |  _|
Aug 07 13:47:31 nixos Stirling-PDF[77540]: |____/ |_| |___|_| \_\_____|___|_| \_|\____|     |_|   |____/|_|
Aug 07 13:47:31 nixos Stirling-PDF[77540]: Powered by Spring Boot 3.5.3
Aug 07 13:47:31 nixos Stirling-PDF[77540]: 13:47:31.591 [main] INFO  s.software.SPDF.SPDFApplication - Starting SPDFApplication v1.0.2 using Java 21.0.7 with PID 77540 (/nix/store/gvljqn9lp7gz8ndgb5n3hvr3bn7jd12f-stirling-pdf-1.0.2/share/stirling-pdf/Stirling-PDF.jar started by stirling-pdf in /var/lib/private/stirling-pdf)
Aug 07 13:47:31 nixos Stirling-PDF[77540]: 13:47:31.593 [main] INFO  s.software.SPDF.SPDFApplication - The following 1 profile is active: "security"
Aug 07 13:47:41 nixos Stirling-PDF[77540]: 13:47:41.246 [main] INFO  s.s.p.s.configuration.DatabaseConfig - Using default H2 database
Aug 07 13:47:48 nixos Stirling-PDF[77540]: 13:47:48.945 [main] WARN  s.s.SPDF.config.ExternalAppDepConfig - Missing dependency: unoconvert - Disabling group: Unoconvert (Affected features: File To PDF)
Aug 07 13:47:49 nixos Stirling-PDF[77540]: 13:47:49.419 [main] INFO  s.s.S.config.EndpointConfiguration - Disabled tool groups: Unoconvert (endpoints may have alternative implementations)
Aug 07 13:47:49 nixos Stirling-PDF[77540]: 13:47:49.420 [main] INFO  s.s.S.config.EndpointConfiguration - Disabled functional groups: enterprise
Aug 07 13:47:49 nixos Stirling-PDF[77540]: 13:47:49.420 [main] INFO  s.s.S.config.EndpointConfiguration - Total disabled endpoints: 1. Disabled endpoints: url-to-pdf
Aug 07 13:47:50 nixos Stirling-PDF[77540]: 13:47:50.577 [main] INFO  s.s.c.config.TempFileConfiguration - Created temporary directory: /tmp/stirling-pdf
Aug 07 13:47:51 nixos Stirling-PDF[77540]: 13:47:51.372 [main] INFO  s.software.common.util.FileMonitor - Monitoring directory: ./pipeline/watchedFolders
Aug 07 13:47:52 nixos Stirling-PDF[77540]: 13:47:52.390 [main] INFO  s.s.c.service.TempFileCleanupService - Created LibreOffice temp directory: /tmp/stirling-pdf/libreoffice
Aug 07 13:47:52 nixos Stirling-PDF[77540]: 13:47:52.391 [main] INFO  s.s.c.service.TempFileCleanupService - Running in Server-jar mode, using conservative cleanup strategy
Aug 07 13:47:52 nixos Stirling-PDF[77540]: 13:47:52.395 [main] INFO  s.s.c.service.TempFileCleanupService - Startup cleanup complete. Deleted 0 temporary files/directories
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.285 [main] ERROR s.s.p.s.service.DatabaseService - Error during database import: Constraint "CONSTRAINT_4" already exists; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         
Aug 07 13:47:53 nixos Stirling-PDF[77540]: ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("USER_ID") [90045-232]
Aug 07 13:47:53 nixos Stirling-PDF[77540]: org.h2.jdbc.JdbcSQLSyntaxErrorException: Constraint "CONSTRAINT_4" already exists; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         
Aug 07 13:47:53 nixos Stirling-PDF[77540]: ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("USER_ID") [90045-232]
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:644)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.get(DbException.java:223)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.get(DbException.java:199)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:111)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:74)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.ddl.AlterTable.update(AlterTable.java:46)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:120)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:71)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:262)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.service.DatabaseService.executeDatabaseScript(DatabaseService.java:311)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.service.DatabaseService.importDatabase(DatabaseService.java:137)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.InitialSecuritySetup.init(InitialSecuritySetup.java:40)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:429)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1818)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.291 [main] INFO  s.s.p.s.service.DatabaseService - Database import completed: configs/db/backup/backup_202508071248.sql
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.302 [main] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 42122, SQLState: 42S22
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.303 [main] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Column "U1_0.TEAM_ID" not found; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.322 [main] WARN  o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initialSecuritySetup': Invocation of init method failed
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.323 [main] INFO  s.s.c.config.TempFileShutdownHook - Application shutting down, cleaning up temporary files
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.323 [main] INFO  s.s.c.config.TempFileShutdownHook - Shutdown cleanup complete. Deleted 0 temporary files/directories
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.324 [main] INFO  s.s.common.service.ResourceMonitor - Shutting down resource monitoring
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.325 [main] INFO  s.s.common.service.TaskManager - Shutting down job result cleanup executor
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.513 [main] ERROR o.s.boot.SpringApplication - Application run failed
Aug 07 13:47:53 nixos Stirling-PDF[77540]: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initialSecuritySetup': Invocation of init method failed
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:222)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:429)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1818)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Aug 07 13:47:53 nixos Stirling-PDF[77540]: Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement [Column "U1_0.TEAM_ID" not found; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]] [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]; SQL [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:256)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:560)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:343)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:160)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:136)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at jdk.proxy2/jdk.proxy2.$Proxy190.findByAuthenticationTypeIgnoreCase(Unknown Source)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.service.UserService.migrateOauth2ToSSO(UserService.java:67)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:359)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.service.UserService$$SpringCGLIB$$1.migrateOauth2ToSSO(<generated>)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at stirling.software.proprietary.security.InitialSecuritySetup.init(InitialSecuritySetup.java:46)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         ... 23 common frames omitted
Aug 07 13:47:53 nixos Stirling-PDF[77540]: Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Column "U1_0.TEAM_ID" not found; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]] [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:66)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:191)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:153)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.internal.StandardStatementCreator.createStatement(StandardStatementCreator.java:49)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:236)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:172)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.<init>(JdbcValuesResultSetImpl.java:74)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.resolveJdbcValuesSource(JdbcSelectExecutorStandardImpl.java:355)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:137)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:102)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.spi.JdbcSelectExecutor.executeQuery(JdbcSelectExecutor.java:91)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:165)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$1(ConcreteSqmSelectQueryPlan.java:152)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:442)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:362)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:380)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:143)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.query.Query.getResultList(Query.java:120)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:130)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:93)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:160)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:148)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:170)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:149)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:69)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         ... 45 common frames omitted
Aug 07 13:47:53 nixos Stirling-PDF[77540]: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "U1_0.TEAM_ID" not found; SQL statement:
Aug 07 13:47:53 nixos Stirling-PDF[77540]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.get(DbException.java:223)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.message.DbException.get(DbException.java:199)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:244)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.expression.ExpressionColumn.optimizeOther(ExpressionColumn.java:226)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:213)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.query.Select.optimizeExpressionsAndPreserveAliases(Select.java:1344)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.query.Select.prepareExpressions(Select.java:1225)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.query.Query.prepare(Query.java:232)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.command.Parser.prepareCommand(Parser.java:489)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:687)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:342)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$4.doPrepare(StatementPreparerImpl.java:151)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:180)
Aug 07 13:47:53 nixos Stirling-PDF[77540]:         ... 76 common frames omitted
Aug 07 13:47:53 nixos Stirling-PDF[77540]: 13:47:53.518 [Thread-10] INFO  s.s.c.config.TempFileShutdownHook - Shutdown cleanup complete. Deleted 0 temporary files/directories
Aug 07 13:47:53 nixos systemd[1]: stirling-pdf.service: Main process exited, code=exited, status=1/FAILURE
Aug 07 13:47:53 nixos systemd[1]: stirling-pdf.service: Failed with result 'exit-code'.
Aug 07 13:47:53 nixos systemd[1]: stirling-pdf.service: Consumed 1min 9.939s CPU time, 636.6M memory peak, 95.2M read from disk, 28K written to disk.

Additional Information

My system information:

  • system: "x86_64-linux"
  • host os: Linux 6.12.44, NixOS, 25.11 (Xantusia), 25.11.20250902.d0fc308
  • multi-user?: yes
  • sandbox: yes
  • version: nix-env (Nix) 2.28.4
  • nixpkgs: /nix/store/8vfhnwmmzqqzy97q9c5m4bzyaqqf63zy-source

Bug also mentioned here: https://github.com/NixOS/nixpkgs/issues/440379

History of the package on nixpkgs repo: https://github.com/NixOS/nixpkgs/commits/nixos-unstable/pkgs/by-name/st/stirling-pdf/package.nix

I also tried using a different port, 3000, with both of these 2 configs (but didn't solve my issue):

services.stirling-pdf.environment =
    {
    INSTALL_BOOK_AND_ADVANCED_HTML_OPS = "true";
    SERVER_PORT = 3000;
    };

services.stirling-pdf.environment =
    {
    # INSTALL_BOOK_AND_ADVANCED_HTML_OPS = "true";
    SERVER_PORT = 3000;
    };

I checked with $ ss -tunlp | grep 3000 and $ ss -tunlp | grep 8080 (I also tried them with sudo as prefix) and I didn't find any service using these ports. I also opened the 3000 and 8080 tcp ports on my firewall without fixing my issue (should I open the udp ports as well?). Though I think enabling the service opens any necessary port automatically on nixos.

Should I try deleting anything? Where does stirling store its config? What should I delete?

Browsers Affected

Firefox

No Duplicate of the Issue

  • [x] I have verified that there are no existing issues raised related to my problem.

BlastboomStrice avatar Sep 06 '25 07:09 BlastboomStrice

Because it didn't fit in the log field, I'll continue here:

Latest log:

$ sudo journalctl -u stirling-pdf.service

-- Boot 104ed6afb29f497a80f1aecd9eb08b0e --
Sep 06 10:14:47 nixos systemd[1]: Started stirling-pdf.service.
Sep 06 10:14:50 nixos Stirling-PDF[811]: 10:14:50.834 [main] INFO  s.software.SPDF.SPDFApplication - Additional features in jar
Sep 06 10:14:51 nixos Stirling-PDF[811]: 10:14:51.648 [main] INFO  s.s.c.c.ConfigInitializer - Settings file updated based on template changes.
Sep 06 10:14:51 nixos Stirling-PDF[811]: 10:14:51.649 [main] INFO  s.software.SPDF.SPDFApplication - Settings file: ./configs/settings.yml
Sep 06 10:14:51 nixos Stirling-PDF[811]: 10:14:51.652 [main] INFO  s.software.SPDF.SPDFApplication - Custom settings file: ./configs/custom_settings.yml
Sep 06 10:14:53 nixos Stirling-PDF[811]:  ____ _____ ___ ____  _     ___ _   _  ____       ____  ____  _____
Sep 06 10:14:53 nixos Stirling-PDF[811]: / ___|_   _|_ _|  _ \| |   |_ _| \ | |/ ___|     |  _ \|  _ \|  ___|
Sep 06 10:14:53 nixos Stirling-PDF[811]: \___ \ | |  | || |_) | |    | ||  \| | |  _ _____| |_) | | | | |_
Sep 06 10:14:53 nixos Stirling-PDF[811]:  ___) || |  | ||  _ <| |___ | || |\  | |_| |_____|  __/| |_| |  _|
Sep 06 10:14:53 nixos Stirling-PDF[811]: |____/ |_| |___|_| \_\_____|___|_| \_|\____|     |_|   |____/|_|
Sep 06 10:14:53 nixos Stirling-PDF[811]: Powered by Spring Boot 3.5.4
Sep 06 10:14:53 nixos Stirling-PDF[811]: 10:14:53.886 [main] INFO  s.software.SPDF.SPDFApplication - Starting SPDFApplication v1.2.0 using Java 21.0.7 with PID 811 (/nix/store/rc4j5b589537q7rjsgzasza864ycd658-stirling-pdf-1.2.0/share/stirling-pdf/Stirling-PDF.jar started by stirling-pdf in /var/lib/private/stirling-pdf)
Sep 06 10:14:53 nixos Stirling-PDF[811]: 10:14:53.887 [main] INFO  s.software.SPDF.SPDFApplication - The following 1 profile is active: "security"
Sep 06 10:15:05 nixos Stirling-PDF[811]: 10:15:05.270 [main] INFO  s.s.p.s.configuration.DatabaseConfig - Using default H2 database
Sep 06 10:15:09 nixos Stirling-PDF[811]: 10:15:09.598 [main] WARN  o.h.t.s.i.ExceptionHandlerLoggedImpl - GenerationTarget encountered exception accepting command : Error executing DDL "alter table if exists authorities add constraint FKk91upmbueyim93v469wj7b2qh foreign key (user_id) references users" via JDBC [Index "PRIMARY_KEY_" not found;]
Sep 06 10:15:09 nixos Stirling-PDF[811]: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table if exists authorities add constraint FKk91upmbueyim93v469wj7b2qh foreign key (user_id) references users" via JDBC [Index "PRIMARY_KEY_" not found;]
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:94)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:576)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:516)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:448)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:269)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:112)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:280)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:144)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/java.util.HashMap.forEach(HashMap.java:1429)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:141)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.boot.internal.SessionFactoryObserverForSchemaExport.sessionFactoryCreated(SessionFactoryObserverForSchemaExport.java:37)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:324)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:463)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1517)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:66)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:419)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:400)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1873)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1822)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:365)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:135)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:513)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1375)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1205)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:365)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:135)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1725)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1474)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:606)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1683)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1628)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:546)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1375)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1205)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1683)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1628)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:230)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:184)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:179)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAdaptableBeans(ServletContextInitializerBeans.java:164)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:96)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:271)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:245)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.ServletContextInitializerConfiguration.callInitializers(ServletContextInitializerConfiguration.java:65)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.ServletContextInitializerConfiguration.configure(ServletContextInitializerConfiguration.java:54)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.Configurations.configure(Configurations.java:505)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.configure(WebAppContext.java:490)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.startContext(WebAppContext.java:1309)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.servlet.ServletContextHandler.lambda$doStart$0(ServletContextHandler.java:1051)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.handler.ContextHandler$ScopedContext.call(ContextHandler.java:1463)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.servlet.ServletContextHandler.doStart(ServletContextHandler.java:1048)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.doStart(WebAppContext.java:509)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:120)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Handler$Abstract.doStart(Handler.java:491)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.handler.StatisticsHandler.doStart(StatisticsHandler.java:66)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Server.start(Server.java:643)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:120)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Handler$Abstract.doStart(Handler.java:491)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Server.doStart(Server.java:584)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyWebServer.initialize(JettyWebServer.java:121)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyWebServer.<init>(JettyWebServer.java:88)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyServletWebServerFactory.getJettyWebServer(JettyServletWebServerFactory.java:481)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyServletWebServerFactory.getWebServer(JettyServletWebServerFactory.java:194)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:193)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:167)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:621)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Sep 06 10:15:09 nixos Stirling-PDF[811]: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Index "PRIMARY_KEY_" not found; SQL statement:
Sep 06 10:15:09 nixos Stirling-PDF[811]: alter table if exists authorities add constraint FKk91upmbueyim93v469wj7b2qh foreign key (user_id) references users [42112-232]
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:223)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:199)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.table.Table.getPrimaryKey(Table.java:920)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:217)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:74)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTable.update(AlterTable.java:46)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:262)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:80)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         ... 120 common frames omitted
Sep 06 10:15:09 nixos Stirling-PDF[811]: 10:15:09.608 [main] WARN  o.h.t.s.i.ExceptionHandlerLoggedImpl - GenerationTarget encountered exception accepting command : Error executing DDL "alter table if exists user_settings add constraint FK8v82nj88rmai0nyck19f873dw foreign key (user_id) references users" via JDBC [Index "PRIMARY_KEY_" not found;]
Sep 06 10:15:09 nixos Stirling-PDF[811]: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table if exists user_settings add constraint FK8v82nj88rmai0nyck19f873dw foreign key (user_id) references users" via JDBC [Index "PRIMARY_KEY_" not found;]
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:94)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:576)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:516)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:448)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:269)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:112)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:280)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:144)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/java.util.HashMap.forEach(HashMap.java:1429)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:141)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.boot.internal.SessionFactoryObserverForSchemaExport.sessionFactoryCreated(SessionFactoryObserverForSchemaExport.java:37)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:324)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:463)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1517)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:66)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:390)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:419)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:400)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:366)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1873)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1822)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:365)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:135)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:691)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:513)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1375)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1205)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:365)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:135)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1725)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1474)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:606)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1683)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1628)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:546)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1375)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1205)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1683)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1628)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:913)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:240)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1395)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1232)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:569)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:230)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:184)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAsRegistrationBean(ServletContextInitializerBeans.java:179)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addAdaptableBeans(ServletContextInitializerBeans.java:164)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:96)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:271)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:245)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.ServletContextInitializerConfiguration.callInitializers(ServletContextInitializerConfiguration.java:65)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.ServletContextInitializerConfiguration.configure(ServletContextInitializerConfiguration.java:54)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.Configurations.configure(Configurations.java:505)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.configure(WebAppContext.java:490)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.startContext(WebAppContext.java:1309)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.servlet.ServletContextHandler.lambda$doStart$0(ServletContextHandler.java:1051)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.handler.ContextHandler$ScopedContext.call(ContextHandler.java:1463)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.servlet.ServletContextHandler.doStart(ServletContextHandler.java:1048)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.ee10.webapp.WebAppContext.doStart(WebAppContext.java:509)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:120)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Handler$Abstract.doStart(Handler.java:491)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.handler.StatisticsHandler.doStart(StatisticsHandler.java:66)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Server.start(Server.java:643)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:120)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Handler$Abstract.doStart(Handler.java:491)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.server.Server.doStart(Server.java:584)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyWebServer.initialize(JettyWebServer.java:121)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyWebServer.<init>(JettyWebServer.java:88)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyServletWebServerFactory.getJettyWebServer(JettyServletWebServerFactory.java:481)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.embedded.jetty.JettyServletWebServerFactory.getWebServer(JettyServletWebServerFactory.java:194)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:193)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:167)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:621)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Sep 06 10:15:09 nixos Stirling-PDF[811]: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Index "PRIMARY_KEY_" not found; SQL statement:
Sep 06 10:15:09 nixos Stirling-PDF[811]: alter table if exists user_settings add constraint FK8v82nj88rmai0nyck19f873dw foreign key (user_id) references users [42112-232]
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:223)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:199)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.table.Table.getPrimaryKey(Table.java:920)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:217)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:74)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTable.update(AlterTable.java:46)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:262)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:231)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:80)
Sep 06 10:15:09 nixos Stirling-PDF[811]:         ... 120 common frames omitted
Sep 06 10:15:14 nixos Stirling-PDF[811]: 10:15:14.712 [main] WARN  s.s.SPDF.config.ExternalAppDepConfig - Missing dependency: unoconvert - Disabling group: Unoconvert (Affected features: File To PDF)
Sep 06 10:15:15 nixos Stirling-PDF[811]: 10:15:15.327 [main] INFO  s.s.S.config.EndpointConfiguration - Disabled tool groups: Unoconvert (endpoints may have alternative implementations)
Sep 06 10:15:15 nixos Stirling-PDF[811]: 10:15:15.328 [main] INFO  s.s.S.config.EndpointConfiguration - Disabled functional groups: enterprise
Sep 06 10:15:15 nixos Stirling-PDF[811]: 10:15:15.328 [main] INFO  s.s.S.config.EndpointConfiguration - Total disabled endpoints: 1. Disabled endpoints: url-to-pdf
Sep 06 10:15:16 nixos Stirling-PDF[811]: 10:15:16.908 [main] INFO  s.s.c.config.TempFileConfiguration - Created temporary directory: /tmp/stirling-pdf
Sep 06 10:15:18 nixos Stirling-PDF[811]: 10:15:18.182 [main] INFO  s.software.common.util.FileMonitor - Monitoring directory: ./pipeline/watchedFolders
Sep 06 10:15:20 nixos Stirling-PDF[811]: 10:15:20.090 [pool-3-thread-1] INFO  s.s.common.service.ResourceMonitor - System resource status changed from OK to CRITICAL
Sep 06 10:15:20 nixos Stirling-PDF[811]: 10:15:20.093 [pool-3-thread-1] INFO  s.s.common.service.ResourceMonitor - Current metrics - CPU: 147.4%, Memory: 3.3%, Free Memory: 218 MB
Sep 06 10:15:20 nixos Stirling-PDF[811]: 10:15:20.178 [main] INFO  s.s.c.service.TempFileCleanupService - Created LibreOffice temp directory: /tmp/stirling-pdf/libreoffice
Sep 06 10:15:20 nixos Stirling-PDF[811]: 10:15:20.178 [main] INFO  s.s.c.service.TempFileCleanupService - Running in Server-jar mode, using conservative cleanup strategy
Sep 06 10:15:20 nixos Stirling-PDF[811]: 10:15:20.184 [main] INFO  s.s.c.service.TempFileCleanupService - Startup cleanup complete. Deleted 0 temporary files/directories
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.159 [main] ERROR s.s.p.s.service.DatabaseService - Error during database import: Constraint "CONSTRAINT_4" already exists; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]:         
Sep 06 10:15:21 nixos Stirling-PDF[811]: ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("USER_ID") [90045-232]
Sep 06 10:15:21 nixos Stirling-PDF[811]: org.h2.jdbc.JdbcSQLSyntaxErrorException: Constraint "CONSTRAINT_4" already exists; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]:         
Sep 06 10:15:21 nixos Stirling-PDF[811]: ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("USER_ID") [90045-232]
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:644)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:223)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:199)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:111)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:74)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.ddl.AlterTable.update(AlterTable.java:46)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:120)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:71)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.CommandContainer.update(CommandContainer.java:139)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:304)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.Command.executeUpdate(Command.java:248)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:262)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.service.DatabaseService.executeDatabaseScript(DatabaseService.java:311)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.service.DatabaseService.importDatabase(DatabaseService.java:137)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.InitialSecuritySetup.init(InitialSecuritySetup.java:40)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:429)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1818)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.163 [main] INFO  s.s.p.s.service.DatabaseService - Database import completed: configs/db/backup/backup_202508071248.sql
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.180 [main] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 42122, SQLState: 42S22
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.182 [main] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Column "U1_0.TEAM_ID" not found; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.216 [main] WARN  o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initialSecuritySetup': Invocation of init method failed
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.217 [main] INFO  s.s.c.config.TempFileShutdownHook - Application shutting down, cleaning up temporary files
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.217 [main] INFO  s.s.c.config.TempFileShutdownHook - Shutdown cleanup complete. Deleted 0 temporary files/directories
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.220 [main] INFO  s.s.common.service.ResourceMonitor - Shutting down resource monitoring
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.221 [main] INFO  s.s.common.service.TaskManager - Shutting down job result cleanup executor
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21.476 [main] ERROR o.s.boot.SpringApplication - Application run failed
Sep 06 10:15:21 nixos Stirling-PDF[811]: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'initialSecuritySetup': Invocation of init method failed
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:222)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:429)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1818)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:607)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:529)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:339)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:373)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:337)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.instantiateSingleton(DefaultListableBeanFactory.java:1222)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingleton(DefaultListableBeanFactory.java:1188)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:1123)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:987)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:627)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:752)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:439)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.SPDF.SPDFApplication.main(SPDFApplication.java:131)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:102)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:64)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:40)
Sep 06 10:15:21 nixos Stirling-PDF[811]: Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement [Column "U1_0.TEAM_ID" not found; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]] [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]; SQL [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:256)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:560)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:343)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:160)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:136)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at jdk.proxy2/jdk.proxy2.$Proxy192.findByAuthenticationTypeIgnoreCase(Unknown Source)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.service.UserService.migrateOauth2ToSSO(UserService.java:67)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:360)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:728)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.service.UserService$$SpringCGLIB$$1.migrateOauth2ToSSO(<generated>)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at stirling.software.proprietary.security.InitialSecuritySetup.init(InitialSecuritySetup.java:46)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at java.base/java.lang.reflect.Method.invoke(Method.java:580)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         ... 23 common frames omitted
Sep 06 10:15:21 nixos Stirling-PDF[811]: Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement [Column "U1_0.TEAM_ID" not found; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]] [select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?)]
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:66)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:191)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:153)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.internal.StandardStatementCreator.createStatement(StandardStatementCreator.java:49)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:236)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:172)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.<init>(JdbcValuesResultSetImpl.java:74)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.resolveJdbcValuesSource(JdbcSelectExecutorStandardImpl.java:355)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:137)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:102)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.spi.JdbcSelectExecutor.executeQuery(JdbcSelectExecutor.java:91)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:165)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$1(ConcreteSqmSelectQueryPlan.java:149)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:439)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:359)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:380)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:143)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.query.Query.getResultList(Query.java:120)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:130)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:93)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:160)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:148)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:170)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:149)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:69)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:380)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         ... 45 common frames omitted
Sep 06 10:15:21 nixos Stirling-PDF[811]: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "U1_0.TEAM_ID" not found; SQL statement:
Sep 06 10:15:21 nixos Stirling-PDF[811]: select u1_0.user_id,u1_0.api_key,u1_0.authenticationtype,u1_0.enabled,u1_0.is_first_login,u1_0.password,u1_0.role_name,u1_0.team_id,u1_0.username from users u1_0 where upper(u1_0.authenticationtype)=upper(?) [42122-232]
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:223)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.message.DbException.get(DbException.java:199)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:244)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.expression.ExpressionColumn.optimizeOther(ExpressionColumn.java:226)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:213)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.query.Select.optimizeExpressionsAndPreserveAliases(Select.java:1344)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.query.Select.prepareExpressions(Select.java:1225)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.query.Query.prepare(Query.java:232)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.command.Parser.prepareCommand(Parser.java:489)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:687)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:342)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$4.doPrepare(StatementPreparerImpl.java:151)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:180)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         ... 76 common frames omitted
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21,489 |-WARN in Logger[stirling.software.common.config.TempFileShutdownHook] - No appenders present in context [default] for logger [stirling.software.common.config.TempFileShutdownHook].
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Failed with result 'exit-code'.
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Consumed 1min 12.353s CPU time, 798.3M memory peak, 200.2M read from disk, 148K written to disk.

Latest short log:

$ sudo systemctl status stirling-pdf.service

× stirling-pdf.service
     Loaded: loaded (/etc/systemd/system/stirling-pdf.service; enabled; preset: ignored)
     Active: failed (Result: exit-code) since Sat 2025-09-06 10:15:21 EEST; 19min ago
   Duration: 34.412s
 Invocation: 2291acf9cdb0498283c227bf00e2bcb8
    Process: 811 ExecStart=/nix/store/rc4j5b589537q7rjsgzasza864ycd658-stirling-pdf-1.2.0/bin/Stirling-PDF (code=exited, status=1/FAILURE)
   Main PID: 811 (code=exited, status=1/FAILURE)
         IP: 0B in, 0B out
         IO: 200.2M read, 148K written
   Mem peak: 798.3M
        CPU: 1min 12.353s

Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:687)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:342)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$4.doPrepare(StatementPreparerImpl.java:151)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:180)
Sep 06 10:15:21 nixos Stirling-PDF[811]:         ... 76 common frames omitted
Sep 06 10:15:21 nixos Stirling-PDF[811]: 10:15:21,489 |-WARN in Logger[stirling.software.common.config.TempFileShutdownHook] - No appenders present in context [default] for logger [stirling.software.common.config.TempFileShutdownHook].
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Failed with result 'exit-code'.
Sep 06 10:15:21 nixos systemd[1]: stirling-pdf.service: Consumed 1min 12.353s CPU time, 798.3M memory peak, 200.2M read from disk, 148K written to disk.

BlastboomStrice avatar Sep 06 '25 07:09 BlastboomStrice

Hi @BlastboomStrice! I'm Dosu and I’m helping the Stirling-PDF team.

Your logs show classic signs of a database schema mismatch after a major upgrade: errors like Constraint "CONSTRAINT_4" already exists, Column "U1_0.TEAM_ID" not found, and Index "PRIMARY_KEY_" not found all point to the H2 database structure not matching what the new Stirling-PDF version expects. This usually happens when the upgrade introduces new tables/columns or changes constraints, but the old database is still present.

Where are the config and database files?

  • Config files: ./configs/settings.yml and ./configs/custom_settings.yml (relative to the working directory, often /var/lib/private/stirling-pdf on NixOS).
  • Database backups: configs/db/backup/ or, in newer versions, config/backup/db/ (again, relative to the working directory) see PR #4225.
  • The actual H2 database file is typically stored in the same working directory as the configs, unless overridden in the config or via environment variables. Look for files like database.mv.db or similar in /var/lib/private/stirling-pdf or a nearby directory.

How to reset and resolve the schema mismatch:

  1. Stop the Stirling-PDF service.
  2. Backup: If you have important data, copy out any recent files from configs/db/backup/ or config/backup/db/ for safekeeping.
  3. Delete the H2 database file(s): Remove files like database.mv.db or any .db files in /var/lib/private/stirling-pdf (or wherever your configs are).
  4. (Optional) Clean up old backups: If you want a truly fresh start, you can also clear out the backup directory, but keep any you want to restore.
  5. Start the Stirling-PDF service again. The app will create a new, clean database with the correct schema for your current version.

If you want to restore from a backup, you can use the web interface or API after the service starts and the schema is correct docs.

This process should resolve the startup errors and let the new version run with a fresh database schema. If you have custom settings, double-check your settings.yml and custom_settings.yml after the upgrade, but these files are not the cause of the schema errors.

Let me know if you need help finding the exact database file path on your system!

To reply, just mention @dosu.

How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other  Chat with Dosu Join Discord Share on X

dosubot[bot] avatar Sep 06 '25 07:09 dosubot[bot]

I would like to be sure before deleting anything with sudo on my system and I'd like to know that I'm not deleting anything wrong, so I don't think I can follow a bot's advice:/ Also it would be cool if I could somehow fix the database instead of deleting it.

BlastboomStrice avatar Sep 06 '25 08:09 BlastboomStrice

We will look into this issue thanks for raising In meantime to unblock the bot is half correct

You could reset your Stirling pdf database by clearing the stirling pdf dB file located in our configs folder

Frooodle avatar Sep 06 '25 08:09 Frooodle

So it seems to be triggering the database restore functionality using a backup file that's not compatible with the current installation Whats odd is this DB restore should only trigger if the database file has 0 users in it

Does your installation have login enabled or disabled?

Frooodle avatar Sep 06 '25 08:09 Frooodle

No, I dont think I ever logged in or something

(Also I think they have disabled the proprietary features which I think are linked to accounts and such.)

Edit: Checked the settings.yml and it confirms me:

oauth2:
    enabled: false # set to 'true' to enable login (Note: enableLogin must also be 'true' for this to work)

BlastboomStrice avatar Sep 06 '25 08:09 BlastboomStrice

please delete your db folder for now, I have confirmed its a issue with the backups and will have a patch out by monday

Frooodle avatar Sep 06 '25 09:09 Frooodle

Starting with version v0.34.0 we switched to a new database version https://github.com/Stirling-Tools/Stirling-PDF/commit/8f4709d82e49c947b233cf3ea6814b759da8bd0f, so it would be advisable to upgrade from v0.33.1 to v0.34.0.

Ludy87 avatar Sep 06 '25 09:09 Ludy87

Thank you everyone:) Very quick response too!

(Ludy I suppose you mean I should first go to 0.34.0 and then update to the newer versions, instead of jumping to 1.0.2 as we did on nixpkgs. I'm not that advanced in nixos, so I cant really do that now, but thanks, it makes sense.)

BlastboomStrice avatar Sep 06 '25 09:09 BlastboomStrice

I'm currently checking which version after 0.34 will trigger the next compatibility error.

I hope the database hasn't been corrupted yet.

Yes, from 0.33.1 to 0.34.0

Ludy87 avatar Sep 06 '25 09:09 Ludy87

No worries, I didnt have anything important on the database, I just wanted to mention it in case someone else stumbles upon this and has important stuff in the database:)

BlastboomStrice avatar Sep 06 '25 09:09 BlastboomStrice

Btw yay, deleting the db folder fixed it:))

BlastboomStrice avatar Sep 06 '25 09:09 BlastboomStrice