Yc-Ma Blog

图数据库创建一万个唯一索引会发生什么

 
  • Yc-Ma
  • Jul 04, 2022

Here’s the table of contents:

  1. 索引
  2. 图数据库报错
  3. 修改最大可打开文件数

索引

CREATE CONSTRAINT ON (n:LABEL1_20211231_1493252252_1493252293) ASSERT n.code IS UNIQUE;
CREATE CONSTRAINT ON (n:LABEL2_20211231_1493252252_1493252293) ASSERT n.code IS UNIQUE;
CREATE CONSTRAINT ON (n:LABEL3_20211231_1493252252_1493252293) ASSERT n.code IS UNIQUE;
CREATE CONSTRAINT ON (n:LABEL4_20211231_1493252252_1493252293) ASSERT (n.date,n.code,n.type) IS NODE KEY;

图数据库报错

Caused by: java.io.UncheckedIOException: java.nio.file.FileSystemException: /home/ongdb/ongdb/data/databases/graph.db/schema/index/native-btree-1.0/105397: Too many open files
        at org.neo4j.kernel.impl.index.schema.FileSystemIndexDropAction.drop(FileSystemIndexDropAction.java:50)
        at org.neo4j.kernel.impl.index.schema.GenericNativeIndexPopulator.drop(GenericNativeIndexPopulator.java:86)
        at org.neo4j.kernel.impl.index.schema.WorkSyncedNativeIndexPopulator.drop(WorkSyncedNativeIndexPopulator.java:77)
        at org.neo4j.kernel.impl.api.index.FailedIndexProxy.drop(FailedIndexProxy.java:71)
        at org.neo4j.kernel.impl.api.index.FlippableIndexProxy.drop(FlippableIndexProxy.java:110)
        at org.neo4j.kernel.impl.api.index.AbstractDelegatingIndexProxy.drop(AbstractDelegatingIndexProxy.java:61)
        at org.neo4j.kernel.impl.api.index.ContractCheckingIndexProxy.drop(ContractCheckingIndexProxy.java:154)
        at org.neo4j.kernel.impl.api.index.IndexingService.lambda$dropIndex$7(IndexingService.java:661)
        at org.neo4j.kernel.impl.api.index.IndexMapReference.modify(IndexMapReference.java:56)
        at org.neo4j.kernel.impl.api.index.IndexingService.dropIndex(IndexingService.java:653)
        at org.neo4j.kernel.impl.transaction.command.IndexBatchTransactionApplier$SingleTransactionApplier.visitSchemaRuleCommand(IndexBatchTransactionApplier.java:252)
        at org.neo4j.kernel.impl.transaction.command.Command$SchemaRuleCommand.handle(Command.java:647)
        at org.neo4j.kernel.impl.api.TransactionApplierFacade.visit(TransactionApplierFacade.java:61)
        at org.neo4j.kernel.impl.api.TransactionApplierFacade.visit(TransactionApplierFacade.java:35)
        at org.neo4j.kernel.impl.transaction.log.PhysicalTransactionRepresentation.accept(PhysicalTransactionRepresentation.java:70)
        at org.neo4j.kernel.impl.api.TransactionToApply.accept(TransactionToApply.java:130)
        at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.apply(RecordStorageEngine.java:294)
        ... 12 more

修改最大可打开文件数

sudo vim /etc/security/limits.conf

ongdb soft nofile 1024000
ongdb hard nofile 1024000
Search