gateway failure upon service restart Data too long for column 'esm_address' at row 1 IPV6

Products

• CA API Gateway

Issue/Introduction

 

2023-05-09T18:18:57.081-0400 WARN    1 org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 1406, SQLState: 22001
2023-05-09T18:18:57.082-0400 ERROR   1 org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Data truncation: Data too long for column 'esm_address' at row 1
2023-05-09T18:18:57.107-0400 WARNING 1 com.l7tech.server.boot.GatewayMain: Error starting server : could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement

Environment

Release : 10.1

Resolution

1) take a DB Backup mysql dump ssg > /somepath/somfile.sql

2) 

# mysql ssg

mysql> ALTER TABLE cluster_info MODIFY COLUMN esm_address VARCHAR(128);

3) 

mysql> describe cluster_info;

You should see an output like,

| esm_address       | varchar(128) | YES  |     | NULL    |       |

Where previously it would have been varchar(39)