how to do maintenance to the base of schedulix

29 views
Skip to first unread message

Pablo Maldonado

unread,
Jan 14, 2019, 12:20:33 PM1/14/19
to schedulix

Hello, I wanted to know what tables I can debug to keep the database clean and small, I mean with information of the last 30 or 15 days of the activity of the jobs. I would like to have a history of Schedulix activity no more than 30 or 15 days. Pablo Maldonado

Ronald Jeninga

unread,
Jan 14, 2019, 12:34:01 PM1/14/19
to schedulix
Hi Pablo,


actually there's no real need to do this yourself. In fact it would even be dangerous if you don't exactly know what you are doing.
There are a bunch of server parameters that address this requirement.

Within the server.conf you find:

#
# Archive: enable/disable archiving of data when using DbHistory != 0
#          removed data will be copied to ARC_... tables before removal
#          specify column lists (comma seperated column names) if you do not want to archive all columns
#          specify NONE if you don't want a specific table to be archived
#          specify ALL if all columns should be archived, which is also the default if archiving is switched on
#
Archive=false
ArchiveSMEColumns=ALL
ArchiveAuditColumns=ALL
ArchiveDependencyColumns=ALL
ArchiveVariableColumns=ALL
ArchiveHierarchyColumns=ALL
ArchiveKillJobColumns=ALL

as well as 

#
# DbHistory: Number of minutes to keep in BICsuite repository database
#            If the Archive option is disabled, data of older job executions will get lost !!!
#            Set to 0 if you do not want to remove data of older job executions from the BICsuite repository
#            Set to 1 to remove all data which isn't any longer in server memory
#            Set to 45000 to keep the data for approximately 1 month
#            Set to 540000 to keep data for approximately 1 year
#
DbHistory=45000

From your question I infer that you don't want to archive anything, just get rid of the old waste.
That means that the archiving parameters are perfect as they are.

Now if you set the DbHistory parameter to some value unequal zero, the server will clean up the database regularly itself.

Note that Jobs that aren't final remain in the database indefinitely.
If a Job is "Red", cancel it if you don't need it any more, or repair the situation and rerun if it still is relevant.

Hope that helps.

Best regards,

Ronald

Pablo Maldonado

unread,
Jan 14, 2019, 12:56:00 PM1/14/19
to schedulix
Hello Ronald,

Thank you for your quick help, that is what I had just done, because I checked the server.conf and the comments of the same configure the server, so I am already calm.

Thank you


Pablo Maldonado

Pablo Maldonado

unread,
Feb 5, 2019, 10:18:56 AM2/5/19
to schedulix
Hello Ronald,


if I enable the parameter "DbHistory = 45000", when wanting to upload the server, it gives a database error.
The database believes it as innodb, can that be the problem?

Pablo Maldonado

Dieter Stubler

unread,
Feb 5, 2019, 10:22:00 AM2/5/19
to schedulix
Hi Pablo,

the database error you get might be helpful.

Regards
Dieter

Pablo Maldonado

unread,
Feb 5, 2019, 10:56:41 AM2/5/19
to schedulix
Hello Ronald,

I attach the log with the error it throws. 
The base is created in MariaDB with the innodb engine.

********************************************************************************************************************************************************************************
START
********************************************************************************************************************************************************************************

INFO    [main]          05 Feb 2019 15:48:20 GMT **************************************************************************
INFO    [main]          05 Feb 2019 15:48:20 GMT Copyright : Copyright (c) 2002-2017 independIT Integrative Technologies GmbH
INFO    [main]          05 Feb 2019 15:48:20 GMT Build-Date : 15.09.2018 13:46
INFO    [main]          05 Feb 2019 15:48:20 GMT Level : OPEN
INFO    [main]          05 Feb 2019 15:48:20 GMT Build : 284b33aea16e5e696bf6ca8a332b096145eae4fc
INFO    [main]          05 Feb 2019 15:48:20 GMT Company : independIT Integrative Technologies GmbH
INFO    [main]          05 Feb 2019 15:48:20 GMT Program-Version : 2.8
INFO    [main]          05 Feb 2019 15:48:20 GMT Created-By : 1.8.0_181 (Oracle Corporation)
INFO    [main]          05 Feb 2019 15:48:20 GMT Manifest-Version : 1.1
INFO    [main]          05 Feb 2019 15:48:20 GMT **************************************************************************
INFO    [main]          05 Feb 2019 15:48:20 GMT ** BICsuite!Server
INFO    [main]          05 Feb 2019 15:48:20 GMT ** Version 2.8
INFO    [main]          05 Feb 2019 15:48:20 GMT ** Copyright (C) 2000-2002 topIT Informationstechnologie GmbH
INFO    [main]          05 Feb 2019 15:48:20 GMT ** Copyright (C) 2003-2014 independIT Integrative Technologies GmbH
INFO    [main]          05 Feb 2019 15:48:20 GMT **************************************************************************
INFO    [main]          05 Feb 2019 15:48:20 GMT Commandline Start Options:
INFO    [main]          05 Feb 2019 15:48:20 GMT        /Software/Schedulix/etc/server.conf
INFO    [main]          05 Feb 2019 15:48:20 GMT TTWakeup=30
INFO    [main]          05 Feb 2019 15:48:20 GMT UserThreads=30
INFO    [main]          05 Feb 2019 15:48:20 GMT JdbcDriver=com.mysql.jdbc.Driver
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveSMEColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT TrustStore=/home/bicsuite/etc/certs/srvkeystore
INFO    [main]          05 Feb 2019 15:48:20 GMT TxRetryCount=3
INFO    [main]          05 Feb 2019 15:48:20 GMT SingleServer=true
INFO    [main]          05 Feb 2019 15:48:20 GMT CompatibilityLevel=BASIC
INFO    [main]          05 Feb 2019 15:48:20 GMT History=14400
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveExtentsColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOuseADGroups=false
INFO    [main]          05 Feb 2019 15:48:20 GMT ParameterHandling=liberal
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOincludeDomainNames=false
INFO    [main]          05 Feb 2019 15:48:20 GMT ClientAuthentication=true
INFO    [main]          05 Feb 2019 15:48:20 GMT PriorityLowerBound=10
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOautoCreateUsers=false
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveHierarchyColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOnameCase=UPPER
INFO    [main]          05 Feb 2019 15:48:20 GMT ServicePort=2505
INFO    [main]          05 Feb 2019 15:48:20 GMT TimerWakeup=30
INFO    [main]          05 Feb 2019 15:48:20 GMT PriorityDelay=1
INFO    [main]          05 Feb 2019 15:48:20 GMT KeyStore=/home/bicsuite/etc/certs/srvkeystore
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveAuditColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT CodePage=latin1
INFO    [main]          05 Feb 2019 15:48:20 GMT DbUrl=jdbc:mysql://schedp1:1979/schedulixdb
INFO    [main]          05 Feb 2019 15:48:20 GMT TimerTimeout=10
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveDependencyColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT DbLoaders=2
INFO    [main]          05 Feb 2019 15:48:20 GMT RunMode=PRODUCTION
INFO    [main]          05 Feb 2019 15:48:20 GMT Port=2506
INFO    [main]          05 Feb 2019 15:48:20 GMT HistoryLimit=28800
INFO    [main]          05 Feb 2019 15:48:20 GMT CalendarEntries=250
INFO    [main]          05 Feb 2019 15:48:20 GMT TimerHorizon=2
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOserverName=DEFAULT
INFO    [main]          05 Feb 2019 15:48:20 GMT ScheduleWakeup=30
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveStatsColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveVariableColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT DbUser=schedulix
INFO    [main]          05 Feb 2019 15:48:20 GMT MinHistoryCount=0
INFO    [main]          05 Feb 2019 15:48:20 GMT SSObicsuitePrefix=BICSUITE
INFO    [main]          05 Feb 2019 15:48:20 GMT CalendarHorizon=90
INFO    [main]          05 Feb 2019 15:48:20 GMT TimerSuspendLimit=15
INFO    [main]          05 Feb 2019 15:48:20 GMT Hostname=mgiap059
INFO    [main]          05 Feb 2019 15:48:20 GMT WorkerThreads=2
INFO    [main]          05 Feb 2019 15:48:20 GMT DbHistory=45000
INFO    [main]          05 Feb 2019 15:48:20 GMT Archive=false
INFO    [main]          05 Feb 2019 15:48:20 GMT TriggerHardLimit=100
INFO    [main]          05 Feb 2019 15:48:20 GMT TriggerSoftLimit=50
INFO    [main]          05 Feb 2019 15:48:20 GMT MaxHistoryCount=0
INFO    [main]          05 Feb 2019 15:48:20 GMT TraceLevel=1
INFO    [main]          05 Feb 2019 15:48:20 GMT ArchiveKillJobColumns=ALL
INFO    [main]          05 Feb 2019 15:48:20 GMT SSOautoCreateGroups=false
INFO    [main]          05 Feb 2019 15:48:20 GMT TimerRecalc=1
INFO    [main]          05 Feb 2019 15:48:20 GMT GCWakeup=240
INFO    [main]          05 Feb 2019 15:48:20 GMT SessionTimeout=0
INFO    [main]          05 Feb 2019 15:48:20 GMT Using internal Authentication
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting ENVIRONMENT
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting ERRORLOG
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting EXPFINALTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting EXPRUNTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting FINISHTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting ISRESTARTABLE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting JOBID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting JOBNAME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting JOBSTATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting JOBTAG
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting KEY
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting LOGFILE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting MASTERID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting MERGEDSTATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting PARENTID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting PID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting RERUNSEQ
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting RESOURCETIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting RUNNABLETIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SCOPENAME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SDMSHOST
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SDMSPORT
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SEID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SEOWNER
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting STARTTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting STATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SUBMITGROUP
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SUBMITTER
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SUBMITTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SYNCTIME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting SYSDATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERBASE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERBASEID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERBASEJOBID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERNAME
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERNEWSTATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERORIGIN
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERORIGINID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERORIGINJOBID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGEROLDSTATE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERREASON
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERREASONID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERREASONJOBID
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERSEQNO
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting TRIGGERTYPE
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting LAST_WARNING
INFO    [main]          05 Feb 2019 15:48:20 GMT Exporting WORKDIR
INFO    [main]          05 Feb 2019 15:48:20 GMT JDBC Driver used : MySQL Connector Java
INFO    [main]          05 Feb 2019 15:48:20 GMT Acquire repository lock for 1549381700104
INFO    [main]          05 Feb 2019 15:48:20 GMT Starting Renew Ticket Thread
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT TableLoader 0 started
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT TableLoader 1 started
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 5, Loaded 5 rows for GROUPS
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RESOURCE_REQUIREMENT
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 78, Loaded 78 rows for SCHEDULING_HIERARCHY
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 35, Loaded 35 rows for SCOPE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 45, Loaded 45 rows for INTERVAL_SELECTION
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RUNNABLE_QUEUE
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 53, Loaded 53 rows for EVENT
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for EXTENTS
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for TRIGGER_QUEUE
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RESOURCE_STATE_PROFILE
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for KILL_JOB
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 53, Loaded 53 rows for SCHEDULED_EVENT
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 161, Loaded 161 rows for SCHEDULE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for TRIGGER_DEFINITION
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 1, Loaded 1 rows for PERSISTENT_VALUE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for GRANTS
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RESOURCE_STATE_MAP_PROF
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 80, Loaded 80 rows for FOLDER
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 24, Loaded 24 rows for DEPENDENCY_DEFINITION
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RESOURCE_STATE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for RESOURCE_TEMPLATE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for DEPENDENCY_STATE
INFO    [Thread-1]      05 Feb 2019 15:48:27 GMT Read 130, Loaded 130 rows for SCHEDULING_ENTITY
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 22511, Loaded 22511 rows for HIERARCHY_INSTANCE
INFO    [Thread-0]      05 Feb 2019 15:48:27 GMT Read 0, Loaded 0 rows for TRIGGER_STATE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 60, Loaded 60 rows for INTERVALL
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for USER_EQUIV
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for EXIT_STATE_TRANS_PROFILE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for CALENDAR
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 128, Loaded 128 rows for DEPENDENCY_INSTANCE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 3, Loaded 3 rows for EXIT_STATE_MAPPING
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 1, Loaded 1 rows for EXIT_STATE_PROFILE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 4, Loaded 4 rows for USERS
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for NICE_PROFILE_ENTRY
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 3, Loaded 3 rows for EXIT_STATE_DEFINITION
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 8, Loaded 8 rows for ENVIRONMENT
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for RESOURCE_REQ_STATES
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for NICE_PROFILE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 1, Loaded 1 rows for EXIT_STATE_MAPPING_PROFILE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 8, Loaded 8 rows for NAMED_ENVIRONMENT
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for PARAMETER_DEFINITION
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 7, Loaded 7 rows for INTERVAL_HIERARCHY
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 6, Loaded 6 rows for MEMBER
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for RESOURCE_STATE_MAPPING
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 11, Loaded 11 rows for NAMED_RESOURCE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for ENTITY_VARIABLE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for OBJECT_COMMENT
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 48, Loaded 48 rows for SCOPE_CONFIG
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for RESOURCE_VARIABLE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for TEMPLATE_VARIABLE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for RESOURCE_ALLOCATION
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for IGNORED_DEPENDENCY
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for RESOURCE_STATE_DEFINITION
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 28, Loaded 28 rows for SME_COUNTER
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for SUBMITTED_ENTITY_STATS
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for VERSIONED_EXTENTS
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for EXIT_STATE_TRANSLATION
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for SCOPE_CONFIG_ENVMAPPING
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 3, Loaded 3 rows for EXIT_STATE
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for FOOTPRINT
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 0, Loaded 0 rows for EVENT_PARAMETER
INFO    [Thread-0]      05 Feb 2019 15:48:28 GMT Read 8, Loaded 8 rows for RESSOURCE
INFO    [Thread-1]      05 Feb 2019 15:48:30 GMT Read 44894, Loaded 44894 rows for SUBMITTED_ENTITY
INFO    [main]          05 Feb 2019 15:48:30 GMT Initializing System Threads
ERROR   [main]          05 Feb 2019 15:48:31 GMT SQLerror on updating the VersionCounter:
SQL Error : Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
ERROR   [main]          05 Feb 2019 15:48:31 GMT ****************** Start Stacktrace *********************
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.repository.TxCounter.getNextQuantum(SDMSTransaction.java:546)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.repository.TxCounter.<init>(SDMSTransaction.java:453)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.repository.SDMSTransaction.<init>(SDMSTransaction.java:89)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.DBCleanupThread.initDBCleanupThread(DBCleanupThread.java:203)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.Server.initDBCleanupThread(Server.java:126)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.Server.serverMain(Server.java:482)
ERROR   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)
ERROR   [main]          05 Feb 2019 15:48:31 GMT ****************** End Stacktrace   *********************
FATAL   [main]          05 Feb 2019 15:48:31 GMT Fatal exception while initializing System Threads:
SQLerror on updating the VersionCounter:
SQL Error : Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
FATAL   [main]          05 Feb 2019 15:48:31 GMT ****************** Start Stacktrace *********************
FATAL   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)
FATAL   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.server.Server.serverMain(Server.java:486)
FATAL   [main]          05 Feb 2019 15:48:31 GMT de.independit.scheduler.BICServer.main(BICServer.java:144)
FATAL   [main]          05 Feb 2019 15:48:31 GMT ****************** End Stacktrace   *********************
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT ***********************************************
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT **                                           **
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT ** U N G R A C E F U L   S H U T D O W N ! ! **
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT **                                           **
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT ***********************************************
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT Release repository lock from 1549381700104
INFO    [Shutdown]      05 Feb 2019 15:48:31 GMT Shutdown completed
[scrolllog] Waiting for child (6724) to terminate
[scrolllog] Child exited with state 1
[scrolllog] Try to restart child (child terminated with exit code <> 0)


********************************************************************************************************************************************************************************
END
********************************************************************************************************************************************************************************

Pablo Maldonado

Dieter Stubler

unread,
Feb 5, 2019, 12:33:59 PM2/5/19
to schedulix
Hi Pablo,

Doing some research, I found this:


Since it is crucial for a save database processing to have multistatement transactions, all schedulix tables use the Innodb engine.
So using BINLOG_FORMAT = STATEMENT isn't supported. Change this to ROW or MIXED depending on your preferences.

Regards
Dieter

Pablo Maldonado

unread,
Feb 5, 2019, 1:06:35 PM2/5/19
to schedulix
Hi Dieter,

You are absolutely right, make the change and upload the server without any problem.

Thank you

Pablo Maldonado
Reply all
Reply to author
Forward
0 new messages