Page MenuHomePhabricator

SQL error for transcode row insertion
Closed, ResolvedPublic

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 set Reference to bz40808.
aaron created this task.Oct 5 2012, 6:43 PM
aaron added a comment.Oct 5 2012, 7:06 PM

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?

aaron added a comment.Oct 9 2012, 4:32 PM

(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?

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