Page MenuHomePhabricator
Create Task
Maniphest T184391

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

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
Peachey88 added a project: SQLite.Jan 8 2018, 7:15 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-ARCHIVED, Discovery-Search. · View Herald TranscriptMay 14 2018, 11:07 AM
Ed29 added a comment.EditedMay 14 2018, 12:21 PM

The video log: http://files.ed29.com/bugReport-tmp-_2018_01_08_10_46_28_685.mp4

• EBjune triaged this task as Medium priority.Jun 7 2018, 5:13 PM
• EBjune subscribed.

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 added a project: patch-welcome.Jun 7 2018, 5:15 PM
• EBjune moved this task from needs triage to search-icebox 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: acl*security.
• 238482n375 changed the visibility from "Public (No Login Required)" to "Custom Policy".
• 238482n375 subscribed.

SG9tZVBoYWJyaWNhdG9yCk5vIG1lc3NhZ2VzLiBObyBub3RpZmljYXRpb25zLgoKICAgIFNlYXJjaAoKQ3JlYXRlIFRhc2sKTWFuaXBoZXN0ClQxOTcyODEKRml4IGZhaWxpbmcgd2VicmVxdWVzdCBob3VycyAodXBsb2FkIGFuZCB0ZXh0IDIwMTgtMDYtMTQtMTEpCk9wZW4sIE5lZWRzIFRyaWFnZVB1YmxpYwoKICAgIEVkaXQgVGFzawogICAgRWRpdCBSZWxhdGVkIFRhc2tzLi4uCiAgICBFZGl0IFJlbGF0ZWQgT2JqZWN0cy4uLgogICAgUHJvdGVjdCBhcyBzZWN1cml0eSBpc3N1ZQoKICAgIE11dGUgTm90aWZpY2F0aW9ucwogICAgQXdhcmQgVG9rZW4KICAgIEZsYWcgRm9yIExhdGVyCgpFVzZSC3IERpc2NsYWltZXIgtyBDQy1CWS1TQSC3IEdQTApZb3VyIGJyb3dzZXIgdGltZXpvbmUgc2V0dGluZyBkaWZmZXJzIGZyb20gdGhlIHRpbWV6b25lIHNldHRpbmcgaW4geW91ciBwcm9maWxlLCBjbGljayB0byByZWNvbmNpbGUu

Aklapper removed a project: acl*security.Jun 15 2018, 10:56 AM
Aklapper changed the visibility from "Custom Policy" to "Public (No Login Required)".
Aklapper removed a subscriber: • 238482n375.
Restricted Application added a project: acl*security. · View Herald TranscriptJun 15 2018, 10:56 AM
Aklapper removed a project: acl*security.Jun 15 2018, 10:57 AM
Bawolff moved this task from Backlog to Bugs in core when using Sqlite on the SQLite board.Nov 11 2022, 5:25 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL