/usr/sbin/mysqld, Version: 5.7.19-log (MySQL Community Server (GPL)). started with:
Tcp port: 0  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
2017-10-06T11:50:54.603511Z	    5 Connect	user@localhost on gnucash using Socket
2017-10-06T11:50:54.603873Z	    6 Connect	user@localhost on mysql using Socket
2017-10-06T11:50:54.603983Z	    6 Query	SET NAMES 'utf8'
2017-10-06T11:50:54.604048Z	    6 Query	SELECT @@sql_mode
2017-10-06T11:50:54.604134Z	    6 Query	CREATE DATABASE gnucash CHARACTER SET utf8
2017-10-06T11:50:54.604395Z	    6 Quit	
2017-10-06T11:50:54.604594Z	    7 Connect	user@localhost on gnucash using Socket
2017-10-06T11:50:54.604654Z	    7 Query	SET NAMES 'utf8'
2017-10-06T11:50:54.604697Z	    7 Query	SELECT @@sql_mode
2017-10-06T11:50:54.604772Z	    7 Query	CREATE TEMPORARY TABLE numtest ( test_int BIGINT, test_unsigned BIGINT, test_double FLOAT8 )
2017-10-06T11:50:54.605164Z	    7 Query	INSERT INTO numtest VALUES (-9223372036854775807, 9223372036854775807, 1.7976921348623158e+307)
2017-10-06T11:50:54.605281Z	    7 Query	SELECT * FROM numtest
2017-10-06T11:50:54.605377Z	    7 Query	BEGIN
2017-10-06T11:50:54.605421Z	    7 Query	SHOW TABLES FROM gnucash LIKE 'gnclock'
2017-10-06T11:50:54.605533Z	    7 Query	CREATE TABLE gnclock ( Hostname varchar(255), PID int )
2017-10-06T11:50:54.847163Z	    7 Query	SELECT * FROM gnclock
2017-10-06T11:50:54.852500Z	    7 Query	INSERT INTO gnclock VALUES ('moon', '31411')
2017-10-06T11:50:54.880396Z	    7 Query	COMMIT
2017-10-06T11:50:54.880516Z	    7 Query	SHOW TABLES FROM gnucash LIKE '%back'
2017-10-06T11:50:54.983425Z	    7 Query	SHOW TABLES FROM gnucash
2017-10-06T11:50:54.983797Z	    7 Query	SHOW TABLES FROM gnucash
2017-10-06T11:50:54.984011Z	    7 Query	SHOW INDEXES IN gnclock WHERE Key_name != 'PRIMARY'
2017-10-06T11:50:54.984296Z	    7 Query	CREATE TABLE versions (table_name varchar(50) CHARACTER SET utf8 PRIMARY KEY NOT NULL, table_version integer NOT NULL)
2017-10-06T11:50:55.260182Z	    7 Query	INSERT INTO versions VALUES('Gnucash',2061700)
2017-10-06T11:50:55.293628Z	    7 Query	INSERT INTO versions VALUES('Gnucash-Resave',19920)
2017-10-06T11:50:55.360666Z	    7 Query	CREATE TABLE accounts (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, account_type varchar(2048) CHARACTER SET utf8 NOT NULL, commodity_guid varchar(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid varchar(32), code varchar(2048) CHARACTER SET utf8, description varchar(2048) CHARACTER SET utf8, hidden integer, placeholder integer)
2017-10-06T11:50:55.628998Z	    7 Query	INSERT INTO versions VALUES('accounts',1)
2017-10-06T11:50:55.651505Z	    7 Query	CREATE TABLE books (guid varchar(32) PRIMARY KEY NOT NULL, root_account_guid varchar(32) NOT NULL, root_template_guid varchar(32) NOT NULL)
2017-10-06T11:50:55.865028Z	    7 Query	INSERT INTO versions VALUES('books',1)
2017-10-06T11:50:55.898419Z	    7 Query	CREATE TABLE budgets (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048) CHARACTER SET utf8, num_periods integer NOT NULL)
2017-10-06T11:50:56.133422Z	    7 Query	INSERT INTO versions VALUES('budgets',1)
2017-10-06T11:50:56.166814Z	    7 Query	CREATE TABLE budget_amounts (id integer PRIMARY KEY AUTO_INCREMENT NOT NULL, budget_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL)
2017-10-06T11:50:56.424752Z	    7 Query	INSERT INTO versions VALUES('budget_amounts',1)
2017-10-06T11:50:56.457444Z	    7 Query	CREATE TABLE commodities (guid varchar(32) PRIMARY KEY NOT NULL, namespace varchar(2048) CHARACTER SET utf8 NOT NULL, mnemonic varchar(2048) CHARACTER SET utf8 NOT NULL, fullname varchar(2048) CHARACTER SET utf8, cusip varchar(2048) CHARACTER SET utf8, fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source varchar(2048) CHARACTER SET utf8, quote_tz varchar(2048) CHARACTER SET utf8)
2017-10-06T11:50:56.770461Z	    7 Query	INSERT INTO versions VALUES('commodities',1)
2017-10-06T11:50:56.803890Z	    7 Query	CREATE TABLE lots (guid varchar(32) PRIMARY KEY NOT NULL, account_guid varchar(32), is_closed integer NOT NULL)
2017-10-06T11:50:57.038798Z	    7 Query	INSERT INTO versions VALUES('lots',2)
2017-10-06T11:50:57.072338Z	    7 Query	CREATE TABLE prices (guid varchar(32) PRIMARY KEY NOT NULL, commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL, date TIMESTAMP NULL DEFAULT 0 NOT NULL, source varchar(2048) CHARACTER SET utf8, type varchar(2048) CHARACTER SET utf8, value_num bigint NOT NULL, value_denom bigint NOT NULL)
2017-10-06T11:50:57.351796Z	    7 Query	INSERT INTO versions VALUES('prices',2)
2017-10-06T11:50:57.385320Z	    7 Query	CREATE TABLE schedxactions (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8, enabled integer NOT NULL, start_date date, end_date date, last_occur date, num_occur integer NOT NULL, rem_occur integer NOT NULL, auto_create integer NOT NULL, auto_notify integer NOT NULL, adv_creation integer NOT NULL, adv_notify integer NOT NULL, instance_count integer NOT NULL, template_act_guid varchar(32) NOT NULL)
2017-10-06T11:50:57.598746Z	    7 Query	INSERT INTO versions VALUES('schedxactions',1)
2017-10-06T11:50:57.632341Z	    7 Query	CREATE TABLE transactions (guid varchar(32) PRIMARY KEY NOT NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) CHARACTER SET utf8 NOT NULL, post_date TIMESTAMP NULL DEFAULT 0, enter_date TIMESTAMP NULL DEFAULT 0, description varchar(2048) CHARACTER SET utf8)
2017-10-06T11:50:57.845019Z	    7 Query	INSERT INTO versions VALUES('transactions',3)
2017-10-06T11:50:57.878538Z	    7 Query	CREATE INDEX tx_post_date_index ON transactions (post_date)
2017-10-06T11:50:58.102526Z	    7 Query	CREATE TABLE splits (guid varchar(32) PRIMARY KEY NOT NULL, tx_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, memo varchar(2048) CHARACTER SET utf8 NOT NULL, action varchar(2048) CHARACTER SET utf8 NOT NULL, reconcile_state varchar(1) CHARACTER SET utf8 NOT NULL, reconcile_date TIMESTAMP NULL DEFAULT 0, value_num bigint NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL, quantity_denom bigint NOT NULL, lot_guid varchar(32))
2017-10-06T11:50:58.336596Z	    7 Query	INSERT INTO versions VALUES('splits',4)
2017-10-06T11:50:58.370232Z	    7 Query	CREATE INDEX splits_tx_guid_index ON splits (tx_guid)
2017-10-06T11:50:58.627287Z	    7 Query	CREATE INDEX splits_account_guid_index ON splits (account_guid)
2017-10-06T11:50:58.850833Z	    7 Query	CREATE TABLE billterms (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048) CHARACTER SET utf8 NOT NULL, refcount integer NOT NULL, invisible integer NOT NULL, parent varchar(32), type varchar(2048) CHARACTER SET utf8 NOT NULL, duedays integer, discountdays integer, discount_num bigint, discount_denom bigint, cutoff integer)
2017-10-06T11:50:59.052273Z	    7 Query	INSERT INTO versions VALUES('billterms',2)
2017-10-06T11:50:59.085860Z	    7 Query	CREATE TABLE customers (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT NULL, discount_num bigint NOT NULL, discount_denom bigint NOT NULL, credit_num bigint NOT NULL, credit_denom bigint NOT NULL, currency varchar(32) NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024) CHARACTER SET utf8, addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2 varchar(1024) CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET utf8, addr_addr4 varchar(1024) CHARACTER SET utf8, addr_phone varchar(128) CHARACTER SET utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email varchar(256) CHARACTER SET utf8, shipaddr_name varchar(1024) CHARACTER SET utf8, shipaddr_addr1 varchar(1024) CHARACTER SET utf8, shipaddr_addr2 varchar(1024) CHARACTER SET utf8, shipaddr_addr3 varchar(1024) CHARACTER SET utf8, shipaddr_addr4 varchar(1024) CHARACTER SET utf8, shipaddr_phone varchar(128) CHARACTER SET utf8, shipaddr_fax varchar(128) CHARACTER SET utf8, shipaddr_email varchar(256) CHARACTER SET utf8, terms varchar(32), tax_included integer, taxtable varchar(32))
2017-10-06T11:50:59.321544Z	    7 Query	INSERT INTO versions VALUES('customers',2)
2017-10-06T11:50:59.355060Z	    7 Query	CREATE TABLE employees (guid varchar(32) PRIMARY KEY NOT NULL, username varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, language varchar(2048) CHARACTER SET utf8 NOT NULL, acl varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, ccard_guid varchar(32), workday_num bigint NOT NULL, workday_denom bigint NOT NULL, rate_num bigint NOT NULL, rate_denom bigint NOT NULL, addr_name varchar(1024) CHARACTER SET utf8, addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2 varchar(1024) CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET utf8, addr_addr4 varchar(1024) CHARACTER SET utf8, addr_phone varchar(128) CHARACTER SET utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email varchar(256) CHARACTER SET utf8)
2017-10-06T11:50:59.712558Z	    7 Query	INSERT INTO versions VALUES('employees',2)
2017-10-06T11:50:59.746095Z	    7 Query	CREATE TABLE entries (guid varchar(32) PRIMARY KEY NOT NULL, date TIMESTAMP NULL DEFAULT 0 NOT NULL, date_entered TIMESTAMP NULL DEFAULT 0, description varchar(2048) CHARACTER SET utf8, action varchar(2048) CHARACTER SET utf8, notes varchar(2048) CHARACTER SET utf8, quantity_num bigint, quantity_denom bigint, i_acct varchar(32), i_price_num bigint, i_price_denom bigint, i_discount_num bigint, i_discount_denom bigint, invoice varchar(32), i_disc_type varchar(2048) CHARACTER SET utf8, i_disc_how varchar(2048) CHARACTER SET utf8, i_taxable integer, i_taxincluded integer, i_taxtable varchar(32), b_acct varchar(32), b_price_num bigint, b_price_denom bigint, bill varchar(32), b_taxable integer, b_taxincluded integer, b_taxtable varchar(32), b_paytype integer, billable integer, billto_type integer, billto_guid varchar(32), order_guid varchar(32))
2017-10-06T11:50:59.980891Z	    7 Query	INSERT INTO versions VALUES('entries',3)
2017-10-06T11:51:00.014249Z	    7 Query	CREATE TABLE invoices (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, date_opened TIMESTAMP NULL DEFAULT 0, date_posted TIMESTAMP NULL DEFAULT 0, notes varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, owner_type integer, owner_guid varchar(32), terms varchar(32), billing_id varchar(2048) CHARACTER SET utf8, post_txn varchar(32), post_lot varchar(32), post_acc varchar(32), billto_type integer, billto_guid varchar(32), charge_amt_num bigint, charge_amt_denom bigint)
2017-10-06T11:51:00.249182Z	    7 Query	INSERT INTO versions VALUES('invoices',3)
2017-10-06T11:51:00.282526Z	    7 Query	CREATE TABLE jobs (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT NULL, owner_type integer, owner_guid varchar(32))
2017-10-06T11:51:00.523623Z	    7 Query	INSERT INTO versions VALUES('jobs',1)
2017-10-06T11:51:00.584436Z	    7 Query	CREATE TABLE orders (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT NULL, date_opened TIMESTAMP NULL DEFAULT 0 NOT NULL, date_closed TIMESTAMP NULL DEFAULT 0 NOT NULL, owner_type integer NOT NULL, owner_guid varchar(32) NOT NULL)
2017-10-06T11:51:00.841681Z	    7 Query	INSERT INTO versions VALUES('orders',1)
2017-10-06T11:51:00.875164Z	    7 Query	CREATE TABLE taxtables (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(50) CHARACTER SET utf8 NOT NULL, refcount bigint NOT NULL, invisible integer NOT NULL, parent varchar(32))
2017-10-06T11:51:01.110840Z	    7 Query	INSERT INTO versions VALUES('taxtables',2)
2017-10-06T11:51:01.144508Z	    7 Query	CREATE TABLE taxtable_entries (id integer PRIMARY KEY AUTO_INCREMENT NOT NULL, taxtable varchar(32) NOT NULL, account varchar(32) NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL, type integer NOT NULL)
2017-10-06T11:51:01.379191Z	    7 Query	INSERT INTO versions VALUES('taxtable_entries',3)
2017-10-06T11:51:01.412831Z	    7 Query	CREATE TABLE vendors (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, currency varchar(32) NOT NULL, active integer NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024) CHARACTER SET utf8, addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2 varchar(1024) CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET utf8, addr_addr4 varchar(1024) CHARACTER SET utf8, addr_phone varchar(128) CHARACTER SET utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email varchar(256) CHARACTER SET utf8, terms varchar(32), tax_inc varchar(2048) CHARACTER SET utf8, tax_table varchar(32))
2017-10-06T11:51:01.736933Z	    7 Query	INSERT INTO versions VALUES('vendors',1)
2017-10-06T11:51:01.770285Z	    7 Query	CREATE TABLE recurrences (id integer PRIMARY KEY AUTO_INCREMENT NOT NULL, obj_guid varchar(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type varchar(2048) CHARACTER SET utf8 NOT NULL, recurrence_period_start date NOT NULL, recurrence_weekend_adjust varchar(2048) CHARACTER SET utf8 NOT NULL)
2017-10-06T11:51:01.983144Z	    7 Query	INSERT INTO versions VALUES('recurrences',2)
2017-10-06T11:51:02.016679Z	    7 Query	CREATE TABLE slots (id integer PRIMARY KEY AUTO_INCREMENT NOT NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) CHARACTER SET utf8 NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val varchar(4096) CHARACTER SET utf8, double_val double, timespec_val TIMESTAMP NULL DEFAULT 0, guid_val varchar(32), numeric_val_num bigint, numeric_val_denom bigint, gdate_val date)
2017-10-06T11:51:02.295902Z	    7 Query	INSERT INTO versions VALUES('slots',3)
2017-10-06T11:51:02.329281Z	    7 Query	CREATE INDEX slots_guid_index ON slots (obj_guid)
2017-10-06T11:51:02.519651Z	    7 Query	BEGIN
2017-10-06T11:51:02.519906Z	    7 Query	INSERT INTO books(guid,root_account_guid,root_template_guid) VALUES('4e758241bfb205660df02e9edbb1fad1','39a37d076d9ad19bbda9caae9b0ea885','4e457365fa7d447e22eb7c3f0ea45516')
2017-10-06T11:51:02.520332Z	    7 Query	INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('4e758241bfb205660df02e9edbb1fad1','options',9,0,NULL,0,'19700101000000','e406913b813dda8847131987d22b2abc',0,1,NULL)
2017-10-06T11:51:02.520594Z	    7 Query	ROLLBACK
2017-10-06T11:51:02.575282Z	    7 Query	SHOW TABLES FROM gnucash
