WordPress.org

Making WordPress.org

#1785 closed defect (worksforme)

Trac uploads and report queries are failing

Reported by: xavortm Owned by:
Milestone: Priority: highest omg bbq
Component: Trac Keywords: has-screenshots
Cc:

Description

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.

Attachments (2)

Core Bug.png (190.2 KB) - added by lukecavanagh 18 months ago.
Screenshot of Issue
Core Bug New.png (48.4 KB) - added by lukecavanagh 18 months ago.
Front-end screenshot of issue

Download all attachments as: .zip

Change History (12)

#1 @netweb
18 months ago

  • Priority changed from normal to highest omg bbq
  • Summary changed from Error on listing "My Tickets" (No such function: CONCAT) to Trac uploads and report queries are failing

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.

Edit: Image removed because of a phishing warning by Google safe browsing.

Last edited 17 months ago by ocean90 (previous) (diff)

#2 follow-up: @nacin
18 months ago

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.

#3 in reply to: ↑ 2 @netweb
18 months ago

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)

#5 in reply to: ↑ 4 @netweb
18 months ago

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

#6 @xavortm
18 months ago

@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
Last edited 18 months ago by xavortm (previous) (diff)

#7 @netweb
18 months ago

@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

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

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

This ticket was mentioned in Slack in #core by netweb. View the logs.


18 months ago

#9 @netweb
18 months ago

#1788 was marked as a duplicate.

@lukecavanagh
18 months ago

Screenshot of Issue

@lukecavanagh
18 months ago

Front-end screenshot of issue

#10 @ocean90
15 months ago

  • Resolution set to worksforme
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.