MunkiWebAdmin postflight database error

86 views
Skip to first unread message

Peter-Erik van Riet

unread,
Jul 10, 2015, 9:50:05 AM7/10/15
to munki-w...@googlegroups.com
Hi all,

Running into error in MunkiWebAdmin, at the time (client Mac) post flight is sending the data to the server a Database error occurred.

Exploring the "ManagedSoftwareUpdate.log" 

Jul 10 2015 15:18:31 +0200 Saving application inventory...

Jul 10 2015 15:18:31 +0200     Performing postflight tasks...

Jul 10 2015 15:18:36 +0200     postflight stdout: 

<!DOCTYPE html>

<html lang="en">

<head>

  <meta http-equiv="content-type" content="text/html; charset=utf-8">

  <meta name="robots" content="NONE,NOARCHIVE">

  <title>DatabaseError at /update/postflight</title>

  <style type="text/css">


Further into the log file i see this:


</head>

<body>

<div id="summary">

  <h1>DatabaseError at /update/postflight</h1>

  <pre class="exception_value">(1264, &quot;Out of range value for column &#39;available_disk_space&#39; at row 1&quot;)</pre>

  <table class="meta">


This is a new iMac Retina 5K with 3Tb HD (Fusion Drive)


Mount Point : / Capacity : 3,12 TB (3.115.223.613.440 Bytes)

Format : Logical Partition Available : 3,08 TB (3.082.538.471.424 Bytes)

Owners Enabled : Yes Used : 32,69 GB (32.685.142.016 Bytes)

Number of Folders : 161.241 Number of Files : 743.087


At this time this is the first iMac (here) with a 3Tb HD, and this iMac gives an error. (older iMac with 500Gb HD gives no problem)

So it looks the HD is to big for database record, anyone seen this problem? where to fix this?


thanks & greetings


Peter-Erik




Steffan Ravn Edwardsen

unread,
Aug 14, 2015, 5:57:39 AM8/14/15
to MunkiWebAdmin
Which database backend are you using?

I can see that in my setup with MySQ, the database field for available_disk_space has a type of int(11) and if the postflight script reports in bytes, then it's actually 13 integers, but then again, it doesn't make sense that your 500GB drive is working fine with the database, as it should be 12 integers. Can you find the datatype in your instance? It should be in your MunkiWebAdmin database under the table reports_machine.

Best regards
Steffan

Peter-Erik van Riet

unread,
Aug 24, 2015, 8:32:56 AM8/24/15
to MunkiWebAdmin
Hi Steffan i also use MySql 


Reply all
Reply to author
Forward
0 new messages