MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Apr 26 14:22:10 2023 ---------------------------------------------------------------------------- 2023-04-26 14:22:10 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2023-04-26 14:22:10 notice : Using up to 586.92MiB of memory for query classifier cache 2023-04-26 14:22:10 notice : syslog logging is disabled. 2023-04-26 14:22:10 notice : maxlog logging is enabled. 2023-04-26 14:22:10 notice : Host: 'me1mspp' OS: Linux@5.4.0-146-generic, #163-Ubuntu SMP Fri Mar 17 18:26:02 UTC 2023, x86_64 with 2 processor cores (2.00 available). 2023-04-26 14:22:10 notice : Total main memory: 3.82GiB (3.82GiB usable). 2023-04-26 14:22:10 notice : MariaDB MaxScale 22.08.5 started (Commit: 640d4030d3c2cc1236283c299d81512fb2d8280e) 2023-04-26 14:22:10 notice : MaxScale is running in process 265139 2023-04-26 14:22:10 notice : Configuration file: /etc/maxscale.cnf 2023-04-26 14:22:10 notice : Log directory: /var/log/maxscale 2023-04-26 14:22:10 notice : Data directory: /var/lib/maxscale 2023-04-26 14:22:10 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2023-04-26 14:22:10 notice : Service cache: /var/cache/maxscale 2023-04-26 14:22:10 notice : Working directory: /var/log/maxscale 2023-04-26 14:22:10 notice : Module 'qc_sqlite' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so'. 2023-04-26 14:22:10 notice : Query classification results are cached and reused. Memory used per thread: 293.46MiB 2023-04-26 14:22:10 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2023-04-26 14:22:10 notice : MaxScale started with 2 worker threads. 2023-04-26 14:22:10 notice : /etc/maxscale.cnf.d does not exist, not reading. 2023-04-26 14:22:10 notice : Module 'mariadbmon' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so'. 2023-04-26 14:22:10 notice : Module 'readwritesplit' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so'. 2023-04-26 14:22:10 notice : Using HS256 for JWT signatures 2023-04-26 14:22:10 notice : Started REST API on [0.0.0.0]:8989 2023-04-26 14:22:10 warning: Discarding journal file '/var/lib/maxscale/repl-monitor_journal.json'. File is for MaxScale version 230201. Current MaxScale version is 220805. 2023-04-26 14:22:10 notice : 'me1db1pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:22:10 notice : 'me1db2pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:22:10 notice : Server 'me1db1pp' charset: utf8mb4_general_ci 2023-04-26 14:22:10 notice : Server 'me1db2pp' charset: utf8mb4_general_ci 2023-04-26 14:22:10 notice : [mariadbmon] Selecting new master server. 2023-04-26 14:22:10 notice : [mariadbmon] Setting 'me1db1pp' as master. 2023-04-26 14:22:10 notice : Server changed state: me1db1pp[192.168.152.11:3306]: master_up. [Down] -> [Master, Running] 2023-04-26 14:22:10 notice : Server changed state: me1db2pp[192.168.152.12:3306]: slave_up. [Down] -> [Slave, Running] 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: % Total % Received % Xferd Average Speed Time Time Time Current 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: Dload Upload Total Spent Left Speed 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 418 100 2 100 416 6 1316 --:--:-- --:--:-- --:--:-- 1318 100 418 100 2 100 416 6 1316 --:--:-- --:--:-- --:--:-- 1318 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: ok 2023-04-26 14:22:10 notice : Executed monitor script for event 'master_up' on me1db1pp. Script was: '/usr/local/bin/ms_monitor_alert --initiator=[192.168.152.11]:3306 --parent= --children=[192.168.152.12]:3306 --event=master_up --node_list=[192.168.152.11]:3306,[192.168.152.12]:3306 --list=[192.168.152.11]:3306,[192.168.152.12]:3306 --master_list=[192.168.152.11]:3306 --slave_list=[192.168.152.12]:3306 --synced_list=' 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: % Total % Received % Xferd Average Speed Time Time Time Current 2023-04-26 14:22:10 notice : /usr/local/bin/ms_monitor_alert: Dload Upload Total Spent Left Speed 2023-04-26 14:22:11 notice : /usr/local/bin/ms_monitor_alert: 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 417 100 2 100 415 7 1461 --:--:-- --:--:-- --:--:-- 1468 2023-04-26 14:22:11 notice : /usr/local/bin/ms_monitor_alert: ok 2023-04-26 14:22:11 notice : Executed monitor script for event 'slave_up' on me1db2pp. Script was: '/usr/local/bin/ms_monitor_alert --initiator=[192.168.152.12]:3306 --parent=[192.168.152.11]:3306 --children= --event=slave_up --node_list=[192.168.152.11]:3306,[192.168.152.12]:3306 --list=[192.168.152.11]:3306,[192.168.152.12]:3306 --master_list=[192.168.152.11]:3306 --slave_list=[192.168.152.12]:3306 --synced_list=' 2023-04-26 14:22:11 notice : Starting a total of 1 services... 2023-04-26 14:22:11 notice : (split-router-listener); Listening for connections at [::]:3306 2023-04-26 14:22:11 notice : Service 'split-router' started (1/1) 2023-04-26 14:22:11 notice : Read 85 user@host entries from 'me1db1pp' for service 'split-router'. 2023-04-26 14:22:14 warning: (10) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,?,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (1447118,'SEMIDISPATCHCAPS','KSFPROJT_SEMIDISPATCHCAPS2_20230424_0000000382497707.CSV',3,'PROCESSING',382497707,'SEMIDISPATCHCAPS','KSFPROJT')'. 2023-04-26 14:22:45 warning: (24) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,?,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (1447119,'SEMIDISPATCHCAPS','KSFPROJT_SEMIDISPATCHCAPS2_20230424_0000000382497714.CSV',2,'PROCESSING',382497714,'SEMIDISPATCHCAPS','KSFPROJT')'. 2023-04-26 14:22:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_REQUEST set STATUS = ? , STATUS_DATE = str_to_date(?,?) where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = ?) and STATUS not in (?)' created from the statement 'update PDR_MANIFEST_REQUEST set STATUS = 'TIMEOUT' , STATUS_DATE = str_to_date('2023/04/26 14:22:58','%Y/%m/%d %H:%i:%s.%f') where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = 'TIMEOUT') and STATUS not in ('TIMEOUT')'. 2023-04-26 14:22:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:22:58','%Y/%m/%d %H:%i:%s.%f') where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != 'ABANDONED''. 2023-04-26 14:22:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REJECTION_COUNT >= ? and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:22:58','%Y/%m/%d %H:%i:%s.%f') where REJECTION_COUNT >= 10 and STATUS != 'ABANDONED''. 2023-04-26 14:23:02 warning: (9) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_REQUEST set STATUS = ? , STATUS_DATE = str_to_date(?,?) where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = ?) and STATUS not in (?)' created from the statement 'update PDR_MANIFEST_REQUEST set STATUS = 'TIMEOUT' , STATUS_DATE = str_to_date('2023/04/26 14:23:02','%Y/%m/%d %H:%i:%s.%f') where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = 'TIMEOUT') and STATUS not in ('TIMEOUT')'. 2023-04-26 14:23:02 warning: (9) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:23:02','%Y/%m/%d %H:%i:%s.%f') where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != 'ABANDONED''. 2023-04-26 14:23:02 warning: (9) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REJECTION_COUNT >= ? and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:23:02','%Y/%m/%d %H:%i:%s.%f') where REJECTION_COUNT >= 10 and STATUS != 'ABANDONED''. 2023-04-26 14:23:07 warning: (138) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('SMCSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:23:08 warning: (144) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in (?) order by INTERVAL_DATETIME desc limit ?' created from the statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in ('SMCSF1') order by INTERVAL_DATETIME desc limit 1'. 2023-04-26 14:23:08 warning: (149) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in (?) order by INTERVAL_DATETIME desc limit ?' created from the statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in ('KIAMSF1') order by INTERVAL_DATETIME desc limit 1'. 2023-04-26 14:24:00 warning: (263) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from optimiser_5ms_states where optimiser_5ms_run_id in (?) order by id asc' created from the statement 'select * from optimiser_5ms_states where optimiser_5ms_run_id in (41915) order by id asc'. 2023-04-26 14:24:07 warning: (277) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('KIAMSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:26:01 warning: Timing out 'kiamal_app'@'::ffff:192.168.152.9', idle for 121 seconds 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES (?, ?, ?, ?, ?, ?, ?, 4.18e0, 4.104e0, -44.87e0, ?, 4.89e0, 0.69e0, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES ('2023-04-26 14:26:24', 'KIAMSF1', 'VIC1', '2023-04-26 14:30:00', 'AUTOMATIC', 'MAX', '1.1.1', 4.18e0, 4.104e0, -44.87e0, 2, 4.89e0, 0.69e0, 'MAX', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-44.70 FOR THE NEXT 2 DISPATCH INTERVALS', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-44.70 >= $-60.00', 'BREAK_EVEN_PRICE_AUD: -60.0\nCURRENT_MODE: AUTOMATIC\nCURRENT_STRATEGY: MAX\nDISPATCH_INTERVAL_0: \'2023-04-26 14:25:00\'\nDISPATCH_INTERVAL_1: \'2023-04-26 14:30:00\'\nDISPATCH_INTERVAL_2: \'2023-04-26 14:35:00\'\nDISPATCH_INTERVAL_3: \'2023-04-26 14:40:00\'\nDI_CLEARED_SUPPLY_0:\n NSW1: 6928.31\n QLD1: 6005.18\n SA1: 1038.52\n TAS1: 1059.95\n VIC1: 4045.03\nDI_CLEARED_SUPPLY_1:\n NSW1: 6945.24\n QLD1: 6038.99\n SA1: 899.21\n TAS1: 1057.16\n VIC1: 4109.01\nDI_CLEARED_SUPPLY_2:\n NSW1: 6944.72\n QLD1: 6066.36\n SA1: 925.07\n TAS1: 1045.82\n VIC1: 4115.45\nDI_CLEARED_SUPPLY_3:\n NSW1: 6945.06\n QLD1: 6124.69\n SA1: 932.33\n TAS1: 1053.93\n VIC1: 4129.73\nDI_ENERGY: 4.104\nDI_FCAS_COSTS_0: 1.03\nDI_FCAS_COSTS_1: 0.998\nDI_FCAS_COSTS_2: 0.0\nDI_FCAS_COSTS_3: 0.0\nDI_GENERATION_MW: 48.9\nDI_GENERATION_MW_0: 51.418\nDI_GENERATION_MW_1: 48.9\nDI_GENERATION_MW_2: 47.428\nDI_GENERATION_MW_3: 45.849\nDI_MII_STATUS: NOT_MII\nDI_OCD_STATUS: NOT_OCD\nDI_R5M_RRP: 0.69\nDI_R5M_RRP_0: 0.68\nDI_R5M_RRP_1: 0.69\nDI_R5M_RRP_2: 0.8\nDI_R5M_RRP_3: 0.8\nDI_R60S_RRP: 4.89\nDI_R60S_RRP_0: 4.89\nDI_R60S_RRP_1: 4.89\nDI_R60S_RRP_2: 4.89\nDI_R60S_RRP_3: 4.89\nDI_R6S_RRP: 2\nDI_R6S_RRP_0: 1.96\nDI_R6S_RRP_1: 2\nDI_R6S_RRP_2: 2\nDI_R6S_RRP_3: 2\nDI_RRP: -44.87\nDI_RRP_0: -50.01\nDI_RRP_1: -44.87\nDI_RRP_2: -44.87\nDI_RRP_3: -44.17\nDI_UNCONSTRAINED_ENERGY_ESTIMATE: 4.18\nDUID: KIAMSF1\nGEN_DI_ENERGY_MAX_0: 4.258\nGEN_DI_ENERGY_MAX_1: 4.104\nGEN_DI_ENERGY_MAX_2: 3.908\nGEN_DI_ENERGY_MAX_3: 3.887\nGEN_DI_ENERGY_SPLIT_0: 4.258\nGEN_DI_ENERGY_SPLIT_1: 4.104\nGEN_DI_ENERGY_SPLIT_2: 3.908\nGEN_DI_ENERGY_SPLIT_3: 3.887\nGEN_DI_ENERGY_ZERO_0: 4.258\nGEN_DI_ENERGY_ZERO_1: 4.104\nGEN_DI_ENERGY_ZERO_2: 1.932\nGEN_DI_ENERGY_ZERO_3: 0.0\nGEN_DI_GEN_REVENUE_MAX_0: -187.867\nGEN_DI_GEN_REVENUE_MAX_1: -162.575\nGEN_DI_GEN_REVENUE_MAX_2: -153.859\nGEN_DI_GEN_REVENUE_MAX_3: -150.664\nGEN_DI_GEN_REVENUE_SPLIT_0: -187.867\nGEN_DI_GEN_REVENUE_SPLIT_1: -162.575\nGEN_DI_GEN_REVENUE_SPLIT_2: -153.859\nGEN_DI_GEN_REVENUE_SPLIT_3: -150.664\nGEN_DI_GEN_REVENUE_ZERO_0: -187.867\nGEN_DI_GEN_REVENUE_ZERO_1: -162.575\nGEN_DI_GEN_REVENUE_ZERO_2: -76.055\nGEN_DI_GEN_REVENUE_ZERO_3: -0.0\nGEN_DI_OP_REVENUE_MAX_0: 0.0\nGEN_DI_OP_REVENUE_MAX_1: 0.0\nGEN_DI_OP_REVENUE_MAX_2: 0.0\nGEN_DI_OP_REVENUE_MAX_3: 0.0\nGEN_DI_OP_REVENUE_SPLIT_0: 0.0\nGEN_DI_OP_REVENUE_SPLIT_1: 0.0\nGEN_DI_OP_REVENUE_SPLIT_2: 0.0\nGEN_DI_OP_REVENUE_SPLIT_3: 0.0\nGEN_DI_OP_REVENUE_ZERO_0: 0.0\nGEN_DI_OP_REVENUE_ZERO_1: 0.0\nGEN_DI_OP_REVENUE_ZERO_2: 0.0\nGEN_DI_OP_REVENUE_ZERO_3: 0.0\nGEN_DI_OTHER_REVENUE_MAX_0: 0.0\nGEN_DI_OTHER_REVENUE_MAX_1: 0.0\nGEN_DI_OTHER_REVENUE_MAX_2: 0.0\nGEN_DI_OTHER_REVENUE_MAX_3: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_0: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_1: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_2: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_3: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_0: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_1: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_2: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_3: 0.0\nGEN_DI_POOL_REVENUE_MAX_0: -186.837\nGEN_DI_POOL_REVENUE_MAX_1: -161.577\nGEN_DI_POOL_REVENUE_MAX_2: -153.859\nGEN_DI_POOL_REVENUE_MAX_3: -150.664\nGEN_DI_POOL_REVENUE_SPLIT_0: -186.837\nGEN_DI_POOL_REVENUE_SPLIT_1: -161.577\nGEN_DI_POOL_REVENUE_SPLIT_2: -153.859\nGEN_DI_POOL_REVENUE_SPLIT_3: -150.664\nGEN_DI_POOL_REVENUE_ZERO_0: -186.837\nGEN_DI_POOL_REVENUE_ZERO_1: -161.577\nGEN_DI_POOL_REVENUE_ZERO_2: -76.055\nGEN_DI_POOL_REVENUE_ZERO_3: -0.0\nGEN_DI_PPA_REVENUE_MAX_0: 0.0\nGEN_DI_PPA_REVENUE_MAX_1: 0.0\nGEN_DI_PPA_REVENUE_MAX_2: 0.0\nGEN_DI_PPA_REVENUE_MAX_3: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_0: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_1: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_2: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_3: 0.0\nGEN_DI_PPA_REVENUE_ZERO_0: 0.0\nGEN_DI_PPA_REVENUE_ZERO_1: 0.0\nGEN_DI_PPA_REVENUE_ZERO_2: 0.0\nGEN_DI_PPA_REVENUE_ZERO_3: 0.0\nGEN_DI_RRN_ENERGY_MAX_0: 3.736\nGEN_DI_RRN_ENERGY_MAX_1: 3.601\nGEN_DI_RRN_ENERGY_MAX_2: 3.429\nGEN_DI_RRN_ENERGY_MAX_3: 3.411\nGEN_DI_RRN_ENERGY_SPLIT_0: 3.736\nGEN_DI_RRN_ENERGY_SPLIT_1: 3.601\nGEN_DI_RRN_ENERGY_SPLIT_2: 3.429\nGEN_DI_RRN_ENERGY_SPLIT_3: 3.411\nGEN_DI_RRN_ENERGY_ZERO_0: 3.736\nGEN_DI_RRN_ENERGY_ZERO_1: 3.601\nGEN_DI_RRN_ENERGY_ZERO_2: 1.695\nGEN_DI_RRN_ENERGY_ZERO_3: 0.0\nGEN_TOTAL_RATIO: 100.0\nLGC_PRICE: 52.5\nLOSS_FACTOR: 0.8775\nP5MIN_RRPS_KEY:\n- -44.87\n- -44.87\n- -44.17\n- -40.93\n- -40.93\n- -35.013\n- -34.37\n- -20\n- -20\n- -19.11\n- -2.54\n- -6.09\nP5MIN_STRATEGIES_KEY:\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\nP5MIN_WEIGHTED_RRPS_KEY:\n- -44.695\n- -43.535\n- -41.74\n- -39.451\n- -36.331\n- -30.938\n- -23.593\n- -19.777\n- -15.19\n- -7.57\n- -4.907\nPPA_COUNT: 0\nPPA_TOTAL_RATIO: 0.0\nPPA_WEIGHTED_PRICE: 0.0\nPREVIOUS_DI_ENERGY: 4.258\nREGIONID: VIC1\n')'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 51.418e0, -50.01e0, 1.96e0, 4.89e0, 0.68e0, 1.03e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41916, '2023-04-26 14:30:00', 0, 51.418e0, -50.01e0, 1.96e0, 4.89e0, 0.68e0, 1.03e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -186.837e0, 0.0e0, 0.0e0, -187.867e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185693, 'MAX', -186.837e0, 0.0e0, 0.0e0, -187.867e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 48.9e0, -44.87e0, ?, 4.89e0, 0.69e0, 0.998e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41916, '2023-04-26 14:30:00', 1, 48.9e0, -44.87e0, 2, 4.89e0, 0.69e0, 0.998e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -161.577e0, 0.0e0, 0.0e0, -162.575e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185694, 'MAX', -161.577e0, 0.0e0, 0.0e0, -162.575e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 47.428e0, -44.87e0, ?, 4.89e0, 0.8e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41916, '2023-04-26 14:30:00', 2, 47.428e0, -44.87e0, 2, 4.89e0, 0.8e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -153.859e0, 0.0e0, 0.0e0, -153.859e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185695, 'MAX', -153.859e0, 0.0e0, 0.0e0, -153.859e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -76.055e0, 0.0e0, 0.0e0, -76.055e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185695, 'ZERO', -76.055e0, 0.0e0, 0.0e0, -76.055e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 45.849e0, -44.17e0, ?, 4.89e0, 0.8e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41916, '2023-04-26 14:30:00', 3, 45.849e0, -44.17e0, 2, 4.89e0, 0.8e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -150.664e0, 0.0e0, 0.0e0, -150.664e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185696, 'MAX', -150.664e0, 0.0e0, 0.0e0, -150.664e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (637) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185696, 'ZERO', -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)'. 2023-04-26 14:26:24 warning: (616) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES ('MAX', '2023-04-26 14:26:24', 'AUTOBIDDER_5MS', '2023-04-26 14:35:00', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-44.70 FOR THE NEXT 2 DISPATCH INTERVALS', 'A', '14:26:24', '14:26:24', '14:26:24', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-44.70 >= $-60.00')'. 2023-04-26 14:26:24 warning: (616) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?)' created from the statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((35997), '2023-04-26 14:35:00', 'MAX'),((35997), '2023-04-26 14:40:00', 'MAX'),((35997), '2023-04-26 14:45:00', 'MAX'),((35997), '2023-04-26 14:50:00', 'MAX'),((35997), '2023-04-26 14:55:00', 'MAX'),((35997), '2023-04-26 15:00:00', 'MAX'),((35997), '2023-04-26 15:05:00', 'MAX'),((35997), '2023-04-26 15:10:00', 'MAX'),((35997), '2023-04-26 15:15:00', 'MAX'),((35997), '2023-04-26 15:20:00', 'MAX'),((35997), '2023-04-26 15:25:00', 'MAX')'. 2023-04-26 14:26:24 warning: (633) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES (?, ?, ?, ?)' created from the statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES ('2023-04-26 14:26:24.934777', 'INFO', 'AUTO BIDDER', 'EXPLANATION: for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-44.70 >= $-60.00')'. 2023-04-26 14:26:24 warning: (616) [qc_sqlite] The function '-' is not found in the canonical statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`=?, `updatedAt`=?, `strategyId`=?, `energyMWh`=?, `generatorRevenue`=?, `offtakerRevenue`=?, `poolRevenue`=?, `PPARevenue`=?, `otherRevenue`=? WHERE `STRATEGY_REVENUE`.`dispatchInterval` = ? AND `STRATEGY_REVENUE`.`strategyId` = ?' created from the statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`='2023-04-26 14:25:00', `updatedAt`='2023-04-26 14:26:24.961516', `strategyId`='MAX', `energyMWh`=4.258, `generatorRevenue`=-188, `offtakerRevenue`=0, `poolRevenue`=-187, `PPARevenue`=0, `otherRevenue`=0 WHERE `STRATEGY_REVENUE`.`dispatchInterval` = '2023-04-26 14:25:00' AND `STRATEGY_REVENUE`.`strategyId` = 'MAX''. (subsequent similar messages suppressed for 10000 milliseconds) 2023-04-26 14:27:44 warning: Timing out 'sunmetals_app'@'::ffff:192.168.152.40', idle for 121 seconds 2023-04-26 14:27:48 warning: Timing out 'sunmetals_app'@'::ffff:192.168.152.40', idle for 121 seconds 2023-04-26 14:28:08 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'delete from PDR_MANIFEST_LOG where STATUS != ? and exists ( select ? from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.EVENT_QUEUE_ID = t2.EVENT_QUEUE_ID and PDR_MANIFEST_LOG.FILE_ID = t2.FILE_ID and PDR_MANIFEST_LOG.CONFIDENTIALITY = t2.CONFIDENTIALITY) and t2.FILE_PROCESS_STATUS = ?)' created from the statement 'delete from PDR_MANIFEST_LOG where STATUS != 'MISSING' and exists ( select 1 from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.EVENT_QUEUE_ID = t2.EVENT_QUEUE_ID and PDR_MANIFEST_LOG.FILE_ID = t2.FILE_ID and PDR_MANIFEST_LOG.CONFIDENTIALITY = t2.CONFIDENTIALITY) and t2.FILE_PROCESS_STATUS = 'SUCCESS')'. 2023-04-26 14:28:08 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'delete from PDR_MANIFEST_LOG where STATUS != ? and exists ( select ? from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.FILENAME = t2.FILENAME and t2.FILE_PROCESS_RECORDS > ?) and t2.FILE_PROCESS_STATUS = ?)' created from the statement 'delete from PDR_MANIFEST_LOG where STATUS != 'MISSING' and exists ( select 1 from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.FILENAME = t2.FILENAME and t2.FILE_PROCESS_RECORDS > 0) and t2.FILE_PROCESS_STATUS = 'SUCCESS')'. 2023-04-26 14:28:08 warning: (5) [qc_sqlite] The function 'isnull' is not found in the canonical statement 'update PDR_MANIFEST_LOG set REQUEST_LIMIT = ? where REQUEST_LIMIT is NULL' created from the statement 'update PDR_MANIFEST_LOG set REQUEST_LIMIT = 5 where REQUEST_LIMIT is NULL'. 2023-04-26 14:28:08 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_REQUEST_LOG set STATUS = ? ,STATUS_DATE = NOW() where STATUS = ? and not exists ( select ? from PDR_MANIFEST_LOG t2 where PDR_REQUEST_LOG.PDR_REQUEST_ID = t2.MANIFEST_REQUEST_ID and t2.STATUS != ?)' created from the statement 'update PDR_REQUEST_LOG set STATUS = 'SUCCESS' ,STATUS_DATE = NOW() where STATUS = 'RECONCILE' and not exists ( select 1 from PDR_MANIFEST_LOG t2 where PDR_REQUEST_LOG.PDR_REQUEST_ID = t2.MANIFEST_REQUEST_ID and t2.STATUS != 'ABANDONED')'. 2023-04-26 14:28:18 warning: (24) [qc_sqlite] The function '=' is not found in the canonical statement 'insert into PDR_REQUEST_LOG (PDR_REQUEST_ID,FILENAME,REQUEST_TYPE,REQUEST_DATE,STATUS,STATUS_DATE) values (?,?,?,str_to_date(?,?),?,str_to_date(?,?))' created from the statement 'insert into PDR_REQUEST_LOG (PDR_REQUEST_ID,FILENAME,REQUEST_TYPE,REQUEST_DATE,STATUS,STATUS_DATE) values (77866,'KSFPROJT_ARCHIVE_REPORTS_20230426142818_77866_KIAMAL-PDR-PP_REQ.CSV','ARCHIVE',str_to_date('2023/04/26 14:28:18','%Y/%m/%d %H:%i:%s.%f'),'REQUESTED',str_to_date('2023/04/26 14:28:18','%Y/%m/%d %H:%i:%s.%f'))'. 2023-04-26 14:28:26 warning: Timing out 'kiamal_app'@'::ffff:192.168.152.9', idle for 121 seconds 2023-04-26 14:28:33 notice : MaxScale is shutting down. 2023-04-26 14:28:33 notice : Stopped MaxScale REST API 2023-04-26 14:28:33 notice : All workers have shut down. 2023-04-26 14:28:33 notice : MaxScale shutdown completed. 2023-04-26 14:28:33 notice : MaxScale received signal SIGTERM. Exiting. 2023-04-26 14:28:33 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Apr 26 14:28:33 2023 ---------------------------------------------------------------------------- 2023-04-26 14:28:33 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2023-04-26 14:28:33 notice : Using up to 586.92MiB of memory for query classifier cache 2023-04-26 14:28:33 notice : syslog logging is disabled. 2023-04-26 14:28:33 notice : maxlog logging is enabled. 2023-04-26 14:28:33 notice : Host: 'me1mspp' OS: Linux@5.4.0-146-generic, #163-Ubuntu SMP Fri Mar 17 18:26:02 UTC 2023, x86_64 with 2 processor cores (2.00 available). 2023-04-26 14:28:33 notice : Total main memory: 3.82GiB (3.82GiB usable). 2023-04-26 14:28:33 notice : MariaDB MaxScale 22.08.5 started (Commit: 640d4030d3c2cc1236283c299d81512fb2d8280e) 2023-04-26 14:28:33 notice : MaxScale is running in process 265522 2023-04-26 14:28:33 notice : Configuration file: /etc/maxscale.cnf 2023-04-26 14:28:33 notice : Log directory: /var/log/maxscale 2023-04-26 14:28:33 notice : Data directory: /var/lib/maxscale 2023-04-26 14:28:33 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2023-04-26 14:28:33 notice : Service cache: /var/cache/maxscale 2023-04-26 14:28:33 notice : Working directory: /var/log/maxscale 2023-04-26 14:28:33 notice : Module 'qc_sqlite' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so'. 2023-04-26 14:28:33 notice : Query classification results are cached and reused. Memory used per thread: 293.46MiB 2023-04-26 14:28:33 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2023-04-26 14:28:33 notice : MaxScale started with 2 worker threads. 2023-04-26 14:28:33 notice : /etc/maxscale.cnf.d does not exist, not reading. 2023-04-26 14:28:33 notice : Module 'mariadbmon' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so'. 2023-04-26 14:28:33 notice : Module 'readwritesplit' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so'. 2023-04-26 14:28:33 notice : Using HS256 for JWT signatures 2023-04-26 14:28:33 notice : Started REST API on [0.0.0.0]:8989 2023-04-26 14:28:33 notice : 'me1db1pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:28:33 notice : 'me1db2pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:28:33 notice : Server 'me1db1pp' charset: utf8mb4_general_ci 2023-04-26 14:28:33 notice : Server 'me1db2pp' charset: utf8mb4_general_ci 2023-04-26 14:28:33 notice : Starting a total of 1 services... 2023-04-26 14:28:33 notice : (split-router-listener); Listening for connections at [::]:3306 2023-04-26 14:28:33 notice : Service 'split-router' started (1/1) 2023-04-26 14:28:34 notice : Read 85 user@host entries from 'me1db1pp' for service 'split-router'. 2023-04-26 14:28:39 warning: (6) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,?,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (1471802,'DISPATCHIS','MWARRA_DISPATCHIS_202304261425_0000000382518555_LEGACY.CSV',2,'PROCESSING',382518555,'DISPATCHIS_LEGACY','MWARRA')'. 2023-04-26 14:28:42 warning: (7) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,?,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (585518,'DISPATCHIS','SMCTSV_DISPATCHIS_202304261425_0000000382518555_LEGACY.CSV',1,'PROCESSING',382518555,'DISPATCHIS_LEGACY','SMCTSV')'. 2023-04-26 14:29:00 warning: (71) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from optimiser_5ms_states where optimiser_5ms_run_id in (?) order by id asc' created from the statement 'select * from optimiser_5ms_states where optimiser_5ms_run_id in (41916) order by id asc'. 2023-04-26 14:29:07 warning: (92) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('KIAMSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:29:07 warning: (94) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO `scada_signals` (`dispatch_mw_flag`, `settlement_date`, `signal_at`, `dispatch_mw`, `duid`) VALUES(?, ?, ?, ?, ?)' created from the statement 'INSERT INTO `scada_signals` (`dispatch_mw_flag`, `settlement_date`, `signal_at`, `dispatch_mw`, `duid`) VALUES(1, '2023-04-26 14:30:00', '2023-04-26 14:29:07', '48.145', 'KIAMSF1')'. 2023-04-26 14:29:08 warning: (99) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in (?) order by INTERVAL_DATETIME desc limit ?' created from the statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in ('SMCSF1') order by INTERVAL_DATETIME desc limit 1'. 2023-04-26 14:29:11 warning: (112) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO `service_alert_events` (`set_value`, `reset_value`, `no_activations_to_set`, `event_value`, `message`, `no_activations_to_reset`, `escalation_delta`, `sms_list`, `service_alert_user_id`, `is_set`, `event_activated_at`, `user_name`, `user_id`, `email_list`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' created from the statement 'INSERT INTO `service_alert_events` (`set_value`, `reset_value`, `no_activations_to_set`, `event_value`, `message`, `no_activations_to_reset`, `escalation_delta`, `sms_list`, `service_alert_user_id`, `is_set`, `event_activated_at`, `user_name`, `user_id`, `email_list`) VALUES('1', '0', 1, 1, 'AEMO has issued a dispatch instruction to limit the output of KIAMSF1 to 48.1 MW for the dispatch interval ending 14:30\n\nThis alert was activated at 2023-04-26 14:29:07', 1, '', '', 3, 0, '2023-04-26 14:29:07', 'harley mackenzie', 1, 'harley@fastmail.fm')'. 2023-04-26 14:29:25 warning: (3) [qc_sqlite] The function 'isnotnull' is not found in the canonical statement 'select max(mr.MANIFEST_END_DATETIME) from PDR_MANIFEST_REQUEST mr where mr.MARKET = ? and mr.STATUS in (?,?) and mr.MANIFEST_END_DATETIME is NOT NULL' created from the statement 'select max(mr.MANIFEST_END_DATETIME) from PDR_MANIFEST_REQUEST mr where mr.MARKET = 'NEM' and mr.STATUS in ('SUCCESS','ADJUSTED') and mr.MANIFEST_END_DATETIME is NOT NULL'. 2023-04-26 14:29:25 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_REQUEST set STATUS = ? , STATUS_DATE = str_to_date(?,?) where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = ?) and STATUS not in (?)' created from the statement 'update PDR_MANIFEST_REQUEST set STATUS = 'TIMEOUT' , STATUS_DATE = str_to_date('2023/04/26 14:29:24','%Y/%m/%d %H:%i:%s.%f') where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = 'TIMEOUT') and STATUS not in ('TIMEOUT')'. 2023-04-26 14:29:27 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:29:24','%Y/%m/%d %H:%i:%s.%f') where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != 'ABANDONED''. 2023-04-26 14:29:28 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REJECTION_COUNT >= ? and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:29:24','%Y/%m/%d %H:%i:%s.%f') where REJECTION_COUNT >= 10 and STATUS != 'ABANDONED''. 2023-04-26 14:29:30 warning: (3) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,NULL,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (1447161,'RESPONSE','KSFPROJT_ARCHIVE_REPORTS_20230426142818_77866_KIAMAL-PDR-PP_REQ_CPT.CSV',2,'PROCESSING',NULL,'RESPONSE','KSFPROJT')'. 2023-04-26 14:30:08 warning: (244) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('SMCSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:30:43 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'delete from PDR_MANIFEST_LOG where STATUS != ? and exists ( select ? from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.EVENT_QUEUE_ID = t2.EVENT_QUEUE_ID and PDR_MANIFEST_LOG.FILE_ID = t2.FILE_ID and PDR_MANIFEST_LOG.CONFIDENTIALITY = t2.CONFIDENTIALITY) and t2.FILE_PROCESS_STATUS = ?)' created from the statement 'delete from PDR_MANIFEST_LOG where STATUS != 'MISSING' and exists ( select 1 from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.EVENT_QUEUE_ID = t2.EVENT_QUEUE_ID and PDR_MANIFEST_LOG.FILE_ID = t2.FILE_ID and PDR_MANIFEST_LOG.CONFIDENTIALITY = t2.CONFIDENTIALITY) and t2.FILE_PROCESS_STATUS = 'SUCCESS')'. 2023-04-26 14:30:44 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'delete from PDR_MANIFEST_LOG where STATUS != ? and exists ( select ? from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.FILENAME = t2.FILENAME and t2.FILE_PROCESS_RECORDS > ?) and t2.FILE_PROCESS_STATUS = ?)' created from the statement 'delete from PDR_MANIFEST_LOG where STATUS != 'MISSING' and exists ( select 1 from PDR_REPORT_AUDIT t2 where (PDR_MANIFEST_LOG.FILENAME = t2.FILENAME and t2.FILE_PROCESS_RECORDS > 0) and t2.FILE_PROCESS_STATUS = 'SUCCESS')'. 2023-04-26 14:30:47 warning: (58) [qc_sqlite] The function 'isnull' is not found in the canonical statement 'update PDR_MANIFEST_LOG set REQUEST_LIMIT = ? where REQUEST_LIMIT is NULL' created from the statement 'update PDR_MANIFEST_LOG set REQUEST_LIMIT = 5 where REQUEST_LIMIT is NULL'. 2023-04-26 14:30:48 warning: (58) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_REQUEST_LOG set STATUS = ? ,STATUS_DATE = NOW() where STATUS = ? and not exists ( select ? from PDR_MANIFEST_LOG t2 where PDR_REQUEST_LOG.PDR_REQUEST_ID = t2.MANIFEST_REQUEST_ID and t2.STATUS != ?)' created from the statement 'update PDR_REQUEST_LOG set STATUS = 'SUCCESS' ,STATUS_DATE = NOW() where STATUS = 'RECONCILE' and not exists ( select 1 from PDR_MANIFEST_LOG t2 where PDR_REQUEST_LOG.PDR_REQUEST_ID = t2.MANIFEST_REQUEST_ID and t2.STATUS != 'ABANDONED')'. 2023-04-26 14:30:49 warning: (58) [qc_sqlite] The function '=' is not found in the canonical statement 'insert into PDR_REQUEST_LOG (PDR_REQUEST_ID,FILENAME,REQUEST_TYPE,REQUEST_DATE,STATUS,STATUS_DATE) values (?,?,?,str_to_date(?,?),?,str_to_date(?,?))' created from the statement 'insert into PDR_REQUEST_LOG (PDR_REQUEST_ID,FILENAME,REQUEST_TYPE,REQUEST_DATE,STATUS,STATUS_DATE) values (47140,'SMCTSV_ARCHIVE_REPORTS_20230426143048_47140_SUNMETALS-PDR-PP_REQ.CSV','ARCHIVE',str_to_date('2023/04/26 14:30:48','%Y/%m/%d %H:%i:%s.%f'),'REQUESTED',str_to_date('2023/04/26 14:30:48','%Y/%m/%d %H:%i:%s.%f'))'. 2023-04-26 14:31:01 warning: Timing out 'kiamal_app'@'::ffff:192.168.152.9', idle for 121 seconds 2023-04-26 14:31:08 warning: (385) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO `scada_signals` (`dispatch_mw_flag`, `settlement_date`, `signal_at`, `dispatch_mw`, `duid`) VALUES(?, ?, ?, ?, ?)' created from the statement 'INSERT INTO `scada_signals` (`dispatch_mw_flag`, `settlement_date`, `signal_at`, `dispatch_mw`, `duid`) VALUES(1, '2023-04-26 14:35:00', '2023-04-26 14:31:07', '47.223', 'KIAMSF1')'. 2023-04-26 14:31:08 warning: (390) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in (?) order by INTERVAL_DATETIME desc limit ?' created from the statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in ('SMCSF1') order by INTERVAL_DATETIME desc limit 1'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES (?, ?, ?, ?, ?, ?, ?, 4.083e0, 4.086e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES ('2023-04-26 14:31:14', 'KIAMSF1', 'VIC1', '2023-04-26 14:35:00', 'AUTOMATIC', 'MAX', '1.1.1', 4.083e0, 4.086e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, 'MAX', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-50.09 FOR THE NEXT 2 DISPATCH INTERVALS', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.09 >= $-60.00', 'BREAK_EVEN_PRICE_AUD: -60.0\nCURRENT_MODE: AUTOMATIC\nCURRENT_STRATEGY: MAX\nDISPATCH_INTERVAL_0: \'2023-04-26 14:30:00\'\nDISPATCH_INTERVAL_1: \'2023-04-26 14:35:00\'\nDISPATCH_INTERVAL_2: \'2023-04-26 14:40:00\'\nDISPATCH_INTERVAL_3: \'2023-04-26 14:45:00\'\nDI_CLEARED_SUPPLY_0:\n NSW1: 6945.24\n QLD1: 6038.99\n SA1: 899.21\n TAS1: 1057.16\n VIC1: 4109.01\nDI_CLEARED_SUPPLY_1:\n NSW1: 6990.63\n QLD1: 6116.94\n SA1: 897.81\n TAS1: 1061.0\n VIC1: 4051.89\nDI_CLEARED_SUPPLY_2:\n NSW1: 6996.06\n QLD1: 6179.53\n SA1: 913.28\n TAS1: 1069.13\n VIC1: 4042.53\nDI_CLEARED_SUPPLY_3:\n NSW1: 7006.64\n QLD1: 6242.61\n SA1: 916.16\n TAS1: 1075.06\n VIC1: 4082.29\nDI_ENERGY: 4.086\nDI_FCAS_COSTS_0: 0.997\nDI_FCAS_COSTS_1: 0.987\nDI_FCAS_COSTS_2: 0.0\nDI_FCAS_COSTS_3: 0.0\nDI_GENERATION_MW: 49.082\nDI_GENERATION_MW_0: 48.9\nDI_GENERATION_MW_1: 49.082\nDI_GENERATION_MW_2: 46.903\nDI_GENERATION_MW_3: 45.924\nDI_MII_STATUS: NOT_MII\nDI_OCD_STATUS: NOT_OCD\nDI_R5M_RRP: 0.68\nDI_R5M_RRP_0: 0.69\nDI_R5M_RRP_1: 0.68\nDI_R5M_RRP_2: 0.72\nDI_R5M_RRP_3: 0.72\nDI_R60S_RRP: 4.89\nDI_R60S_RRP_0: 4.89\nDI_R60S_RRP_1: 4.89\nDI_R60S_RRP_2: 4.89\nDI_R60S_RRP_3: 4.89\nDI_R6S_RRP: 1.96\nDI_R6S_RRP_0: 2\nDI_R6S_RRP_1: 1.96\nDI_R6S_RRP_2: 2.25\nDI_R6S_RRP_3: 2.25\nDI_RRP: -50.09\nDI_RRP_0: -44.87\nDI_RRP_1: -50.09\nDI_RRP_2: -50.09\nDI_RRP_3: -50.09\nDI_UNCONSTRAINED_ENERGY_ESTIMATE: 4.083\nDUID: KIAMSF1\nGEN_DI_ENERGY_MAX_0: 4.102\nGEN_DI_ENERGY_MAX_1: 4.086\nGEN_DI_ENERGY_MAX_2: 3.833\nGEN_DI_ENERGY_MAX_3: 3.868\nGEN_DI_ENERGY_SPLIT_0: 4.102\nGEN_DI_ENERGY_SPLIT_1: 4.086\nGEN_DI_ENERGY_SPLIT_2: 3.833\nGEN_DI_ENERGY_SPLIT_3: 3.868\nGEN_DI_ENERGY_ZERO_0: 4.102\nGEN_DI_ENERGY_ZERO_1: 4.086\nGEN_DI_ENERGY_ZERO_2: 1.879\nGEN_DI_ENERGY_ZERO_3: 0.0\nGEN_DI_GEN_REVENUE_MAX_0: -162.529\nGEN_DI_GEN_REVENUE_MAX_1: -180.56\nGEN_DI_GEN_REVENUE_MAX_2: -168.453\nGEN_DI_GEN_REVENUE_MAX_3: -170.005\nGEN_DI_GEN_REVENUE_SPLIT_0: -162.529\nGEN_DI_GEN_REVENUE_SPLIT_1: -180.56\nGEN_DI_GEN_REVENUE_SPLIT_2: -168.453\nGEN_DI_GEN_REVENUE_SPLIT_3: -170.005\nGEN_DI_GEN_REVENUE_ZERO_0: -162.529\nGEN_DI_GEN_REVENUE_ZERO_1: -180.56\nGEN_DI_GEN_REVENUE_ZERO_2: -82.598\nGEN_DI_GEN_REVENUE_ZERO_3: -0.0\nGEN_DI_OP_REVENUE_MAX_0: 0.0\nGEN_DI_OP_REVENUE_MAX_1: 0.0\nGEN_DI_OP_REVENUE_MAX_2: 0.0\nGEN_DI_OP_REVENUE_MAX_3: 0.0\nGEN_DI_OP_REVENUE_SPLIT_0: 0.0\nGEN_DI_OP_REVENUE_SPLIT_1: 0.0\nGEN_DI_OP_REVENUE_SPLIT_2: 0.0\nGEN_DI_OP_REVENUE_SPLIT_3: 0.0\nGEN_DI_OP_REVENUE_ZERO_0: 0.0\nGEN_DI_OP_REVENUE_ZERO_1: 0.0\nGEN_DI_OP_REVENUE_ZERO_2: 0.0\nGEN_DI_OP_REVENUE_ZERO_3: 0.0\nGEN_DI_OTHER_REVENUE_MAX_0: 0.0\nGEN_DI_OTHER_REVENUE_MAX_1: 0.0\nGEN_DI_OTHER_REVENUE_MAX_2: 0.0\nGEN_DI_OTHER_REVENUE_MAX_3: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_0: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_1: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_2: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_3: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_0: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_1: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_2: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_3: 0.0\nGEN_DI_POOL_REVENUE_MAX_0: -161.532\nGEN_DI_POOL_REVENUE_MAX_1: -179.573\nGEN_DI_POOL_REVENUE_MAX_2: -168.453\nGEN_DI_POOL_REVENUE_MAX_3: -170.005\nGEN_DI_POOL_REVENUE_SPLIT_0: -161.532\nGEN_DI_POOL_REVENUE_SPLIT_1: -179.573\nGEN_DI_POOL_REVENUE_SPLIT_2: -168.453\nGEN_DI_POOL_REVENUE_SPLIT_3: -170.005\nGEN_DI_POOL_REVENUE_ZERO_0: -161.532\nGEN_DI_POOL_REVENUE_ZERO_1: -179.573\nGEN_DI_POOL_REVENUE_ZERO_2: -82.598\nGEN_DI_POOL_REVENUE_ZERO_3: -0.0\nGEN_DI_PPA_REVENUE_MAX_0: 0.0\nGEN_DI_PPA_REVENUE_MAX_1: 0.0\nGEN_DI_PPA_REVENUE_MAX_2: 0.0\nGEN_DI_PPA_REVENUE_MAX_3: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_0: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_1: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_2: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_3: 0.0\nGEN_DI_PPA_REVENUE_ZERO_0: 0.0\nGEN_DI_PPA_REVENUE_ZERO_1: 0.0\nGEN_DI_PPA_REVENUE_ZERO_2: 0.0\nGEN_DI_PPA_REVENUE_ZERO_3: 0.0\nGEN_DI_RRN_ENERGY_MAX_0: 3.6\nGEN_DI_RRN_ENERGY_MAX_1: 3.585\nGEN_DI_RRN_ENERGY_MAX_2: 3.363\nGEN_DI_RRN_ENERGY_MAX_3: 3.394\nGEN_DI_RRN_ENERGY_SPLIT_0: 3.6\nGEN_DI_RRN_ENERGY_SPLIT_1: 3.585\nGEN_DI_RRN_ENERGY_SPLIT_2: 3.363\nGEN_DI_RRN_ENERGY_SPLIT_3: 3.394\nGEN_DI_RRN_ENERGY_ZERO_0: 3.6\nGEN_DI_RRN_ENERGY_ZERO_1: 3.585\nGEN_DI_RRN_ENERGY_ZERO_2: 1.649\nGEN_DI_RRN_ENERGY_ZERO_3: 0.0\nGEN_TOTAL_RATIO: 100.0\nLGC_PRICE: 52.5\nLOSS_FACTOR: 0.8775\nP5MIN_RRPS_KEY:\n- -50.09\n- -50.09\n- -50.09\n- -50.09\n- -50.01\n- -45.22\n- -44.17\n- -40.93\n- -21.72\n- -20\n- -20\n- -19.99\nP5MIN_STRATEGIES_KEY:\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\nP5MIN_WEIGHTED_RRPS_KEY:\n- -50.09\n- -50.09\n- -50.07\n- -48.833\n- -46.155\n- -43.623\n- -36.938\n- -26.093\n- -20.43\n- -19.997\n- -19.993\nPPA_COUNT: 0\nPPA_TOTAL_RATIO: 0.0\nPPA_WEIGHTED_PRICE: 0.0\nPREVIOUS_DI_ENERGY: 4.102\nREGIONID: VIC1\n')'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 48.9e0, -44.87e0, ?, 4.89e0, 0.69e0, 0.997e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41917, '2023-04-26 14:35:00', 0, 48.9e0, -44.87e0, 2, 4.89e0, 0.69e0, 0.997e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -161.532e0, 0.0e0, 0.0e0, -162.529e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185697, 'MAX', -161.532e0, 0.0e0, 0.0e0, -162.529e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 49.082e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, 0.987e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41917, '2023-04-26 14:35:00', 1, 49.082e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, 0.987e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -179.573e0, 0.0e0, 0.0e0, -180.56e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185698, 'MAX', -179.573e0, 0.0e0, 0.0e0, -180.56e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 46.903e0, -50.09e0, 2.25e0, 4.89e0, 0.72e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41917, '2023-04-26 14:35:00', 2, 46.903e0, -50.09e0, 2.25e0, 4.89e0, 0.72e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -168.453e0, 0.0e0, 0.0e0, -168.453e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185699, 'MAX', -168.453e0, 0.0e0, 0.0e0, -168.453e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -82.598e0, 0.0e0, 0.0e0, -82.598e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185699, 'ZERO', -82.598e0, 0.0e0, 0.0e0, -82.598e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 45.924e0, -50.09e0, 2.25e0, 4.89e0, 0.72e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41917, '2023-04-26 14:35:00', 3, 45.924e0, -50.09e0, 2.25e0, 4.89e0, 0.72e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -170.005e0, 0.0e0, 0.0e0, -170.005e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185700, 'MAX', -170.005e0, 0.0e0, 0.0e0, -170.005e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (429) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185700, 'ZERO', -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)'. 2023-04-26 14:31:14 warning: (24) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES ('MAX', '2023-04-26 14:31:14', 'AUTOBIDDER_5MS', '2023-04-26 14:40:00', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-50.09 FOR THE NEXT 2 DISPATCH INTERVALS', 'A', '14:31:14', '14:31:14', '14:31:14', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.09 >= $-60.00')'. 2023-04-26 14:31:14 warning: (24) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?)' created from the statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((35998), '2023-04-26 14:40:00', 'MAX'),((35998), '2023-04-26 14:45:00', 'MAX'),((35998), '2023-04-26 14:50:00', 'MAX'),((35998), '2023-04-26 14:55:00', 'MAX'),((35998), '2023-04-26 15:00:00', 'MAX'),((35998), '2023-04-26 15:05:00', 'MAX'),((35998), '2023-04-26 15:10:00', 'MAX'),((35998), '2023-04-26 15:15:00', 'MAX'),((35998), '2023-04-26 15:20:00', 'MAX'),((35998), '2023-04-26 15:25:00', 'MAX'),((35998), '2023-04-26 15:30:00', 'MAX')'. 2023-04-26 14:31:14 warning: (25) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES (?, ?, ?, ?)' created from the statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES ('2023-04-26 14:31:14.952216', 'INFO', 'AUTO BIDDER', 'EXPLANATION: for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.09 >= $-60.00')'. 2023-04-26 14:31:14 warning: (24) [qc_sqlite] The function '-' is not found in the canonical statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`=?, `updatedAt`=?, `strategyId`=?, `energyMWh`=?, `generatorRevenue`=?, `offtakerRevenue`=?, `poolRevenue`=?, `PPARevenue`=?, `otherRevenue`=? WHERE `STRATEGY_REVENUE`.`dispatchInterval` = ? AND `STRATEGY_REVENUE`.`strategyId` = ?' created from the statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`='2023-04-26 14:30:00', `updatedAt`='2023-04-26 14:31:14.982638', `strategyId`='MAX', `energyMWh`=4.102, `generatorRevenue`=-163, `offtakerRevenue`=0, `poolRevenue`=-162, `PPARevenue`=0, `otherRevenue`=0 WHERE `STRATEGY_REVENUE`.`dispatchInterval` = '2023-04-26 14:30:00' AND `STRATEGY_REVENUE`.`strategyId` = 'MAX''. 2023-04-26 14:31:14 warning: (22) [qc_sqlite] The function '-' is not found in the canonical statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`=?, `updatedAt`=?, `strategyId`=?, `energyMWh`=?, `generatorRevenue`=?, `offtakerRevenue`=?, `poolRevenue`=?, `PPARevenue`=?, `otherRevenue`=? WHERE `STRATEGY_REVENUE`.`dispatchInterval` = ? AND `STRATEGY_REVENUE`.`strategyId` = ?' created from the statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`='2023-04-26 14:30:00', `updatedAt`='2023-04-26 14:31:14.997469', `strategyId`='SPLIT', `energyMWh`=4.102, `generatorRevenue`=-163, `offtakerRevenue`=0, `poolRevenue`=-162, `PPARevenue`=0, `otherRevenue`=0 WHERE `STRATEGY_REVENUE`.`dispatchInterval` = '2023-04-26 14:30:00' AND `STRATEGY_REVENUE`.`strategyId` = 'SPLIT''. 2023-04-26 14:31:15 warning: (22) [qc_sqlite] The function '-' is not found in the canonical statement 'UPDATE `DISPATCH_INTERVAL_FINANCIALS` SET `dispatchInterval`=?, `updatedAt`=?, `isCurrent`=?, `isForecast`=?, `generationMW`=?, `regionalReferencePrice`=?, `fcasCost`=?, `r6sPrice`=?, `r60sPrice`=?, `r5mPrice`=? WHERE `DISPATCH_INTERVAL_FINANCIALS`.`dispatchInterval` = ?' created from the statement 'UPDATE `DISPATCH_INTERVAL_FINANCIALS` SET `dispatchInterval`='2023-04-26 14:30:00', `updatedAt`='2023-04-26 14:31:15.033802', `isCurrent`=0, `isForecast`=0, `generationMW`=48.9, `regionalReferencePrice`=-44.87, `fcasCost`=1, `r6sPrice`=2, `r60sPrice`=4.89, `r5mPrice`=0.69 WHERE `DISPATCH_INTERVAL_FINANCIALS`.`dispatchInterval` = '2023-04-26 14:30:00''. (subsequent similar messages suppressed for 10000 milliseconds) 2023-04-26 14:31:36 warning: Timing out 'sunmetals_app'@'::ffff:192.168.152.40', idle for 121 seconds 2023-04-26 14:32:32 warning: Timing out 'sunmetals_app'@'::ffff:192.168.152.40', idle for 121 seconds 2023-04-26 14:32:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_REQUEST set STATUS = ? , STATUS_DATE = str_to_date(?,?) where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = ?) and STATUS not in (?)' created from the statement 'update PDR_MANIFEST_REQUEST set STATUS = 'TIMEOUT' , STATUS_DATE = str_to_date('2023/04/26 14:32:58','%Y/%m/%d %H:%i:%s.%f') where PDR_REQUEST_ID in ( select PDR_REQUEST_ID from PDR_REQUEST_LOG where STATUS = 'TIMEOUT') and STATUS not in ('TIMEOUT')'. 2023-04-26 14:32:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:32:58','%Y/%m/%d %H:%i:%s.%f') where REQUEST_COUNT >= REQUEST_LIMIT and STATUS != 'ABANDONED''. 2023-04-26 14:32:58 warning: (5) [qc_sqlite] The function '<>' is not found in the canonical statement 'update PDR_MANIFEST_LOG set STATUS = ? , STATUS_DATE = str_to_date(?,?) where REJECTION_COUNT >= ? and STATUS != ?' created from the statement 'update PDR_MANIFEST_LOG set STATUS = 'ABANDONED' , STATUS_DATE = str_to_date('2023/04/26 14:32:58','%Y/%m/%d %H:%i:%s.%f') where REJECTION_COUNT >= 10 and STATUS != 'ABANDONED''. 2023-04-26 14:33:16 warning: Timing out 'kiamal_app'@'::ffff:192.168.152.9', idle for 121 seconds 2023-04-26 14:33:49 warning: Timing out 'sunmetals_app'@'::ffff:192.168.152.40', idle for 121 seconds 2023-04-26 14:35:37 notice : MaxScale is shutting down. 2023-04-26 14:35:37 notice : Stopped MaxScale REST API 2023-04-26 14:35:37 notice : All workers have shut down. 2023-04-26 14:35:37 notice : MaxScale shutdown completed. 2023-04-26 14:35:37 notice : MaxScale received signal SIGTERM. Exiting. 2023-04-26 14:35:37 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Wed Apr 26 14:35:37 2023 ---------------------------------------------------------------------------- 2023-04-26 14:35:37 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2023-04-26 14:35:37 notice : Using up to 586.92MiB of memory for query classifier cache 2023-04-26 14:35:37 notice : syslog logging is disabled. 2023-04-26 14:35:37 notice : maxlog logging is enabled. 2023-04-26 14:35:37 notice : Host: 'me1mspp' OS: Linux@5.4.0-146-generic, #163-Ubuntu SMP Fri Mar 17 18:26:02 UTC 2023, x86_64 with 2 processor cores (2.00 available). 2023-04-26 14:35:37 notice : Total main memory: 3.82GiB (3.82GiB usable). 2023-04-26 14:35:37 notice : MariaDB MaxScale 22.08.5 started (Commit: 640d4030d3c2cc1236283c299d81512fb2d8280e) 2023-04-26 14:35:37 notice : MaxScale is running in process 265717 2023-04-26 14:35:37 notice : Configuration file: /etc/maxscale.cnf 2023-04-26 14:35:37 notice : Log directory: /var/log/maxscale 2023-04-26 14:35:37 notice : Data directory: /var/lib/maxscale 2023-04-26 14:35:37 notice : Module directory: /usr/lib/x86_64-linux-gnu/maxscale 2023-04-26 14:35:37 notice : Service cache: /var/cache/maxscale 2023-04-26 14:35:37 notice : Working directory: /var/log/maxscale 2023-04-26 14:35:37 notice : Module 'qc_sqlite' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libqc_sqlite.so'. 2023-04-26 14:35:37 notice : Query classification results are cached and reused. Memory used per thread: 293.46MiB 2023-04-26 14:35:37 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2023-04-26 14:35:37 notice : MaxScale started with 2 worker threads. 2023-04-26 14:35:37 notice : /etc/maxscale.cnf.d does not exist, not reading. 2023-04-26 14:35:37 notice : Module 'mariadbmon' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libmariadbmon.so'. 2023-04-26 14:35:37 notice : Module 'readwritesplit' loaded from '/usr/lib/x86_64-linux-gnu/maxscale/libreadwritesplit.so'. 2023-04-26 14:35:37 notice : Using HS256 for JWT signatures 2023-04-26 14:35:37 notice : Started REST API on [0.0.0.0]:8989 2023-04-26 14:35:37 notice : 'me1db1pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:35:37 notice : 'me1db2pp' sent version string '10.6.5-MariaDB-1:10.6.5+maria~focal-log'. Detected type: 'MariaDB', version: 10.6.5. 2023-04-26 14:35:37 notice : Server 'me1db1pp' charset: utf8mb4_general_ci 2023-04-26 14:35:37 notice : Server 'me1db2pp' charset: utf8mb4_general_ci 2023-04-26 14:35:37 notice : Starting a total of 1 services... 2023-04-26 14:35:37 notice : (split-router-listener); Listening for connections at [::]:3306 2023-04-26 14:35:37 notice : Service 'split-router' started (1/1) 2023-04-26 14:35:37 notice : Read 85 user@host entries from 'me1db1pp' for service 'split-router'. 2023-04-26 14:35:52 warning: (30) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (?,?,?,?,?,?,?,?)' created from the statement 'INSERT INTO PDR_REPORT_AUDIT (PDR_REPORT_ID,REPORT_TYPE,FILENAME,THREAD_ID,FILE_PROCESS_STATUS,EVENT_QUEUE_ID,FILE_ID,CONFIDENTIALITY) values (1447246,'SEMIDISPATCHCAPS','KSFPROJT_SEMIDISPATCHCAPS2_20230424_0000000382497847.CSV',3,'PROCESSING',382497847,'SEMIDISPATCHCAPS','KSFPROJT')'. 2023-04-26 14:36:08 warning: (83) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('SMCSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:36:08 warning: (86) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in (?) order by INTERVAL_DATETIME desc limit ?' created from the statement 'select * from DISPATCH_UNIT_CONFORMANCE where DUID in ('SMCSF1') order by INTERVAL_DATETIME desc limit 1'. 2023-04-26 14:36:08 warning: (89) [qc_sqlite] The function '=' is not found in the canonical statement 'select * from DISPATCHLOAD where DUID in (?) order by SETTLEMENTDATE desc limit ?' created from the statement 'select * from DISPATCHLOAD where DUID in ('KIAMSF1') order by SETTLEMENTDATE desc limit 2'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES (?, ?, ?, ?, ?, ?, ?, 4.106e0, 4.104e0, -50.09e0, ?, 4.89e0, 0.68e0, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimiser_5ms_runs (state_at, duid, regionid, dispatch_interval, current_mode, current_strategy, rules_version, di_est_energy_unconstrained, di_est_energy, di_rrp, di_r6s_rrp, di_r60s_rrp, di_r5m_rrp, optimal_strategy, reason, solutions, state) VALUES ('2023-04-26 14:36:12', 'KIAMSF1', 'VIC1', '2023-04-26 14:40:00', 'AUTOMATIC', 'MAX', '1.1.1', 4.106e0, 4.104e0, -50.09e0, 2, 4.89e0, 0.68e0, 'MAX', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-50.03 FOR THE NEXT 2 DISPATCH INTERVALS', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.03 >= $-60.00', 'BREAK_EVEN_PRICE_AUD: -60.0\nCURRENT_MODE: AUTOMATIC\nCURRENT_STRATEGY: MAX\nDISPATCH_INTERVAL_0: \'2023-04-26 14:35:00\'\nDISPATCH_INTERVAL_1: \'2023-04-26 14:40:00\'\nDISPATCH_INTERVAL_2: \'2023-04-26 14:45:00\'\nDISPATCH_INTERVAL_3: \'2023-04-26 14:50:00\'\nDI_CLEARED_SUPPLY_0:\n NSW1: 6990.63\n QLD1: 6116.94\n SA1: 897.81\n TAS1: 1061.0\n VIC1: 4051.89\nDI_CLEARED_SUPPLY_1:\n NSW1: 7010.34\n QLD1: 5895.08\n SA1: 941.09\n TAS1: 1059.43\n VIC1: 4073.02\nDI_CLEARED_SUPPLY_2:\n NSW1: 7015.8\n QLD1: 5958.37\n SA1: 966.35\n TAS1: 1065.35\n VIC1: 4104.38\nDI_CLEARED_SUPPLY_3:\n NSW1: 7061.18\n QLD1: 5960.07\n SA1: 969.37\n TAS1: 1065.12\n VIC1: 4125.21\nDI_ENERGY: 4.104\nDI_FCAS_COSTS_0: 0.987\nDI_FCAS_COSTS_1: 1.002\nDI_FCAS_COSTS_2: 0.0\nDI_FCAS_COSTS_3: 0.0\nDI_GENERATION_MW: 49.473\nDI_GENERATION_MW_0: 49.082\nDI_GENERATION_MW_1: 49.473\nDI_GENERATION_MW_2: 42.746\nDI_GENERATION_MW_3: 39.831\nDI_MII_STATUS: NOT_MII\nDI_OCD_STATUS: NOT_OCD\nDI_R5M_RRP: 0.68\nDI_R5M_RRP_0: 0.68\nDI_R5M_RRP_1: 0.68\nDI_R5M_RRP_2: 0.49\nDI_R5M_RRP_3: 0.68\nDI_R60S_RRP: 4.89\nDI_R60S_RRP_0: 4.89\nDI_R60S_RRP_1: 4.89\nDI_R60S_RRP_2: 4.89\nDI_R60S_RRP_3: 4.89\nDI_R6S_RRP: 2\nDI_R6S_RRP_0: 1.96\nDI_R6S_RRP_1: 2\nDI_R6S_RRP_2: 2\nDI_R6S_RRP_3: 2.25\nDI_RRP: -50.09\nDI_RRP_0: -50.09\nDI_RRP_1: -50.09\nDI_RRP_2: -50.01\nDI_RRP_3: -50.01\nDI_UNCONSTRAINED_ENERGY_ESTIMATE: 4.106\nDUID: KIAMSF1\nGEN_DI_ENERGY_MAX_0: 4.084\nGEN_DI_ENERGY_MAX_1: 4.104\nGEN_DI_ENERGY_MAX_2: 3.666\nGEN_DI_ENERGY_MAX_3: 3.441\nGEN_DI_ENERGY_SPLIT_0: 4.084\nGEN_DI_ENERGY_SPLIT_1: 4.104\nGEN_DI_ENERGY_SPLIT_2: 3.666\nGEN_DI_ENERGY_SPLIT_3: 3.441\nGEN_DI_ENERGY_ZERO_0: 4.084\nGEN_DI_ENERGY_ZERO_1: 4.104\nGEN_DI_ENERGY_ZERO_2: 1.885\nGEN_DI_ENERGY_ZERO_3: 0.0\nGEN_DI_GEN_REVENUE_MAX_0: -180.51\nGEN_DI_GEN_REVENUE_MAX_1: -181.376\nGEN_DI_GEN_REVENUE_MAX_2: -160.882\nGEN_DI_GEN_REVENUE_MAX_3: -150.98\nGEN_DI_GEN_REVENUE_SPLIT_0: -180.51\nGEN_DI_GEN_REVENUE_SPLIT_1: -181.376\nGEN_DI_GEN_REVENUE_SPLIT_2: -160.882\nGEN_DI_GEN_REVENUE_SPLIT_3: -150.98\nGEN_DI_GEN_REVENUE_ZERO_0: -180.51\nGEN_DI_GEN_REVENUE_ZERO_1: -181.376\nGEN_DI_GEN_REVENUE_ZERO_2: -82.717\nGEN_DI_GEN_REVENUE_ZERO_3: -0.0\nGEN_DI_OP_REVENUE_MAX_0: 0.0\nGEN_DI_OP_REVENUE_MAX_1: 0.0\nGEN_DI_OP_REVENUE_MAX_2: 0.0\nGEN_DI_OP_REVENUE_MAX_3: 0.0\nGEN_DI_OP_REVENUE_SPLIT_0: 0.0\nGEN_DI_OP_REVENUE_SPLIT_1: 0.0\nGEN_DI_OP_REVENUE_SPLIT_2: 0.0\nGEN_DI_OP_REVENUE_SPLIT_3: 0.0\nGEN_DI_OP_REVENUE_ZERO_0: 0.0\nGEN_DI_OP_REVENUE_ZERO_1: 0.0\nGEN_DI_OP_REVENUE_ZERO_2: 0.0\nGEN_DI_OP_REVENUE_ZERO_3: 0.0\nGEN_DI_OTHER_REVENUE_MAX_0: 0.0\nGEN_DI_OTHER_REVENUE_MAX_1: 0.0\nGEN_DI_OTHER_REVENUE_MAX_2: 0.0\nGEN_DI_OTHER_REVENUE_MAX_3: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_0: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_1: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_2: 0.0\nGEN_DI_OTHER_REVENUE_SPLIT_3: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_0: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_1: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_2: 0.0\nGEN_DI_OTHER_REVENUE_ZERO_3: 0.0\nGEN_DI_POOL_REVENUE_MAX_0: -179.523\nGEN_DI_POOL_REVENUE_MAX_1: -180.374\nGEN_DI_POOL_REVENUE_MAX_2: -160.882\nGEN_DI_POOL_REVENUE_MAX_3: -150.98\nGEN_DI_POOL_REVENUE_SPLIT_0: -179.523\nGEN_DI_POOL_REVENUE_SPLIT_1: -180.374\nGEN_DI_POOL_REVENUE_SPLIT_2: -160.882\nGEN_DI_POOL_REVENUE_SPLIT_3: -150.98\nGEN_DI_POOL_REVENUE_ZERO_0: -179.523\nGEN_DI_POOL_REVENUE_ZERO_1: -180.374\nGEN_DI_POOL_REVENUE_ZERO_2: -82.717\nGEN_DI_POOL_REVENUE_ZERO_3: -0.0\nGEN_DI_PPA_REVENUE_MAX_0: 0.0\nGEN_DI_PPA_REVENUE_MAX_1: 0.0\nGEN_DI_PPA_REVENUE_MAX_2: 0.0\nGEN_DI_PPA_REVENUE_MAX_3: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_0: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_1: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_2: 0.0\nGEN_DI_PPA_REVENUE_SPLIT_3: 0.0\nGEN_DI_PPA_REVENUE_ZERO_0: 0.0\nGEN_DI_PPA_REVENUE_ZERO_1: 0.0\nGEN_DI_PPA_REVENUE_ZERO_2: 0.0\nGEN_DI_PPA_REVENUE_ZERO_3: 0.0\nGEN_DI_RRN_ENERGY_MAX_0: 3.584\nGEN_DI_RRN_ENERGY_MAX_1: 3.601\nGEN_DI_RRN_ENERGY_MAX_2: 3.217\nGEN_DI_RRN_ENERGY_MAX_3: 3.019\nGEN_DI_RRN_ENERGY_SPLIT_0: 3.584\nGEN_DI_RRN_ENERGY_SPLIT_1: 3.601\nGEN_DI_RRN_ENERGY_SPLIT_2: 3.217\nGEN_DI_RRN_ENERGY_SPLIT_3: 3.019\nGEN_DI_RRN_ENERGY_ZERO_0: 3.584\nGEN_DI_RRN_ENERGY_ZERO_1: 3.601\nGEN_DI_RRN_ENERGY_ZERO_2: 1.654\nGEN_DI_RRN_ENERGY_ZERO_3: 0.0\nGEN_TOTAL_RATIO: 100.0\nLGC_PRICE: 52.5\nLOSS_FACTOR: 0.8775\nP5MIN_RRPS_KEY:\n- -50.09\n- -50.01\n- -50.01\n- -44.87\n- -44.87\n- -20\n- -20\n- 4.737\n- 8.94\n- 8.94\n- 8.94\n- 8.94\nP5MIN_STRATEGIES_KEY:\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\n- MAX\nP5MIN_WEIGHTED_RRPS_KEY:\n- -50.03\n- -48.725\n- -46.155\n- -38.652\n- -26.218\n- -13.816\n- -0.397\n- 7.889\n- 8.94\n- 8.94\n- 8.94\nPPA_COUNT: 0\nPPA_TOTAL_RATIO: 0.0\nPPA_WEIGHTED_PRICE: 0.0\nPREVIOUS_DI_ENERGY: 4.084\nREGIONID: VIC1\n')'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 49.082e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, 0.987e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41918, '2023-04-26 14:40:00', 0, 49.082e0, -50.09e0, 1.96e0, 4.89e0, 0.68e0, 0.987e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -179.523e0, 0.0e0, 0.0e0, -180.51e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185701, 'MAX', -179.523e0, 0.0e0, 0.0e0, -180.51e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 49.473e0, -50.09e0, ?, 4.89e0, 0.68e0, 1.002e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41918, '2023-04-26 14:40:00', 1, 49.473e0, -50.09e0, 2, 4.89e0, 0.68e0, 1.002e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -180.374e0, 0.0e0, 0.0e0, -181.376e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185702, 'MAX', -180.374e0, 0.0e0, 0.0e0, -181.376e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 42.746e0, -50.01e0, ?, 4.89e0, 0.49e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41918, '2023-04-26 14:40:00', 2, 42.746e0, -50.01e0, 2, 4.89e0, 0.49e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -160.882e0, 0.0e0, 0.0e0, -160.882e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185703, 'MAX', -160.882e0, 0.0e0, 0.0e0, -160.882e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -82.717e0, 0.0e0, 0.0e0, -82.717e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185703, 'ZERO', -82.717e0, 0.0e0, 0.0e0, -82.717e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (?, ?, ?, 39.831e0, -50.01e0, 2.25e0, 4.89e0, 0.68e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_states (optimiser_5ms_run_id, dispatch_interval, di_index, di_est_generation, di_est_rrp, di_est_r6s_rrp, di_est_r60s_rrp, di_est_r5m_rrp, di_est_fcas_cost) VALUES (41918, '2023-04-26 14:40:00', 3, 39.831e0, -50.01e0, 2.25e0, 4.89e0, 0.68e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -150.98e0, 0.0e0, 0.0e0, -150.98e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185704, 'MAX', -150.98e0, 0.0e0, 0.0e0, -150.98e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (114) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (?, ?, -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)' created from the statement 'INSERT INTO optimiser_5ms_revenues (optimiser_5ms_state_id, revenue_strategy, di_est_pool_revenue, di_est_ppa_revenue, di_est_other_revenue, di_est_gen_revenue, di_est_op_revenue) VALUES (185704, 'ZERO', -0.0e0, 0.0e0, 0.0e0, -0.0e0, 0.0e0)'. 2023-04-26 14:36:12 warning: (28) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' created from the statement 'INSERT INTO optimal_strategy (`strategyId`, `optimisedAt`, author, `dispatchInterval`, `rebidReason`, category, `decisionTime`, `awareTime`, `eventTime`, `lateRebiddingRecord`) VALUES ('MAX', '2023-04-26 14:36:12', 'AUTOBIDDER_5MS', '2023-04-26 14:45:00', 'CHANGE IN FORECAST AVERAGE DISPATCH INTERVAL PRICE TO $-50.03 FOR THE NEXT 2 DISPATCH INTERVALS', 'A', '14:36:12', '14:36:12', '14:36:12', 'for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.03 >= $-60.00')'. 2023-04-26 14:36:12 warning: (28) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?),((?), ?, ?)' created from the statement 'INSERT INTO optimal_strategy_interval (`optimalStrategyId`, `dispatchInterval`, `strategyId`) VALUES ((35999), '2023-04-26 14:45:00', 'MAX'),((35999), '2023-04-26 14:50:00', 'MAX'),((35999), '2023-04-26 14:55:00', 'MAX'),((35999), '2023-04-26 15:00:00', 'MAX'),((35999), '2023-04-26 15:05:00', 'MAX'),((35999), '2023-04-26 15:10:00', 'MAX'),((35999), '2023-04-26 15:15:00', 'MAX'),((35999), '2023-04-26 15:20:00', 'MAX'),((35999), '2023-04-26 15:25:00', 'MAX'),((35999), '2023-04-26 15:30:00', 'MAX'),((35999), '2023-04-26 15:35:00', 'MAX')'. 2023-04-26 14:36:12 warning: (26) [qc_sqlite] The function '=' is not found in the canonical statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES (?, ?, ?, ?)' created from the statement 'INSERT INTO system_event (loggedat, severity, category, description) VALUES ('2023-04-26 14:36:12.290159', 'INFO', 'AUTO BIDDER', 'EXPLANATION: for check REVENUE_CHECK strategy is set to MAX as the RRP over the next 2 DIs is $-50.03 >= $-60.00')'. 2023-04-26 14:36:12 warning: (28) [qc_sqlite] The function '-' is not found in the canonical statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`=?, `updatedAt`=?, `strategyId`=?, `energyMWh`=?, `generatorRevenue`=?, `offtakerRevenue`=?, `poolRevenue`=?, `PPARevenue`=?, `otherRevenue`=? WHERE `STRATEGY_REVENUE`.`dispatchInterval` = ? AND `STRATEGY_REVENUE`.`strategyId` = ?' created from the statement 'UPDATE `STRATEGY_REVENUE` SET `dispatchInterval`='2023-04-26 14:35:00', `updatedAt`='2023-04-26 14:36:12.316992', `strategyId`='MAX', `energyMWh`=4.084, `generatorRevenue`=-181, `offtakerRevenue`=0, `poolRevenue`=-180, `PPARevenue`=0, `otherRevenue`=0 WHERE `STRATEGY_REVENUE`.`dispatchInterval` = '2023-04-26 14:35:00' AND `STRATEGY_REVENUE`.`strategyId` = 'MAX''. (subsequent similar messages suppressed for 10000 milliseconds)