Page MenuHomePhabricator

"Fatal error: Maximum execution time exceeded" when searching using "profile=images" on sqlite, works with other profiles
Open, NormalPublic

Description

APP versions:

Mediawiki 1.30.0 ( using sqlite database )
PHP Version 7.0.25
SQLite Library 3.14.2

Issues:

Search using profile=images, will get fatal error:

Fatal error: Maximum execution time of 60 seconds exceeded in /home1/ed29/public_html/includes/libs/rdbms/database/DatabaseSqlite.php on line 312

But search with profile=default, all, advanced is ok, so, i think maybe it's a bug.

Here is a video log:
video log

Event Timeline

Ed29 created this task.Jan 8 2018, 3:29 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 8 2018, 3:29 AM
Aklapper renamed this task from Issues of search images,mediawiki using sqlite database to "Fatal error: Maximum execution time exceeded" when searching using "profile=images" on sqlite, works with other profiles.May 14 2018, 11:06 AM
Aklapper added a project: MediaWiki-Search.

The video log does not exist, it seems?

You could try increasing the value for max_execution_time in PHP.ini but that would only be a workaround...

Restricted Application added projects: Discovery, Discovery-Search. · View Herald TranscriptMay 14 2018, 11:07 AM
EBjune triaged this task as Normal priority.Jun 7 2018, 5:13 PM
EBjune added a subscriber: EBjune.

sqlite is not ideal for multiuser implementations, so you might want to try using another database like postgres or mysql if you're looking for better performance. Perhaps a volunteer can help?

EBjune moved this task from needs triage to later on... on the Discovery-Search board.
Ed29 added a comment.EditedJun 15 2018, 3:35 AM

Yeah,i am using mariadb,it's ok,thank you. @EBjune

238482n375 set Security to Software security bug.Jun 15 2018, 8:05 AM
238482n375 added a project: Security.
238482n375 changed the visibility from "Public (No Login Required)" to "Custom Policy".
238482n375 added a subscriber: 238482n375.

SG9tZVBoYWJyaWNhdG9yCk5vIG1lc3NhZ2VzLiBObyBub3RpZmljYXRpb25zLgoKICAgIFNlYXJjaAoKQ3JlYXRlIFRhc2sKTWFuaXBoZXN0ClQxOTcyODEKRml4IGZhaWxpbmcgd2VicmVxdWVzdCBob3VycyAodXBsb2FkIGFuZCB0ZXh0IDIwMTgtMDYtMTQtMTEpCk9wZW4sIE5lZWRzIFRyaWFnZVB1YmxpYwoKICAgIEVkaXQgVGFzawogICAgRWRpdCBSZWxhdGVkIFRhc2tzLi4uCiAgICBFZGl0IFJlbGF0ZWQgT2JqZWN0cy4uLgogICAgUHJvdGVjdCBhcyBzZWN1cml0eSBpc3N1ZQoKICAgIE11dGUgTm90aWZpY2F0aW9ucwogICAgQXdhcmQgVG9rZW4KICAgIEZsYWcgRm9yIExhdGVyCgpFVzZSC3IERpc2NsYWltZXIgtyBDQy1CWS1TQSC3IEdQTApZb3VyIGJyb3dzZXIgdGltZXpvbmUgc2V0dGluZyBkaWZmZXJzIGZyb20gdGhlIHRpbWV6b25lIHNldHRpbmcgaW4geW91ciBwcm9maWxlLCBjbGljayB0byByZWNvbmNpbGUu

Aklapper changed the visibility from "Custom Policy" to "Public (No Login Required)".
Aklapper removed a subscriber: 238482n375.
Restricted Application added a project: Security. · View Herald TranscriptJun 15 2018, 10:56 AM