View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006402OXID eShop (all versions)4.01. Database handlingpublic2016-05-30 11:492017-03-29 13:59
ReporterBernhardScheffold Assigned To 
PrioritynormalSeveritymajorReproducibilityrandom
Status closedResolutionno change required 
OSUbuntu 12.04.5 LSOS Version12.04.5 LS 
Product Version4.9.0 / 5.2.0 
Summary0006402: OxCounter delivery same value twice
DescriptionOxCounter seems to have a race condition. It delivers the same value twice. This happens again and again. The installation has three web frontends and one database. The shop frontends use eShop 5.2.0, the database version is 10.0.21-MariaDB.

Values generated by oxCounter are used to create unique integer ids for orders and users.
Steps To ReproduceUsage of the counter values is wrapped as follows:

        $oDb = oxDb::getDb();

        $iCnt = null;
        while ($iCnt == null) {
            // determine an unused counter value
            $sNext = oxNew('oxCounter')->getNext($this->_getCounterIdent());
            if (oxDB::getDb()->getOne('SELECT oxid FROM oxorder WHERE oxid = ?', array($sNext)) == false) {
                $iCnt = $sNext;
            } else {
                /** @var oxps_logger_core_loggerfactory $oLoggerFactory */
                $oLoggerFactory = oxNew("oxps_logger_core_loggerfactory");
                $oLogger = $oLoggerFactory->createLogger('oxCounter');
                $oLogger->warn("Id $sNext already in use for oxorder. Trying next one.");
            }
        }


The warning events are logged quite often:

2016-02-01 20:42:59 oxCounter WARN: Id 152641 already in use for oxorder. Trying next one.
2016-02-02 00:50:31 oxCounter WARN: Id 152685 already in use for oxorder. Trying next one.
2016-02-02 09:47:51 oxCounter WARN: Id 152793 already in use for oxorder. Trying next one.
2016-02-02 11:56:14 oxCounter WARN: Id 153000 already in use for oxorder. Trying next one.
2016-02-02 13:26:30 oxCounter WARN: Id 153142 already in use for oxorder. Trying next one.
2016-02-02 13:26:48 oxCounter WARN: Id 25327 already in use for oxuser. Trying next one.
2016-02-03 15:12:57 oxCounter WARN: Id 153984 already in use for oxorder. Trying next one.
2016-02-03 15:15:26 oxCounter WARN: Id 153987 already in use for oxorder. Trying next one.
2016-02-03 16:30:39 oxCounter WARN: Id 154062 already in use for oxorder. Trying next one.
2016-02-04 11:11:28 oxCounter WARN: Id 154355 already in use for oxorder. Trying next one.
2016-02-05 13:42:04 oxCounter WARN: Id 155096 already in use for oxorder. Trying next one.
2016-02-05 13:59:41 oxCounter WARN: Id 155110 already in use for oxorder. Trying next one.
2016-02-07 21:18:25 oxCounter WARN: Id 155323 already in use for oxorder. Trying next one.
2016-02-08 00:09:58 oxCounter WARN: Id 155331 already in use for oxorder. Trying next one.
2016-02-08 10:07:51 oxCounter WARN: Id 155393 already in use for oxorder. Trying next one.
2016-02-08 12:48:51 oxCounter WARN: Id 155516 already in use for oxorder. Trying next one.
2016-02-09 12:25:54 oxCounter WARN: Id 156109 already in use for oxorder. Trying next one.
2016-02-09 12:48:53 oxCounter WARN: Id 156153 already in use for oxorder. Trying next one.
2016-02-09 14:18:13 oxCounter WARN: Id 156274 already in use for oxorder. Trying next one.
2016-02-09 18:56:04 oxCounter WARN: Id 156445 already in use for oxorder. Trying next one.
2016-02-10 11:53:06 oxCounter WARN: Id 156742 already in use for oxorder. Trying next one.
2016-02-10 15:20:49 oxCounter WARN: Id 157000 already in use for oxorder. Trying next one.
2016-02-10 20:15:35 oxCounter WARN: Id 157125 already in use for oxorder. Trying next one.
2016-02-11 13:13:35 oxCounter WARN: Id 157515 already in use for oxorder. Trying next one.
2016-02-11 13:13:35 oxCounter WARN: Id 157516 already in use for oxorder. Trying next one.
2016-02-11 16:21:23 oxCounter WARN: Id 157676 already in use for oxorder. Trying next one.
2016-02-12 12:36:57 oxCounter WARN: Id 158064 already in use for oxorder. Trying next one.
2016-02-12 12:37:23 oxCounter WARN: Id 158068 already in use for oxorder. Trying next one.
2016-02-15 10:37:30 oxCounter WARN: Id 158609 already in use for oxorder. Trying next one.
2016-02-15 11:12:07 oxCounter WARN: Id 158670 already in use for oxorder. Trying next one.
2016-02-17 09:34:59 oxCounter WARN: Id 160000 already in use for oxorder. Trying next one.
2016-02-17 11:24:40 oxCounter WARN: Id 160163 already in use for oxorder. Trying next one.
2016-02-17 16:42:12 oxCounter WARN: Id 160534 already in use for oxorder. Trying next one.
2016-02-17 23:36:32 oxCounter WARN: Id 160616 already in use for oxorder. Trying next one.
2016-02-19 11:42:36 oxCounter WARN: Id 161461 already in use for oxorder. Trying next one.
2016-02-20 13:45:17 oxCounter WARN: Id 161773 already in use for oxorder. Trying next one.
2016-02-22 09:28:15 oxCounter WARN: Id 161995 already in use for oxorder. Trying next one.
2016-02-22 09:53:18 oxCounter WARN: Id 162032 already in use for oxorder. Trying next one.
2016-02-22 10:50:16 oxCounter WARN: Id 162111 already in use for oxorder. Trying next one.
2016-02-22 11:38:28 oxCounter WARN: Id 162207 already in use for oxorder. Trying next one.
2016-02-22 12:18:59 oxCounter WARN: Id 162285 already in use for oxorder. Trying next one.
2016-02-22 13:29:02 oxCounter WARN: Id 162390 already in use for oxorder. Trying next one.
2016-02-23 09:35:35 oxCounter WARN: Id 162827 already in use for oxorder. Trying next one.
2016-02-23 12:50:57 oxCounter WARN: Id 25849 already in use for oxuser. Trying next one.
2016-02-23 16:27:29 oxCounter WARN: Id 163379 already in use for oxorder. Trying next one.
2016-02-23 16:40:55 oxCounter WARN: Id 163391 already in use for oxorder. Trying next one.
2016-02-23 17:48:30 oxCounter WARN: Id 163430 already in use for oxorder. Trying next one.
2016-02-23 23:53:35 oxCounter WARN: Id 163500 already in use for oxorder. Trying next one.
2016-02-24 12:08:51 oxCounter WARN: Id 163802 already in use for oxorder. Trying next one.
2016-02-24 14:36:50 oxCounter WARN: Id 164000 already in use for oxorder. Trying next one.
2016-02-24 20:03:17 oxCounter WARN: Id 164183 already in use for oxorder. Trying next one.
2016-02-25 08:38:42 oxCounter WARN: Id 164242 already in use for oxorder. Trying next one.
2016-02-25 09:57:50 oxCounter WARN: Id 164321 already in use for oxorder. Trying next one.
2016-02-25 10:00:38 oxCounter WARN: Id 164324 already in use for oxorder. Trying next one.
2016-02-25 10:49:43 oxCounter WARN: Id 164391 already in use for oxorder. Trying next one.
2016-02-25 11:09:05 oxCounter WARN: Id 164418 already in use for oxorder. Trying next one.
2016-02-29 12:34:44 oxCounter WARN: Id 165956 already in use for oxorder. Trying next one.
2016-03-01 09:44:06 oxCounter WARN: Id 166491 already in use for oxorder. Trying next one.
2016-03-01 13:57:36 oxCounter WARN: Id 166903 already in use for oxorder. Trying next one.
2016-03-02 11:30:38 oxCounter WARN: Id 167476 already in use for oxorder. Trying next one.
2016-03-03 09:21:13 oxCounter WARN: Id 168086 already in use for oxorder. Trying next one.
2016-03-03 12:18:37 oxCounter WARN: Id 168374 already in use for oxorder. Trying next one.
2016-03-03 13:07:33 oxCounter WARN: Id 168446 already in use for oxorder. Trying next one.
2016-03-03 13:19:48 oxCounter WARN: Id 168465 already in use for oxorder. Trying next one.
2016-03-04 12:12:05 oxCounter WARN: Id 169085 already in use for oxorder. Trying next one.
2016-03-04 16:03:48 oxCounter WARN: Id 169296 already in use for oxorder. Trying next one.
2016-03-05 13:32:27 oxCounter WARN: Id 169375 already in use for oxorder. Trying next one.
2016-03-06 16:27:55 oxCounter WARN: Id 169398 already in use for oxorder. Trying next one.
2016-03-07 09:53:30 oxCounter WARN: Id 169540 already in use for oxorder. Trying next one.
2016-03-07 12:14:06 oxCounter WARN: Id 169825 already in use for oxorder. Trying next one.
2016-03-07 14:02:25 oxCounter WARN: Id 170000 already in use for oxorder. Trying next one.
2016-03-07 17:09:46 oxCounter WARN: Id 170227 already in use for oxorder. Trying next one.
2016-03-08 08:16:21 oxCounter WARN: Id 170347 already in use for oxorder. Trying next one.
2016-03-08 13:53:04 oxCounter WARN: Id 170901 already in use for oxorder. Trying next one.
2016-03-08 13:58:11 oxCounter WARN: Id 170909 already in use for oxorder. Trying next one.
2016-03-08 18:35:50 oxCounter WARN: Id 171180 already in use for oxorder. Trying next one.
2016-03-08 23:04:49 oxCounter WARN: Id 171231 already in use for oxorder. Trying next one.
2016-03-09 08:11:16 oxCounter WARN: Id 171269 already in use for oxorder. Trying next one.
2016-03-10 13:04:26 oxCounter WARN: Id 172434 already in use for oxorder. Trying next one.
2016-03-10 13:10:53 oxCounter WARN: Id 172442 already in use for oxorder. Trying next one.
2016-03-11 15:11:57 oxCounter WARN: Id 173228 already in use for oxorder. Trying next one.
2016-03-11 15:17:36 oxCounter WARN: Id 173235 already in use for oxorder. Trying next one.
2016-03-12 19:11:20 oxCounter WARN: Id 173394 already in use for oxorder. Trying next one.
2016-03-13 10:54:49 oxCounter WARN: Id 173413 already in use for oxorder. Trying next one.
2016-03-14 11:14:41 oxCounter WARN: Id 173754 already in use for oxorder. Trying next one.
2016-03-14 14:37:50 oxCounter WARN: Id 174118 already in use for oxorder. Trying next one.
2016-03-15 08:56:57 oxCounter WARN: Id 174466 already in use for oxorder. Trying next one.
2016-03-15 12:47:15 oxCounter WARN: Id 174808 already in use for oxorder. Trying next one.
2016-03-15 14:31:37 oxCounter WARN: Id 174954 already in use for oxorder. Trying next one.
2016-03-16 09:10:35 oxCounter WARN: Id 175300 already in use for oxorder. Trying next one.
2016-03-16 11:06:16 oxCounter WARN: Id 175461 already in use for oxorder. Trying next one.
2016-03-16 14:38:23 oxCounter WARN: Id 175797 already in use for oxorder. Trying next one.
2016-03-16 16:24:15 oxCounter WARN: Id 175906 already in use for oxorder. Trying next one.
2016-03-17 11:15:13 oxCounter WARN: Id 176215 already in use for oxorder. Trying next one.
2016-03-17 12:20:25 oxCounter WARN: Id 176314 already in use for oxorder. Trying next one.
2016-03-17 16:22:53 oxCounter WARN: Id 176565 already in use for oxorder. Trying next one.
2016-03-17 16:56:49 oxCounter WARN: Id 176589 already in use for oxorder. Trying next one.
2016-03-18 05:53:17 oxCounter WARN: Id 176674 already in use for oxorder. Trying next one.
2016-03-18 09:56:00 oxCounter WARN: Id 176772 already in use for oxorder. Trying next one.
2016-03-18 12:12:00 oxCounter WARN: Id 176953 already in use for oxorder. Trying next one.
2016-03-18 15:54:16 oxCounter WARN: Id 177146 already in use for oxorder. Trying next one.
2016-03-18 18:28:51 oxCounter WARN: Id 177202 already in use for oxorder. Trying next one.
2016-03-20 20:22:14 oxCounter WARN: Id 177350 already in use for oxorder. Trying next one.
2016-03-21 10:27:31 oxCounter WARN: Id 177593 already in use for oxorder. Trying next one.
2016-03-21 10:47:33 oxCounter WARN: Id 177622 already in use for oxorder. Trying next one.
2016-03-21 11:22:40 oxCounter WARN: Id 177679 already in use for oxorder. Trying next one.
2016-03-21 14:30:03 oxCounter WARN: Id 178000 already in use for oxorder. Trying next one.
2016-03-21 17:28:41 oxCounter WARN: Id 178228 already in use for oxorder. Trying next one.
2016-03-22 10:19:02 oxCounter WARN: Id 178453 already in use for oxorder. Trying next one.
2016-03-23 08:36:25 oxCounter WARN: Id 179127 already in use for oxorder. Trying next one.
2016-03-23 10:41:42 oxCounter WARN: Id 179268 already in use for oxorder. Trying next one.
2016-03-23 11:00:14 oxCounter WARN: Id 179294 already in use for oxorder. Trying next one.
2016-03-23 12:37:12 oxCounter WARN: Id 179448 already in use for oxorder. Trying next one.
2016-03-23 12:48:57 oxCounter WARN: Id 179473 already in use for oxorder. Trying next one.
2016-03-23 13:58:36 oxCounter WARN: Id 179566 already in use for oxorder. Trying next one.
2016-03-23 15:01:50 oxCounter WARN: Id 179637 already in use for oxorder. Trying next one.
2016-03-24 11:34:09 oxCounter WARN: Id 180000 already in use for oxorder. Trying next one.
2016-03-24 12:13:21 oxCounter WARN: Id 180043 already in use for oxorder. Trying next one.
2016-03-28 10:47:50 oxCounter WARN: Id 180441 already in use for oxorder. Trying next one.
2016-03-29 13:23:42 oxCounter WARN: Id 181005 already in use for oxorder. Trying next one.
2016-03-29 18:35:10 oxCounter WARN: Id 181294 already in use for oxorder. Trying next one.
2016-03-30 14:15:19 oxCounter WARN: Id 181842 already in use for oxorder. Trying next one.
2016-03-30 15:17:20 oxCounter WARN: Id 181916 already in use for oxorder. Trying next one.
2016-03-31 08:29:17 oxCounter WARN: Id 182125 already in use for oxorder. Trying next one.
2016-03-31 09:17:47 oxCounter WARN: Id 182162 already in use for oxorder. Trying next one.
2016-03-31 09:34:00 oxCounter WARN: Id 182171 already in use for oxorder. Trying next one.
2016-04-01 11:11:51 oxCounter WARN: Id 182985 already in use for oxorder. Trying next one.
2016-04-04 09:29:52 oxCounter WARN: Id 183544 already in use for oxorder. Trying next one.
2016-04-04 10:27:22 oxCounter WARN: Id 183645 already in use for oxorder. Trying next one.
2016-04-04 11:29:29 oxCounter WARN: Id 183769 already in use for oxorder. Trying next one.
2016-04-04 17:31:33 oxCounter WARN: Id 184271 already in use for oxorder. Trying next one.
2016-04-05 08:41:55 oxCounter WARN: Id 184398 already in use for oxorder. Trying next one.
2016-04-05 11:10:27 oxCounter WARN: Id 184614 already in use for oxorder. Trying next one.
2016-04-05 14:06:51 oxCounter WARN: Id 184929 already in use for oxorder. Trying next one.
2016-04-06 13:31:31 oxCounter WARN: Id 185739 already in use for oxorder. Trying next one.
2016-04-06 14:40:04 oxCounter WARN: Id 185845 already in use for oxorder. Trying next one.
2016-04-07 07:47:35 oxCounter WARN: Id 186104 already in use for oxorder. Trying next one.
2016-04-07 11:56:15 oxCounter WARN: Id 186420 already in use for oxorder. Trying next one.
2016-04-07 12:11:55 oxCounter WARN: Id 186455 already in use for oxorder. Trying next one.
2016-04-07 13:29:49 oxCounter WARN: Id 186562 already in use for oxorder. Trying next one.
2016-04-07 14:27:57 oxCounter WARN: Id 186642 already in use for oxorder. Trying next one.
2016-04-07 15:30:46 oxCounter WARN: Id 186727 already in use for oxorder. Trying next one.
2016-04-08 10:17:02 oxCounter WARN: Id 187028 already in use for oxorder. Trying next one.
2016-04-11 11:18:26 oxCounter WARN: Id 187982 already in use for oxorder. Trying next one.
2016-04-11 11:19:15 oxCounter WARN: Id 187986 already in use for oxorder. Trying next one.
2016-04-11 13:26:45 oxCounter WARN: Id 188241 already in use for oxorder. Trying next one.
2016-04-11 14:07:16 oxCounter WARN: Id 188308 already in use for oxorder. Trying next one.
2016-04-12 08:15:26 oxCounter WARN: Id 188695 already in use for oxorder. Trying next one.
2016-04-12 08:23:54 oxCounter WARN: Id 188699 already in use for oxorder. Trying next one.
2016-04-12 10:19:14 oxCounter WARN: Id 188864 already in use for oxorder. Trying next one.
2016-04-12 11:33:55 oxCounter WARN: Id 189007 already in use for oxorder. Trying next one.
2016-04-13 12:13:03 oxCounter WARN: Id 190000 already in use for oxorder. Trying next one.
2016-04-14 08:47:32 oxCounter WARN: Id 190544 already in use for oxorder. Trying next one.
2016-04-14 09:42:05 oxCounter WARN: Id 190601 already in use for oxorder. Trying next one.
2016-04-15 11:42:10 oxCounter WARN: Id 191471 already in use for oxorder. Trying next one.
2016-04-15 11:59:42 oxCounter WARN: Id 191514 already in use for oxorder. Trying next one.
2016-04-15 12:42:48 oxCounter WARN: Id 191581 already in use for oxorder. Trying next one.
2016-04-15 14:49:05 oxCounter WARN: Id 191754 already in use for oxorder. Trying next one.
2016-04-18 09:14:36 oxCounter WARN: Id 192194 already in use for oxorder. Trying next one.
2016-04-18 11:27:47 oxCounter WARN: Id 192472 already in use for oxorder. Trying next one.
2016-04-18 12:43:46 oxCounter WARN: Id 192651 already in use for oxorder. Trying next one.
2016-04-18 13:04:04 oxCounter WARN: Id 192682 already in use for oxorder. Trying next one.
2016-04-18 13:43:54 oxCounter WARN: Id 192762 already in use for oxorder. Trying next one.
2016-04-18 14:04:19 oxCounter WARN: Id 192794 already in use for oxorder. Trying next one.
2016-04-18 16:38:08 oxCounter WARN: Id 192991 already in use for oxorder. Trying next one.
2016-04-19 09:30:42 oxCounter WARN: Id 193288 already in use for oxorder. Trying next one.
2016-04-19 10:10:18 oxCounter WARN: Id 193365 already in use for oxorder. Trying next one.
2016-04-19 11:24:53 oxCounter WARN: Id 193522 already in use for oxorder. Trying next one.
2016-04-19 14:09:50 oxCounter WARN: Id 193831 already in use for oxorder. Trying next one.
2016-04-20 09:58:56 oxCounter WARN: Id 194350 already in use for oxorder. Trying next one.
2016-04-20 13:31:11 oxCounter WARN: Id 194751 already in use for oxorder. Trying next one.
2016-04-20 16:51:29 oxCounter WARN: Id 195000 already in use for oxorder. Trying next one.
2016-04-20 21:38:03 oxCounter WARN: Id 195106 already in use for oxorder. Trying next one.
2016-04-21 09:22:19 oxCounter WARN: Id 195211 already in use for oxorder. Trying next one.
2016-04-21 10:54:38 oxCounter WARN: Id 195354 already in use for oxorder. Trying next one.
2016-04-21 13:17:26 oxCounter WARN: Id 195618 already in use for oxorder. Trying next one.
2016-04-21 14:04:12 oxCounter WARN: Id 195700 already in use for oxorder. Trying next one.
2016-04-21 16:52:47 oxCounter WARN: Id 195902 already in use for oxorder. Trying next one.
2016-04-23 15:14:50 oxCounter WARN: Id 196700 already in use for oxorder. Trying next one.
2016-04-24 13:43:27 oxCounter WARN: Id 196777 already in use for oxorder. Trying next one.
2016-04-24 18:37:40 oxCounter WARN: Id 196822 already in use for oxorder. Trying next one.
2016-04-25 08:12:36 oxCounter WARN: Id 196904 already in use for oxorder. Trying next one.
2016-04-25 09:40:56 oxCounter WARN: Id 197000 already in use for oxorder. Trying next one.
2016-04-25 12:27:33 oxCounter WARN: Id 197369 already in use for oxorder. Trying next one.
2016-04-25 15:46:29 oxCounter WARN: Id 197747 already in use for oxorder. Trying next one.
2016-04-26 10:19:31 oxCounter WARN: Id 198172 already in use for oxorder. Trying next one.
2016-04-26 11:48:02 oxCounter WARN: Id 198364 already in use for oxorder. Trying next one.
2016-04-26 12:58:45 oxCounter WARN: Id 198497 already in use for oxorder. Trying next one.
2016-04-26 14:51:04 oxCounter WARN: Id 198705 already in use for oxorder. Trying next one.
2016-04-27 10:53:49 oxCounter WARN: Id 199234 already in use for oxorder. Trying next one.
2016-04-27 11:48:57 oxCounter WARN: Id 199351 already in use for oxorder. Trying next one.
2016-04-27 11:49:04 oxCounter WARN: Id 199353 already in use for oxorder. Trying next one.
2016-04-27 12:38:05 oxCounter WARN: Id 199458 already in use for oxorder. Trying next one.
2016-04-28 08:43:39 oxCounter WARN: Id 200000 already in use for oxorder. Trying next one.
2016-04-28 13:06:54 oxCounter WARN: Id 200400 already in use for oxorder. Trying next one.
2016-04-28 15:39:46 oxCounter WARN: Id 200624 already in use for oxorder. Trying next one.
2016-04-29 11:09:39 oxCounter WARN: Id 201061 already in use for oxorder. Trying next one.
2016-04-29 12:29:11 oxCounter WARN: Id 201205 already in use for oxorder. Trying next one.
2016-05-02 10:14:06 oxCounter WARN: Id 201900 already in use for oxorder. Trying next one.
2016-05-02 13:15:09 oxCounter WARN: Id 202323 already in use for oxorder. Trying next one.
2016-05-02 13:48:47 oxCounter WARN: Id 202389 already in use for oxorder. Trying next one.
2016-05-02 13:49:39 oxCounter WARN: Id 202391 already in use for oxorder. Trying next one.
2016-05-03 09:30:47 oxCounter WARN: Id 202926 already in use for oxorder. Trying next one.
2016-05-03 15:16:01 oxCounter WARN: Id 203566 already in use for oxorder. Trying next one.
2016-05-04 09:28:52 oxCounter WARN: Id 203900 already in use for oxorder. Trying next one.
2016-05-04 09:29:19 oxCounter WARN: Id 203902 already in use for oxorder. Trying next one.
2016-05-04 10:01:14 oxCounter WARN: Id 203951 already in use for oxorder. Trying next one.
2016-05-04 10:57:57 oxCounter WARN: Id 204039 already in use for oxorder. Trying next one.
2016-05-04 11:30:33 oxCounter WARN: Id 204100 already in use for oxorder. Trying next one.
2016-05-04 13:14:06 oxCounter WARN: Id 204279 already in use for oxorder. Trying next one.
2016-05-04 15:00:45 oxCounter WARN: Id 204427 already in use for oxorder. Trying next one.
2016-05-04 17:14:07 oxCounter WARN: Id 204562 already in use for oxorder. Trying next one.
2016-05-06 08:51:43 oxCounter WARN: Id 204728 already in use for oxorder. Trying next one.
2016-05-06 08:56:37 oxCounter WARN: Id 204731 already in use for oxorder. Trying next one.
2016-05-06 10:21:13 oxCounter WARN: Id 204818 already in use for oxorder. Trying next one.
2016-05-06 12:57:53 oxCounter WARN: Id 204956 already in use for oxorder. Trying next one.
2016-05-06 20:07:15 oxCounter WARN: Id 205154 already in use for oxorder. Trying next one.
2016-05-07 11:04:34 oxCounter WARN: Id 205176 already in use for oxorder. Trying next one.
2016-05-07 15:39:55 oxCounter WARN: Id 205202 already in use for oxorder. Trying next one.
2016-05-08 13:46:13 oxCounter WARN: Id 205244 already in use for oxorder. Trying next one.
2016-05-09 12:07:05 oxCounter WARN: Id 205855 already in use for oxorder. Trying next one.
2016-05-09 12:18:38 oxCounter WARN: Id 205895 already in use for oxorder. Trying next one.
2016-05-09 15:08:39 oxCounter WARN: Id 206226 already in use for oxorder. Trying next one.
2016-05-09 15:36:42 oxCounter WARN: Id 206262 already in use for oxorder. Trying next one.
2016-05-09 16:49:41 oxCounter WARN: Id 206357 already in use for oxorder. Trying next one.
2016-05-09 19:12:52 oxCounter WARN: Id 206452 already in use for oxorder. Trying next one.
2016-05-10 12:58:30 oxCounter WARN: Id 207163 already in use for oxorder. Trying next one.
2016-05-10 16:36:23 oxCounter WARN: Id 207520 already in use for oxorder. Trying next one.
2016-05-10 19:22:40 oxCounter WARN: Id 207625 already in use for oxorder. Trying next one.
2016-05-10 19:33:57 oxCounter WARN: Id 207627 already in use for oxorder. Trying next one.
2016-05-11 09:02:25 oxCounter WARN: Id 207765 already in use for oxorder. Trying next one.
2016-05-11 10:18:58 oxCounter WARN: Id 207903 already in use for oxorder. Trying next one.
2016-05-11 11:19:16 oxCounter WARN: Id 208040 already in use for oxorder. Trying next one.
2016-05-11 13:30:10 oxCounter WARN: Id 208307 already in use for oxorder. Trying next one.
2016-05-11 17:12:04 oxCounter WARN: Id 208611 already in use for oxorder. Trying next one.
2016-05-11 21:22:09 oxCounter WARN: Id 208687 already in use for oxorder. Trying next one.
2016-05-11 21:36:44 oxCounter WARN: Id 208690 already in use for oxorder. Trying next one.
2016-05-12 11:14:55 oxCounter WARN: Id 209056 already in use for oxorder. Trying next one.
2016-05-12 12:34:49 oxCounter WARN: Id 209224 already in use for oxorder. Trying next one.
2016-05-12 12:47:06 oxCounter WARN: Id 209246 already in use for oxorder. Trying next one.
2016-05-12 13:10:51 oxCounter WARN: Id 209289 already in use for oxorder. Trying next one.
2016-05-12 13:44:52 oxCounter WARN: Id 209352 already in use for oxorder. Trying next one.
2016-05-12 14:04:52 oxCounter WARN: Id 209390 already in use for oxorder. Trying next one.
2016-05-13 11:48:11 oxCounter WARN: Id 210000 already in use for oxorder. Trying next one.
2016-05-13 16:42:48 oxCounter WARN: Id 210351 already in use for oxorder. Trying next one.
2016-05-15 14:27:54 oxCounter WARN: Id 210516 already in use for oxorder. Trying next one.
2016-05-16 18:51:56 oxCounter WARN: Id 210639 already in use for oxorder. Trying next one.
2016-05-17 08:01:32 oxCounter WARN: Id 210715 already in use for oxorder. Trying next one.
2016-05-17 09:00:37 oxCounter WARN: Id 210778 already in use for oxorder. Trying next one.
2016-05-17 10:18:04 oxCounter WARN: Id 210922 already in use for oxorder. Trying next one.
2016-05-17 11:58:54 oxCounter WARN: Id 211197 already in use for oxorder. Trying next one.
2016-05-17 12:41:44 oxCounter WARN: Id 211300 already in use for oxorder. Trying next one.
2016-05-17 13:43:39 oxCounter WARN: Id 211442 already in use for oxorder. Trying next one.
2016-05-17 14:53:27 oxCounter WARN: Id 211568 already in use for oxorder. Trying next one.
2016-05-17 16:19:09 oxCounter WARN: Id 211703 already in use for oxorder. Trying next one.
2016-05-18 10:31:31 oxCounter WARN: Id 212163 already in use for oxorder. Trying next one.
2016-05-18 16:51:15 oxCounter WARN: Id 212882 already in use for oxorder. Trying next one.
2016-05-19 09:16:08 oxCounter WARN: Id 213089 already in use for oxorder. Trying next one.
2016-05-19 13:52:04 oxCounter WARN: Id 213632 already in use for oxorder. Trying next one.
2016-05-19 16:29:06 oxCounter WARN: Id 213830 already in use for oxorder. Trying next one.
2016-05-19 19:20:05 oxCounter WARN: Id 213922 already in use for oxorder. Trying next one.
2016-05-20 09:19:39 oxCounter WARN: Id 214083 already in use for oxorder. Trying next one.
2016-05-20 09:23:02 oxCounter WARN: Id 214089 already in use for oxorder. Trying next one.
2016-05-20 12:18:58 oxCounter WARN: Id 214439 already in use for oxorder. Trying next one.
2016-05-20 15:31:17 oxCounter WARN: Id 214670 already in use for oxorder. Trying next one.
2016-05-22 18:28:00 oxCounter WARN: Id 214914 already in use for oxorder. Trying next one.
2016-05-22 21:27:42 oxCounter WARN: Id 214948 already in use for oxorder. Trying next one.
2016-05-23 12:15:49 oxCounter WARN: Id 215484 already in use for oxorder. Trying next one.
2016-05-23 12:32:38 oxCounter WARN: Id 215519 already in use for oxorder. Trying next one.
2016-05-23 13:46:30 oxCounter WARN: Id 215695 already in use for oxorder. Trying next one.
2016-05-24 11:15:58 oxCounter WARN: Id 216500 already in use for oxorder. Trying next one.
2016-05-24 12:48:16 oxCounter WARN: Id 216697 already in use for oxorder. Trying next one.
2016-05-24 13:10:02 oxCounter WARN: Id 216769 already in use for oxorder. Trying next one.
2016-05-24 15:36:39 oxCounter WARN: Id 217064 already in use for oxorder. Trying next one.
2016-05-24 19:11:52 oxCounter WARN: Id 217289 already in use for oxorder. Trying next one.
2016-05-25 10:38:06 oxCounter WARN: Id 217571 already in use for oxorder. Trying next one.
2016-05-25 15:43:16 oxCounter WARN: Id 218132 already in use for oxorder. Trying next one.
2016-05-25 19:59:38 oxCounter WARN: Id 218260 already in use for oxorder. Trying next one.
2016-05-26 22:44:41 oxCounter WARN: Id 218658 already in use for oxorder. Trying next one.
2016-05-27 10:22:47 oxCounter WARN: Id 218818 already in use for oxorder. Trying next one.


Additional InformationWe also installed a trigger on the database which logs when a value smaller than the previous one is written to the database table. This never happened.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP Version5.4
Database VersionOther

Activities

QA

2017-03-29 13:59

administrator   ~0012006

After discussion with @BernhardScheffold, this bug is being closed. The where clause in the below code should be 'SELECT oxid FROM oxorder WHERE oxordernr = ?' instead of 'SELECT oxid FROM oxorder WHERE oxid = ?'. Hence the logging functionality is wrong. The issue itself has to be yet analysed if it exists after correcting the above.