Comments (11)
Hi @mimib00, can you confirm that the rocksdb file storage has the same file size still?
from surrealdb.
Hi @mimib00, can you confirm that the rocksdb file storage has the same file size still?
Yeah that's the weird thing the data was still on the disk but surrealdb 1.4.2 and surrealist 2.0.5 can't see it for some reason
I have edited the main bug question with more details you can check it
from surrealdb.
Hey @mimib00, did you upgrade from v1.0.0? Or perhaps one of it's beta's
from surrealdb.
Hey @mimib00, did you upgrade from v1.0.0? Or perhaps one of it's beta's
The database was in 1.0.0 and updated to v1.4.2 using docker-compose
from surrealdb.
@mimib00 can you confirm the docker volumes you have please?
from surrealdb.
he docker volumes you have please?
what do you mean by that?
if you mean that the volume exists and has permissions it does cause as soon as I reverted the database version in the docker-compose file to 1.0 every worked just fine and the data is there
from surrealdb.
Could you please export the 1.0 database and import it into the latest (either 1.4 or 1.5).
I was wondering if it was the case that a separate image would have had separate storage, explaining the above.
Either way, exporting and importing should solve the problem, whatever the underlying infra issue is. The data will only disappear if it isn't found.
from surrealdb.
I'm busy with other projects at the moment, but I'll give it a try as soon as I'm free and update you here
from surrealdb.
@mimib00 there's a bug I also encountered on Surrealist when upgrading surrealDB versions. In my case the data is not lost, Surrealist just can't show the results in the UI, if you manually query your data you should be able to see it.
from surrealdb.
AN update on this issue so, I have just finished the migration of this project from version 1.0 to 1.5.1 and now it is working just fine but there is another bug with the data types here is an example of a query:
SELECT is_new, email FROM users WHERE email=$email
now in v1.0 it was working just fine but after I upgraded to v1.5.1 the query didn't return anything after some debugging I found that surrealdb is not registering the email as a string and if I ran the same query but like this:
SELECT is_new, email FROM users WHERE email=type::string($email)
It works just fine, I did more digging and tried this query:
LET $user = SELECT * FROM users:iaMwpm1QCBdtmFKGLaOZGCLENNe2;
type::is::string($user.email); // returns false even tho it's a string in the table schema.
but the weird thing is that this happens only on the database that has been migrated from 1.0 to 1.5.1 cause I have a dev db that was created newly with 1.5.1 the above query is working just fine with it.
from surrealdb.
AN update on this issue so, I have just finished the migration of this project from version 1.0 to 1.5.1 and now it is working just fine but there is another bug with the data types here is an example of a query:
SELECT is_new, email FROM users WHERE email=$emailnow in v1.0 it was working just fine but after I upgraded to v1.5.1 the query didn't return anything after some debugging I found that surrealdb is not registering the email as a string and if I ran the same query but like this:
SELECT is_new, email FROM users WHERE email=type::string($email)It works just fine, I did more digging and tried this query:
LET $user = SELECT * FROM users:iaMwpm1QCBdtmFKGLaOZGCLENNe2; type::is::string($user.email); // returns false even tho it's a string in the table schema.but the weird thing is that this happens only on the database that has been migrated from 1.0 to 1.5.1 cause I have a dev db that was created newly with 1.5.1 the above query is working just fine with it.
BTW this also created this same issue with strings with the full-text search where now I need to use type::string()
with every variable in the query
from surrealdb.
Related Issues (20)
- Bug: CLI handling of version check not working HOT 1
- Bug: "No Iterator has been found" when mixing indexes HOT 1
- Bug: REPL exits immediately HOT 4
- Bug: graph queries do not work as documented HOT 3
- Uploaded SurrealML Model Did Not Give Expected Results HOT 1
- Bug: Relation creation using Rust SDK fails HOT 2
- Bug: Select value breaks fetch
- Bug: table name is stored in an escaped format if the id is passed as a field HOT 2
- Bug: (Rust SDK) `.bind()` function on query doesn't seem to work correctly when passing valid record id as a `&str`. HOT 1
- Feature: `surrealdb::api::method::Surreal::create` should return `Option<T>` when creating a record with a random ID.
- Bug: Large `number`s cast into odd floats instead of decimals
- Bug: Incorrect parsing of the Content-Type request header
- Bug: `type::thing()` method allows creation of empty ident parts
- Bug: multiple `take()`'s for different fields on one response can fail
- Bug: Aggregate on Aggregate table results to "Cannot perform addition with '0' and 'NONE'" HOT 1
- Bug: Aggregate on Aggregate Table results to "Cannot perform division with '0' and '0'"
- Bug: math::median says it expects an array, whereas math::mean, sum, etc. work
- Feature: Bidirectional link records
- Bug: --tick-interval seems to be ignored
- Bug: Internal database error: ts is less than or equal to the latest ts
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 surrealdb.