Re: Error during setup

Subject: Re: Error during setup

From: JBash <..hidden..>

Date: Thu, 5 Nov 2015 15:47:45 -0500

Hi Chris,

Thanks very much for your quick response.

I have attached the file that contains logs from systemd. This is my first experience with arch linux, and things are not configured the same as debian. So I learned a little about postgresql logging. I still have more to learn :).

In any case, I hope that these logs help. I have some new information as well.

I stopped postgres (you'll see at the beginning of the log) and restarted, and then tried the setup.pl from the browser.

I noticed in the log that it was complaining about a duplicate user, so I backed up and ran setup again to add a different user. That completed without (apparent, to me the user) errors and sent me to the screen asking if I wanted to start using ledgersmb, and when I did, I was able to log in as that user, so it seems like some limited success. Screens look mostly normal, but that is as far as I've gotten.

However, I notice a lot of errors in the logs, so I suspect I have something mis-configured still.

I see a lot of "current transaction is aborted, commands ignored until the end ..."

Also, if it helps I can try to get the 'pure' postgresql logs. These, as I mentioned, are journalctl, so have some other stuff mixed in. It looks like I have to do some reconfiguring to save the logs directly, but if that helps, I'll certainly try. This was what I could come up with at the moment.

If you can let me know what I may have wrong or where to look, I'd appreciate it.

Thanks,
Jerry

On Thu, Nov 5, 2015 at 2:06 PM, Chris Travers <..hidden..> wrote:

Hi;

On Thu, Nov 5, 2015 at 7:40 PM, JBash <..hidden..> wrote:
Hello,

I'm getting the following error when setting up a new database using ledgersmb 1.4.18. This is an install on a new machine that has not run ledgersmb previously.

This display on the browser:

Error!

25P02: ERROR: current transaction is aborted, commands ignored until the end of transaction block at LedgerSMB.pm line 770.

Hmmm in addition to helping you with a workaround I really want to make sure cases where this sort of error happens are eliminated since it makes troubleshooting hard.

Can you please check your PostgreSQL logs for errors? If you want to attach them or email them directly to me I can put the relevant portion here in the email for future reference, discussion, workarounds, and fixes.

dbversion: 1.4.18, company:

And in the http server (apache 2.4) error log:

2015/11/05 18:19:06 - ERROR - LedgerSMB::_error LedgerSMB.pm (639) --
25P02:ERROR: current transaction is aborted, commands ignored until end of
transaction block at LedgerSMB.pm line 770.
2015/11/05 18:19:06 - ERROR - LedgerSMB::_error LedgerSMB.pm (640) --
dbversion: 1.4.18, company:
exit at LedgerSMB.pm line 653.
Compilation failed in require at /srv/http/domain3.com/ledgersmb/setup.pl line
8.

As I said earlier, this is a new machine running arch linux that I've not had ledger on in the past, so there may be some configuration issues. During the install of postgres, I had an issue getting the locale set correctly. Is it possible that is causing this problem?

Please let me know other areas that I may need to verify.

Thanks in advance for your help.
Jerry

------------------------------------------------------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--
Best Wishes,
Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
http://www.efficito.com/learn_more

------------------------------------------------------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

-- Logs begin at Mon 2015-10-26 16:20:52 UTC, end at Thu 2015-11-05 20:25:48 UTC. -- Nov 05 14:15:03 arch001 systemd-journald[138]: Runtime journal (/run/log/journal/) is currently using 8.0M. Maximum allowed usage is set to 197.8M. Leaving at least 296.7M free (of currently available 1.9G of space). Enforced usage limit is thus 197.8M, of which 189.8M are still available. Nov 05 14:15:04 arch001 systemd-journald[138]: System journal (/var/log/journal/) is currently using 24.0M. Maximum allowed usage is set to 1.8G. Leaving at least 2.7G free (of currently available 12.5G of space). Enforced usage limit is thus 1.8G, of which 1.8G are still available. Nov 05 14:15:07 arch001 systemd-journald[138]: Time spent on flushing to /var is 3.151496s for 2 entries. Nov 05 14:15:07 arch001 kernel: Initializing cgroup subsys cpuset Nov 05 14:15:07 arch001 kernel: Initializing cgroup subsys cpu Nov 05 14:15:08 arch001 kernel: Initializing cgroup subsys cpuacct Nov 05 14:15:08 arch001 kernel: Linux version 4.2.5-1-ARCH (builduser@tobias) (gcc version 5.2.0 (GCC) ) #1 SMP PREEMPT Tue Oct 27 08:13:28 CET 2015 Nov 05 14:15:08 arch001 kernel: Command line: BOOT_IMAGE=/boot/vmlinuz-linux root=UUID=192d2bbd-3085-44e1-988a-4f93f1303d61 rw quiet Nov 05 14:15:08 arch001 kernel: x86/fpu: xstate_offset[2]: 0240, xstate_sizes[2]: 0100 Nov 05 14:15:08 arch001 kernel: x86/fpu: Supporting XSAVE feature 0x01: 'x87 floating point registers' Nov 05 14:15:08 arch001 kernel: x86/fpu: Supporting XSAVE feature 0x02: 'SSE registers' Nov 05 14:15:08 arch001 kernel: x86/fpu: Supporting XSAVE feature 0x04: 'AVX registers' Nov 05 14:15:08 arch001 kernel: x86/fpu: Enabled xstate features 0x7, context size is 0x340 bytes, using 'standard' format. Nov 05 14:15:08 arch001 kernel: x86/fpu: Using 'lazy' FPU context switches. Nov 05 14:15:08 arch001 kernel: e820: BIOS-provided physical RAM map: Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x0000000000000000-0x000000000009fbff] usable Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x000000000009fc00-0x000000000009ffff] reserved Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x00000000000f0000-0x00000000000fffff] reserved Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x0000000000100000-0x00000000dffeffff] usable Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x00000000dfff0000-0x00000000dfffffff] ACPI data Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x00000000fffc0000-0x00000000ffffffff] reserved Nov 05 14:15:08 arch001 kernel: BIOS-e820: [mem 0x0000000100000000-0x000000011fffffff] usable Nov 05 14:15:08 arch001 kernel: NX (Execute Disable) protection: active Nov 05 14:15:08 arch001 kernel: SMBIOS 2.5 present. Nov 05 14:15:08 arch001 kernel: DMI: innotek GmbH VirtualBox/VirtualBox, BIOS VirtualBox 12/01/2006 Nov 05 14:15:08 arch001 kernel: Hypervisor detected: KVM Nov 05 14:15:08 arch001 kernel: e820: update [mem 0x00000000-0x00000fff] usable ==> reserved Nov 05 14:15:08 arch001 kernel: e820: remove [mem 0x000a0000-0x000fffff] usable Nov 05 14:15:08 arch001 kernel: e820: last_pfn = 0x120000 max_arch_pfn = 0x400000000 Nov 05 14:15:08 arch001 kernel: MTRR default type: uncachable Nov 05 14:15:08 arch001 kernel: MTRR variable ranges disabled: Nov 05 14:15:08 arch001 kernel: x86/PAT: Configuration [0-7]: WB WC UC- UC WB WC UC- WT Nov 05 14:15:08 arch001 kernel: MTRR: Disabled Nov 05 14:15:08 arch001 kernel: CPU MTRRs all blank - virtualized system. Nov 05 14:15:08 arch001 kernel: e820: last_pfn = 0xdfff0 max_arch_pfn = 0x400000000 Nov 05 14:15:08 arch001 kernel: found SMP MP-table at [mem 0x0009fff0-0x0009ffff] mapped at [ffff88000009fff0] Nov 05 14:15:08 arch001 kernel: Scanning 1 areas for low memory corruption Nov 05 14:15:08 arch001 kernel: Base memory trampoline at [ffff880000099000] 99000 size 24576 Nov 05 14:15:08 arch001 kernel: init_memory_mapping: [mem 0x00000000-0x000fffff] Nov 05 14:15:08 arch001 kernel: [mem 0x00000000-0x000fffff] page 4k Nov 05 14:15:08 arch001 kernel: BRK [0x01b36000, 0x01b36fff] PGTABLE Nov 05 14:15:08 arch001 kernel: BRK [0x01b37000, 0x01b37fff] PGTABLE Nov 05 14:15:08 arch001 kernel: BRK [0x01b38000, 0x01b38fff] PGTABLE Nov 05 14:15:08 arch001 kernel: init_memory_mapping: [mem 0x11fe00000-0x11fffffff] Nov 05 14:15:08 arch001 kernel: [mem 0x11fe00000-0x11fffffff] page 2M Nov 05 14:15:08 arch001 kernel: BRK [0x01b39000, 0x01b39fff] PGTABLE Nov 05 14:15:08 arch001 kernel: init_memory_mapping: [mem 0x100000000-0x11fdfffff] Nov 05 14:15:08 arch001 kernel: [mem 0x100000000-0x11fdfffff] page 2M Nov 05 14:15:08 arch001 kernel: init_memory_mapping: [mem 0x00100000-0xdffeffff] Nov 05 14:15:08 arch001 kernel: [mem 0x00100000-0x001fffff] page 4k Nov 05 14:15:08 arch001 kernel: [mem 0x00200000-0xdfdfffff] page 2M Nov 05 14:15:08 arch001 kernel: [mem 0xdfe00000-0xdffeffff] page 4k Nov 05 14:15:08 arch001 kernel: RAMDISK: [mem 0x37950000-0x37c9ffff] Nov 05 14:15:08 arch001 kernel: ACPI: Early table checksum verification disabled Nov 05 14:15:08 arch001 kernel: ACPI: RSDP 0x00000000000E0000 000024 (v02 VBOX ) Nov 05 14:15:08 arch001 kernel: ACPI: XSDT 0x00000000DFFF0030 00003C (v01 VBOX VBOXXSDT 00000001 ASL 00000061) Nov 05 14:15:08 arch001 kernel: ACPI: FACP 0x00000000DFFF00F0 0000F4 (v04 VBOX VBOXFACP 00000001 ASL 00000061) Nov 05 14:15:08 arch001 kernel: ACPI: DSDT 0x00000000DFFF0470 001CEB (v01 VBOX VBOXBIOS 00000002 INTL 20100528) Nov 05 14:15:08 arch001 kernel: ACPI: FACS 0x00000000DFFF0200 000040 Nov 05 14:15:08 arch001 kernel: ACPI: FACS 0x00000000DFFF0200 000040 Nov 05 14:15:08 arch001 kernel: ACPI: APIC 0x00000000DFFF0240 000054 (v02 VBOX VBOXAPIC 00000001 ASL 00000061) Nov 05 14:15:08 arch001 kernel: ACPI: SSDT 0x00000000DFFF02A0 0001CC (v01 VBOX VBOXCPUT 00000002 INTL 20100528) Nov 05 14:15:09 arch001 kernel: ACPI: Local APIC address 0xfee00000 Nov 05 14:15:09 arch001 kernel: No NUMA configuration found Nov 05 14:15:09 arch001 kernel: Faking a node at [mem 0x0000000000000000-0x000000011fffffff] Nov 05 14:15:09 arch001 kernel: NODE_DATA(0) allocated [mem 0x11fff8000-0x11fffbfff] Nov 05 14:15:09 arch001 kernel: kvm-clock: Using msrs 4b564d01 and 4b564d00 Nov 05 14:15:09 arch001 kernel: kvm-clock: cpu 0, msr 1:1fff6001, primary cpu clock Nov 05 14:15:09 arch001 kernel: clocksource: kvm-clock: mask: 0xffffffffffffffff max_cycles: 0x1cd42e4dffb, max_idle_ns: 881590591483 ns Nov 05 14:15:09 arch001 kernel: [ffffea0000000000-ffffea00047fffff] PMD -> [ffff88011b600000-ffff88011f5fffff] on node 0 Nov 05 14:15:09 arch001 kernel: Zone ranges: Nov 05 14:15:09 arch001 kernel: DMA [mem 0x0000000000001000-0x0000000000ffffff] Nov 05 14:15:09 arch001 kernel: DMA32 [mem 0x0000000001000000-0x00000000ffffffff] Nov 05 14:15:09 arch001 kernel: Normal [mem 0x0000000100000000-0x000000011fffffff] Nov 05 14:15:09 arch001 kernel: Movable zone start for each node Nov 05 14:15:09 arch001 kernel: Early memory node ranges Nov 05 14:15:09 arch001 kernel: node 0: [mem 0x0000000000001000-0x000000000009efff] Nov 05 14:15:09 arch001 kernel: node 0: [mem 0x0000000000100000-0x00000000dffeffff] Nov 05 14:15:09 arch001 kernel: node 0: [mem 0x0000000100000000-0x000000011fffffff] Nov 05 14:15:09 arch001 kernel: Initmem setup node 0 [mem 0x0000000000001000-0x000000011fffffff] Nov 05 14:15:09 arch001 kernel: On node 0 totalpages: 1048462 Nov 05 14:15:09 arch001 kernel: DMA zone: 64 pages used for memmap Nov 05 14:15:09 arch001 kernel: DMA zone: 21 pages reserved Nov 05 14:15:09 arch001 kernel: DMA zone: 3998 pages, LIFO batch:0 Nov 05 14:15:09 arch001 kernel: DMA32 zone: 14272 pages used for memmap Nov 05 14:15:09 arch001 kernel: DMA32 zone: 913392 pages, LIFO batch:31 Nov 05 14:15:09 arch001 kernel: Normal zone: 2048 pages used for memmap Nov 05 14:15:09 arch001 kernel: Normal zone: 131072 pages, LIFO batch:31 Nov 05 14:15:09 arch001 kernel: ACPI: PM-Timer IO Port: 0x4008 Nov 05 14:15:09 arch001 kernel: ACPI: Local APIC address 0xfee00000 Nov 05 14:15:09 arch001 kernel: IOAPIC[0]: apic_id 1, version 17, address 0xfec00000, GSI 0-23 Nov 05 14:15:09 arch001 kernel: ACPI: INT_SRC_OVR (bus 0 bus_irq 0 global_irq 2 dfl dfl) Nov 05 14:15:09 arch001 kernel: ACPI: INT_SRC_OVR (bus 0 bus_irq 9 global_irq 9 high level) Nov 05 14:15:09 arch001 kernel: ACPI: IRQ0 used by override. Nov 05 14:15:09 arch001 kernel: ACPI: IRQ9 used by override. Nov 05 14:15:09 arch001 kernel: Using ACPI (MADT) for SMP configuration information Nov 05 14:15:09 arch001 kernel: smpboot: Allowing 1 CPUs, 0 hotplug CPUs Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0x00000000-0x00000fff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0xdfff0000-0xdfffffff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0xe0000000-0xfffbffff] Nov 05 14:15:09 arch001 kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 05 14:15:09 arch001 kernel: e820: [mem 0xe0000000-0xfffbffff] available for PCI devices Nov 05 14:15:09 arch001 kernel: Booting paravirtualized kernel on KVM Nov 05 14:15:09 arch001 kernel: clocksource: refined-jiffies: mask: 0xffffffff max_cycles: 0xffffffff, max_idle_ns: 6370452778343963 ns Nov 05 14:15:09 arch001 kernel: setup_percpu: NR_CPUS:128 nr_cpumask_bits:128 nr_cpu_ids:1 nr_node_ids:1 Nov 05 14:15:09 arch001 kernel: PERCPU: Embedded 32 pages/cpu @ffff88011fc00000 s91480 r8192 d31400 u2097152 Nov 05 14:15:09 arch001 kernel: pcpu-alloc: s91480 r8192 d31400 u2097152 alloc=1*2097152 Nov 05 14:15:09 arch001 kernel: pcpu-alloc: [0] 0 Nov 05 14:15:09 arch001 kernel: Built 1 zonelists in Node order, mobility grouping on. Total pages: 1032057 Nov 05 14:15:09 arch001 kernel: Policy zone: Normal Nov 05 14:15:09 arch001 kernel: Kernel command line: BOOT_IMAGE=/boot/vmlinuz-linux root=UUID=192d2bbd-3085-44e1-988a-4f93f1303d61 rw quiet Nov 05 14:15:09 arch001 kernel: PID hash table entries: 4096 (order: 3, 32768 bytes) Nov 05 14:15:09 arch001 kernel: Calgary: detecting Calgary via BIOS EBDA area Nov 05 14:15:09 arch001 kernel: Calgary: Unable to locate Rio Grande table in EBDA - bailing! Nov 05 14:15:09 arch001 kernel: Memory: 4046864K/4193848K available (5611K kernel code, 922K rwdata, 1768K rodata, 1180K init, 1152K bss, 146984K reserved, 0K cma-reserved) Nov 05 14:15:09 arch001 kernel: SLUB: HWalign=64, Order=0-3, MinObjects=0, CPUs=1, Nodes=1 Nov 05 14:15:09 arch001 kernel: Preemptible hierarchical RCU implementation. Nov 05 14:15:09 arch001 kernel: Build-time adjustment of leaf fanout to 64. Nov 05 14:15:09 arch001 kernel: RCU restricting CPUs from NR_CPUS=128 to nr_cpu_ids=1. Nov 05 14:15:09 arch001 kernel: RCU: Adjusting geometry for rcu_fanout_leaf=64, nr_cpu_ids=1 Nov 05 14:15:09 arch001 kernel: NR_IRQS:8448 nr_irqs:256 16 Nov 05 14:15:09 arch001 kernel: Console: colour dummy device 80x25 Nov 05 14:15:09 arch001 kernel: console [tty0] enabled Nov 05 14:15:09 arch001 kernel: tsc: Detected 2691.260 MHz processor Nov 05 14:15:09 arch001 kernel: Calibrating delay loop (skipped) preset value.. 5384.79 BogoMIPS (lpj=8970866) Nov 05 14:15:09 arch001 kernel: pid_max: default: 32768 minimum: 301 Nov 05 14:15:09 arch001 kernel: ACPI: Core revision 20150619 Nov 05 14:15:09 arch001 kernel: ACPI: All ACPI Tables successfully acquired Nov 05 14:15:09 arch001 kernel: Security Framework initialized Nov 05 14:15:09 arch001 kernel: Yama: becoming mindful. Nov 05 14:15:09 arch001 kernel: Dentry cache hash table entries: 524288 (order: 10, 4194304 bytes) Nov 05 14:15:09 arch001 kernel: Inode-cache hash table entries: 262144 (order: 9, 2097152 bytes) Nov 05 14:15:09 arch001 kernel: Mount-cache hash table entries: 8192 (order: 4, 65536 bytes) Nov 05 14:15:09 arch001 kernel: Mountpoint-cache hash table entries: 8192 (order: 4, 65536 bytes) Nov 05 14:15:09 arch001 kernel: Initializing cgroup subsys blkio Nov 05 14:15:09 arch001 kernel: Initializing cgroup subsys memory Nov 05 14:15:09 arch001 kernel: Initializing cgroup subsys devices Nov 05 14:15:09 arch001 kernel: Initializing cgroup subsys freezer Nov 05 14:15:09 arch001 kernel: Initializing cgroup subsys net_cls Nov 05 14:15:09 arch001 kernel: CPU: Physical Processor ID: 0 Nov 05 14:15:09 arch001 kernel: mce: CPU supports 0 MCE banks Nov 05 14:15:09 arch001 kernel: process: using mwait in idle threads Nov 05 14:15:09 arch001 kernel: Last level iTLB entries: 4KB 512, 2MB 8, 4MB 8 Nov 05 14:15:09 arch001 kernel: Last level dTLB entries: 4KB 512, 2MB 32, 4MB 32, 1GB 0 Nov 05 14:15:09 arch001 kernel: Freeing SMP alternatives memory: 20K (ffffffff81a0f000 - ffffffff81a14000) Nov 05 14:15:09 arch001 kernel: ftrace: allocating 22161 entries in 87 pages Nov 05 14:15:09 arch001 kernel: ..TIMER: vector=0x30 apic1=0 pin1=2 apic2=-1 pin2=-1 Nov 05 14:15:09 arch001 kernel: smpboot: CPU0: Intel(R) Core(TM) i7-3740QM CPU @ 2.70GHz (fam: 06, model: 3a, stepping: 09) Nov 05 14:15:09 arch001 kernel: Performance Events: unsupported p6 CPU model 58 no PMU driver, software events only. Nov 05 14:15:09 arch001 kernel: x86: Booted up 1 node, 1 CPUs Nov 05 14:15:09 arch001 kernel: smpboot: Total of 1 processors activated (5384.79 BogoMIPS) Nov 05 14:15:09 arch001 kernel: devtmpfs: initialized Nov 05 14:15:09 arch001 kernel: clocksource: jiffies: mask: 0xffffffff max_cycles: 0xffffffff, max_idle_ns: 6370867519511994 ns Nov 05 14:15:09 arch001 kernel: pinctrl core: initialized pinctrl subsystem Nov 05 14:15:09 arch001 kernel: RTC time: 14:14:52, date: 11/05/15 Nov 05 14:15:09 arch001 kernel: NET: Registered protocol family 16 Nov 05 14:15:09 arch001 kernel: cpuidle: using governor ladder Nov 05 14:15:09 arch001 kernel: cpuidle: using governor menu Nov 05 14:15:09 arch001 kernel: ACPI: bus type PCI registered Nov 05 14:15:09 arch001 kernel: acpiphp: ACPI Hot Plug PCI Controller Driver version: 0.5 Nov 05 14:15:09 arch001 kernel: PCI: Using configuration type 1 for base access Nov 05 14:15:09 arch001 kernel: ACPI: Added _OSI(Module Device) Nov 05 14:15:09 arch001 kernel: ACPI: Added _OSI(Processor Device) Nov 05 14:15:09 arch001 kernel: ACPI: Added _OSI(3.0 _SCP Extensions) Nov 05 14:15:09 arch001 kernel: ACPI: Added _OSI(Processor Aggregator Device) Nov 05 14:15:09 arch001 kernel: ACPI: Executed 1 blocks of module-level executable AML code Nov 05 14:15:09 arch001 kernel: ACPI: Interpreter enabled Nov 05 14:15:09 arch001 kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S1_] (20150619/hwxface-580) Nov 05 14:15:09 arch001 kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S2_] (20150619/hwxface-580) Nov 05 14:15:09 arch001 kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S3_] (20150619/hwxface-580) Nov 05 14:15:09 arch001 kernel: ACPI Exception: AE_NOT_FOUND, While evaluating Sleep State [\_S4_] (20150619/hwxface-580) Nov 05 14:15:09 arch001 kernel: ACPI: (supports S0 S5) Nov 05 14:15:09 arch001 kernel: ACPI: Using IOAPIC for interrupt routing Nov 05 14:15:09 arch001 kernel: PCI: Using host bridge windows from ACPI; if necessary, use "pci=nocrs" and report a bug Nov 05 14:15:09 arch001 kernel: ACPI: PCI Root Bridge [PCI0] (domain 0000 [bus 00-ff]) Nov 05 14:15:09 arch001 kernel: acpi PNP0A03:00: _OSC: OS supports [ASPM ClockPM Segments MSI] Nov 05 14:15:09 arch001 kernel: acpi PNP0A03:00: _OSC failed (AE_NOT_FOUND); disabling ASPM Nov 05 14:15:09 arch001 kernel: acpi PNP0A03:00: fail to add MMCONFIG information, can't access extended PCI configuration space under this bridge. Nov 05 14:15:09 arch001 kernel: PCI host bridge to bus 0000:00 Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: root bus resource [bus 00-ff] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: root bus resource [io 0x0000-0x0cf7 window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: root bus resource [io 0x0d00-0xffff window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: root bus resource [mem 0x000a0000-0x000bffff window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: root bus resource [mem 0xe0000000-0xffdfffff window] Nov 05 14:15:09 arch001 kernel: pci 0000:00:00.0: [8086:1237] type 00 class 0x060000 Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.0: [8086:7000] type 00 class 0x060100 Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: [8086:7111] type 00 class 0x01018a Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: reg 0x20: [io 0xd000-0xd00f] Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: legacy IDE quirk: reg 0x10: [io 0x01f0-0x01f7] Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: legacy IDE quirk: reg 0x14: [io 0x03f6] Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: legacy IDE quirk: reg 0x18: [io 0x0170-0x0177] Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.1: legacy IDE quirk: reg 0x1c: [io 0x0376] Nov 05 14:15:09 arch001 kernel: pci 0000:00:02.0: [80ee:beef] type 00 class 0x030000 Nov 05 14:15:09 arch001 kernel: pci 0000:00:02.0: reg 0x10: [mem 0xe0000000-0xe0ffffff pref] Nov 05 14:15:09 arch001 kernel: pci 0000:00:03.0: [8086:100e] type 00 class 0x020000 Nov 05 14:15:09 arch001 kernel: pci 0000:00:03.0: reg 0x10: [mem 0xf0000000-0xf001ffff] Nov 05 14:15:09 arch001 kernel: pci 0000:00:03.0: reg 0x18: [io 0xd010-0xd017] Nov 05 14:15:09 arch001 kernel: pci 0000:00:04.0: [80ee:cafe] type 00 class 0x088000 Nov 05 14:15:09 arch001 kernel: pci 0000:00:04.0: reg 0x10: [io 0xd020-0xd03f] Nov 05 14:15:09 arch001 kernel: pci 0000:00:04.0: reg 0x14: [mem 0xf0400000-0xf07fffff] Nov 05 14:15:09 arch001 kernel: pci 0000:00:04.0: reg 0x18: [mem 0xf0800000-0xf0803fff pref] Nov 05 14:15:09 arch001 kernel: pci 0000:00:05.0: [8086:2415] type 00 class 0x040100 Nov 05 14:15:09 arch001 kernel: pci 0000:00:05.0: reg 0x10: [io 0xd100-0xd1ff] Nov 05 14:15:09 arch001 kernel: pci 0000:00:05.0: reg 0x14: [io 0xd200-0xd23f] Nov 05 14:15:09 arch001 kernel: pci 0000:00:06.0: [106b:003f] type 00 class 0x0c0310 Nov 05 14:15:09 arch001 kernel: pci 0000:00:06.0: reg 0x10: [mem 0xf0804000-0xf0804fff] Nov 05 14:15:09 arch001 kernel: pci 0000:00:07.0: [8086:7113] type 00 class 0x068000 Nov 05 14:15:09 arch001 kernel: pci 0000:00:0d.0: [8086:2829] type 00 class 0x010601 Nov 05 14:15:09 arch001 kernel: pci 0000:00:0d.0: reg 0x10: [io 0xd240-0xd247] Nov 05 14:15:09 arch001 kernel: pci 0000:00:0d.0: reg 0x18: [io 0xd250-0xd257] Nov 05 14:15:09 arch001 kernel: pci 0000:00:0d.0: reg 0x20: [io 0xd260-0xd26f] Nov 05 14:15:09 arch001 kernel: pci 0000:00:0d.0: reg 0x24: [mem 0xf0806000-0xf0807fff] Nov 05 14:15:09 arch001 kernel: ACPI: PCI Interrupt Link [LNKA] (IRQs 5 9 10 *11) Nov 05 14:15:09 arch001 kernel: ACPI: PCI Interrupt Link [LNKB] (IRQs 5 9 10 *11) Nov 05 14:15:09 arch001 kernel: ACPI: PCI Interrupt Link [LNKC] (IRQs 5 9 *10 11) Nov 05 14:15:09 arch001 kernel: ACPI: PCI Interrupt Link [LNKD] (IRQs 5 *9 10 11) Nov 05 14:15:09 arch001 kernel: ACPI: Enabled 2 GPEs in block 00 to 07 Nov 05 14:15:09 arch001 kernel: vgaarb: setting as boot device: PCI:0000:00:02.0 Nov 05 14:15:09 arch001 kernel: vgaarb: device added: PCI:0000:00:02.0,decodes=io+mem,owns=io+mem,locks=none Nov 05 14:15:09 arch001 kernel: vgaarb: loaded Nov 05 14:15:09 arch001 kernel: vgaarb: bridge control possible 0000:00:02.0 Nov 05 14:15:09 arch001 kernel: PCI: Using ACPI for IRQ routing Nov 05 14:15:09 arch001 kernel: PCI: pci_cache_line_size set to 64 bytes Nov 05 14:15:09 arch001 kernel: e820: reserve RAM buffer [mem 0x0009fc00-0x0009ffff] Nov 05 14:15:09 arch001 kernel: e820: reserve RAM buffer [mem 0xdfff0000-0xdfffffff] Nov 05 14:15:09 arch001 kernel: NetLabel: Initializing Nov 05 14:15:09 arch001 kernel: NetLabel: domain hash size = 128 Nov 05 14:15:09 arch001 kernel: NetLabel: protocols = UNLABELED CIPSOv4 Nov 05 14:15:09 arch001 kernel: NetLabel: unlabeled traffic allowed by default Nov 05 14:15:09 arch001 kernel: clocksource: Switched to clocksource kvm-clock Nov 05 14:15:09 arch001 kernel: pnp: PnP ACPI init Nov 05 14:15:09 arch001 kernel: pnp 00:00: Plug and Play ACPI device, IDs PNP0303 (active) Nov 05 14:15:09 arch001 kernel: pnp 00:01: Plug and Play ACPI device, IDs PNP0f03 (active) Nov 05 14:15:09 arch001 kernel: pnp: PnP ACPI: found 2 devices Nov 05 14:15:09 arch001 kernel: clocksource: acpi_pm: mask: 0xffffff max_cycles: 0xffffff, max_idle_ns: 2085701024 ns Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: resource 4 [io 0x0000-0x0cf7 window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: resource 5 [io 0x0d00-0xffff window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: resource 6 [mem 0x000a0000-0x000bffff window] Nov 05 14:15:09 arch001 kernel: pci_bus 0000:00: resource 7 [mem 0xe0000000-0xffdfffff window] Nov 05 14:15:09 arch001 kernel: NET: Registered protocol family 2 Nov 05 14:15:09 arch001 kernel: TCP established hash table entries: 32768 (order: 6, 262144 bytes) Nov 05 14:15:09 arch001 kernel: TCP bind hash table entries: 32768 (order: 7, 524288 bytes) Nov 05 14:15:09 arch001 kernel: TCP: Hash tables configured (established 32768 bind 32768) Nov 05 14:15:09 arch001 kernel: UDP hash table entries: 2048 (order: 4, 65536 bytes) Nov 05 14:15:09 arch001 kernel: UDP-Lite hash table entries: 2048 (order: 4, 65536 bytes) Nov 05 14:15:09 arch001 kernel: NET: Registered protocol family 1 Nov 05 14:15:09 arch001 kernel: pci 0000:00:00.0: Limiting direct PCI/PCI transfers Nov 05 14:15:09 arch001 kernel: pci 0000:00:01.0: Activating ISA DMA hang workarounds Nov 05 14:15:09 arch001 kernel: pci 0000:00:02.0: Video device with shadowed ROM Nov 05 14:15:09 arch001 kernel: PCI: CLS 0 bytes, default 64 Nov 05 14:15:09 arch001 kernel: Unpacking initramfs... Nov 05 14:15:09 arch001 kernel: Freeing initrd memory: 3392K (ffff880037950000 - ffff880037ca0000) Nov 05 14:15:09 arch001 kernel: PCI-DMA: Using software bounce buffering for IO (SWIOTLB) Nov 05 14:15:09 arch001 kernel: software IO TLB [mem 0xdbff0000-0xdfff0000] (64MB) mapped at [ffff8800dbff0000-ffff8800dffeffff] Nov 05 14:15:09 arch001 kernel: platform rtc_cmos: registered platform RTC device (no PNP device found) Nov 05 14:15:09 arch001 kernel: RAPL PMU detected, API unit is 2^-32 Joules, 3 fixed counters 10737418240 ms ovfl timer Nov 05 14:15:09 arch001 kernel: hw unit of domain pp0-core 2^-0 Joules Nov 05 14:15:09 arch001 kernel: hw unit of domain package 2^-0 Joules Nov 05 14:15:09 arch001 kernel: hw unit of domain pp1-gpu 2^-0 Joules Nov 05 14:15:09 arch001 kernel: microcode: CPU0 sig=0x306a9, pf=0x2, revision=0x19 Nov 05 14:15:09 arch001 kernel: microcode: Microcode Update Driver: v2.00 <..hidden..>, Peter Oruba Nov 05 14:15:09 arch001 kernel: Scanning for low memory corruption every 60 seconds Nov 05 14:15:09 arch001 kernel: futex hash table entries: 256 (order: 2, 16384 bytes) Nov 05 14:15:09 arch001 kernel: Initialise system trusted keyring Nov 05 14:15:09 arch001 kernel: HugeTLB registered 2 MB page size, pre-allocated 0 pages Nov 05 14:15:09 arch001 kernel: zpool: loaded Nov 05 14:15:09 arch001 kernel: zbud: loaded Nov 05 14:15:09 arch001 kernel: VFS: Disk quotas dquot_6.6.0 Nov 05 14:15:09 arch001 kernel: VFS: Dquot-cache hash table entries: 512 (order 0, 4096 bytes) Nov 05 14:15:09 arch001 kernel: Key type big_key registered Nov 05 14:15:09 arch001 kernel: Block layer SCSI generic (bsg) driver version 0.4 loaded (major 250) Nov 05 14:15:09 arch001 kernel: io scheduler noop registered Nov 05 14:15:09 arch001 kernel: io scheduler deadline registered Nov 05 14:15:09 arch001 kernel: io scheduler cfq registered (default) Nov 05 14:15:09 arch001 kernel: pci_hotplug: PCI Hot Plug PCI Core version: 0.5 Nov 05 14:15:09 arch001 kernel: pciehp: PCI Express Hot Plug Controller Driver version: 0.4 Nov 05 14:15:09 arch001 kernel: vesafb: mode is 640x480x32, linelength=2560, pages=0 Nov 05 14:15:09 arch001 kernel: vesafb: scrolling: redraw Nov 05 14:15:09 arch001 kernel: vesafb: Truecolor: size=8:8:8:8, shift=24:16:8:0 Nov 05 14:15:09 arch001 kernel: vesafb: framebuffer at 0xe0000000, mapped to 0xffffc90000800000, using 1216k, total 1216k Nov 05 14:15:09 arch001 kernel: Console: switching to colour frame buffer device 80x30 Nov 05 14:15:09 arch001 kernel: fb0: VESA VGA frame buffer device Nov 05 14:15:09 arch001 kernel: GHES: HEST is not enabled! Nov 05 14:15:09 arch001 kernel: Serial: 8250/16550 driver, 4 ports, IRQ sharing disabled Nov 05 14:15:09 arch001 kernel: Linux agpgart interface v0.103 Nov 05 14:15:09 arch001 kernel: rtc_cmos rtc_cmos: rtc core: registered rtc_cmos as rtc0 Nov 05 14:15:09 arch001 kernel: rtc_cmos rtc_cmos: alarms up to one day, 114 bytes nvram Nov 05 14:15:09 arch001 kernel: ledtrig-cpu: registered to indicate activity on CPUs Nov 05 14:15:09 arch001 kernel: NET: Registered protocol family 10 Nov 05 14:15:09 arch001 kernel: NET: Registered protocol family 17 Nov 05 14:15:09 arch001 kernel: Loading compiled-in X.509 certificates Nov 05 14:15:09 arch001 kernel: registered taskstats version 1 Nov 05 14:15:09 arch001 kernel: zswap: loading zswap Nov 05 14:15:09 arch001 kernel: zswap: using zbud pool Nov 05 14:15:09 arch001 kernel: zswap: using lzo compressor Nov 05 14:15:09 arch001 kernel: Magic number: 7:59:232 Nov 05 14:15:09 arch001 kernel: rtc_cmos rtc_cmos: setting system clock to 2015-11-05 14:14:52 UTC (1446732892) Nov 05 14:15:09 arch001 kernel: PM: Hibernation image not present or could not be loaded. Nov 05 14:15:09 arch001 kernel: Freeing unused kernel memory: 1180K (ffffffff818e8000 - ffffffff81a0f000) Nov 05 14:15:09 arch001 kernel: Write protecting the kernel read-only data: 8192k Nov 05 14:15:09 arch001 kernel: Freeing unused kernel memory: 520K (ffff88000157e000 - ffff880001600000) Nov 05 14:15:09 arch001 kernel: Freeing unused kernel memory: 280K (ffff8800017ba000 - ffff880001800000) Nov 05 14:15:09 arch001 kernel: random: systemd-tmpfile urandom read with 1 bits of entropy available Nov 05 14:15:09 arch001 kernel: SCSI subsystem initialized Nov 05 14:15:09 arch001 kernel: ACPI: bus type USB registered Nov 05 14:15:09 arch001 kernel: usbcore: registered new interface driver usbfs Nov 05 14:15:09 arch001 kernel: usbcore: registered new interface driver hub Nov 05 14:15:09 arch001 kernel: usbcore: registered new device driver usb Nov 05 14:15:09 arch001 kernel: ohci_hcd: USB 1.1 'Open' Host Controller (OHCI) Driver Nov 05 14:15:09 arch001 kernel: ohci-pci: OHCI PCI platform driver Nov 05 14:15:09 arch001 kernel: ohci-pci 0000:00:06.0: OHCI PCI host controller Nov 05 14:15:09 arch001 kernel: ohci-pci 0000:00:06.0: new USB bus registered, assigned bus number 1 Nov 05 14:15:09 arch001 kernel: ohci-pci 0000:00:06.0: irq 22, io mem 0xf0804000 Nov 05 14:15:09 arch001 kernel: i8042: PNP: PS/2 Controller [PNP0303:PS2K,PNP0f03:PS2M] at 0x60,0x64 irq 1,12 Nov 05 14:15:09 arch001 kernel: serio: i8042 KBD port at 0x60,0x64 irq 1 Nov 05 14:15:09 arch001 kernel: serio: i8042 AUX port at 0x60,0x64 irq 12 Nov 05 14:15:09 arch001 kernel: libata version 3.00 loaded. Nov 05 14:15:09 arch001 kernel: input: AT Translated Set 2 keyboard as /devices/platform/i8042/serio0/input/input0 Nov 05 14:15:09 arch001 kernel: hub 1-0:1.0: USB hub found Nov 05 14:15:09 arch001 kernel: hub 1-0:1.0: 12 ports detected Nov 05 14:15:09 arch001 kernel: ata_piix 0000:00:01.1: version 2.13 Nov 05 14:15:09 arch001 kernel: scsi host0: ata_piix Nov 05 14:15:09 arch001 kernel: scsi host1: ata_piix Nov 05 14:15:09 arch001 kernel: ata1: PATA max UDMA/33 cmd 0x1f0 ctl 0x3f6 bmdma 0xd000 irq 14 Nov 05 14:15:09 arch001 kernel: ata2: PATA max UDMA/33 cmd 0x170 ctl 0x376 bmdma 0xd008 irq 15 Nov 05 14:15:09 arch001 kernel: ahci 0000:00:0d.0: version 3.0 Nov 05 14:15:09 arch001 kernel: ahci 0000:00:0d.0: SSS flag set, parallel bus scan disabled Nov 05 14:15:09 arch001 kernel: ahci 0000:00:0d.0: AHCI 0001.0100 32 slots 1 ports 3 Gbps 0x1 impl SATA mode Nov 05 14:15:09 arch001 kernel: ahci 0000:00:0d.0: flags: 64bit ncq stag only ccc Nov 05 14:15:09 arch001 kernel: scsi host2: ahci Nov 05 14:15:09 arch001 kernel: ata3: SATA max UDMA/133 abar m8192@0xf0806000 port 0xf0806100 irq 21 Nov 05 14:15:09 arch001 kernel: ata2.00: ATAPI: VBOX CD-ROM, 1.0, max UDMA/133 Nov 05 14:15:09 arch001 kernel: ata2.00: configured for UDMA/33 Nov 05 14:15:09 arch001 kernel: scsi 1:0:0:0: CD-ROM VBOX CD-ROM 1.0 PQ: 0 ANSI: 5 Nov 05 14:15:09 arch001 kernel: ata3: SATA link up 3.0 Gbps (SStatus 123 SControl 300) Nov 05 14:15:09 arch001 kernel: ata3.00: ATA-6: VBOX HARDDISK, 1.0, max UDMA/133 Nov 05 14:15:09 arch001 kernel: ata3.00: 43620736 sectors, multi 128: LBA48 NCQ (depth 31/32) Nov 05 14:15:09 arch001 kernel: ata3.00: configured for UDMA/133 Nov 05 14:15:09 arch001 kernel: scsi 2:0:0:0: Direct-Access ATA VBOX HARDDISK 1.0 PQ: 0 ANSI: 5 Nov 05 14:15:09 arch001 kernel: sr 1:0:0:0: [sr0] scsi3-mmc drive: 32x/32x xa/form2 tray Nov 05 14:15:09 arch001 kernel: cdrom: Uniform CD-ROM driver Revision: 3.20 Nov 05 14:15:09 arch001 kernel: sr 1:0:0:0: Attached scsi CD-ROM sr0 Nov 05 14:15:09 arch001 kernel: sd 2:0:0:0: [sda] 43620736 512-byte logical blocks: (22.3 GB/20.7 GiB) Nov 05 14:15:09 arch001 kernel: sd 2:0:0:0: [sda] Write Protect is off Nov 05 14:15:09 arch001 kernel: sd 2:0:0:0: [sda] Mode Sense: 00 3a 00 00 Nov 05 14:15:09 arch001 kernel: sd 2:0:0:0: [sda] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA Nov 05 14:15:09 arch001 kernel: sda: sda1 sda2 Nov 05 14:15:09 arch001 kernel: sd 2:0:0:0: [sda] Attached SCSI disk Nov 05 14:15:09 arch001 kernel: usb 1-1: new full-speed USB device number 2 using ohci-pci Nov 05 14:15:09 arch001 kernel: hidraw: raw HID events driver (C) Jiri Kosina Nov 05 14:15:09 arch001 kernel: usbcore: registered new interface driver usbhid Nov 05 14:15:09 arch001 kernel: usbhid: USB HID core driver Nov 05 14:15:09 arch001 kernel: input: VirtualBox USB Tablet as /devices/pci0000:00/0000:00:06.0/usb1/1-1/1-1:1.0/0003:80EE:0021.0001/input/input2 Nov 05 14:15:09 arch001 kernel: hid-generic 0003:80EE:0021.0001: input,hidraw0: USB HID v1.10 Mouse [VirtualBox USB Tablet] on usb-0000:00:06.0-1/input0 Nov 05 14:15:09 arch001 kernel: tsc: Refined TSC clocksource calibration: 2688.535 MHz Nov 05 14:15:09 arch001 kernel: clocksource: tsc: mask: 0xffffffffffffffff max_cycles: 0x26c0efa138b, max_idle_ns: 440795204986 ns Nov 05 14:15:09 arch001 kernel: floppy0: no floppy controllers found Nov 05 14:15:09 arch001 kernel: work still pending Nov 05 14:15:09 arch001 kernel: EXT4-fs (sda1): mounted filesystem with ordered data mode. Opts: (null) Nov 05 14:15:09 arch001 kernel: random: nonblocking pool is initialized Nov 05 14:15:09 arch001 kernel: ip_tables: (C) 2000-2006 Netfilter Core Team Nov 05 14:15:09 arch001 systemd[1]: systemd 227 running in system mode. (+PAM -AUDIT -SELINUX -IMA -APPARMOR +SMACK -SYSVINIT +UTMP +LIBCRYPTSETUP +GCRYPT +GNUTLS +ACL +XZ +LZ4 +SECCOMP +BLKID -ELFUTILS +KMOD +IDN) Nov 05 14:15:09 arch001 systemd[1]: Detected virtualization oracle. Nov 05 14:15:09 arch001 systemd[1]: Detected architecture x86-64. Nov 05 14:15:09 arch001 systemd[1]: Set hostname to <arch001>. Nov 05 14:15:09 arch001 systemd[1]: display-manager.service: Cannot add dependency job, ignoring: Unit display-manager.service failed to load: No such file or directory. Nov 05 14:15:09 arch001 systemd[1]: Started Forward Password Requests to Wall Directory Watch. Nov 05 14:15:09 arch001 systemd[1]: Listening on /dev/initctl Compatibility Named Pipe. Nov 05 14:15:09 arch001 systemd[1]: Reached target Encrypted Volumes. Nov 05 14:15:09 arch001 systemd[1]: Created slice System Slice. Nov 05 14:15:09 arch001 systemd[1]: Created slice system-getty.slice. Nov 05 14:15:09 arch001 systemd[1]: Listening on Journal Socket (/dev/log). Nov 05 14:15:09 arch001 systemd[1]: Listening on Device-mapper event daemon FIFOs. Nov 05 14:15:09 arch001 systemd[1]: Listening on LVM2 metadata daemon socket. Nov 05 14:15:09 arch001 systemd[1]: Started Dispatch Password Requests to Console Directory Watch. Nov 05 14:15:09 arch001 systemd[1]: Reached target Paths. Nov 05 14:15:09 arch001 systemd[1]: Listening on udev Kernel Socket. Nov 05 14:15:09 arch001 systemd[1]: Set up automount Arbitrary Executable File Formats File System Automount Point. Nov 05 14:15:09 arch001 systemd[1]: Created slice User and Session Slice. Nov 05 14:15:09 arch001 systemd[1]: Reached target Slices. Nov 05 14:15:09 arch001 systemd[1]: Listening on udev Control Socket. Nov 05 14:15:09 arch001 systemd[1]: Reached target Remote File Systems. Nov 05 14:15:09 arch001 systemd[1]: Listening on Journal Socket. Nov 05 14:15:09 arch001 systemd[1]: Starting Setup Virtual Console... Nov 05 14:15:09 arch001 systemd[1]: Starting Load Kernel Modules... Nov 05 14:15:09 arch001 systemd[1]: Starting Create list of required static device nodes for the current kernel... Nov 05 14:15:09 arch001 systemd[1]: Mounting Debug File System... Nov 05 14:15:09 arch001 systemd[1]: Mounting Temporary Directory... Nov 05 14:15:09 arch001 systemd[1]: Mounting Huge Pages File System... Nov 05 14:15:09 arch001 systemd[1]: Mounting POSIX Message Queue File System... Nov 05 14:15:09 arch001 systemd[1]: Starting Journal Service... Nov 05 14:15:09 arch001 systemd[1]: Starting Remount Root and Kernel File Systems... Nov 05 14:15:09 arch001 systemd[1]: Started Setup Virtual Console. Nov 05 14:15:09 arch001 systemd[1]: Started Create list of required static device nodes for the current kernel. Nov 05 14:15:09 arch001 systemd[1]: Mounted POSIX Message Queue File System. Nov 05 14:15:09 arch001 systemd[1]: Mounted Temporary Directory. Nov 05 14:15:09 arch001 kernel: EXT4-fs (sda1): re-mounted. Opts: data=ordered Nov 05 14:15:09 arch001 systemd[1]: Mounted Debug File System. Nov 05 14:15:09 arch001 systemd[1]: Mounted Huge Pages File System. Nov 05 14:15:09 arch001 systemd[1]: Started Remount Root and Kernel File Systems. Nov 05 14:15:09 arch001 systemd[1]: Starting udev Coldplug all Devices... Nov 05 14:15:09 arch001 systemd[1]: Starting Load/Save Random Seed... Nov 05 14:15:09 arch001 systemd[1]: Starting Create Static Device Nodes in /dev... Nov 05 14:15:09 arch001 kernel: VbgdCommonInitDevExt: Setting up heartbeat to trigger every 2000 milliseconds Nov 05 14:15:09 arch001 kernel: input: Unspecified device as /devices/pci0000:00/0000:00:04.0/input/input3 Nov 05 14:15:09 arch001 kernel: vboxguest: misc device minor 58, IRQ 20, I/O port d020, MMIO at 00000000f0400000 (size 0x400000) Nov 05 14:15:09 arch001 kernel: vboxguest: Successfully loaded version 5.0.8_OSE (interface 0x00010004) Nov 05 14:15:09 arch001 kernel: vboxsf: Successfully loaded version 5.0.8_OSE (interface 0x00010004) Nov 05 14:15:09 arch001 systemd[1]: Started udev Coldplug all Devices. Nov 05 14:15:09 arch001 kernel: [drm] Initialized drm 1.1.0 20060810 Nov 05 14:15:09 arch001 systemd[1]: Started Load/Save Random Seed. Nov 05 14:15:09 arch001 kernel: [drm] Initialized vboxvideo 1.0.0 20090303 for 0000:00:02.0 on minor 0 Nov 05 14:15:09 arch001 systemd[1]: Started Load Kernel Modules. Nov 05 14:15:09 arch001 systemd[1]: Mounting Configuration File System... Nov 05 14:15:09 arch001 systemd[1]: Starting Apply Kernel Variables... Nov 05 14:15:09 arch001 systemd[1]: Mounted Configuration File System. Nov 05 14:15:09 arch001 systemd[1]: Started Create Static Device Nodes in /dev. Nov 05 14:15:09 arch001 systemd[1]: Reached target Local File Systems (Pre). Nov 05 14:15:09 arch001 systemd[1]: Reached target Local File Systems. Nov 05 14:15:09 arch001 systemd[1]: Starting udev Kernel Device Manager... Nov 05 14:15:09 arch001 systemd[1]: Started Apply Kernel Variables. Nov 05 14:15:09 arch001 systemd[1]: Started udev Kernel Device Manager. Nov 05 14:15:09 arch001 kernel: input: Power Button as /devices/LNXSYSTM:00/LNXPWRBN:00/input/input4 Nov 05 14:15:09 arch001 kernel: ACPI: Power Button [PWRF] Nov 05 14:15:09 arch001 kernel: input: Sleep Button as /devices/LNXSYSTM:00/LNXSLPBN:00/input/input5 Nov 05 14:15:09 arch001 kernel: ACPI: Sleep Button [SLPF] Nov 05 14:15:09 arch001 kernel: ACPI: Video Device [GFX0] (multi-head: yes rom: no post: no) Nov 05 14:15:09 arch001 kernel: input: Video Bus as /devices/LNXSYSTM:00/LNXSYBUS:00/PNP0A03:00/LNXVIDEO:00/input/input6 Nov 05 14:15:09 arch001 kernel: ACPI: AC Adapter [AC] (on-line) Nov 05 14:15:09 arch001 kernel: ACPI: Battery Slot [BAT0] (battery present) Nov 05 14:15:09 arch001 kernel: piix4_smbus 0000:00:07.0: SMBus base address uninitialized - upgrade BIOS or use force_addr=0xaddr Nov 05 14:15:09 arch001 kernel: e1000: Intel(R) PRO/1000 Network Driver - version 7.3.21-k8-NAPI Nov 05 14:15:09 arch001 kernel: e1000: Copyright (c) 1999-2006 Intel Corporation. Nov 05 14:15:09 arch001 kernel: mousedev: PS/2 mouse device common for all mice Nov 05 14:15:09 arch001 kernel: input: PC Speaker as /devices/platform/pcspkr/input/input7 Nov 05 14:15:09 arch001 kernel: ppdev: user-space parallel port driver Nov 05 14:15:09 arch001 kernel: e1000 0000:00:03.0 eth0: (PCI:33MHz:32-bit) 08:00:27:f0:c7:ce Nov 05 14:15:09 arch001 kernel: e1000 0000:00:03.0 eth0: Intel(R) PRO/1000 Network Connection Nov 05 14:15:09 arch001 kernel: e1000 0000:00:03.0 enp0s3: renamed from eth0 Nov 05 14:15:09 arch001 kernel: AVX version of gcm_enc/dec engaged. Nov 05 14:15:09 arch001 kernel: AES CTR mode by8 optimization enabled Nov 05 14:15:09 arch001 kernel: input: ImExPS/2 Generic Explorer Mouse as /devices/platform/i8042/serio1/input/input8 Nov 05 14:15:09 arch001 kernel: snd_intel8x0 0000:00:05.0: disable (unknown or VT-d) VM optimization Nov 05 14:15:09 arch001 systemd[1]: Found device VBOX_HARDDISK 2. Nov 05 14:15:09 arch001 systemd[1]: Activating swap /dev/sda2... Nov 05 14:15:09 arch001 kernel: intel_rapl: no valid rapl domains found in package 0 Nov 05 14:15:09 arch001 kernel: snd_intel8x0 0000:00:05.0: white list rate for 1028:0177 is 48000 Nov 05 14:15:09 arch001 systemd[1]: Reached target Sound Card. Nov 05 14:15:09 arch001 kernel: Adding 1887228k swap on /dev/sda2. Priority:-1 extents:1 across:1887228k FS Nov 05 14:15:09 arch001 systemd[1]: Activated swap /dev/sda2. Nov 05 14:15:09 arch001 systemd[1]: Reached target Swap. Nov 05 14:15:09 arch001 systemd-journald[138]: Journal started Nov 05 14:15:09 arch001 systemd[1]: Started Journal Service. Nov 05 14:15:09 arch001 systemd-modules-load[132]: Inserted module 'vboxguest' Nov 05 14:15:09 arch001 systemd-modules-load[132]: Inserted module 'vboxsf' Nov 05 14:15:03 arch001 systemd-modules-load[132]: Inserted module 'vboxvideo' Nov 05 14:15:09 arch001 systemd[1]: Starting Flush Journal to Persistent Storage... Nov 05 14:15:10 arch001 systemd[1]: Started Flush Journal to Persistent Storage. Nov 05 14:15:10 arch001 systemd[1]: Starting Create Volatile Files and Directories... Nov 05 14:15:10 arch001 systemd[1]: Started Create Volatile Files and Directories. Nov 05 14:15:10 arch001 systemd[1]: Starting Update UTMP about System Boot/Shutdown... Nov 05 14:15:11 arch001 systemd[1]: Started Update UTMP about System Boot/Shutdown. Nov 05 14:15:11 arch001 systemd[1]: Reached target System Initialization. Nov 05 14:15:11 arch001 systemd[1]: Started Daily man-db cache update. Nov 05 14:15:11 arch001 systemd[1]: Listening on D-Bus System Message Bus Socket. Nov 05 14:15:11 arch001 systemd[1]: Reached target Sockets. Nov 05 14:15:11 arch001 systemd[1]: Started Daily verification of password and group files. Nov 05 14:15:11 arch001 systemd[1]: Started Daily Cleanup of Temporary Directories. Nov 05 14:15:11 arch001 systemd[1]: Started Daily rotation of log files. Nov 05 14:15:11 arch001 systemd[1]: Reached target Timers. Nov 05 14:15:11 arch001 systemd[1]: Reached target Basic System. Nov 05 14:15:11 arch001 systemd[1]: Starting dhcpcd on all interfaces... Nov 05 14:15:11 arch001 systemd[1]: Started D-Bus System Message Bus. Nov 05 14:15:11 arch001 kernel: floppy0: no floppy controllers found Nov 05 14:15:11 arch001 kernel: work still pending Nov 05 14:15:11 arch001 dhcpcd[215]: dev: loaded udev Nov 05 14:15:11 arch001 dhcpcd[215]: enp0s3: adding address fe80::e69f:6a1e:2f44:ec16 Nov 05 14:15:11 arch001 dhcpcd[215]: forked to background, child pid 226 Nov 05 14:15:12 arch001 kernel: e1000: enp0s3 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: RX Nov 05 14:15:12 arch001 dhcpcd[226]: enp0s3: waiting for carrier Nov 05 14:15:12 arch001 dhcpcd[226]: enp0s3: carrier acquired Nov 05 14:15:12 arch001 kernel: IPv6: ADDRCONF(NETDEV_UP): enp0s3: link is not ready Nov 05 14:15:12 arch001 kernel: IPv6: ADDRCONF(NETDEV_CHANGE): enp0s3: link becomes ready Nov 05 14:15:12 arch001 systemd[1]: Starting Permit User Sessions... Nov 05 14:15:12 arch001 systemd[1]: Starting Login Service... Nov 05 14:15:12 arch001 systemd[1]: Started dhcpcd on all interfaces. Nov 05 14:15:12 arch001 dhcpcd[226]: DUID 00:01:00:01:1d:c1:82:72:08:00:27:f0:c7:ce Nov 05 14:15:12 arch001 dhcpcd[226]: enp0s3: IAID 27:f0:c7:ce Nov 05 14:15:12 arch001 systemd[1]: Started Permit User Sessions. Nov 05 14:15:12 arch001 systemd[1]: Started Getty on tty1. Nov 05 14:15:12 arch001 systemd[1]: Reached target Login Prompts. Nov 05 14:15:12 arch001 systemd[1]: Listening on Load/Save RF Kill Switch Status /dev/rfkill Watch. Nov 05 14:15:12 arch001 systemd[1]: Reached target Network. Nov 05 14:15:12 arch001 systemd-logind[234]: New seat seat0. Nov 05 14:15:12 arch001 systemd-logind[234]: Watching system buttons on /dev/input/event3 (Power Button) Nov 05 14:15:12 arch001 systemd[1]: Started Login Service. Nov 05 14:15:12 arch001 systemd[1]: Reached target Multi-User System. Nov 05 14:15:12 arch001 systemd-logind[234]: Watching system buttons on /dev/input/event4 (Sleep Button) Nov 05 14:15:12 arch001 systemd[1]: Reached target Graphical Interface. Nov 05 14:15:12 arch001 systemd[1]: Startup finished in 7.383s (kernel) + 13.096s (userspace) = 20.479s. Nov 05 14:15:12 arch001 systemd-logind[234]: Watching system buttons on /dev/input/event5 (Video Bus) Nov 05 14:15:12 arch001 dhcpcd[226]: enp0s3: soliciting an IPv6 router Nov 05 14:15:13 arch001 dhcpcd[226]: enp0s3: rebinding lease of 10.0.2.15 Nov 05 14:15:13 arch001 dhcpcd[226]: enp0s3: probing static address 10.0.2.15/24 Nov 05 14:15:18 arch001 dhcpcd[226]: enp0s3: leased 10.0.2.15 for 86400 seconds Nov 05 14:15:18 arch001 dhcpcd[226]: enp0s3: adding route to 10.0.2.0/24 Nov 05 14:15:18 arch001 dhcpcd[226]: enp0s3: adding default route via 10.0.2.2 Nov 05 14:15:19 arch001 dhcpcd[226]: enp0s3: removing route to 10.0.2.0/24 Nov 05 14:15:26 arch001 dhcpcd[226]: enp0s3: no IPv6 Routers available Nov 05 14:16:25 arch001 login[236]: pam_unix(login:session): session opened for user jlb by LOGIN(uid=0) Nov 05 14:16:25 arch001 systemd[1]: Created slice user-1000.slice. Nov 05 14:16:25 arch001 systemd[1]: Starting User Manager for UID 1000... Nov 05 14:16:25 arch001 systemd-logind[234]: New session c1 of user jlb. Nov 05 14:16:25 arch001 systemd[1]: Started Session c1 of user jlb. Nov 05 14:16:26 arch001 systemd[297]: pam_unix(systemd-user:session): session opened for user jlb by (uid=0) Nov 05 14:16:26 arch001 systemd[297]: Reached target Paths. Nov 05 14:16:26 arch001 systemd[297]: Starting D-Bus User Message Bus Socket. Nov 05 14:16:26 arch001 login[236]: LOGIN ON tty1 BY jlb Nov 05 14:16:26 arch001 systemd[297]: Reached target Timers. Nov 05 14:16:26 arch001 systemd[297]: Listening on D-Bus User Message Bus Socket. Nov 05 14:16:26 arch001 systemd[297]: Reached target Sockets. Nov 05 14:16:26 arch001 systemd[297]: Reached target Basic System. Nov 05 14:16:26 arch001 systemd[297]: Reached target Default. Nov 05 14:16:26 arch001 systemd[297]: Startup finished in 159ms. Nov 05 14:16:26 arch001 systemd[1]: Started User Manager for UID 1000. Nov 05 14:16:31 arch001 systemd[297]: Started D-Bus User Message Bus. Nov 05 14:16:49 arch001 sudo[368]: jlb : TTY=pts/0 ; PWD=/home/jlb ; USER=root ; COMMAND=/usr/bin/sh unix/xinitjlb.sh Nov 05 14:16:49 arch001 sudo[368]: pam_unix(sudo:session): session opened for user root by jlb(uid=0) Nov 05 14:16:49 arch001 sudo[368]: pam_unix(sudo:session): session closed for user root Nov 05 14:30:01 arch001 systemd[1]: Starting Cleanup of Temporary Directories... Nov 05 14:30:02 arch001 systemd[1]: Started Cleanup of Temporary Directories. Nov 05 15:05:38 arch001 kernel: usb 1-1: USB disconnect, device number 2 Nov 05 15:05:39 arch001 kernel: usb 1-1: new full-speed USB device number 3 using ohci-pci Nov 05 15:05:39 arch001 kernel: input: VirtualBox USB Tablet as /devices/pci0000:00/0000:00:06.0/usb1/1-1/1-1:1.0/0003:80EE:0021.0002/input/input9 Nov 05 15:05:39 arch001 kernel: hid-generic 0003:80EE:0021.0002: input,hidraw0: USB HID v1.10 Mouse [VirtualBox USB Tablet] on usb-0000:00:06.0-1/input0 Nov 05 15:36:17 arch001 sudo[974]: jlb : TTY=pts/1 ; PWD=/home/jlb ; USER=root ; COMMAND=/usr/bin/systemctl start httpd.service Nov 05 15:36:17 arch001 sudo[974]: pam_unix(sudo:session): session opened for user root by jlb(uid=0) Nov 05 15:36:17 arch001 dbus[216]: [system] Activating via systemd: service name='org.freedesktop.PolicyKit1' unit='polkit.service' Nov 05 15:36:17 arch001 systemd[1]: Starting Authorization Manager... Nov 05 15:36:17 arch001 polkitd[980]: Started polkitd version 0.113 Nov 05 15:36:17 arch001 polkitd[980]: Loading rules from directory /etc/polkit-1/rules.d Nov 05 15:36:17 arch001 polkitd[980]: Loading rules from directory /usr/share/polkit-1/rules.d Nov 05 15:36:17 arch001 polkitd[980]: Finished loading, compiling and executing 1 rules Nov 05 15:36:17 arch001 dbus[216]: [system] Successfully activated service 'org.freedesktop.PolicyKit1' Nov 05 15:36:17 arch001 systemd[1]: Started Authorization Manager. Nov 05 15:36:17 arch001 polkitd[980]: Acquired the name org.freedesktop.PolicyKit1 on the system bus Nov 05 15:36:17 arch001 polkitd[980]: Registered Authentication Agent for unix-process:975:488511 (system bus name :1.5 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 15:36:17 arch001 systemd[1]: Starting Apache Web Server... Nov 05 15:36:22 arch001 apachectl[988]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 15:36:24 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 15:36:24 arch001 systemd[1]: Started Apache Web Server. Nov 05 15:36:24 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:975:488511 (system bus name :1.5, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 15:36:24 arch001 sudo[974]: pam_unix(sudo:session): session closed for user root Nov 05 15:36:51 arch001 su[1210]: (to root) jlb on pts/2 Nov 05 15:36:51 arch001 su[1210]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 15:37:42 arch001 sudo[1248]: jlb : TTY=pts/1 ; PWD=/home/jlb ; USER=root ; COMMAND=/usr/bin/systemctl restart httpd.service Nov 05 15:37:42 arch001 sudo[1248]: pam_unix(sudo:session): session opened for user root by jlb(uid=0) Nov 05 15:37:42 arch001 polkitd[980]: Registered Authentication Agent for unix-process:1249:497003 (system bus name :1.7 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 15:37:42 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 15:37:42 arch001 apachectl[1255]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 15:37:53 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 15:37:53 arch001 systemd[1]: Starting Apache Web Server... Nov 05 15:37:53 arch001 apachectl[1262]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 15:37:53 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 15:37:54 arch001 systemd[1]: Started Apache Web Server. Nov 05 15:37:54 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:1249:497003 (system bus name :1.7, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 15:37:54 arch001 sudo[1248]: pam_unix(sudo:session): session closed for user root Nov 05 15:44:08 arch001 su[1430]: (to root) jlb on pts/0 Nov 05 15:44:08 arch001 su[1430]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 15:44:44 arch001 sudo[1527]: jlb : TTY=pts/1 ; PWD=/home/jlb ; USER=root ; COMMAND=/usr/bin/systemctl restart httpd.service Nov 05 15:44:44 arch001 sudo[1527]: pam_unix(sudo:session): session opened for user root by jlb(uid=0) Nov 05 15:44:44 arch001 polkitd[980]: Registered Authentication Agent for unix-process:1528:539250 (system bus name :1.8 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 15:44:44 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 15:44:45 arch001 apachectl[1534]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 15:44:45 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 15:44:45 arch001 systemd[1]: Starting Apache Web Server... Nov 05 15:44:45 arch001 apachectl[1541]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 15:44:45 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 15:44:45 arch001 systemd[1]: Started Apache Web Server. Nov 05 15:44:45 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:1528:539250 (system bus name :1.8, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 15:44:45 arch001 sudo[1527]: pam_unix(sudo:session): session closed for user root Nov 05 15:45:17 arch001 dbus-daemon[341]: Activating service name='org.a11y.Bus' Nov 05 15:45:18 arch001 dbus-daemon[341]: Successfully activated service 'org.a11y.Bus' Nov 05 15:45:18 arch001 org.a11y.Bus[341]: Activating service name='org.a11y.atspi.Registry' Nov 05 15:45:18 arch001 org.a11y.Bus[341]: Successfully activated service 'org.a11y.atspi.Registry' Nov 05 15:45:18 arch001 org.a11y.atspi.Registry[1647]: SpiRegistry daemon is running with well-known name - org.a11y.atspi.Registry Nov 05 15:45:18 arch001 dbus-daemon[341]: Activating service name='org.gnome.GConf' Nov 05 15:45:18 arch001 dbus-daemon[341]: Successfully activated service 'org.gnome.GConf' Nov 05 16:05:42 arch001 sudo[1730]: jlb : TTY=pts/1 ; PWD=/home/jlb ; USER=root ; COMMAND=/usr/bin/systemctl restart httpd.service Nov 05 16:05:42 arch001 sudo[1730]: pam_unix(sudo:session): session opened for user root by jlb(uid=0) Nov 05 16:05:42 arch001 polkitd[980]: Registered Authentication Agent for unix-process:1731:664973 (system bus name :1.10 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 16:05:42 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 16:05:42 arch001 apachectl[1737]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:05:42 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 16:05:42 arch001 systemd[1]: Starting Apache Web Server... Nov 05 16:05:42 arch001 apachectl[1744]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:05:42 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 16:05:43 arch001 systemd[1]: Started Apache Web Server. Nov 05 16:05:43 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:1731:664973 (system bus name :1.10, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 16:05:43 arch001 sudo[1730]: pam_unix(sudo:session): session closed for user root Nov 05 16:07:32 arch001 su[1937]: pam_unix(su:auth): authentication failure; logname=jlb uid=1000 euid=0 tty=pts/1 ruser=jlb rhost= user=root Nov 05 16:07:34 arch001 su[1937]: FAILED SU (to root) jlb on pts/1 Nov 05 16:07:40 arch001 su[1938]: (to root) jlb on pts/1 Nov 05 16:07:40 arch001 su[1938]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 16:10:39 arch001 polkitd[980]: Registered Authentication Agent for unix-process:1944:694757 (system bus name :1.11 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 16:10:39 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 16:10:40 arch001 apachectl[1950]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:10:40 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 16:10:40 arch001 systemd[1]: Starting Apache Web Server... Nov 05 16:10:40 arch001 apachectl[1957]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:10:40 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 16:10:40 arch001 systemd[1]: Started Apache Web Server. Nov 05 16:10:40 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:1944:694757 (system bus name :1.11, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 16:12:42 arch001 polkitd[980]: Registered Authentication Agent for unix-process:2056:707061 (system bus name :1.12 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 16:12:42 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 16:12:43 arch001 apachectl[2062]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:12:43 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 16:12:43 arch001 systemd[1]: Starting Apache Web Server... Nov 05 16:12:43 arch001 apachectl[2069]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:12:43 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 16:12:44 arch001 systemd[1]: Started Apache Web Server. Nov 05 16:12:44 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:2056:707061 (system bus name :1.12, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 16:50:59 arch001 polkitd[980]: Registered Authentication Agent for unix-process:2232:936725 (system bus name :1.13 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 16:50:59 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 16:51:04 arch001 apachectl[2238]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:51:04 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 16:51:04 arch001 systemd[1]: Starting Apache Web Server... Nov 05 16:51:07 arch001 apachectl[2245]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:51:07 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 16:51:08 arch001 systemd[1]: Started Apache Web Server. Nov 05 16:51:08 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:2232:936725 (system bus name :1.13, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 16:51:48 arch001 polkitd[980]: Registered Authentication Agent for unix-process:2360:941615 (system bus name :1.14 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 16:51:48 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 16:51:48 arch001 apachectl[2366]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:51:48 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 16:51:48 arch001 systemd[1]: Starting Apache Web Server... Nov 05 16:51:49 arch001 apachectl[2373]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 16:51:49 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 16:51:49 arch001 systemd[1]: Started Apache Web Server. Nov 05 16:51:49 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:2360:941615 (system bus name :1.14, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 17:03:01 arch001 su[2505]: (to postgres) jlb on pts/1 Nov 05 17:03:01 arch001 su[2505]: pam_unix(su-l:session): session opened for user postgres by jlb(uid=0) Nov 05 17:03:15 arch001 su[2505]: pam_unix(su-l:session): session closed for user postgres Nov 05 17:03:25 arch001 polkitd[980]: Registered Authentication Agent for unix-process:2510:1011304 (system bus name :1.15 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 17:03:25 arch001 systemd[1]: Starting PostgreSQL database server... Nov 05 17:03:25 arch001 postgres[2519]: LOG: database system was shut down at 2015-11-04 23:16:59 UTC Nov 05 17:03:26 arch001 postgres[2519]: LOG: MultiXact member wraparound protections are now enabled Nov 05 17:03:26 arch001 postgres[2519]: LOG: database system is ready to accept connections Nov 05 17:03:26 arch001 postgres[2519]: LOG: autovacuum launcher started Nov 05 17:03:26 arch001 systemd[1]: Started PostgreSQL database server. Nov 05 17:03:26 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:2510:1011304 (system bus name :1.15, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 17:03:34 arch001 su[2531]: (to postgres) jlb on pts/1 Nov 05 17:03:34 arch001 su[2531]: pam_unix(su-l:session): session opened for user postgres by jlb(uid=0) Nov 05 17:05:53 arch001 postgres[2519]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 17:05:53 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 17:05:53 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 17:05:54 arch001 postgres[2519]: FATAL: database "testlsmb001" does not exist Nov 05 17:05:54 arch001 postgres[2519]: FATAL: database "testlsmb001" does not exist Nov 05 17:05:54 arch001 postgres[2519]: FATAL: database "testlsmb001" does not exist Nov 05 17:06:07 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 17:06:07 arch001 postgres[2519]: DETAIL: Key (class)=(internal) already exists. Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: relation "file_internal" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_internal ( Nov 05 17:06:07 arch001 postgres[2519]: check (file_class = 6), Nov 05 17:06:07 arch001 postgres[2519]: unique(id), Nov 05 17:06:07 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 17:06:07 arch001 postgres[2519]: check (ref_key = 0) Nov 05 17:06:07 arch001 postgres[2519]: ) inherits (file_base); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 17:06:07 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 17:06:07 arch001 postgres[2519]: are for internal use and against the company, not categorized.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 17:06:07 arch001 postgres[2519]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 17:06:07 arch001 postgres[2519]: company logos would be here.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 17:06:07 arch001 postgres[2519]: check (file_class = 7), Nov 05 17:06:07 arch001 postgres[2519]: unique(id), Nov 05 17:06:07 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 17:06:07 arch001 postgres[2519]: check (ref_key = 0) Nov 05 17:06:07 arch001 postgres[2519]: ) inherits (file_base); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 17:06:07 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 17:06:07 arch001 postgres[2519]: are for interal incoming use, not categorized.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 17:06:07 arch001 postgres[2519]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 17:06:07 arch001 postgres[2519]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: relation "lot_tracking_number" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 17:06:07 arch001 postgres[2519]: id serial not null unique, Nov 05 17:06:07 arch001 postgres[2519]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 17:06:07 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 17:06:07 arch001 postgres[2519]: qty numeric not null, Nov 05 17:06:07 arch001 postgres[2519]: stock_date date not null default now()::date Nov 05 17:06:07 arch001 postgres[2519]: ); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 17:06:07 arch001 postgres[2519]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 17:06:07 arch001 postgres[2519]: may change as we refactor the parts.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 17:06:07 arch001 postgres[2519]: id serial not null unique, Nov 05 17:06:07 arch001 postgres[2519]: mfg_lot_id int not null references mfg_lot(id), Nov 05 17:06:07 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 17:06:07 arch001 postgres[2519]: qty numeric not null Nov 05 17:06:07 arch001 postgres[2519]: ); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 17:06:07 arch001 postgres[2519]: $$ This tracks items used in assembly restocking.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: create table location_class_to_entity_class ( Nov 05 17:06:07 arch001 postgres[2519]: id serial unique, Nov 05 17:06:07 arch001 postgres[2519]: location_class int not null references location_class(id), Nov 05 17:06:07 arch001 postgres[2519]: entity_class int not null references entity_class(id) Nov 05 17:06:07 arch001 postgres[2519]: ); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 17:06:07 arch001 postgres[2519]: $$This determines which location classes go with which entity classes$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 17:06:07 arch001 postgres[2519]: (location_class, entity_class) Nov 05 17:06:07 arch001 postgres[2519]: SELECT lc.id, ec.id Nov 05 17:06:07 arch001 postgres[2519]: FROM entity_class ec Nov 05 17:06:07 arch001 postgres[2519]: cross Nov 05 17:06:07 arch001 postgres[2519]: join location_class lc Nov 05 17:06:07 arch001 postgres[2519]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 17:06:07 arch001 postgres[2519]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: function setting_get(unknown) does not exist at character 83 Nov 05 17:06:07 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: UPDATE entity_credit_account Nov 05 17:06:07 arch001 postgres[2519]: SET curr = (select s from unnest(string_to_array((setting_get('curr')).value, ':')) s limit 1) Nov 05 17:06:07 arch001 postgres[2519]: WHERE curr IS NULL; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 17:06:07 arch001 postgres[2519]: DETAIL: Key (id)=(90) already exists. Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 17:06:07 arch001 postgres[2519]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 17:06:07 arch001 postgres[2519]: (99, 156, 2, 'Product Receipt'); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute Nov 05 17:06:07 arch001 postgres[2519]: (id, node_id, attribute, value) VALUES Nov 05 17:06:07 arch001 postgres[2519]: (228, 90, 'module', 'template.pm'), Nov 05 17:06:07 arch001 postgres[2519]: (229, 90, 'action', 'display'), Nov 05 17:06:07 arch001 postgres[2519]: (230, 90, 'template_name', 'product_receipt'), Nov 05 17:06:07 arch001 postgres[2519]: (231, 90, 'format', 'tex'), Nov 05 17:06:07 arch001 postgres[2519]: (240, 99, 'module', 'template.pm'), Nov 05 17:06:07 arch001 postgres[2519]: (241, 99, 'action', 'display'), Nov 05 17:06:07 arch001 postgres[2519]: (242, 99, 'template_name', 'product_receipt'), Nov 05 17:06:07 arch001 postgres[2519]: (245, 99, 'format', 'html'); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "birthdate" of relation "person" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 17:06:07 arch001 postgres[2519]: WARNING: there is no transaction in progress Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "is_return" of relation "ar" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "is_return" of relation "ap" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 17:06:07 arch001 postgres[2519]: DETAIL: Key (id)=(129) already exists. Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 17:06:07 arch001 postgres[2519]: VALUES (129, 1, 7, 'Add Return'); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 17:06:07 arch001 postgres[2519]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 17:06:07 arch001 postgres[2519]: (252, 129, 'action', 'add'), Nov 05 17:06:07 arch001 postgres[2519]: (253, 129, 'type', 'customer_return'); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 17:06:07 arch001 postgres[2519]: where parts_id = invoice.parts_id Nov 05 17:06:07 arch001 postgres[2519]: AND credit_id = ( Nov 05 17:06:07 arch001 postgres[2519]: select entity_credit_account Nov 05 17:06:07 arch001 postgres[2519]: from ap Nov 05 17:06:07 arch001 postgres[2519]: where ap.id = invoice.trans_id Nov 05 17:06:07 arch001 postgres[2519]: ) Nov 05 17:06:07 arch001 postgres[2519]: ) Nov 05 17:06:07 arch001 postgres[2519]: WHERE trans_id in (select id from ap); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: column "category" of relation "account_heading" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: relation "account_translation" already exists Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_translation Nov 05 17:06:07 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_translation Nov 05 17:06:07 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 17:06:07 arch001 postgres[2519]: $$Translations for account descriptions.$$; Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 17:06:07 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 17:06:07 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 17:06:07 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:07 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 17:06:07 arch001 postgres[2519]: $$Translations for account heading descriptions.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 17:06:08 arch001 postgres[2519]: DETAIL: Key (class)=(internal) already exists. Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "file_internal" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_internal ( Nov 05 17:06:08 arch001 postgres[2519]: check (file_class = 6), Nov 05 17:06:08 arch001 postgres[2519]: unique(id), Nov 05 17:06:08 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 17:06:08 arch001 postgres[2519]: check (ref_key = 0) Nov 05 17:06:08 arch001 postgres[2519]: ) inherits (file_base); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 17:06:08 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 17:06:08 arch001 postgres[2519]: are for internal use and against the company, not categorized.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 17:06:08 arch001 postgres[2519]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 17:06:08 arch001 postgres[2519]: company logos would be here.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 17:06:08 arch001 postgres[2519]: check (file_class = 7), Nov 05 17:06:08 arch001 postgres[2519]: unique(id), Nov 05 17:06:08 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 17:06:08 arch001 postgres[2519]: check (ref_key = 0) Nov 05 17:06:08 arch001 postgres[2519]: ) inherits (file_base); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 17:06:08 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 17:06:08 arch001 postgres[2519]: are for interal incoming use, not categorized.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 17:06:08 arch001 postgres[2519]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 17:06:08 arch001 postgres[2519]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "lot_tracking_number" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 17:06:08 arch001 postgres[2519]: id serial not null unique, Nov 05 17:06:08 arch001 postgres[2519]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 17:06:08 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 17:06:08 arch001 postgres[2519]: qty numeric not null, Nov 05 17:06:08 arch001 postgres[2519]: stock_date date not null default now()::date Nov 05 17:06:08 arch001 postgres[2519]: ); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 17:06:08 arch001 postgres[2519]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 17:06:08 arch001 postgres[2519]: may change as we refactor the parts.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 17:06:08 arch001 postgres[2519]: id serial not null unique, Nov 05 17:06:08 arch001 postgres[2519]: mfg_lot_id int not null references mfg_lot(id), Nov 05 17:06:08 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 17:06:08 arch001 postgres[2519]: qty numeric not null Nov 05 17:06:08 arch001 postgres[2519]: ); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 17:06:08 arch001 postgres[2519]: $$ This tracks items used in assembly restocking.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "fixed_acc_trans" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: create table location_class_to_entity_class ( Nov 05 17:06:08 arch001 postgres[2519]: id serial unique, Nov 05 17:06:08 arch001 postgres[2519]: location_class int not null references location_class(id), Nov 05 17:06:08 arch001 postgres[2519]: entity_class int not null references entity_class(id) Nov 05 17:06:08 arch001 postgres[2519]: ); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 17:06:08 arch001 postgres[2519]: $$This determines which location classes go with which entity classes$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 17:06:08 arch001 postgres[2519]: (location_class, entity_class) Nov 05 17:06:08 arch001 postgres[2519]: SELECT lc.id, ec.id Nov 05 17:06:08 arch001 postgres[2519]: FROM entity_class ec Nov 05 17:06:08 arch001 postgres[2519]: cross Nov 05 17:06:08 arch001 postgres[2519]: join location_class lc Nov 05 17:06:08 arch001 postgres[2519]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 17:06:08 arch001 postgres[2519]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 17:06:08 arch001 postgres[2519]: DETAIL: Key (id)=(90) already exists. Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 17:06:08 arch001 postgres[2519]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 17:06:08 arch001 postgres[2519]: (99, 156, 2, 'Product Receipt'); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute Nov 05 17:06:08 arch001 postgres[2519]: (id, node_id, attribute, value) VALUES Nov 05 17:06:08 arch001 postgres[2519]: (228, 90, 'module', 'template.pm'), Nov 05 17:06:08 arch001 postgres[2519]: (229, 90, 'action', 'display'), Nov 05 17:06:08 arch001 postgres[2519]: (230, 90, 'template_name', 'product_receipt'), Nov 05 17:06:08 arch001 postgres[2519]: (231, 90, 'format', 'tex'), Nov 05 17:06:08 arch001 postgres[2519]: (240, 99, 'module', 'template.pm'), Nov 05 17:06:08 arch001 postgres[2519]: (241, 99, 'action', 'display'), Nov 05 17:06:08 arch001 postgres[2519]: (242, 99, 'template_name', 'product_receipt'), Nov 05 17:06:08 arch001 postgres[2519]: (245, 99, 'format', 'html'); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "birthdate" of relation "person" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 17:06:08 arch001 postgres[2519]: WARNING: there is no transaction in progress Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "is_return" of relation "ar" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "is_return" of relation "ap" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 17:06:08 arch001 postgres[2519]: DETAIL: Key (id)=(129) already exists. Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 17:06:08 arch001 postgres[2519]: VALUES (129, 1, 7, 'Add Return'); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 17:06:08 arch001 postgres[2519]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 17:06:08 arch001 postgres[2519]: (252, 129, 'action', 'add'), Nov 05 17:06:08 arch001 postgres[2519]: (253, 129, 'type', 'customer_return'); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 17:06:08 arch001 postgres[2519]: where parts_id = invoice.parts_id Nov 05 17:06:08 arch001 postgres[2519]: AND credit_id = ( Nov 05 17:06:08 arch001 postgres[2519]: select entity_credit_account Nov 05 17:06:08 arch001 postgres[2519]: from ap Nov 05 17:06:08 arch001 postgres[2519]: where ap.id = invoice.trans_id Nov 05 17:06:08 arch001 postgres[2519]: ) Nov 05 17:06:08 arch001 postgres[2519]: ) Nov 05 17:06:08 arch001 postgres[2519]: WHERE trans_id in (select id from ap); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: column "category" of relation "account_heading" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: relation "account_translation" already exists Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_translation Nov 05 17:06:08 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_translation Nov 05 17:06:08 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 17:06:08 arch001 postgres[2519]: $$Translations for account descriptions.$$; Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 17:06:08 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 17:06:08 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 17:06:08 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:06:08 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 17:06:08 arch001 postgres[2519]: $$Translations for account heading descriptions.$$; Nov 05 17:07:29 arch001 postgres[2519]: ERROR: Duplicate user Nov 05 17:07:29 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 17:07:29 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:07:29 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 17:08:15 arch001 postgres[2519]: ERROR: Duplicate user Nov 05 17:08:15 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 17:08:15 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:08:15 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 17:11:33 arch001 su[2531]: pam_unix(su-l:session): session closed for user postgres Nov 05 17:16:57 arch001 polkitd[980]: Registered Authentication Agent for unix-process:2876:1092481 (system bus name :1.16 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 17:16:57 arch001 systemd[1]: Stopping Apache Web Server... Nov 05 17:17:01 arch001 apachectl[2882]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 17:17:01 arch001 systemd[1]: Stopped Apache Web Server. Nov 05 17:17:01 arch001 systemd[1]: Starting Apache Web Server... Nov 05 17:17:01 arch001 apachectl[2889]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using fe80::e69f:6a1e:2f44:ec16. Set the 'ServerName' directive globally to suppress this message Nov 05 17:17:01 arch001 systemd[1]: httpd.service: PID file /run/httpd/httpd.pid not readable (yet?) after start: No such file or directory Nov 05 17:17:02 arch001 systemd[1]: Started Apache Web Server. Nov 05 17:17:02 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:2876:1092481 (system bus name :1.16, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 17:17:31 arch001 postgres[2519]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 17:17:31 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 17:17:31 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 17:18:27 arch001 postgres[2519]: ERROR: Duplicate user Nov 05 17:18:27 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 17:18:27 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 17:18:27 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 18:16:52 arch001 postgres[2519]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 18:16:52 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 18:16:52 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 18:16:53 arch001 postgres[2519]: FATAL: database "lsmbtest001" does not exist Nov 05 18:16:53 arch001 postgres[2519]: FATAL: database "lsmbtest001" does not exist Nov 05 18:16:53 arch001 postgres[2519]: FATAL: database "lsmbtest001" does not exist Nov 05 18:17:19 arch001 postgres[2519]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 18:17:19 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 18:17:19 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 18:17:55 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 18:17:55 arch001 postgres[2519]: DETAIL: Key (class)=(internal) already exists. Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "file_internal" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_internal ( Nov 05 18:17:55 arch001 postgres[2519]: check (file_class = 6), Nov 05 18:17:55 arch001 postgres[2519]: unique(id), Nov 05 18:17:55 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 18:17:55 arch001 postgres[2519]: check (ref_key = 0) Nov 05 18:17:55 arch001 postgres[2519]: ) inherits (file_base); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 18:17:55 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 18:17:55 arch001 postgres[2519]: are for internal use and against the company, not categorized.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 18:17:55 arch001 postgres[2519]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 18:17:55 arch001 postgres[2519]: company logos would be here.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 18:17:55 arch001 postgres[2519]: check (file_class = 7), Nov 05 18:17:55 arch001 postgres[2519]: unique(id), Nov 05 18:17:55 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 18:17:55 arch001 postgres[2519]: check (ref_key = 0) Nov 05 18:17:55 arch001 postgres[2519]: ) inherits (file_base); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 18:17:55 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 18:17:55 arch001 postgres[2519]: are for interal incoming use, not categorized.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 18:17:55 arch001 postgres[2519]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 18:17:55 arch001 postgres[2519]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "lot_tracking_number" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 18:17:55 arch001 postgres[2519]: id serial not null unique, Nov 05 18:17:55 arch001 postgres[2519]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 18:17:55 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 18:17:55 arch001 postgres[2519]: qty numeric not null, Nov 05 18:17:55 arch001 postgres[2519]: stock_date date not null default now()::date Nov 05 18:17:55 arch001 postgres[2519]: ); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 18:17:55 arch001 postgres[2519]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 18:17:55 arch001 postgres[2519]: may change as we refactor the parts.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 18:17:55 arch001 postgres[2519]: id serial not null unique, Nov 05 18:17:55 arch001 postgres[2519]: mfg_lot_id int not null references mfg_lot(id), Nov 05 18:17:55 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 18:17:55 arch001 postgres[2519]: qty numeric not null Nov 05 18:17:55 arch001 postgres[2519]: ); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 18:17:55 arch001 postgres[2519]: $$ This tracks items used in assembly restocking.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "fixed_acc_trans" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: create table location_class_to_entity_class ( Nov 05 18:17:55 arch001 postgres[2519]: id serial unique, Nov 05 18:17:55 arch001 postgres[2519]: location_class int not null references location_class(id), Nov 05 18:17:55 arch001 postgres[2519]: entity_class int not null references entity_class(id) Nov 05 18:17:55 arch001 postgres[2519]: ); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 18:17:55 arch001 postgres[2519]: $$This determines which location classes go with which entity classes$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 18:17:55 arch001 postgres[2519]: (location_class, entity_class) Nov 05 18:17:55 arch001 postgres[2519]: SELECT lc.id, ec.id Nov 05 18:17:55 arch001 postgres[2519]: FROM entity_class ec Nov 05 18:17:55 arch001 postgres[2519]: cross Nov 05 18:17:55 arch001 postgres[2519]: join location_class lc Nov 05 18:17:55 arch001 postgres[2519]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 18:17:55 arch001 postgres[2519]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 18:17:55 arch001 postgres[2519]: DETAIL: Key (id)=(90) already exists. Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 18:17:55 arch001 postgres[2519]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 18:17:55 arch001 postgres[2519]: (99, 156, 2, 'Product Receipt'); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute Nov 05 18:17:55 arch001 postgres[2519]: (id, node_id, attribute, value) VALUES Nov 05 18:17:55 arch001 postgres[2519]: (228, 90, 'module', 'template.pm'), Nov 05 18:17:55 arch001 postgres[2519]: (229, 90, 'action', 'display'), Nov 05 18:17:55 arch001 postgres[2519]: (230, 90, 'template_name', 'product_receipt'), Nov 05 18:17:55 arch001 postgres[2519]: (231, 90, 'format', 'tex'), Nov 05 18:17:55 arch001 postgres[2519]: (240, 99, 'module', 'template.pm'), Nov 05 18:17:55 arch001 postgres[2519]: (241, 99, 'action', 'display'), Nov 05 18:17:55 arch001 postgres[2519]: (242, 99, 'template_name', 'product_receipt'), Nov 05 18:17:55 arch001 postgres[2519]: (245, 99, 'format', 'html'); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "birthdate" of relation "person" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 18:17:55 arch001 postgres[2519]: WARNING: there is no transaction in progress Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "is_return" of relation "ar" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "is_return" of relation "ap" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 18:17:55 arch001 postgres[2519]: DETAIL: Key (id)=(129) already exists. Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 18:17:55 arch001 postgres[2519]: VALUES (129, 1, 7, 'Add Return'); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 18:17:55 arch001 postgres[2519]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 18:17:55 arch001 postgres[2519]: (252, 129, 'action', 'add'), Nov 05 18:17:55 arch001 postgres[2519]: (253, 129, 'type', 'customer_return'); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 18:17:55 arch001 postgres[2519]: where parts_id = invoice.parts_id Nov 05 18:17:55 arch001 postgres[2519]: AND credit_id = ( Nov 05 18:17:55 arch001 postgres[2519]: select entity_credit_account Nov 05 18:17:55 arch001 postgres[2519]: from ap Nov 05 18:17:55 arch001 postgres[2519]: where ap.id = invoice.trans_id Nov 05 18:17:55 arch001 postgres[2519]: ) Nov 05 18:17:55 arch001 postgres[2519]: ) Nov 05 18:17:55 arch001 postgres[2519]: WHERE trans_id in (select id from ap); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: column "category" of relation "account_heading" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: relation "account_translation" already exists Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_translation Nov 05 18:17:55 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_translation Nov 05 18:17:55 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 18:17:55 arch001 postgres[2519]: $$Translations for account descriptions.$$; Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 18:17:55 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 18:17:55 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 18:17:55 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:55 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 18:17:55 arch001 postgres[2519]: $$Translations for account heading descriptions.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 18:17:57 arch001 postgres[2519]: DETAIL: Key (class)=(internal) already exists. Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "file_internal" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_internal ( Nov 05 18:17:57 arch001 postgres[2519]: check (file_class = 6), Nov 05 18:17:57 arch001 postgres[2519]: unique(id), Nov 05 18:17:57 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 18:17:57 arch001 postgres[2519]: check (ref_key = 0) Nov 05 18:17:57 arch001 postgres[2519]: ) inherits (file_base); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 18:17:57 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 18:17:57 arch001 postgres[2519]: are for internal use and against the company, not categorized.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 18:17:57 arch001 postgres[2519]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 18:17:57 arch001 postgres[2519]: company logos would be here.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 18:17:57 arch001 postgres[2519]: check (file_class = 7), Nov 05 18:17:57 arch001 postgres[2519]: unique(id), Nov 05 18:17:57 arch001 postgres[2519]: primary key (ref_key, file_name, file_class), Nov 05 18:17:57 arch001 postgres[2519]: check (ref_key = 0) Nov 05 18:17:57 arch001 postgres[2519]: ) inherits (file_base); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 18:17:57 arch001 postgres[2519]: $$ Always must be 0, and we have no primary key since these files all Nov 05 18:17:57 arch001 postgres[2519]: are for interal incoming use, not categorized.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 18:17:57 arch001 postgres[2519]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 18:17:57 arch001 postgres[2519]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "lot_tracking_number" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 18:17:57 arch001 postgres[2519]: id serial not null unique, Nov 05 18:17:57 arch001 postgres[2519]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 18:17:57 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 18:17:57 arch001 postgres[2519]: qty numeric not null, Nov 05 18:17:57 arch001 postgres[2519]: stock_date date not null default now()::date Nov 05 18:17:57 arch001 postgres[2519]: ); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 18:17:57 arch001 postgres[2519]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 18:17:57 arch001 postgres[2519]: may change as we refactor the parts.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 18:17:57 arch001 postgres[2519]: id serial not null unique, Nov 05 18:17:57 arch001 postgres[2519]: mfg_lot_id int not null references mfg_lot(id), Nov 05 18:17:57 arch001 postgres[2519]: parts_id int not null references parts(id), Nov 05 18:17:57 arch001 postgres[2519]: qty numeric not null Nov 05 18:17:57 arch001 postgres[2519]: ); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 18:17:57 arch001 postgres[2519]: $$ This tracks items used in assembly restocking.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "fixed_acc_trans" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: create table location_class_to_entity_class ( Nov 05 18:17:57 arch001 postgres[2519]: id serial unique, Nov 05 18:17:57 arch001 postgres[2519]: location_class int not null references location_class(id), Nov 05 18:17:57 arch001 postgres[2519]: entity_class int not null references entity_class(id) Nov 05 18:17:57 arch001 postgres[2519]: ); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 18:17:57 arch001 postgres[2519]: $$This determines which location classes go with which entity classes$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 18:17:57 arch001 postgres[2519]: (location_class, entity_class) Nov 05 18:17:57 arch001 postgres[2519]: SELECT lc.id, ec.id Nov 05 18:17:57 arch001 postgres[2519]: FROM entity_class ec Nov 05 18:17:57 arch001 postgres[2519]: cross Nov 05 18:17:57 arch001 postgres[2519]: join location_class lc Nov 05 18:17:57 arch001 postgres[2519]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 18:17:57 arch001 postgres[2519]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 18:17:57 arch001 postgres[2519]: DETAIL: Key (id)=(90) already exists. Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 18:17:57 arch001 postgres[2519]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 18:17:57 arch001 postgres[2519]: (99, 156, 2, 'Product Receipt'); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute Nov 05 18:17:57 arch001 postgres[2519]: (id, node_id, attribute, value) VALUES Nov 05 18:17:57 arch001 postgres[2519]: (228, 90, 'module', 'template.pm'), Nov 05 18:17:57 arch001 postgres[2519]: (229, 90, 'action', 'display'), Nov 05 18:17:57 arch001 postgres[2519]: (230, 90, 'template_name', 'product_receipt'), Nov 05 18:17:57 arch001 postgres[2519]: (231, 90, 'format', 'tex'), Nov 05 18:17:57 arch001 postgres[2519]: (240, 99, 'module', 'template.pm'), Nov 05 18:17:57 arch001 postgres[2519]: (241, 99, 'action', 'display'), Nov 05 18:17:57 arch001 postgres[2519]: (242, 99, 'template_name', 'product_receipt'), Nov 05 18:17:57 arch001 postgres[2519]: (245, 99, 'format', 'html'); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "birthdate" of relation "person" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 18:17:57 arch001 postgres[2519]: WARNING: there is no transaction in progress Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "is_return" of relation "ar" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "is_return" of relation "ap" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 18:17:57 arch001 postgres[2519]: DETAIL: Key (id)=(129) already exists. Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 18:17:57 arch001 postgres[2519]: VALUES (129, 1, 7, 'Add Return'); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 18:17:57 arch001 postgres[2519]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 18:17:57 arch001 postgres[2519]: (252, 129, 'action', 'add'), Nov 05 18:17:57 arch001 postgres[2519]: (253, 129, 'type', 'customer_return'); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 18:17:57 arch001 postgres[2519]: where parts_id = invoice.parts_id Nov 05 18:17:57 arch001 postgres[2519]: AND credit_id = ( Nov 05 18:17:57 arch001 postgres[2519]: select entity_credit_account Nov 05 18:17:57 arch001 postgres[2519]: from ap Nov 05 18:17:57 arch001 postgres[2519]: where ap.id = invoice.trans_id Nov 05 18:17:57 arch001 postgres[2519]: ) Nov 05 18:17:57 arch001 postgres[2519]: ) Nov 05 18:17:57 arch001 postgres[2519]: WHERE trans_id in (select id from ap); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: column "category" of relation "account_heading" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: relation "account_translation" already exists Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_translation Nov 05 18:17:57 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_translation Nov 05 18:17:57 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 18:17:57 arch001 postgres[2519]: $$Translations for account descriptions.$$; Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 18:17:57 arch001 postgres[2519]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 18:17:57 arch001 postgres[2519]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 18:17:57 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:17:57 arch001 postgres[2519]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 18:17:57 arch001 postgres[2519]: $$Translations for account heading descriptions.$$; Nov 05 18:18:19 arch001 postgres[2519]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 18:18:19 arch001 postgres[2519]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 18:18:19 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 18:19:06 arch001 postgres[2519]: ERROR: Duplicate user Nov 05 18:19:06 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 18:19:06 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 18:19:06 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 18:20:12 arch001 su[1938]: pam_unix(su:session): session closed for user root Nov 05 19:01:27 arch001 postgres[2519]: ERROR: Duplicate user Nov 05 19:01:27 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 19:01:27 arch001 postgres[2519]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 19:01:27 arch001 postgres[2519]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 19:06:54 arch001 dbus-daemon[341]: Activating service name='ca.desrt.dconf' Nov 05 19:06:54 arch001 dbus-daemon[341]: Successfully activated service 'ca.desrt.dconf' Nov 05 19:06:54 arch001 dbus[216]: [system] Activating via systemd: service name='org.freedesktop.hostname1' unit='dbus-org.freedesktop.hostname1.service' Nov 05 19:06:54 arch001 systemd[1]: Starting Hostname Service... Nov 05 19:06:55 arch001 dbus[216]: [system] Successfully activated service 'org.freedesktop.hostname1' Nov 05 19:06:55 arch001 systemd[1]: Started Hostname Service. Nov 05 19:07:29 arch001 dbus[216]: [system] Activating via systemd: service name='org.freedesktop.hostname1' unit='dbus-org.freedesktop.hostname1.service' Nov 05 19:07:29 arch001 systemd[1]: Starting Hostname Service... Nov 05 19:07:29 arch001 dbus[216]: [system] Successfully activated service 'org.freedesktop.hostname1' Nov 05 19:07:29 arch001 systemd[1]: Started Hostname Service. Nov 05 19:11:07 arch001 dbus[216]: [system] Activating via systemd: service name='org.freedesktop.hostname1' unit='dbus-org.freedesktop.hostname1.service' Nov 05 19:11:07 arch001 systemd[1]: Starting Hostname Service... Nov 05 19:11:07 arch001 dbus[216]: [system] Successfully activated service 'org.freedesktop.hostname1' Nov 05 19:11:07 arch001 systemd[1]: Started Hostname Service. Nov 05 19:41:41 arch001 su[3917]: (to root) jlb on pts/1 Nov 05 19:41:41 arch001 su[3917]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 19:41:45 arch001 su[3919]: (to postgres) jlb on pts/1 Nov 05 19:41:45 arch001 su[3919]: pam_unix(su-l:session): session opened for user postgres by jlb(uid=0) Nov 05 19:44:17 arch001 su[1430]: pam_unix(su:session): session closed for user root Nov 05 19:44:44 arch001 su[3936]: (to root) jlb on pts/0 Nov 05 19:44:44 arch001 su[3936]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 20:08:13 arch001 su[3919]: pam_unix(su-l:session): session closed for user postgres Nov 05 20:08:40 arch001 polkitd[980]: Registered Authentication Agent for unix-process:4025:2122769 (system bus name :1.23 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 20:08:40 arch001 systemd[1]: Stopping PostgreSQL database server... Nov 05 20:08:40 arch001 postgres[2519]: LOG: received fast shutdown request Nov 05 20:08:40 arch001 postgres[2519]: LOG: aborting any active transactions Nov 05 20:08:40 arch001 postgres[2519]: LOG: autovacuum launcher shutting down Nov 05 20:08:40 arch001 postgres[2519]: LOG: shutting down Nov 05 20:08:40 arch001 postgres[2519]: LOG: database system is shut down Nov 05 20:08:41 arch001 systemd[1]: Stopped PostgreSQL database server. Nov 05 20:08:41 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:4025:2122769 (system bus name :1.23, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 20:12:28 arch001 su[4038]: (to postgres) jlb on pts/1 Nov 05 20:12:28 arch001 su[4038]: pam_unix(su-l:session): session opened for user postgres by jlb(uid=0) Nov 05 20:13:00 arch001 su[4038]: pam_unix(su-l:session): session closed for user postgres Nov 05 20:13:01 arch001 su[3917]: pam_unix(su:session): session closed for user root Nov 05 20:13:32 arch001 su[4044]: (to root) jlb on pts/1 Nov 05 20:13:32 arch001 su[4044]: pam_unix(su:session): session opened for user root by jlb(uid=1000) Nov 05 20:13:44 arch001 polkitd[980]: Registered Authentication Agent for unix-process:4047:2153191 (system bus name :1.24 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 20:13:44 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:4047:2153191 (system bus name :1.24, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 20:13:54 arch001 polkitd[980]: Registered Authentication Agent for unix-process:4053:2154228 (system bus name :1.25 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 20:13:54 arch001 systemd[1]: Starting PostgreSQL database server... Nov 05 20:13:54 arch001 postgres[4063]: LOG: database system was shut down at 2015-11-05 20:08:40 UTC Nov 05 20:13:54 arch001 postgres[4063]: LOG: MultiXact member wraparound protections are now enabled Nov 05 20:13:54 arch001 postgres[4063]: LOG: database system is ready to accept connections Nov 05 20:13:54 arch001 postgres[4063]: LOG: autovacuum launcher started Nov 05 20:13:55 arch001 systemd[1]: Started PostgreSQL database server. Nov 05 20:13:55 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:4053:2154228 (system bus name :1.25, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 20:14:51 arch001 su[4081]: (to postgres) jlb on pts/2 Nov 05 20:14:51 arch001 su[4081]: pam_unix(su-l:session): session opened for user postgres by jlb(uid=0) Nov 05 20:15:35 arch001 postgres[4063]: ERROR: syntax error at or near "show" at character 22 Nov 05 20:15:35 arch001 postgres[4063]: STATEMENT: show log_destination Nov 05 20:15:35 arch001 postgres[4063]: show log_destination; Nov 05 20:15:41 arch001 postgres[4063]: ERROR: syntax error at or near "show" at character 22 Nov 05 20:15:41 arch001 postgres[4063]: STATEMENT: show log_destination Nov 05 20:15:41 arch001 postgres[4063]: show log_destination; Nov 05 20:19:54 arch001 polkitd[980]: Registered Authentication Agent for unix-process:4124:2190181 (system bus name :1.26 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 20:19:54 arch001 systemd[1]: Stopping PostgreSQL database server... Nov 05 20:19:54 arch001 postgres[4063]: LOG: received fast shutdown request Nov 05 20:19:54 arch001 postgres[4063]: LOG: aborting any active transactions Nov 05 20:19:54 arch001 postgres[4063]: FATAL: terminating connection due to administrator command Nov 05 20:19:54 arch001 postgres[4063]: LOG: autovacuum launcher shutting down Nov 05 20:19:54 arch001 postgres[4063]: LOG: shutting down Nov 05 20:19:54 arch001 postgres[4063]: LOG: database system is shut down Nov 05 20:19:55 arch001 systemd[1]: Stopped PostgreSQL database server. Nov 05 20:19:55 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:4124:2190181 (system bus name :1.26, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 20:20:01 arch001 polkitd[980]: Registered Authentication Agent for unix-process:4136:2190911 (system bus name :1.27 [/usr/bin/pkttyagent --notify-fd 4 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) Nov 05 20:20:01 arch001 systemd[1]: Starting PostgreSQL database server... Nov 05 20:20:01 arch001 postgres[4146]: LOG: database system was shut down at 2015-11-05 20:19:54 UTC Nov 05 20:20:01 arch001 postgres[4146]: LOG: MultiXact member wraparound protections are now enabled Nov 05 20:20:01 arch001 postgres[4146]: LOG: database system is ready to accept connections Nov 05 20:20:01 arch001 postgres[4146]: LOG: autovacuum launcher started Nov 05 20:20:02 arch001 systemd[1]: Started PostgreSQL database server. Nov 05 20:20:02 arch001 polkitd[980]: Unregistered Authentication Agent for unix-process:4136:2190911 (system bus name :1.27, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale C) (disconnected from bus) Nov 05 20:20:25 arch001 postgres[4146]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 20:20:25 arch001 postgres[4146]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 20:20:25 arch001 postgres[4146]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 20:22:08 arch001 postgres[4146]: ERROR: Duplicate user Nov 05 20:22:08 arch001 postgres[4146]: STATEMENT: SELECT * FROM "public"."admin__save_user"($1, $2, $3, $4, $5) Nov 05 20:22:08 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:22:08 arch001 postgres[4146]: STATEMENT: SELECT * FROM "public"."person__list_salutations"() Nov 05 20:23:15 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:23:15 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:23:15 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:23:15 arch001 postgres[4146]: unique(id), Nov 05 20:23:15 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:23:15 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:23:15 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:23:15 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:23:15 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:23:15 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:23:15 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:23:15 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:23:15 arch001 postgres[4146]: unique(id), Nov 05 20:23:15 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:23:15 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:23:15 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:23:15 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:23:15 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:23:15 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:23:15 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:23:15 arch001 postgres[4146]: id serial not null unique, Nov 05 20:23:15 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:23:15 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:23:15 arch001 postgres[4146]: qty numeric not null, Nov 05 20:23:15 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:23:15 arch001 postgres[4146]: ); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:23:15 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:23:15 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:23:15 arch001 postgres[4146]: id serial not null unique, Nov 05 20:23:15 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:23:15 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:23:15 arch001 postgres[4146]: qty numeric not null Nov 05 20:23:15 arch001 postgres[4146]: ); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:23:15 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "fixed_acc_trans" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:23:15 arch001 postgres[4146]: id serial unique, Nov 05 20:23:15 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:23:15 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:23:15 arch001 postgres[4146]: ); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:23:15 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:23:15 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:23:15 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:23:15 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:23:15 arch001 postgres[4146]: cross Nov 05 20:23:15 arch001 postgres[4146]: join location_class lc Nov 05 20:23:15 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:23:15 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:23:15 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:23:15 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:23:15 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:23:15 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:23:15 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:23:15 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:23:15 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:23:15 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:23:15 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:23:15 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:23:15 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:23:15 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:23:15 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:23:15 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:23:15 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:23:15 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:23:15 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:23:15 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:23:15 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:23:15 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:23:15 arch001 postgres[4146]: select entity_credit_account Nov 05 20:23:15 arch001 postgres[4146]: from ap Nov 05 20:23:15 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:23:15 arch001 postgres[4146]: ) Nov 05 20:23:15 arch001 postgres[4146]: ) Nov 05 20:23:15 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:23:15 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:23:15 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:23:15 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:23:15 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:23:15 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:23:15 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:15 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:23:15 arch001 postgres[4146]: $$Translations for account heading descriptions.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:23:16 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:23:16 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:23:16 arch001 postgres[4146]: unique(id), Nov 05 20:23:16 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:23:16 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:23:16 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:23:16 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:23:16 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:23:16 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:23:16 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:23:16 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:23:16 arch001 postgres[4146]: unique(id), Nov 05 20:23:16 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:23:16 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:23:16 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:23:16 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:23:16 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:23:16 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:23:16 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:23:16 arch001 postgres[4146]: id serial not null unique, Nov 05 20:23:16 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:23:16 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:23:16 arch001 postgres[4146]: qty numeric not null, Nov 05 20:23:16 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:23:16 arch001 postgres[4146]: ); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:23:16 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:23:16 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:23:16 arch001 postgres[4146]: id serial not null unique, Nov 05 20:23:16 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:23:16 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:23:16 arch001 postgres[4146]: qty numeric not null Nov 05 20:23:16 arch001 postgres[4146]: ); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:23:16 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "fixed_acc_trans" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:23:16 arch001 postgres[4146]: id serial unique, Nov 05 20:23:16 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:23:16 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:23:16 arch001 postgres[4146]: ); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:23:16 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:23:16 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:23:16 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:23:16 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:23:16 arch001 postgres[4146]: cross Nov 05 20:23:16 arch001 postgres[4146]: join location_class lc Nov 05 20:23:16 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:23:16 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:23:16 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:23:16 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:23:16 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:23:16 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:23:16 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:23:16 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:23:16 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:23:16 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:23:16 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:23:16 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:23:16 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:23:16 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:23:16 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:23:16 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:23:16 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:23:16 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:23:16 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:23:16 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:23:16 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:23:16 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:23:16 arch001 postgres[4146]: select entity_credit_account Nov 05 20:23:16 arch001 postgres[4146]: from ap Nov 05 20:23:16 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:23:16 arch001 postgres[4146]: ) Nov 05 20:23:16 arch001 postgres[4146]: ) Nov 05 20:23:16 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:23:16 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:23:16 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:23:16 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:23:16 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:23:16 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:23:16 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:23:16 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:23:16 arch001 postgres[4146]: $$Translations for account heading descriptions.$$; Nov 05 20:23:34 arch001 postgres[4146]: FATAL: role "jlb01" does not exist Nov 05 20:23:49 arch001 postgres[4146]: FATAL: database "cj2015a" does not exist Nov 05 20:24:02 arch001 postgres[4146]: FATAL: role "jlb01" does not exist Nov 05 20:24:11 arch001 postgres[4146]: FATAL: role "http" does not exist Nov 05 20:24:14 arch001 postgres[4146]: FATAL: role "http" does not exist Nov 05 20:24:21 arch001 postgres[4146]: FATAL: role "http" does not exist Nov 05 20:24:46 arch001 postgres[4146]: ERROR: function public.setting_get(unknown) does not exist at character 15 Nov 05 20:24:46 arch001 postgres[4146]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 20:24:46 arch001 postgres[4146]: STATEMENT: SELECT * FROM "public"."setting_get"('ignore_version') Nov 05 20:24:46 arch001 postgres[4146]: FATAL: database "cj2015a" does not exist Nov 05 20:24:46 arch001 postgres[4146]: FATAL: database "cj2015a" does not exist Nov 05 20:24:46 arch001 postgres[4146]: FATAL: database "cj2015a" does not exist Nov 05 20:24:56 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:24:56 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:24:56 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:24:56 arch001 postgres[4146]: unique(id), Nov 05 20:24:56 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:24:56 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:24:56 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:24:56 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:24:56 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:24:56 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:24:56 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:24:56 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:24:56 arch001 postgres[4146]: unique(id), Nov 05 20:24:56 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:24:56 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:24:56 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:24:56 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:24:56 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:24:56 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:24:56 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:24:56 arch001 postgres[4146]: id serial not null unique, Nov 05 20:24:56 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:24:56 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:24:56 arch001 postgres[4146]: qty numeric not null, Nov 05 20:24:56 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:24:56 arch001 postgres[4146]: ); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:24:56 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:24:56 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:24:56 arch001 postgres[4146]: id serial not null unique, Nov 05 20:24:56 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:24:56 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:24:56 arch001 postgres[4146]: qty numeric not null Nov 05 20:24:56 arch001 postgres[4146]: ); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:24:56 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:24:56 arch001 postgres[4146]: id serial unique, Nov 05 20:24:56 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:24:56 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:24:56 arch001 postgres[4146]: ); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:24:56 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:24:56 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:24:56 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:24:56 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:24:56 arch001 postgres[4146]: cross Nov 05 20:24:56 arch001 postgres[4146]: join location_class lc Nov 05 20:24:56 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:24:56 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: function setting_get(unknown) does not exist at character 83 Nov 05 20:24:56 arch001 postgres[4146]: HINT: No function matches the given name and argument types. You might need to add explicit type casts. Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: UPDATE entity_credit_account Nov 05 20:24:56 arch001 postgres[4146]: SET curr = (select s from unnest(string_to_array((setting_get('curr')).value, ':')) s limit 1) Nov 05 20:24:56 arch001 postgres[4146]: WHERE curr IS NULL; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:24:56 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:24:56 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:24:56 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:24:56 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:24:56 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:24:56 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:24:56 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:24:56 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:24:56 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:24:56 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:24:56 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:24:56 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:24:56 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:24:56 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:24:56 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:24:56 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:24:56 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:24:56 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:24:56 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:24:56 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:24:56 arch001 postgres[4146]: select entity_credit_account Nov 05 20:24:56 arch001 postgres[4146]: from ap Nov 05 20:24:56 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:24:56 arch001 postgres[4146]: ) Nov 05 20:24:56 arch001 postgres[4146]: ) Nov 05 20:24:56 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:24:56 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:24:56 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:24:56 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:24:57 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:24:57 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:24:57 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:24:57 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:24:57 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:24:57 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:57 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:24:57 arch001 postgres[4146]: $$Translations for account heading descriptions.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:24:58 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:24:58 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:24:58 arch001 postgres[4146]: unique(id), Nov 05 20:24:58 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:24:58 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:24:58 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:24:58 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:24:58 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:24:58 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:24:58 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:24:58 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:24:58 arch001 postgres[4146]: unique(id), Nov 05 20:24:58 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:24:58 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:24:58 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:24:58 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:24:58 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:24:58 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:24:58 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:24:58 arch001 postgres[4146]: id serial not null unique, Nov 05 20:24:58 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:24:58 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:24:58 arch001 postgres[4146]: qty numeric not null, Nov 05 20:24:58 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:24:58 arch001 postgres[4146]: ); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:24:58 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:24:58 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:24:58 arch001 postgres[4146]: id serial not null unique, Nov 05 20:24:58 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:24:58 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:24:58 arch001 postgres[4146]: qty numeric not null Nov 05 20:24:58 arch001 postgres[4146]: ); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:24:58 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "fixed_acc_trans" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:24:58 arch001 postgres[4146]: id serial unique, Nov 05 20:24:58 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:24:58 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:24:58 arch001 postgres[4146]: ); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:24:58 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:24:58 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:24:58 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:24:58 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:24:58 arch001 postgres[4146]: cross Nov 05 20:24:58 arch001 postgres[4146]: join location_class lc Nov 05 20:24:58 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:24:58 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:24:58 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:24:58 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:24:58 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:24:58 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:24:58 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:24:58 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:24:58 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:24:58 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:24:58 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:24:58 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:24:58 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:24:58 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:24:58 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:24:58 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:24:58 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:24:58 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:24:58 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:24:58 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:24:58 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:24:58 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:24:58 arch001 postgres[4146]: select entity_credit_account Nov 05 20:24:58 arch001 postgres[4146]: from ap Nov 05 20:24:58 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:24:58 arch001 postgres[4146]: ) Nov 05 20:24:58 arch001 postgres[4146]: ) Nov 05 20:24:58 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:24:58 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:24:58 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:24:58 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:24:58 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:24:58 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:24:58 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:24:58 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:24:58 arch001 postgres[4146]: $$Translations for account heading descriptions.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:25:46 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:25:46 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:25:46 arch001 postgres[4146]: unique(id), Nov 05 20:25:46 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:25:46 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:25:46 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:25:46 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:25:46 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:25:46 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:25:46 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:25:46 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:25:46 arch001 postgres[4146]: unique(id), Nov 05 20:25:46 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:25:46 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:25:46 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:25:46 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:25:46 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:25:46 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:25:46 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:25:46 arch001 postgres[4146]: id serial not null unique, Nov 05 20:25:46 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:25:46 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:25:46 arch001 postgres[4146]: qty numeric not null, Nov 05 20:25:46 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:25:46 arch001 postgres[4146]: ); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:25:46 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:25:46 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:25:46 arch001 postgres[4146]: id serial not null unique, Nov 05 20:25:46 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:25:46 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:25:46 arch001 postgres[4146]: qty numeric not null Nov 05 20:25:46 arch001 postgres[4146]: ); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:25:46 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "fixed_acc_trans" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:25:46 arch001 postgres[4146]: id serial unique, Nov 05 20:25:46 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:25:46 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:25:46 arch001 postgres[4146]: ); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:25:46 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:25:46 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:25:46 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:25:46 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:25:46 arch001 postgres[4146]: cross Nov 05 20:25:46 arch001 postgres[4146]: join location_class lc Nov 05 20:25:46 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:25:46 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:25:46 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:25:46 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:25:46 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:25:46 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:25:46 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:25:46 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:25:46 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:25:46 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:25:46 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:25:46 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:25:46 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:25:46 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:25:46 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:25:46 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:25:46 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:25:46 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:25:46 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:25:46 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:25:46 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:25:46 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:25:46 arch001 postgres[4146]: select entity_credit_account Nov 05 20:25:46 arch001 postgres[4146]: from ap Nov 05 20:25:46 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:25:46 arch001 postgres[4146]: ) Nov 05 20:25:46 arch001 postgres[4146]: ) Nov 05 20:25:46 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:25:46 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:25:46 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:25:46 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:25:46 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:25:46 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:25:46 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:46 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:25:46 arch001 postgres[4146]: $$Translations for account heading descriptions.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "file_class_pkey" Nov 05 20:25:48 arch001 postgres[4146]: DETAIL: Key (class)=(internal) already exists. Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO file_class (id, class) values (6, 'internal'), (7, 'incoming'); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "file_internal" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_internal ( Nov 05 20:25:48 arch001 postgres[4146]: check (file_class = 6), Nov 05 20:25:48 arch001 postgres[4146]: unique(id), Nov 05 20:25:48 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:25:48 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:25:48 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_internal.ref_key IS Nov 05 20:25:48 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:25:48 arch001 postgres[4146]: are for internal use and against the company, not categorized.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_internal IS Nov 05 20:25:48 arch001 postgres[4146]: $$ This is for internal files used operationally by LedgerSMB. For example, Nov 05 20:25:48 arch001 postgres[4146]: company logos would be here.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE file_incoming ( Nov 05 20:25:48 arch001 postgres[4146]: check (file_class = 7), Nov 05 20:25:48 arch001 postgres[4146]: unique(id), Nov 05 20:25:48 arch001 postgres[4146]: primary key (ref_key, file_name, file_class), Nov 05 20:25:48 arch001 postgres[4146]: check (ref_key = 0) Nov 05 20:25:48 arch001 postgres[4146]: ) inherits (file_base); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON COLUMN file_incoming.ref_key IS Nov 05 20:25:48 arch001 postgres[4146]: $$ Always must be 0, and we have no primary key since these files all Nov 05 20:25:48 arch001 postgres[4146]: are for interal incoming use, not categorized.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE file_incoming IS Nov 05 20:25:48 arch001 postgres[4146]: $$ This is essentially a spool for files to be reviewed and attached. It is Nov 05 20:25:48 arch001 postgres[4146]: important that the names are somehow guaranteed to be unique, so one may want to prepend them with an email equivalent or the like.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "lot_tracking_number" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE SEQUENCE lot_tracking_number; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot ( Nov 05 20:25:48 arch001 postgres[4146]: id serial not null unique, Nov 05 20:25:48 arch001 postgres[4146]: lot_number text not null unique default nextval('lot_tracking_number')::text, Nov 05 20:25:48 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:25:48 arch001 postgres[4146]: qty numeric not null, Nov 05 20:25:48 arch001 postgres[4146]: stock_date date not null default now()::date Nov 05 20:25:48 arch001 postgres[4146]: ); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot IS Nov 05 20:25:48 arch001 postgres[4146]: $$ This tracks assembly restocks. This is designed to work with old code and Nov 05 20:25:48 arch001 postgres[4146]: may change as we refactor the parts.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE mfg_lot_item ( Nov 05 20:25:48 arch001 postgres[4146]: id serial not null unique, Nov 05 20:25:48 arch001 postgres[4146]: mfg_lot_id int not null references mfg_lot(id), Nov 05 20:25:48 arch001 postgres[4146]: parts_id int not null references parts(id), Nov 05 20:25:48 arch001 postgres[4146]: qty numeric not null Nov 05 20:25:48 arch001 postgres[4146]: ); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE mfg_lot_item IS Nov 05 20:25:48 arch001 postgres[4146]: $$ This tracks items used in assembly restocking.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "is_manager" of relation "entity_employee" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE entity_employee ADD is_manager bool DEFAULT FALSE; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: UPDATE entity_employee SET is_manager = true WHERE role = 'manager'; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "fixed_acc_trans" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE fixed_acc_trans (LIKE acc_trans); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "location_class_to_entity_class" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: create table location_class_to_entity_class ( Nov 05 20:25:48 arch001 postgres[4146]: id serial unique, Nov 05 20:25:48 arch001 postgres[4146]: location_class int not null references location_class(id), Nov 05 20:25:48 arch001 postgres[4146]: entity_class int not null references entity_class(id) Nov 05 20:25:48 arch001 postgres[4146]: ); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: GRANT SELECT ON location_class_to_entity_class TO PUBLIC; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE location_class_to_entity_class IS Nov 05 20:25:48 arch001 postgres[4146]: $$This determines which location classes go with which entity classes$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('4','Physical',TRUE); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class(id,class,authoritative) VALUES ('5','Mailing',FALSE); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: SELECT SETVAL('location_class_id_seq',5); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class Nov 05 20:25:48 arch001 postgres[4146]: (location_class, entity_class) Nov 05 20:25:48 arch001 postgres[4146]: SELECT lc.id, ec.id Nov 05 20:25:48 arch001 postgres[4146]: FROM entity_class ec Nov 05 20:25:48 arch001 postgres[4146]: cross Nov 05 20:25:48 arch001 postgres[4146]: join location_class lc Nov 05 20:25:48 arch001 postgres[4146]: WHERE ec.id <> 3 and lc.id < 4; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO location_class_to_entity_class (location_class, entity_class) Nov 05 20:25:48 arch001 postgres[4146]: SELECT id, 3 from location_class lc where lc.id > 3; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:25:48 arch001 postgres[4146]: DETAIL: Key (id)=(90) already exists. Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:25:48 arch001 postgres[4146]: VALUES (90, 172, 2, 'Product Receipt'), Nov 05 20:25:48 arch001 postgres[4146]: (99, 156, 2, 'Product Receipt'); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute Nov 05 20:25:48 arch001 postgres[4146]: (id, node_id, attribute, value) VALUES Nov 05 20:25:48 arch001 postgres[4146]: (228, 90, 'module', 'template.pm'), Nov 05 20:25:48 arch001 postgres[4146]: (229, 90, 'action', 'display'), Nov 05 20:25:48 arch001 postgres[4146]: (230, 90, 'template_name', 'product_receipt'), Nov 05 20:25:48 arch001 postgres[4146]: (231, 90, 'format', 'tex'), Nov 05 20:25:48 arch001 postgres[4146]: (240, 99, 'module', 'template.pm'), Nov 05 20:25:48 arch001 postgres[4146]: (241, 99, 'action', 'display'), Nov 05 20:25:48 arch001 postgres[4146]: (242, 99, 'template_name', 'product_receipt'), Nov 05 20:25:48 arch001 postgres[4146]: (245, 99, 'format', 'html'); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "birthdate" of relation "person" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN birthdate date; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE person ADD COLUMN personal_id text; Nov 05 20:25:48 arch001 postgres[4146]: WARNING: there is no transaction in progress Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "is_return" of relation "ar" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD COLUMN is_return bool default false; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "is_return" of relation "ap" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE ap ADD COLUMN is_return bool default false; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: duplicate key value violates unique constraint "menu_node_pkey" Nov 05 20:25:48 arch001 postgres[4146]: DETAIL: Key (id)=(129) already exists. Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_node (id, parent, position, label) Nov 05 20:25:48 arch001 postgres[4146]: VALUES (129, 1, 7, 'Add Return'); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: update menu_node set position = position * -1 where position < 0; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: INSERT INTO menu_attribute (id, node_id, attribute, value) Nov 05 20:25:48 arch001 postgres[4146]: VALUES (251, 129, 'module', 'is.pl'), Nov 05 20:25:48 arch001 postgres[4146]: (252, 129, 'action', 'add'), Nov 05 20:25:48 arch001 postgres[4146]: (253, 129, 'type', 'customer_return'); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "vendor_sku" of relation "invoice" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE invoice ADD vendor_sku text; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: UPDATE invoice SET vendor_sku = (select min(partnumber) from partsvendor Nov 05 20:25:48 arch001 postgres[4146]: where parts_id = invoice.parts_id Nov 05 20:25:48 arch001 postgres[4146]: AND credit_id = ( Nov 05 20:25:48 arch001 postgres[4146]: select entity_credit_account Nov 05 20:25:48 arch001 postgres[4146]: from ap Nov 05 20:25:48 arch001 postgres[4146]: where ap.id = invoice.trans_id Nov 05 20:25:48 arch001 postgres[4146]: ) Nov 05 20:25:48 arch001 postgres[4146]: ) Nov 05 20:25:48 arch001 postgres[4146]: WHERE trans_id in (select id from ap); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: constraint "ar_invnumber_key" of relation "ar" does not exist Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar DROP CONSTRAINT ar_invnumber_key; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD CHECK(invnumber is not null OR not approved); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE UNIQUE INDEX ar_invnumber_key_p ON ar(invnumber) where invnumber is not null; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "setting_sequence" of relation "ar" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE ar ADD setting_sequence TEXT; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: column "category" of relation "account_heading" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading ADD COLUMN category CHAR(1); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "business_unit_ac_entry_id_idx" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_ac_entry_id_idx ON business_unit_ac (entry_id); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_inv_entry_id_idx ON business_unit_inv(entry_id); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE INDEX business_unit_oitem_entry_id_idx ON business_unit_oitem(entry_id); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: relation "account_translation" already exists Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_translation Nov 05 20:25:48 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_translation Nov 05 20:25:48 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account(id); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_translation IS Nov 05 20:25:48 arch001 postgres[4146]: $$Translations for account descriptions.$$; Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: CREATE TABLE account_heading_translation Nov 05 20:25:48 arch001 postgres[4146]: (PRIMARY KEY (trans_id, language_code)) INHERITS (translation); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: ALTER TABLE account_heading_translation Nov 05 20:25:48 arch001 postgres[4146]: ADD foreign key (trans_id) REFERENCES account_heading(id); Nov 05 20:25:48 arch001 postgres[4146]: ERROR: current transaction is aborted, commands ignored until end of transaction block Nov 05 20:25:48 arch001 postgres[4146]: STATEMENT: COMMENT ON TABLE account_heading_translation IS Nov 05 20:25:48 arch001 postgres[4146]: $$Translations for account heading descriptions.$$;

------------------------------------------------------------------------------

References:

Error during setup
- From: JBash
Re: Error during setup
- From: Chris Travers