mysql语句没问题，但是报错了，请指教

Question

com.zhuzher.cri.database.util.DaoRuntimeException: 数据库操作错误!; nested exception is org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select id,city,IFNULL(X(centerpoint),'') as longitude,IFNULL(Y(centerpoint),'') as latitude from city WHERE chainhotelid=?;]; Data truncation: Invalid GIS data provided to function st_x.; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

    at com.zhuzher.cri.database.util.CloudyUtil.getArrayList(CloudyUtil.java:155)
    at com.zhuzher.cri.dao.impl.CityDaoImpl.getCityList(CityDaoImpl.java:16)
    at com.zhuzher.cri.cache.CertInfoUtil.cache(CertInfoUtil.java:188)
    at com.zhuzher.cri.cache.CertInfoUtil.cacheBrandInfo(CertInfoUtil.java:117)
    at com.zhuzher.cri.cache.CertInfoUtil.removeTimeOut(CertInfoUtil.java:280)
    at com.zhuzher.cri.task.ClearTask.execute(ClearTask.java:15)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select id,city,IFNULL(X(centerpoint),'') as longitude,IFNULL(Y(centerpoint),'') as latitude from city WHERE chainhotelid=?;]; Data truncation: Invalid GIS data provided to function st_x.; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:718)
    at com.zhuzher.cri.database.util.CloudyUtil.getArrayList(CloudyUtil.java:143)
    ... 14 more

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid GIS data provided to function st_x.

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3601)
    at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1569)
    at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1425)
    at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2912)
    at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:479)
    at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2618)
    at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1787)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2208)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
    ... 19 more