Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-939

SCHEDULER-451 Database check failed for 1.3.3025-SNAPSHOT (2013-01-29)

    XMLWordPrintable

Details

    • Fix
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 1.3.12.3044
    • 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.

      Attachments

        1. scheduler.log
          13 kB
          Jan Lolling
        2. scheduler.out
          0.4 kB
          Jan Lolling

        Activity

          People

            jz Joacim Zschimmer
            oh Oliver Haufe
            Stefan Schädlich Stefan Schädlich (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: