[Virtuoso-users] Random long query execution after restart

Виктор Магаев via Virtuoso-users Tue, 24 Oct 2017 04:01:59 -0700

I have query, which has execution time ~1000ms. But after something magic it  
increases to timeout .
To fix time, i need to  restart several times  my database.
After several restarts i can make this query  timeout again .
PREFIX crm2: <http://sp7.ru/ontology/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>


SELECT ?author ?object ?subject ?date_fixed ?date WHERE {
   ?subject ?sp ?object.
   ?sp rdf:singletonPropertyOf <http://www.w3.org/2000/01/rdf-schema#label>.
    
   ?sp ?author_sp ?author.
   ?author_sp rdf:singletonPropertyOf crm2:author.
   ?sp ?date_sp ?date.
   ?date_sp rdf:singletonPropertyOf crm2:date.
}

ORDER BY DESC(?date)
LIMIT 500

In logs i see (for execution time = 1s):
SELECT ?author ?object ?subject ?date WHERE {
   ?subject ?sp ?object.
   ?sp rdf:singletonPropertyOf <http://www.w3.org/2000/01/rdf-schema#label>.
    
   ?sp ?author_sp ?author.
   ?author_sp rdf:singletonPropertyOf crm2:author.
   ?sp ?date_sp ?date.
   ?date_sp rdf:singletonPropertyOf crm2:date.
    
}

ORDER BY DESC(?date)
LIMIT 500

}
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740e20e0 0 12970
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740e20e0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1eb830 0 12991
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1eb830
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740c5000 0 12979
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740c5000
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7408ae40 0 12986
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7408ae40
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc0e9eb0 0 12990
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc0e9eb0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c56b40 0 12978
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c56b40
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c5e090 0 12984
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c5e090
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74156480 0 12971
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74156480
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95322040 0 12983
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95322040
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c89fe0 0 12982
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c89fe0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74050c80 0 12977
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74050c80
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740a7f20 0 12972
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740a7f20
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c658c0 0 12988
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74016ac0 0 12980
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c658c0
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74016ac0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74033ba0 0 12974
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74033ba0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95ccfb30 0 12981
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95ccfb30
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7411c2a0 0 12973
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7411c2a0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95544160 0 12975
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95544160
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa952e43f0 0 12976
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa952e43f0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7406dd60 0 12985
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7406dd60
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1cb500 0 12989
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1cb500
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7408ae40 0 14466
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7408ae40
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c658c0 0 14475
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c658c0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74050c80 0 14473
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74050c80
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7411c2a0 0 14479
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7411c2a0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc0e9eb0 0 14467
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc0e9eb0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95ccfb30 0 14478
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95ccfb30
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a741393a0 0 12987
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a741393a0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74033ba0 0 14477
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74033ba0
14:08:23 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74016ac0 0 14476
14:08:23 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74016ac0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c89fe0 0 14472
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c89fe0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740a7f20 0 14474
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740a7f20
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95322040 0 14471
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95322040
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7406dd60 0 14482
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7406dd60
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95544160 0 14480
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95544160
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74156480 0 14470
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74156480
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c56b40 0 14468
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c56b40
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c5e090 0 14469
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c5e090
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa952e43f0 0 14481
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa952e43f0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740c5000 0 14465
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740c5000
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1cb500 0 14483
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1cb500
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95322040 0 14495
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95322040
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740a7f20 0 14494
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740a7f20
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7408ae40 0 14484
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7408ae40
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1eb830 0 14464
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1eb830
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c658c0 0 14485
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c658c0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74033ba0 0 14491
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74033ba0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c89fe0 0 14493
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c89fe0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74016ac0 0 14492
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74016ac0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95544160 0 14497
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95544160
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74156480 0 14498
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74156480
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c5e090 0 14500
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c5e090
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c56b40 0 14499
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c56b40
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a741393a0 0 14490
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a741393a0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7406dd60 0 14496
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7406dd60
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95ccfb30 0 14489
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95ccfb30
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc0e9eb0 0 14488
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc0e9eb0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa952e43f0 0 14501
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa952e43f0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7411c2a0 0 14487
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7411c2a0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74050c80 0 14486
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74050c80
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740c5000 0 14502
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740c5000
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95322040 0 14504
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95322040
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740e20e0 0 14463
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740e20e0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a7408ae40 0 14506
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a7408ae40
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c658c0 0 14508
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c658c0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1eb830 0 14507
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1eb830
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a74033ba0 0 14509
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a74033ba0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f3a740a7f20 0 14505
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f3a740a7f20
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0xa95c89fe0 0 14510
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0xa95c89fe0
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc2cce80 0 12969
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc2cce80
14:08:24 LTRS_1 SPARQL 0.0.0.0 Internal Rollback transact 0x7f38cc1cb500 0 14503
14:08:24 LTRS_2 SPARQL 0.0.0.0 Internal Restart transact 0x7f38cc1cb500
14:08:24 LTRS_1 SPARQL 185.136.77.141 Internal Commit transact 0xb05c9c570 0 
14462
14:08:24 LTRS_2 SPARQL 185.136.77.141 Internal Restart transact 0xb05c9c570
For bad execution time i see much more lines of transact restart/rollback.
Help me please, what parameters should i check?
Version 7.2.5-dev.3217-pthreads as of Aug 3 2017

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Random long query execution after restart

Reply via email to