You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by GitBox <gi...@apache.org> on 2022/02/25 07:27:02 UTC
[GitHub] [incubator-inlong] ciscozhou opened a new issue #2714: [Bug][Manager] Create stream_source table failed
ciscozhou opened a new issue #2714:
URL: https://github.com/apache/incubator-inlong/issues/2714
### What happened
When I execute the `apache_inlong_manager.sql` file,
```
CREATE TABLE `stream_source2`
(
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`inlong_group_id` varchar(256) NOT NULL COMMENT 'Inlong group id',
`inlong_stream_id` varchar(256) NOT NULL COMMENT 'Inlong stream id',
`source_type` varchar(20) DEFAULT '0' COMMENT 'Source type, including: FILE, DB, etc',
`agent_ip` varchar(40) DEFAULT NULL COMMENT 'Ip of the agent running the task',
`uuid` varchar(30) DEFAULT NULL COMMENT 'Mac uuid of the agent running the task',
`server_id` int(11) DEFAULT NULL COMMENT 'Id of the source server',
`server_name` varchar(50) DEFAULT '' COMMENT 'Name of the source server',
`cluster_id` int(11) DEFAULT NULL COMMENT 'Id of the cluster that collected this source',
`cluster_name` varchar(50) DEFAULT '' COMMENT 'Name of the cluster that collected this source',
`snapshot` text DEFAULT NULL COMMENT 'Snapshot of this source task',
`report_time` timestamp DEFAULT NULL COMMENT 'Snapshot time',
`ext_params` text DEFAULT NULL COMMENT 'Another fields will saved as JSON string, such as filePath, dbName, tableName, etc',
`status` int(4) DEFAULT '0' COMMENT 'Data source status',
`previous_status` int(4) DEFAULT '0' COMMENT 'Previous status',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete, 0: not deleted, > 0: deleted',
`creator` varchar(64) NOT NULL COMMENT 'Creator name',
`modifier` varchar(64) DEFAULT NULL COMMENT 'Modifier name',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Create time',
`modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modify time',
PRIMARY KEY (`id`)
);
```
there was some error:
```
Error Code: 1067. Invalid default value for 'report_time'
```
### What you expected to happen
It's should no error and the table create success.
### How to reproduce
Just re-execute the above SQL.
### Environment
_No response_
### InLong version
master
### InLong Component
InLong Manager
### Are you willing to submit PR?
- [X] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: dev-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-inlong] dockerzhang closed issue #2714: [Bug][Manager] Create stream_source table failed
Posted by GitBox <gi...@apache.org>.
dockerzhang closed issue #2714:
URL: https://github.com/apache/incubator-inlong/issues/2714
--
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: dev-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-inlong] ciscozhou commented on issue #2714: [Bug][Manager] Create stream_source table failed
Posted by GitBox <gi...@apache.org>.
ciscozhou commented on issue #2714:
URL: https://github.com/apache/incubator-inlong/issues/2714#issuecomment-1050602705
I'll fix this bug.
--
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: commits-unsubscribe@inlong.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org