catalogue · 442c8e0382e71848af720aed6ef95f145e3e07c2 · dCache / cta

Added ARCHIVE_FILE_DIN_DFP_IDX to catalaogue db

Steven Murray authored 7 years ago

Without this index we got errors like:

[root@p06253947b39467 ~]# cta af ls --instance cta --path /eos/dev/test/gcancio/10072017/file_2167
Failed to execute the command. Reason: Failed to open root://10.16.135.81:10955//Y3Rh&YWY=&bHM=&LS1pbnN0YW5jZQ==&Y3Rh&LS1wYXRo&L2Vvcy9kZXYvdGVzdC9nY2FuY2lvLzEwMDcyMDE3L2ZpbGVfMjE2Nw==: [ERROR] Operation expired
[root@p06253947b39467 ~]#

With this index we execute the same query in less than a second:

[root@p06253947b39467 ~]# time cta af ls --instance cta --path /eos/dev/test/gcancio/10072017/file_2167
 289440       1  I20170    1381    51096      cta   18965         1006       ADLER32     0XFBA23F1D    german_raw  gcancio       c3    1499697578 /eos/dev/test/gcancio/10072017/file_2167

real    0m0.590s
user    0m0.005s
sys    0m0.006s
[root@p06253947b39467 ~]#

442c8e03

History

442c8e03 7 years ago

History

Name	Last commit	Last update
..
ArchiveFileBuilder.cpp
ArchiveFileBuilder.hpp
ArchiveFileItor.cpp
ArchiveFileItor.hpp
ArchiveFileItorImpl.cpp
ArchiveFileItorImpl.hpp
ArchiveFileRow.cpp
ArchiveFileRow.hpp
CMakeLists.txt
Catalogue.cpp
Catalogue.hpp
CatalogueFactory.cpp
CatalogueFactory.hpp
CatalogueFactoryTest.cpp
CatalogueFactory_OCCI_SUPPORT_OFF.cpp
CatalogueTest.cpp
CatalogueTest.hpp
CmdLineTool.cpp
CmdLineTool.hpp
CreateAdminHostCmd.cpp
CreateAdminHostCmd.hpp
CreateAdminHostCmdLineArgs.cpp
CreateAdminHostCmdLineArgs.hpp
CreateAdminHostCmdLineArgsTest.cpp
CreateAdminHostCmdMain.cpp
CreateAdminUserCmd.cpp
CreateAdminUserCmd.hpp
CreateAdminUserCmdLineArgs.cpp
CreateAdminUserCmdLineArgs.hpp
CreateAdminUserCmdLineArgsTest.cpp
CreateAdminUserCmdMain.cpp
CreateSchemaCmd.cpp
CreateSchemaCmd.hpp
CreateSchemaCmdLineArgs.cpp
CreateSchemaCmdLineArgs.hpp
CreateSchemaCmdLineArgsTest.cpp
CreateSchemaCmdMain.cpp
DbConfigCatalogueTest.cpp
DropOracleCatalogueSchema.before_SQL.cpp
DropOracleCatalogueSchema.hpp
DropSchemaCmd.cpp
DropSchemaCmd.hpp
DropSchemaCmdLineArgs.cpp
DropSchemaCmdLineArgs.hpp
DropSchemaCmdLineArgsTest.cpp
DropSchemaCmdMain.cpp
DropSqliteCatalogueSchema.before_SQL.cpp
DropSqliteCatalogueSchema.hpp
DummyCatalogue.hpp
InMemoryCatalogue.cpp
InMemoryCatalogue.hpp
InMemoryCatalogueTest.cpp
OracleCatalogue.cpp
OracleCatalogue.hpp
OracleCatalogueSchema.before_SQL.cpp
OracleCatalogueSchema.hpp
PollDatabaseCmd.cpp
PollDatabaseCmd.hpp
PollDatabaseCmdLineArgs.cpp
PollDatabaseCmdLineArgs.hpp
PollDatabaseCmdLineArgsTest.cpp
PollDatabaseCmdMain.cpp
RdbmsArchiveFileItorImpl.cpp
RdbmsArchiveFileItorImpl.hpp
RdbmsCatalogue.cpp
RdbmsCatalogue.hpp
RequesterAndGroupMountPolicies.hpp
SchemaCreatingSqliteCatalogue.cpp
SchemaCreatingSqliteCatalogue.hpp
SqliteCatalogue.cpp
SqliteCatalogue.hpp
SqliteCatalogueSchema.before_SQL.cpp
SqliteCatalogueSchema.hpp
TapeFileSearchCriteria.hpp
TapeFileWritten.cpp
TapeFileWritten.hpp
TapeForWriting.cpp
TapeForWriting.hpp
TapeSearchCriteria.hpp
catalogue_common_schema.sql
catalogue_schema.pdf
cta-catalogue-admin-host-create.1cta
cta-catalogue-admin-user-create.1cta
cta-catalogue-schema-create.1cta
cta-catalogue-schema-drop.1cta
cta-database-poll.1cta
cta_catalogue_db.conf.example
oracle_catalogue_schema_header.sql
oracle_catalogue_schema_trailer.sql
sqlite_catalogue_schema_header.sql
sqlite_catalogue_schema_trailer.sql