Comments (7)
szarnyasg
commented on September 27, 2024
1
Hi, I ran it and got a slightly different error. This may be traced to the same underlying issue so I'm marking this as reproduced and we'll take a look.
---------------------------------------------------------------------------
InternalException Traceback (most recent call last)
[<ipython-input-1-3af29e6fae21>](https://localhost:8080/#) in <cell line: 36>()
34 on x.duid=z.duid """).to_view('DUID_WA')
35
---> 36 df_duid=duckdb.sql(f""" with xx as (select * from DUID union BY NAME select * from DUID_WA)
37 select trim(DUID) as DUID,min(Region) as Region, min(FuelSourceDescriptor) as FuelSourceDescriptor,min(Participant) as Participant from xx group by all
38 """)
[/usr/local/lib/python3.10/dist-packages/duckdb/__init__.py](https://localhost:8080/#) in sql(query, **kwargs)
453 else:
454 conn = duckdb.connect(":default:")
--> 455 return conn.sql(query, **kwargs)
456 _exported_symbols.append('sql')
457
InternalException: INTERNAL Error: Attempted to access index 0 within vector of size 0
This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/dev/internal_errors
from duckdb.
Tishj
commented on September 27, 2024
1
Thanks for raising this, but in the future, please put more effort into reducing the issue
It looks very esoteric and hard to run into in your reproduction
Spatial is not needed to reproduce this issue, removing that from the repro would have made this a much bigger dot on our radar
This is the only code needed to reproduce the problem.
Had I seen this, it would have been a bigger priority to tackle
import duckdb
duckdb.sql("""
create table tbl(a varchar);
insert into tbl values ('test');
SELECT
*
FROM tbl
""").to_view('DUID')
res = duckdb.sql("select * from DUID").fetchone()
print(res)from duckdb.
szarnyasg
commented on September 27, 2024
Hi @djouallah, thanks for raising this issue. When trying to run the reproduction script, I get a NotImplementedException:
---------------------------------------------------------------------------
NotImplementedException Traceback (most recent call last)
[<ipython-input-3-3af29e6fae21>](https://localhost:8080/#) in <cell line: 36>()
34 on x.duid=z.duid """).to_view('DUID_WA')
35
---> 36 df_duid=duckdb.sql(f""" with xx as (select * from DUID union BY NAME select * from DUID_WA)
37 select trim(DUID) as DUID,min(Region) as Region, min(FuelSourceDescriptor) as FuelSourceDescriptor,min(Participant) as Participant from xx group by all
38 """)
[/usr/local/lib/python3.10/dist-packages/duckdb/__init__.py](https://localhost:8080/#) in sql(query, **kwargs)
453 else:
454 conn = duckdb.connect(":default:")
--> 455 return conn.sql(query, **kwargs)
456 _exported_symbols.append('sql')
457
NotImplementedException: Not implemented Error: Enum value: '6' not implemented
Can you please take a look?
from duckdb.
djouallah
commented on September 27, 2024
the first run on colab, crash the notebook. the second run you get this
from duckdb.
lnkuiper
commented on September 27, 2024
I managed to reproduce this locally, using the python bleeding edge. However, when I build the python package locally (in debug mode, because we need symbols) it doesn't reproduce. Maybe it has been fixed, or it only shows up in release builds. This needs some more investigation
from duckdb.
djouallah
commented on September 27, 2024
now, I am getting a different error
InternalException: INTERNAL Error: Attempted to access index 0 within vector of size 0
This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/dev/internal_errors
from duckdb.
djouallah
commented on September 27, 2024
I would really appreciate not releasing 0.10.3 till this is fixed :) please
from duckdb.
Related Issues (20)
- Equivalent MACRO definitions yield different results HOT 2
- DROP TABLE IF EXISTS fails with an existing VIEW HOT 2
- Newly imported tables not showing HOT 3
- Date Difference Discrepancy in DuckDB HOT 2
- Change SQL autocompletion function name into a pragma rather than sql_auto_complete
- Using random() in an uncorrelated subquery replicates the result HOT 4
- `USE` does not affect for the table referenced after the keyword ON for the `CREATE UNIQUE INDEX ... ON ...` HOT 1
- For even number of inputs, MEDIAN() does wrong floor/mean behavior for various dtypes HOT 16
- query hangs forever using views, completes immediately with equivalent tables HOT 4
- Conversion Error of a DATE column when reading a file to insert in table HOT 6
- Wrong number of results when calling a MACRO that calls a scalar function HOT 7
- product of unnested array versus not unnested array give very different answers HOT 5
- File protocol not supported HOT 8
- Bad list performance HOT 3
- json_deserialize_sql(): Error: Attempted to dereference unique_ptr that is NULL
- DuckDBPyConnection cannot be used to fetch rows of original query after HOT 3
- No performance difference in duckdb when running with SSE and AVX 2 instruction set HOT 1
- Slow join performance when adding a condition that applies to only the left table
- DESCRIBE and query_table can't work together
- read_csv() can't skip rows where cells have a new line char HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from duckdb.