2022-11-25 08:35:59.085; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketWriter; send: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 23 00 00 00 16 54 52 55 4E 43 41 54 45 20 54 41 | #....TRUNCATE TA | | 42 4C 45 20 63 61 6C 63 75 6C 61 74 65 64 50 72 | BLE calculatedPr | | 69 63 65 54 6D 70 3B | iceTmp; | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.090; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 0C 00 00 01 00 D2 00 00 00 00 00 00 00 00 00 00 | ................ | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.133; DEBUG; programname[hostname]; org.mariadb.jdbc.client.impl.StandardClient; execute query: EXECUTE TRUNCATE TABLE calculatedPriceTmp;; thread-1 2022-11-25 08:35:59.134; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketWriter; send: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 0A 00 00 00 17 D2 00 00 00 00 01 00 00 00 | .............. | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.137; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 07 00 00 01 00 00 00 02 00 00 00 | ........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.140; TRACE; programname[hostname]; org.springframework.jdbc.core.JdbcTemplate; SQL update affected 0 rows; thread-1 2022-11-25 08:35:59.142; DEBUG; programname[hostname]; mypackage.programname.output.PriceDatabaseOutput; Successfully truncated temporary table CalculatedPriceTmp in 143ms; thread-1 2022-11-25 08:35:59.142; DEBUG; programname[hostname]; org.springframework.jdbc.core.JdbcTemplate; Executing SQL batch update [INSERT INTO calculatedPriceTmp (bidPrice, bidAnnualYield, bidSemiannualYield, offrPrice, offrAnnualYield, offrSemiannualYield, calculatedPriceId) VALUES (?, ?, ?, ?, ?, ?, ?)] with a batch size of 5880; thread-1 2022-11-25 08:35:59.144; DEBUG; programname[hostname]; org.springframework.jdbc.core.JdbcTemplate; Executing prepared SQL statement [INSERT INTO calculatedPriceTmp (bidPrice, bidAnnualYield, bidSemiannualYield, offrPrice, offrAnnualYield, offrSemiannualYield, calculatedPriceId) VALUES (?, ?, ?, ?, ?, ?, ?)]; thread-1 2022-11-25 08:35:59.144; DEBUG; programname[hostname]; org.springframework.jdbc.datasource.DataSourceUtils; Fetching JDBC Connection from DataSource; thread-1 2022-11-25 08:35:59.145; DEBUG; programname[hostname]; org.springframework.jdbc.support.JdbcUtils; JDBC driver supports batch updates; thread-1 2022-11-25 08:35:59.223; TRACE; programname[hostname]; org.springframework.jdbc.core.JdbcTemplate; Sending SQL batch update #1 with 5880 items; thread-1 2022-11-25 08:35:59.225; DEBUG; programname[hostname]; org.mariadb.jdbc.client.impl.StandardClient; execute query: PREPARE INSERT INTO calculatedPriceTmp (bidPrice, bidAnnualYield, bidSemiannualYield, offrPrice, offrAnnualYield, offrSemiannualYield, calculatedPriceId) VALUES (?, ?, ?, ?, ?, ?, ?); thread-1 2022-11-25 08:35:59.225; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketWriter; send: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | AF 00 00 00 16 49 4E 53 45 52 54 20 49 4E 54 4F | .....INSERT INTO | | 20 63 61 6C 63 75 6C 61 74 65 64 50 72 69 63 65 | calculatedPrice | | 54 6D 70 20 28 62 69 64 50 72 69 63 65 2C 20 62 | Tmp (bidPrice, b | | 69 64 41 6E 6E 75 61 6C 59 69 65 6C 64 2C 20 62 | idAnnualYield, b | | 69 64 53 65 6D 69 61 6E 6E 75 61 6C 59 69 65 6C | idSemiannualYiel | | 64 2C 20 6F 66 66 72 50 72 69 63 65 2C 20 6F 66 | d, offrPrice, of | | 66 72 41 6E 6E 75 61 6C 59 69 65 6C 64 2C 20 6F | frAnnualYield, o | | 66 66 72 53 65 6D 69 61 6E 6E 75 61 6C 59 69 65 | ffrSemiannualYie | | 6C 64 2C 20 63 61 6C 63 75 6C 61 74 65 64 50 72 | ld, calculatedPr | | 69 63 65 49 64 29 0A 56 41 4C 55 45 53 20 28 3F | iceId).VALUES (? | | 2C 20 3F 2C 20 3F 2C 20 3F 2C 20 3F 2C 20 3F 2C | , ?, ?, ?, ?, ?, | | 20 3F 29 | ?) | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.225; DEBUG; programname[hostname]; org.mariadb.jdbc.client.impl.StandardClient; execute query: INSERT INTO calculatedPriceTmp (bidPrice, bidAnnualYield, bidSemiannualYield, offrPrice, offrAnnualYield, offrSemiannualYield, calculatedPriceId) VALUES (?, ?, ?, ?, ?, ?, ?); thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketWriter; send: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 04 77 06 00 FA FF FF FF FF 80 00 F6 00 F6 00 F6 | .w.............. | | 00 F6 00 F6 00 F6 00 08 00 00 09 39 39 2E 38 32 | ...........99.82 | | 39 31 37 38 00 08 33 2E 31 30 39 30 31 36 00 08 | 9178..3.109016.. | | 33 2E 30 38 35 32 31 39 00 09 39 39 2E 39 33 36 | 3.085219..99.936 | | 36 36 30 00 08 32 2E 37 33 30 32 32 39 00 08 32 | 660..2.730229..2 | | 2E 37 31 31 38 34 34 00 03 40 01 00 00 00 00 00 | .711844..@...... | | 00 09 39 38 2E 39 36 33 30 38 34 00 08 36 2E 31 | ..98.963084..6.1 | | 39 31 31 37 30 00 08 36 2E 30 39 38 32 30 30 00 | 91170..6.098200. | | 0A 31 30 30 2E 38 30 35 36 34 38 00 09 2D 30 2E | .100.805648..-0. | | 33 30 32 37 34 37 00 09 2D 30 2E 33 30 32 35 31 | 302747..-0.30251 | | 38 00 02 40 01 00 00 00 00 00 00 09 39 39 2E 38 | 8..@........99.8 | | 36 33 30 38 34 00 08 32 2E 39 38 39 34 33 38 00 | 63084..2.989438. | | 08 32 2E 39 36 37 34 32 34 00 09 39 39 2E 39 30 | .2.967424..99.90 | | 35 36 34 38 00 08 32 2E 38 33 39 34 33 38 00 08 | 5648..2.839438.. | | 32 2E 38 31 39 35 36 33 00 04 40 01 00 00 00 00 | 2.819563..@..... | | 00 00 09 39 38 2E 36 36 39 35 37 33 00 08 33 2E | ...98.669573..3. | | 32 38 31 30 32 35 00 08 33 2E 32 35 34 35 34 35 | 281025..3.254545 | | 00 09 39 38 2E 38 32 36 35 36 35 00 08 32 2E 38 | ..98.826565..2.8 | | 38 39 32 36 31 00 08 32 2E 38 36 38 36 38 38 00 | 89261..2.868688. | | 07 A0 01 00 00 00 00 00 00 0A 31 30 32 2E 38 30 | ..........102.80 | | 32 32 37 36 00 08 33 2E 32 39 38 36 32 36 00 08 | 2276..3.298626.. | | 33 2E 32 37 31 38 36 33 00 0A 31 30 34 2E 36 35 | 3.271863..104.65 | | 32 32 37 36 00 08 32 2E 36 32 38 33 30 36 00 08 | 2276..2.628306.. | | 32 2E 36 31 31 32 35 39 00 07 E0 01 00 00 00 00 | 2.611259........ | | 00 00 09 39 38 2E 37 32 30 30 38 38 00 08 33 2E | ...98.720088..3. | | 31 35 34 38 33 31 00 08 33 2E 31 33 30 33 33 34 | 154831..3.130334 | | 00 09 39 38 2E 37 38 30 32 30 31 00 08 33 2E 30 | ..98.780201..3.0 | | 30 34 38 33 31 00 08 32 2E 39 38 32 35 39 32 00 | 04831..2.982592. | | 06 A0 01 00 00 00 00 00 00 0A 31 30 33 2E 37 30 | ..........103.70 | | 32 32 37 36 00 08 32 2E 39 37 30 34 34 31 00 08 | 2276..2.970441.. | | 32 2E 39 34 38 37 30 34 00 0A 31 30 33 2E 37 35 | 2.948704..103.75 | | 32 32 37 36 00 08 32 2E 39 35 32 33 32 35 00 08 | 2276..2.952325.. | | 32 2E 39 33 30 38 35 31 00 09 E0 01 00 00 00 00 | 2.930851........ | | 00 00 0A 31 30 33 2E 36 30 32 32 37 36 00 08 33 | ...103.602276..3 | | 2E 30 30 36 37 31 30 00 08 32 2E 39 38 34 34 34 | .006710..2.98444 | | 32 00 0A 31 30 33 2E 38 37 32 32 37 36 00 08 32 | 2..103.872276..2 | | 2E 39 30 38 38 39 37 00 08 32 2E 38 38 38 30 34 | .908897..2.88804 | | 35 00 08 E0 01 00 00 00 00 00 00 09 39 37 2E 38 | 5...........97.8 | | 32 30 30 38 38 00 08 35 2E 34 32 32 36 36 32 00 | 20088..5.422662. | | 08 35 2E 33 35 31 30 37 37 00 09 39 39 2E 36 38 | .5.351077..99.68 | | 30 32 30 31 00 08 30 2E 37 38 30 36 37 35 00 08 | 0201..0.780675.. | | 30 2E 37 37 39 31 35 37 00 08 A0 01 00 00 00 00 | 0.779157........ | | 00 00 09 39 38 2E 33 35 34 37 35 34 00 08 33 2E | ...98.354754..3. | | 31 38 30 30 30 30 00 08 33 2E 31 35 35 31 31 33 | 180000..3.155113 | | 00 09 39 38 2E 34 33 31 31 34 32 00 08 33 2E 30 | ..98.431142..3.0 | | 33 30 30 30 30 00 08 33 2E 30 30 37 33 38 39 00 | 30000..3.007389. | | 0F A0 01 00 00 00 00 00 00 09 39 39 2E 31 34 38 | ..........99.148 | | 30 38 32 00 0A 31 35 36 2E 38 31 30 38 39 33 00 | 082..156.810893. | | 0A 31 32 30 2E 35 30 36 34 30 38 00 0A 31 30 30 | .120.506408..100 | | 2E 38 34 38 33 35 36 00 0B 2D 31 35 33 2E 35 32 | .848356..-153.52 | | 32 35 38 37 00 0B 2D 31 31 38 2E 34 34 37 38 35 | 2587..-118.44785 | | 32 00 0E 60 00 00 00 00 00 00 00 09 39 39 2E 39 | 2..`........99.9 | | 39 38 30 34 32 00 08 30 2E 33 35 37 33 35 30 00 | 98042..0.357350. | | 08 30 2E 33 35 37 30 33 31 00 09 39 39 2E 39 39 | .0.357031..99.99 | | 38 33 39 30 00 08 30 2E 32 39 33 38 30 31 00 08 | 8390..0.293801.. | | 30 2E 32 39 33 35 38 35 00 0F 60 00 00 00 00 00 | 0.293585..`..... | | 00 00 09 39 38 2E 39 32 35 36 32 33 00 08 35 2E | ...98.925623..5. | | 34 33 37 32 35 37 00 08 35 2E 33 36 35 32 39 31 | 437257..5.365291 | | 00 0A 31 30 30 2E 37 38 34 39 36 39 00 08 30 2E | ..100.784969..0. | | 37 33 37 32 33 39 00 08 30 2E 37 33 35 38 38 35 | 737239..0.735885 | | 00 11 40 01 00 00 00 00 00 00 09 39 38 2E 33 30 | ..@........98.30 | | 35 33 32 32 00 08 33 2E 37 32 33 32 30 30 00 08 | 5322..3.723200.. | | 33 2E 36 38 39 31 37 35 00 09 39 38 2E 34 39 35 | 3.689175..98.495 | | 39 31 33 00 08 33 2E 32 39 38 30 37 37 00 08 33 | 913..3.298077..3 | +-------------------truncated----------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 0C 00 00 01 00 D3 00 00 00 00 00 07 00 00 00 00 | ................ | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 02 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 03 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 04 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 05 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.345; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 06 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.346; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 07 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.346; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 18 00 00 08 03 64 65 66 00 00 00 01 3F 00 00 0C | .....def....?... | | 3F 00 00 00 00 00 06 80 00 00 00 00 | ?........... | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.353; TRACE; programname[hostname]; org.mariadb.jdbc.client.socket.impl.PacketReader; read: conn=10932 (M) +--------------------------------------------------+ | 0 1 2 3 4 5 6 7 8 9 a b c d e f | +--------------------------------------------------+------------------+ | 38 00 00 01 FF BA 04 23 48 59 30 30 30 49 6E 63 | 8......#HY000Inc | | 6F 72 72 65 63 74 20 61 72 67 75 6D 65 6E 74 73 | orrect arguments | | 20 74 6F 20 6D 79 73 71 6C 64 5F 73 74 6D 74 5F | to mysqld_stmt_ | | 62 75 6C 6B 5F 65 78 65 63 75 74 65 | bulk_execute | +--------------------------------------------------+------------------+ ; thread-1 2022-11-25 08:35:59.355; WARN ; programname[hostname]; org.mariadb.jdbc.message.server.ErrorPacket; Error: 1210-HY000: Incorrect arguments to mysqld_stmt_bulk_execute; thread-1