[pkg-go] goiardi / wrong column size in MySQL schema

[Jakob Pfeiffer]

Hi,

when I run chef-client against goiardi it can't report node state back
to server:

----------------------------------------------------------------------
INFO: HTTP Request Returned 500 Internal Server Error: Error 1406: Data
too long for column 'extended_info' at row 1
----------------------------------------------------------------------

See attached file "chef-client_error.txt" for details


It turned out the report is >100k which is too large for MariaDB's
'text' type of 64k

You should modify the schema according to my patch file "goiardi-
schema-mysql.sql.patch"

With kind regards
Jakob
-------------- next part --------------
root at kommunist:~# chef-client                                                                                                                                                                                      
[2019-12-07T21:19:33+01:00] INFO: Forking chef instance to converge...                                                                                                                                             
Starting Chef Client, version 13.8.7                                                                                                                                                                               
[2019-12-07T21:19:33+01:00] INFO: *** Chef 13.8.7 ***                                                                                                                                                              
[2019-12-07T21:19:33+01:00] INFO: Platform: x86_64-linux-gnu                                                                                                                                                       
[2019-12-07T21:19:33+01:00] INFO: Chef-client pid: 21442                                                                                                                                                           
[2019-12-07T21:19:33+01:00] INFO: The plugin path /etc/chef/ohai/plugins does not exist. Skipping...                                                                                                               
[2019-12-07T21:19:35+01:00] INFO: Run List is [role[default-debian]]                                                                                                                                               
[2019-12-07T21:19:35+01:00] INFO: Run List expands to [base-debian]                                                                                                                                                
[2019-12-07T21:19:35+01:00] INFO: Starting Chef Run for kommunist.muc.pfeiffer.ws                                                                                                                                  
[2019-12-07T21:19:35+01:00] INFO: Running start handlers                                                                                                                                                           
[2019-12-07T21:19:35+01:00] INFO: Start handlers complete.                                                                                                                                                         
resolving cookbooks for run list: ["base-debian"]
[2019-12-07T21:19:35+01:00] INFO: Loading cookbooks [base-debian at 0.1.0]
Synchronizing Cookbooks:
  - base-debian (0.1.0)                                                                                                                                                                                           
Installing Cookbook Gems:
Compiling Cookbooks...
[2019-12-07T21:19:35+01:00] INFO: Required Recipe found, loading it
Converging 1 resources
Recipe: base-debian::packages
  * apt_package[tmux] action install[2019-12-07T21:19:35+01:00] INFO: Processing apt_package[tmux] action install (base-debian::packages line 7)                                                                  
 (up to date)
[2019-12-07T21:19:35+01:00] ERROR: Server returned error 500 for http://kommunist.muc.pfeiffer.ws:4545/nodes/kommunist.muc.pfeiffer.ws, retrying 1/5 in 3s                                                        
[2019-12-07T21:19:38+01:00] ERROR: Server returned error 500 for http://kommunist.muc.pfeiffer.ws:4545/nodes/kommunist.muc.pfeiffer.ws, retrying 2/5 in 7s                                                        
[2019-12-07T21:19:45+01:00] ERROR: Server returned error 500 for http://kommunist.muc.pfeiffer.ws:4545/nodes/kommunist.muc.pfeiffer.ws, retrying 3/5 in 14s                                                       
[2019-12-07T21:20:00+01:00] ERROR: Server returned error 500 for http://kommunist.muc.pfeiffer.ws:4545/nodes/kommunist.muc.pfeiffer.ws, retrying 4/5 in 31s                                                       
[2019-12-07T21:20:31+01:00] ERROR: Server returned error 500 for http://kommunist.muc.pfeiffer.ws:4545/nodes/kommunist.muc.pfeiffer.ws, retrying 5/5 in 47s                                                       
[2019-12-07T21:21:18+01:00] INFO: HTTP Request Returned 500 Internal Server Error: Error 1406: Data too long for column 'extended_info' at row 1                                                                  

Running handlers:
[2019-12-07T21:21:18+01:00] ERROR: Running exception handlers
Running handlers complete
[2019-12-07T21:21:18+01:00] ERROR: Exception handlers complete
Chef Client failed. 0 resources updated in 01 minutes 45 seconds
[2019-12-07T21:21:18+01:00] INFO: Sending resource update report (run-id: bd232d71-84b4-497c-935e-7c2b691b05f4)                                                                                                   
[2019-12-07T21:21:18+01:00] FATAL: Stacktrace dumped to /var/cache/chef/chef-stacktrace.out
[2019-12-07T21:21:18+01:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report                                                                                                
[2019-12-07T21:21:18+01:00] ERROR: 500 "Internal Server Error"
[2019-12-07T21:21:18+01:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)                                                                                     
root at kommunist:~#

-------------- next part --------------
A non-text attachment was scrubbed...
Name: goiardi-schema-mysql.sql.patch
Type: text/x-patch
Size: 507 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-go-maintainers/attachments/20191207/cac2e1fe/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: This is a digitally signed message part
URL: <http://alioth-lists.debian.net/pipermail/pkg-go-maintainers/attachments/20191207/cac2e1fe/attachment.sig>