PFyyh commented on issue #4840:
URL: https://github.com/apache/shenyu/issues/4840#issuecomment-1633851464
pg is the same as mysql
```
Exception in thread "shenyu-disruptor-shenyu_disruptor_consumer_-19"
org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: org.postgresql.util.PSQLException:
ERROR: null value in column "match_restful" of relation "selector" violates
not-null constraint
详细：Failing row contains (1679415422994956288, 5, /http, 0, 1, 1, , 1, 1,
1, null, 2023-07-13 17:00:13.527, 2023-07-13 17:00:13.527).
### The error may exist in class path resource [mappers/selector-sqlmap.xml]
### The error may involve
org.apache.shenyu.admin.mapper.SelectorMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into selector ( id,
date_created, date_updated,
plugin_id,
name, match_mode,
type,
sort, enabled,
loged, continued,
handle ) values ( ?,
?, ?,
?, ?,
?,
?, ?,
?,
?, ?,
? )
### Cause: org.postgresql.util.PSQLException: ERROR: null value in column
"match_restful" of relation "selector" violates not-null constraint
详细：Failing row contains (1679415422994956288, 5, /http, 0, 1, 1, , 1, 1,
1, null, 2023-07-13 17:00:13.527, 2023-07-13 17:00:13.527).
; ERROR: null value in column "match_restful" of relation "selector"
violates not-null constraint
详细：Failing row contains (1679415422994956288, 5, /http, 0, 1, 1, , 1, 1,
1, null, 2023-07-13 17:00:13.527, 2023-07-13 17:00:13.527).; nested exception
is org.postgresql.util.PSQLException: ERROR: null value in column
"match_restful" of relation "selector" violates not-null constraint
详细：Failing row contains (1679415422994956288, 5, /http, 0, 1, 1, , 1, 1,
1, null, 2023-07-13 17:00:13.527, 2023-07-13 17:00:13.527).
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:251)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy104.insert(Unknown Source)
at
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at com.sun.proxy.$Proxy119.insertSelective(Unknown Source)
at
org.apache.shenyu.admin.service.impl.SelectorServiceImpl.registerDefault(SelectorServiceImpl.java:124)
at
org.apache.shenyu.admin.service.impl.SelectorServiceImpl.registerDefault(SelectorServiceImpl.java:138)
at
org.apache.shenyu.admin.service.impl.SelectorServiceImpl$$FastClassBySpringCGLIB$$20b2533e.invoke(<generated>)
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
