实践-jira 报错处理

1、使用jira的plugin okr board 。创建group之类的操作，会报错：

There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.7.32-0ubuntu0.16.04.1 - minor version:7 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be ) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'PRIMARY'

google 了一下
参考文档：https://confluence.atlassian.com/confkb/duplicate-entry-0-for-key-primary-exceptions-during-plugin-update-815261206.html

解决方式就是：you have to remove sql_mode = NO_AUTO_VALUE_ON_ZERO from MySQL configuration file

1. Stop the application.
2. Stop MySQL
3. Edit the my.cnf file (often named my.ini on Windows operating systems or my.cnf on UNIX operating systems) in your MySQL server.

4. Remove NO_AUTO_VALUE_ON_ZERO from sql_mode.

5. Start MySQL
6. Start the application.