Lealone
Lealone copied to clipboard
lealone
比 MySQL 和 MongoDB 快10倍的 OLTP 关系数据库和文档数据库
根据文档[Sharding集群搭建](https://github.com/lealone/Lealone-Docs/blob/master/%E5%BA%94%E7%94%A8%E6%96%87%E6%A1%A3/Sharding%E9%9B%86%E7%BE%A4%E6%90%AD%E5%BB%BA.md)搭建了集群， 使用以下建库语句 ```sql CREATE DATABASE mydb_sharding RUN MODE sharding PARAMETERS(replication_factor: 2, assignment_factor: 2); ``` 之后按文档建表， 并插入一条记录 ```sql insert into test values(1,2); ``` 查询结果一会能查到， 一会查不到这条记录 ``` sql> select * from test;...
https://github.com/lealone/Lealone/blob/e2e8936a07dd42cdda867c973bcc0297168f9d3e/pom.xml#L99 不知道是不是我电脑环境原因，必须3.2.1才能打包
org.lealone.common.exceptions.DbException: Wrong user name or password [28000-0] at org.lealone.common.exceptions.DbException.get(DbException.java:172) ~[lealone-common-5.0.0-SNAPSHOT.jar:na] at org.lealone.common.exceptions.DbException.get(DbException.java:149) ~[lealone-common-5.0.0-SNAPSHOT.jar:na] at org.lealone.common.exceptions.DbException.get(DbException.java:138) ~[lealone-common-5.0.0-SNAPSHOT.jar:na] at org.lealone.db.session.ServerSessionFactory.createServerSession(ServerSessionFactory.java:100) ~[lealone-db-5.0.0-SNAPSHOT.jar:na] at org.lealone.db.session.ServerSessionFactory.createServerSession(ServerSessionFactory.java:48) ~[lealone-db-5.0.0-SNAPSHOT.jar:na] at org.lealone.db.session.ServerSessionFactory.createSession(ServerSessionFactory.java:39) ~[lealone-db-5.0.0-SNAPSHOT.jar:na] at org.lealone.db.session.SessionFactory.createSession(SessionFactory.java:31) ~[lealone-common-5.0.0-SNAPSHOT.jar:na] at org.lealone.orm.ModelTable.bindTable(ModelTable.java:70)...
··· "ScheduleService-1" #21 daemon prio=5 os_prio=31 cpu=576615.75ms elapsed=870.60s tid=0x00007faf33844e00 nid=0x6b03 runnable [0x00007000036f4000] java.lang.Thread.State: RUNNABLE at org.lealone.storage.aose.btree.page.LocalPage.binarySearch(LocalPage.java:105) at org.lealone.storage.aose.btree.page.Page.getPageIndex(Page.java:184) at org.lealone.storage.aose.btree.page.Page.gotoLeafPage(Page.java:449) at org.lealone.storage.aose.btree.BTreeMap.gotoLeafPage(BTreeMap.java:510) at org.lealone.storage.aose.btree.page.PageOperations$SingleWrite.gotoLeafPage(PageOperations.java:178) at org.lealone.storage.aose.btree.page.PageOperations$SingleWrite.run(PageOperations.java:88) at org.lealone.storage.page.PageOperationHandlerBase.runPageOperationTasks(PageOperationHandlerBase.java:87) at org.lealone.server.Scheduler.executeNextStatement(Scheduler.java:224)...
https://github.com/lealone/Lealone/blob/6c343cec3be0a04d90001886a55124caea5ff973/lealone-sql/src/main/java/org/lealone/sql/LealoneSQLParser.java#L2767 这个位置Case function 被设置为空会导致 SystemFunction.java 中的 getValueN(ServerSession session, Expression[] args, Value[] values)方法的中的下面这个调用会出空指针异常，最终导致包含case 函数的语句都执行不成功， Value v0 = getNullOrValue(session, args, values, 0); 建议FIx LealoneSQLParser.java#L2767 的 function.setParameter(0, null); 修改为 function.setParameter(0, ValueExpression.get(ValueBoolean.get(true)));
我更新到了最新的代码, 遇到两个问题: 1, 先新增100万条数据, 停止服务再启动, 报错 2, 把data里的数据删除, 重新新增100万条数据, 服务开着过了一个晚上, 第二天我重启服务再新增100万条数据, select count(*) from user 返回200万条数据正确, 但是我查询前100万条里埋点的数据却查不到
不drop database，只执行服务创建脚本services.sql，重复三次就会报错 Exception in thread "main" org.lealone.common.exceptions.JdbcSQLException: General error: "java.lang.ClassCastException: class org.lealone.transaction.aote.TransactionalValue cannot be cast to class org.lealone.db.index.standard.VersionedValue (org.lealone.transaction.aote.TransactionalValue and org.lealone.db.index.standard.VersionedValue are in unnamed module of loader 'app')"; SQL statement:...
我遇到了两个问题: 1, 批量插入50万条数据,插入的过程中其他服务被阻塞,不能用 2, 每次批量插入50万条数据,data文件夹都会增大10m左右, 但是总共插入200万条后, 后面不管插入多少条,data文件夹的大小都没有变化,我查看了lealone.log日志, 每隔几十条就有如下的warn日志: WARN [NodePageOperationHandler] [2021-12-25T13:56:57,035] [DefaultPageOperationHandler.java] Failed to run page operation: org.lealone.storage.aose.btree.PageOperations$AddChild@11eb4935 java.lang.NullPointerException: null