SQL error for transcode row insertion
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	aaron
	Oct 5 2012, 6:43 PM

Description

Using SQLite during a job insertion:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

INSERT INTO transcode (transcode_image_name,transcode_key,transcode_time_addjob) VALUES ('Monthly_Metrics_Meeting_September_4,_2012.ogv','360p.webm','20121005183821')

from within function "WebVideoTranscode::updateJobQueue/single-row". Database returned error "19: transcode.transcode_error may not be NULL".

Backtrace:

#0 /var/www/SwiftWiki/core/includes/db/Database.php(925): DatabaseBase->reportQueryError('transcode.trans...', 19, 'INSERT INTO tr...', 'WebVideoTransco...', false)
#1 /var/www/SwiftWiki/core/includes/db/Database.php(1681): DatabaseBase->query('INSERT INTO tr...', 'WebVideoTransco...')
#2 /var/www/SwiftWiki/core/includes/db/DatabaseSqlite.php(527): DatabaseBase->insert('transcode', Array, 'WebVideoTransco...', Array)
#3 /var/www/DevWiki/extensions/TimedMediaHandler/WebVideoTranscode/WebVideoTranscode.php(659): DatabaseSqlite->insert('transcode', Array, 'WebVideoTransco...')
#4 /var/www/DevWiki/extensions/TimedMediaHandler/WebVideoTranscode/WebVideoTranscode.php(539): WebVideoTranscode::updateJobQueue(Object(LocalFile), '360p.webm')
#5 /var/www/DevWiki/extensions/TimedMediaHandler/WebVideoTranscode/WebVideoTranscode.php(368): WebVideoTranscode::addSourceIfReady(Object(LocalFile), Array, '360p.webm', Array)
#6 /var/www/DevWiki/extensions/TimedMediaHandler/WebVideoTranscode/WebVideoTranscode.php(234): WebVideoTranscode::getLocalSources(Object(LocalFile), Array)
#7 /var/www/DevWiki/extensions/TimedMediaHandler/TimedMediaTransformOutput.php(336): WebVideoTranscode::getSources(Object(LocalFile))
#8 /var/www/DevWiki/extensions/TimedMediaHandler/TimedMediaTransformOutput.php(182): TimedMediaTransformOutput->getMediaSources()
#9 /var/www/DevWiki/extensions/TimedMediaHandler/TimedMediaTransformOutput.php(114): TimedMediaTransformOutput->getHtmlMediaTagOutput()
#10 /var/www/SwiftWiki/core/includes/ImagePage.php(412): TimedMediaTransformOutput->toHtml(Array)
#11 /var/www/SwiftWiki/core/includes/ImagePage.php(149): ImagePage->openShowImage()
#12 /var/www/SwiftWiki/core/includes/actions/ViewAction.php(37): ImagePage->view()
#13 /var/www/SwiftWiki/core/includes/Wiki.php(427): ViewAction->show()
#14 /var/www/SwiftWiki/core/includes/Wiki.php(304): MediaWiki->performAction(Object(ImagePage))
#15 /var/www/SwiftWiki/core/includes/Wiki.php(553): MediaWiki->performRequest()
#16 /var/www/SwiftWiki/core/includes/Wiki.php(446): MediaWiki->main()
#17 /var/www/SwiftWiki/core/index.php(59): MediaWiki->run()
#18 {main}

Version: master
Severity: normal

Details

Reference: bz40808

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 1:03 AM

• bzimport added a project: TimedMediaHandler.

• bzimport set Reference to bz40808.

aaron created this task.Oct 5 2012, 6:43 PM

Seen on http://localhost/SwiftWiki/core/index.php/Special:NewFiles

I also get the same error with transcode_final_bitrate if the first problem is fixed. If I hack transcode_final_bitrate to default to 0 the thumbs work (though who knows what that hack breaks).

mdale wrote:

We use SQLite? Is the issue we just need default non NULL values in SQLite that we don't need in mysql?

(In reply to comment #3)

We use SQLite? Is the issue we just need default non NULL values in SQLite that
we don't need in mysql?

You could just give the values for those columns in the INSERT as well. Is transcode_final_bitrate ever supposed to be 0 or is that some other problem?

jgerber wrote:

fixed in https://gerrit.wikimedia.org/r/#/c/29545/

• Gilles added a project: Multimedia.Dec 4 2014, 9:33 AM

• Gilles triaged this task as Unbreak Now! priority.Dec 4 2014, 10:10 AM

• Gilles moved this task from Untriaged to Done on the Multimedia board.

• Gilles lowered the priority of this task from Unbreak Now! to Needs Triage.Dec 4 2014, 11:22 AM

SQL error for transcode row insertionClosed, ResolvedPublicActions

Description

Details

Event Timeline

SQL error for transcode row insertion
Closed, ResolvedPublic
Actions