Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

COPY FROM DATABASE cause Segmentation fault #103

Closed
AAG81 opened this issue Dec 7, 2024 · 2 comments
Closed

COPY FROM DATABASE cause Segmentation fault #103

AAG81 opened this issue Dec 7, 2024 · 2 comments

Comments

@AAG81
Copy link

AAG81 commented Dec 7, 2024

Copying a MySQL database to a local DuckDB database using
COPY FROM DATABASE results in a segmentation fault.

duckdb --version : v1.1.3 19864453f7
mysql: Server version: 8.0.35-commercial MySQL Enterprise Server - Commercial
OS: Debian GNU/Linux 12 (bookworm)

Steps to reproduce:

duckdb my_duckdb
ATTACH 'host=127.0.0.1 user=myuser password=mystrongpass port=3306 database=mydb' AS mydb (TYPE MYSQL);
use mydb;
COPY FROM DATABASE mydb TO my_duckdb; 
Segmentation fault
@Mytherin
Copy link
Contributor

Mytherin commented Dec 7, 2024

Thanks for the report!

This might already be fixed in the nightly - could you try installing the nightly to check if the problem persists?

force install mysql from core_nightly;

@AAG81
Copy link
Author

AAG81 commented Dec 29, 2024

Thank you,
I tested it with a 20GB database, and my system froze. However, it worked successfully with a smaller database using core_nightly. I'll close this issue as resolved.

@AAG81 AAG81 closed this as completed Dec 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants