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
root@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 [[email protected]]
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@kommunist:~#
--- /usr/share/goiardi/sql-files/sql-files/goiardi-schema-mysql.sql_orig 2019-02-14 18:44:26.000000000 +0100
+++ /usr/share/goiardi/sql-files/sql-files/goiardi-schema-mysql.sql 2019-12-07 21:52:23.159692624 +0100
@@ -269,7 +269,7 @@
`action` enum('create','delete','modify') NOT NULL,
`object_type` varchar(100) NOT NULL,
`object_name` varchar(255) NOT NULL,
- `extended_info` text,
+ `extended_info` mediumtext,
PRIMARY KEY (`id`),
KEY `actor_id` (`actor_id`),
KEY `action` (`action`),
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Pkg-go-maintainers mailing list [email protected] https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-go-maintainers
