Details
-
Fix
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
-
None
Description
I've tested
version=1.3.3025-SNAPSHOT
platform=windows-x86
builddate=2013-01-29 14\:16\:10
The JobScheduler doesn't start because of:
.29 17:30:57.083 scheduler 0 4604.1834 480.391MB .{scheduler} sos::scheduler::database::Transaction::execute UPDATE SCHEDULER_VARIABLES set "TEXTWERT"=' .29 17:30:57.083 scheduler 0 4604.1834 480.391MB . !"#$%&''()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\' where "NAME"='SCHEDULER.TEST.CHECK_DATABASE.2013-01-29 17:30:57.083.41' (sos::scheduler::database::Transaction::try_update_variable) .29 17:30:57.084 scheduler 0 4604.1834 480.391MB .{scheduler} sos::scheduler::database::Transaction::execute INSERT into SCHEDULER_VARIABLES ("NAME","TEXTWERT") values ('SCHEDULER.TEST.CHECK_DATABASE.2013-01-29 17:30:57.083.41',' .29 17:30:57.084 scheduler 0 4604.1834 480.391MB . !"#$%&''()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\') (sos::scheduler::database::Transaction::insert_variable) .29 17:30:57.089 scheduler 15 4604.1834 480.391MB ..DatabaseProductName=PostgreSQL, DriverName=PostgreSQL Native Driver .29 17:30:57.093 scheduler 0 4604.1834 480.391MB .~Sos_database_session() db=jdbc:postgresql://wilma:5432/test user=setup cmd= open_mode=1 ref=0 .29 17:30:57.093 scheduler 0 4604.1834 480.391MB .[ERROR SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.093 scheduler 0 4604.1834 480.391MB . .29 17:30:57.093 scheduler 0 4604.1834 480.391MB . !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\ (written value) .29 17:30:57.093 scheduler 0 4604.1834 480.391MB . (read value)] .29 17:30:57.093 scheduler 0 4604.1834 480.391MB .{scheduler} sos::scheduler::database::Transaction::execute ROLLBACK (sos::scheduler::database::Transaction::~Transaction) .29 17:30:57.094 scheduler 0 4604.1834 480.391MB .[ERROR SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\ (written value) .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . (read value)] .29 17:30:57.094 scheduler 0 4604.1834 481.641MB .{scheduler.service} SetServiceStatus SERVICE_PAUSED .29 17:30:57.094 scheduler 0 4604.16FC 481.641MB {scheduler.service} pending_watchdog_thread endet .29 17:30:57.094 scheduler 0 4604.F3C 480.391MB {scheduler.service} Selbstzerstörung in 35 Sekunden (ohne weitere Ankündigung) ... .29 17:30:57.094 scheduler 0 4604.1834 480.391MB .{scheduler.service} event_log() ERROR SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\ (written value) .29 17:30:57.094 scheduler 0 4604.1834 480.391MB . (read value) .29 17:30:57.095 scheduler 0 4604.1834 480.891MB .{scheduler.service} ReportEvent() .29 17:30:57.096 scheduler 0 4604.1834 480.891MB .[ERROR SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.096 scheduler 0 4604.1834 480.891MB . .29 17:30:57.096 scheduler 0 4604.1834 480.891MB . !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\ (written value) .29 17:30:57.096 scheduler 0 4604.1834 480.891MB . (read value)] .29 17:30:57.096 scheduler 0 4604.1834 480.891MB .CreateInstance(jmail::Message {E5FF9F62-0E7C-4372-8AD5-DA7D2418070C} (unknown)) .29 17:30:57.215 scheduler 125 4604.1834 482.777MB .xsltApplyStylesheet( "config/scheduler_mail.xsl" ) .29 17:30:57.216 scheduler 0 4604.1834 482.777MB .CreateInstance(jmail::Message {E5FF9F62-0E7C-4372-8AD5-DA7D2418070C} (unknown)) .29 17:30:57.234 scheduler 16 4604.1834 482.777MB .{scheduler} [debug3] email oh@sos-berlin.com: ERROR ON SCHEDULER START: SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.234 scheduler 0 4604.1834 482.777MB .JavaMail Send smtp=smtp.sos to="oh@sos-berlin.com" subject="ERROR ON SCHEDULER START: SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values:" .29 17:30:57.302 scheduler 62 4604.1834 482.777MB .JavaMail Send fertig .29 17:30:57.302 scheduler 0 4604.1834 482.777MB .{scheduler} [ERROR] SCHEDULER-451 Database check failed, database is not useable. SCHEDULER-452 Database does not correctly store test values: .29 17:30:57.302 scheduler 0 4604.1834 482.777MB .{scheduler} [ERROR] .29 17:30:57.302 scheduler 0 4604.1834 482.777MB .{scheduler} [ERROR] !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\ (written value) .29 17:30:57.303 scheduler 0 4604.1834 482.777MB .{scheduler} [ERROR] (read value) .29 17:30:57.303 scheduler 0 4604.1834 482.777MB .~Sos_database_session() id=spooler db=jdbc:postgresql://wilma:5432/test user=setup cmd=ROLLBACK open_mode=3 ref=0 .29 17:30:57.303 scheduler 0 4604.1834 482.777MB .close(4) C:/ProgramData/sos-berlin.com/jobscheduler/scheduler.oh/logs/scheduler.pid .29 17:30:57.304 scheduler 16 4604.1834 482.777MB .unlink("C:/ProgramData/sos-berlin.com/jobscheduler/scheduler.oh/logs/scheduler.pid") .29 17:30:57.319 scheduler 15 4604.1834 482.777MB .{log4j.com.sos.scheduler.engine.kernel.log.LogSubsystem} Closed .29 17:30:57.322 scheduler 0 4604.1834 482.777MB .{scheduler.service} SetServiceStatus SERVICE_STOPPED .29 17:30:57.323 scheduler 0 4604.1834 482.777MB .{scheduler.service} service_thread ok .29 17:30:57.323 scheduler 0 4604.AEC 482.777MB ..{scheduler.service} StartServiceCtrlDispatcher() OK .29 17:30:57.324 scheduler 0 4604.1868 481.527MB .{scheduler.service} ServiceMain ok .29 17:30:57.324 scheduler 0 4604.AEC 481.527MB .{scheduler.service} spooler_service() fertig .29 17:30:57.324 scheduler 0 4604.AEC 480.277MB {scheduler} Executable will be terminated. .29 17:30:57.324 scheduler 0 4604.AEC 480.273MB ~Sos_database_static() struct sos::Sos_database_static
This error occured with MySQL and PostGres. Other DBs are not tested.