You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/12/22 12:43:26 UTC
[GitHub] [dolphinscheduler] ruanwenjun opened a new issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
ruanwenjun opened a new issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
After starting the Standalone server several minutes, find the data in database lost.
It seems the h2 has been restart.
I guess this is related with `minimum-idle`, I will take a deep look at this.
### What you expected to happen
No.
### How to reproduce
Start Standalone server and wait, this may happen in several minutes.
If you hope to reproduce fast, you can set minimum-idle=1/2/3, then you will reproduce in less than 3 minutes.
### Anything else
_No response_
### Version
dev
### Are you willing to submit PR?
- [ ] 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: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] ruanwenjun commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-999567473
@kezhenxu94 Yes, has submitted a pr, please take a look.
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] ruanwenjun commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-999562496
This is due to the connection url. Each times we create a new connection, will run the init script. In the script will drop the exist table.
```
url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true;INIT=runscript from 'classpath:sql/dolphinscheduler_h2.sql'
```
This solution is to remove the init script from url
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-999549580
Hi:
* Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can subscribe to the developer's email，Mail subscription steps reference https://dolphinscheduler.apache.org/en-us/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] zhuangchong closed issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
zhuangchong closed issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] kezhenxu94 commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
kezhenxu94 commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-1000627601
Reverted, reopening this issue
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] caishunfeng closed issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
caishunfeng closed issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] kezhenxu94 commented on issue #7554: [Bug] [Standlone] H2 in standalone server will auto restart after several minutes
Posted by GitBox <gi...@apache.org>.
kezhenxu94 commented on issue #7554:
URL: https://github.com/apache/dolphinscheduler/issues/7554#issuecomment-999565276
> This is due to the connection url. Each times we create a new connection, will run the init script. In the script will drop the exist table.
>
> ```
> url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true;INIT=runscript from 'classpath:sql/dolphinscheduler_h2.sql'
> ```
>
> This solution is to remove the init script from url
We need put the initialization elsewhere, this is a good candidate👇
```yaml
spring:
sql:
init:
schema-locations: classpath:sql/dolphinscheduler_h2.sql
```
--
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@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org