Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error during mainnet sync #14

Closed
satran004 opened this issue Sep 15, 2023 · 0 comments · Fixed by #15
Closed

SQL error during mainnet sync #14

satran004 opened this issue Sep 15, 2023 · 0 comments · Fixed by #15

Comments

@satran004
Copy link
Member

ERROR: value too long for type character varying(64)

2023-09-15 13:06:22.080  INFO 76719 --- [ntLoopGroup-7-1] o.c.l.e.listeners.BlockEventListener     : Block already exists. Skipping block no 157182, hash 08ecdb54a80c81073ddee790f3cf4f8d4ff4422eb369b41cd5e0e18c13de6bbe
2023-09-15 13:06:22.109  INFO 76719 --- [ntLoopGroup-7-1] o.c.l.e.listeners.BlockEventListener     : Block  number 5561508, slot_no 26250031, hash 52fd6283bc5a1e6b78707a1534abfb3aa2499ca2c108741d5db6c8c7d99353ae
2023-09-15 13:06:22.300  INFO 76719 --- [ntLoopGroup-7-1] o.h.e.j.b.internal.AbstractBatchImpl     : HHH000010: On release of batch it still contained JDBC statements
2023-09-15 13:06:22.300 ERROR 76719 --- [ntLoopGroup-7-1] o.h.e.jdbc.batch.internal.BatchingBatch  : HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into cexplorer.param_proposal (coins_per_utxo_size, collateral_percent, cost_model_id, decentralisation, entropy, epoch_no, influence, key, key_deposit, max_bh_size, max_block_ex_mem, max_block_ex_steps, max_block_size, max_collateral_inputs, max_epoch, max_tx_ex_mem, max_tx_ex_steps, max_tx_size, max_val_size, min_fee_a, min_fee_b, min_pool_cost, min_utxo_value, monetary_expand_rate, optimal_pool_count, pool_deposit, price_mem, price_step, protocol_major, protocol_minor, registered_tx_id, treasury_growth_rate, id) values (NULL, NULL, NULL, NULL, '[1, d982e06fd33e7440b43cefad529b7ecafbaa255e38178ad4189a37e4ce9bf1fa]', 258, NULL, '268cfc0b89e910ead22e0ade91493d8212f53f3e2164b2e4bef0819b', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5875270, NULL, 46) was aborted: ERROR: value too long for type character varying(64)  Call getNextException to see other errors in the batch.], SQL: insert into cexplorer.param_proposal (coins_per_utxo_size, collateral_percent, cost_model_id, decentralisation, entropy, epoch_no, influence, key, key_deposit, max_bh_size, max_block_ex_mem, max_block_ex_steps, max_block_size, max_collateral_inputs, max_epoch, max_tx_ex_mem, max_tx_ex_steps, max_tx_size, max_val_size, min_fee_a, min_fee_b, min_pool_cost, min_utxo_value, monetary_expand_rate, optimal_pool_count, pool_deposit, price_mem, price_step, protocol_major, protocol_minor, registered_tx_id, treasury_growth_rate, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2023-09-15 13:06:22.300  WARN 76719 --- [ntLoopGroup-7-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 22001
2023-09-15 13:06:22.301 ERROR 76719 --- [ntLoopGroup-7-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : Batch entry 0 insert into cexplorer.param_proposal (coins_per_utxo_size, collateral_percent, cost_model_id, decentralisation, entropy, epoch_no, influence, key, key_deposit, max_bh_size, max_block_ex_mem, max_block_ex_steps, max_block_size, max_collateral_inputs, max_epoch, max_tx_ex_mem, max_tx_ex_steps, max_tx_size, max_val_size, min_fee_a, min_fee_b, min_pool_cost, min_utxo_value, monetary_expand_rate, optimal_pool_count, pool_deposit, price_mem, price_step, protocol_major, protocol_minor, registered_tx_id, treasury_growth_rate, id) values (NULL, NULL, NULL, NULL, '[1, d982e06fd33e7440b43cefad529b7ecafbaa255e38178ad4189a37e4ce9bf1fa]', 258, NULL, '268cfc0b89e910ead22e0ade91493d8212f53f3e2164b2e4bef0819b', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5875270, NULL, 46) was aborted: ERROR: value too long for type character varying(64)  Call getNextException to see other errors in the batch.
2023-09-15 13:06:22.301 ERROR 76719 --- [ntLoopGroup-7-1] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: value too long for type character varying(64)
2023-09-15 13:06:22.308 ERROR 76719 --- [ntLoopGroup-7-1] o.c.l.e.listeners.BlockEventListener     : could not execute batch; SQL [insert into cexplorer.param_proposal (coins_per_utxo_size, collateral_percent, cost_model_id, decentralisation, entropy, epoch_no, influence, key, key_deposit, max_bh_size, max_block_ex_mem, max_block_ex_steps, max_block_size, max_collateral_inputs, max_epoch, max_tx_ex_mem, max_tx_ex_steps, max_tx_size, max_val_size, min_fee_a, min_fee_b, min_pool_cost, min_utxo_value, monetary_expand_rate, optimal_pool_count, pool_deposit, price_mem, price_step, protocol_major, protocol_minor, registered_tx_id, treasury_growth_rate, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant