Trac uploads and report queries are failing

[xavortm]

Copy paste of the error in a gist file - ​https://gist.github.com/xavortm/2b53b62aa7e416b71b369f50aab8a423
Screenshot link to the error page - ​http://imgur.com/h7vayOI

Error happened at 10:37 Monday, 27 June 2016 (GMT+2) on url ​https://core.trac.wordpress.org/my-tickets and is currently still visible.

[netweb]

See also #meta-tracdev Slack discussion ​https://wordpress.slack.com/archives/meta-tracdev/p1467013726000019

• ​https://core.trac.wordpress.org/report/24: OperationalError: no such function: CONCAT
• Trac reports 11, 22, 24, 30, 31 report OperationalError: no such function: CURDATE
• Uploading patches results in: database is locked
  • 

The CURDATE is a MySQL function, not available in SQLite, updating those Trac reports to use whatever compatible SQLite queries appears to be the fix required for that, not sure for patch uploads.

[nacin]

Everything should be OK now.

Regarding "database is locked", it should be better now, but I think there's probably a few tweaks still necessary to the server for it to be fully cooperative with SQLite.

[netweb]

Replying to nacin:

Everything should be OK now.

Regarding "database is locked", it should be better now, but I think there's probably a few tweaks still necessary to the server for it to be fully cooperative with SQLite.

On its way, thanks....

​https://core.trac.wordpress.org/component/Widgets throws TypeError: not enough arguments for format string which appears to be from whatever that Trac report is with the change from CURDATE to strftime("%s", current_date)

[xavortm]

​https://core.trac.wordpress.org/tickets/awaiting-review
​https://core.trac.wordpress.org/tickets/ux-feedback
​https://core.trac.wordpress.org/tickets/dev-feedback
​https://core.trac.wordpress.org/tickets/ancient

All of the links above are still outputting errors or not loading at all

​https://core.trac.wordpress.org/tickets/needs-response - I can't load the page to even see an error.

[netweb]

Replying to xavortm:

All of the links above are still outputting errors or not loading at all

​https://core.trac.wordpress.org/tickets/awaiting-review
​https://core.trac.wordpress.org/tickets/ux-feedback
​https://core.trac.wordpress.org/tickets/dev-feedback
​https://core.trac.wordpress.org/tickets/ancient

All 4 of these now work for me

​https://core.trac.wordpress.org/tickets/needs-response - I can't load the page to even see an error.

Likewise, this page does not load at all

[xavortm]

@netweb on ancient for example I am getting with error "OperationalError: database is locked"

How to Reproduce

While doing a GET operation on /report/43, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'id': u'43'}

User agent: #USER_AGENT#

System Information

System information not available

Enabled Plugins

Plugin information not available

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 234, in dispatch
    req.send(output, content_type or 'text/html')
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/api.py", line 490, in send
    self.send_response(status)
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 79, in send_response
    self.session.save()
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/session.py", line 161, in save
    session_saved = True
  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/api.py", line 155, in __exit__
    self.db.commit()
OperationalError: database is locked

[netweb]

@xavortm yes, that's a database is locked error, not related to any specific report, these may occur for any report.

Only 2 reports need further tweaks, all other reports ​https://core.trac.wordpress.org/report work as expected

• ​https://core.trac.wordpress.org/report/30: TypeError: not enough arguments for format string
• ​https://core.trac.wordpress.org/report/31: TypeError: not enough arguments for format string

Individual component pages appear to have correct ticket counts, no ticket numbers and links to the actual tickets, no milestones:

• ​https://make.wordpress.org/core/components/themes/widgets/
  • 

@nacin Lots of database is locked errors, and quite persistent, only 1 in 20 queries work /shrug

[netweb]

#1788 was marked as a duplicate.

[lukecavanagh]

Screenshot of Issue

[lukecavanagh]

Front-end screenshot of issue