WordPress.org

Making WordPress.org

Opened 3 years ago

Closed 3 years ago

#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 3 years ago.
Screenshot of Issue
Core Bug New.png (48.4 KB) - added by lukecavanagh 3 years ago.
Front-end screenshot of issue

Download all attachments as: .zip

Change History (12)

#1 @netweb
3 years 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
    • https://s3.amazonaws.com/f.cl.ly/items/3k0m0Z1h383X08140E1v/Internal_Error__WordPress_Trac_2016-06-27_09-59-12.jpg

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.

Version 0, edited 3 years ago by netweb (next)

#2 follow-up: @nacin
3 years 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
3 years 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
3 years 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
3 years 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 3 years ago by xavortm (previous) (diff)

#7 @netweb
3 years 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.


3 years ago

#9 @netweb
3 years ago

#1788 was marked as a duplicate.

@lukecavanagh
3 years ago

Screenshot of Issue

@lukecavanagh
3 years ago

Front-end screenshot of issue

#10 @ocean90
3 years ago

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