Last modified: 2012-10-24 13:26:03 UTC
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}
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).
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?
fixed in https://gerrit.wikimedia.org/r/#/c/29545/